[MDEV-32465] dyncol changes under view protocol Created: 2023-10-13  Updated: 2023-11-02  Resolved: 2023-11-02

Status: Closed
Project: MariaDB Server
Component/s: Data types, Dynamic Columns
Affects Version/s: 11.0.2, 10.4.31, 10.5.22, 10.6.15, 10.10.6, 10.11.5, 11.0.3
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1

Type: Bug Priority: Critical
Reporter: Oleksandr Byelkin Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-27871 View is created with wrong column nam... Stalled
relates to MDEV-32461 types changed in view protocol in cas... Closed

 Description   

--- /home/sanja/maria/git/10.4/mysql-test/main/dyncol.result	2023-10-13 10:14:56.150143291 +0200
+++ /home/sanja/maria/git/10.4/mysql-test/main/dyncol.reject	2023-10-13 10:15:21.902210719 +0200
@@ -1452,8 +1452,8 @@
 # creation test (names)
 set names utf8;
 select hex(column_create("адын", 1212));
-hex(column_create("адын", 1212))
-040100080000000000D0B0D0B4D18BD0BD7809
+hex(column_create("адын", 1212))
+040100110000000000C390C2B0C390C2B4C391E280B9C390C2BD7809
 select hex(column_create("1212", 1212));
 hex(column_create("1212", 1212))
 040100040000000000313231327809
@@ -1467,8 +1467,8 @@
 hex(column_create("1212", 2, 3, 3))
 0402000500000000000100100033313231320604
 select hex(column_create("1212", 2, "адын", 1, 3, 3));
-hex(column_create("1212", 2, "адын", 1, 3, 3))
-0403000D000000000001001000050020003331323132D0B0D0B4D18BD0BD060402
+hex(column_create("1212", 2, "адын", 1, 3, 3))
+04030016000000000001001000050020003331323132C390C2B0C390C2B4C391E280B9C390C2BD060402
 set names latin1;
 # fetching column test (names)
 set names utf8;

--- /home/sanja/maria/git/10.4/mysql-test/main/dyncol.result	2023-10-13 10:21:38.983624435 +0200
+++ /home/sanja/maria/git/10.4/mysql-test/main/dyncol.reject	2023-10-13 10:22:05.615747128 +0200
@@ -1524,10 +1524,10 @@
 # column changing test (names)
 select hex(column_add(column_create(1, "AAA"), "b", "BBB")) as ex;
 ex
-0402000200000003000100430031620841414108424242
+0402000200000003000100430031622141414121424242
 select hex(column_add(column_create("1", "AAA"), "b", "BBB")) as ex;
 ex
-0402000200000003000100430031620841414108424242
+0402000200000003000100430031622141414121424242
 select column_get(column_add(column_create(1, "AAA"), "b", "BBB"), 1 as char) as ex;
 ex
 AAA
@@ -1536,10 +1536,10 @@
 BBB
 select hex(column_add(column_create("a", "AAA"), 1, "BBB")) as ex;
 ex
-0402000200000003000100430031610842424208414141
+0402000200000003000100430031612142424221414141
 select hex(column_add(column_create("a", "AAA"), "1", "BBB")) as ex;
 ex
-0402000200000003000100430031610842424208414141
+0402000200000003000100430031612142424221414141
 select hex(column_add(column_create("a", 1212 as integer), "b", "1212" as integer)) as ex;
 ex
 04020002000000000001002000616278097809
@@ -1703,7 +1703,7 @@
 #
 select column_json(column_create("string", "'\"/\\`.,whatever")),hex(column_create("string", "'\"/\\`.,whatever"));
 column_json(column_create("string", "'\"/\\`.,whatever"))	hex(column_create("string", "'\"/\\`.,whatever"))
-{"string":"'\"/\\`.,whatever"}	040100060000000300737472696E670827222F5C602E2C7768617465766572
+{"string":"'\"/\\`.,whatever"}	040100060000000300737472696E672127222F5C602E2C7768617465766572
 #
 # embedding test
 #

To test remove all disable/enable marked by #enable after MDEV-32465 fix


Generated at Thu Feb 08 10:31:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.