[MDEV-31460] main.order_by_pack_big fails with view-protocol Created: 2023-06-11  Updated: 2023-10-18  Resolved: 2023-09-19

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Lena Startseva
Resolution: Fixed Votes: 0
Labels: None


 Description   

10.5 b3074128

main.order_by_pack_big                   [ fail ]
        Test ended at 2023-06-12 01:25:05
 
CURRENT_TEST: main.order_by_pack_big
--- /mnt8t/bld/10.5-asan/mysql-test/main/order_by_pack_big.result	2021-03-06 05:41:06.000000000 +0200
+++ /mnt8t/bld/10.5-asan/mysql-test/main/order_by_pack_big.reject	2023-06-12 01:25:04.840812082 +0300
@@ -124,8 +124,7 @@
 order by id))
 FROM t3
 GROUP BY x;
-x	MD5(group_concat(substring(names,1,3), substring(address,1,3)
-order by id))
+x	Name_exp_2
 0	3d24cb0237caf81aa74a2dddf367ac23
 1	618f9b8b6cefaa268dcb5477eece5e90
 2	fbfe93cc7713f852852f66e578d999aa
@@ -282,8 +281,7 @@
 order by id))
 FROM t3
 GROUP BY x;
-x	MD5(group_concat(substring(names,1,3), substring(address,1,3)
-order by id))
+x	Name_exp_2
 0	3d24cb0237caf81aa74a2dddf367ac23
 1	618f9b8b6cefaa268dcb5477eece5e90
 2	fbfe93cc7713f852852f66e578d999aa
 
mysqltest: Result length mismatch



 Comments   
Comment by Lena Startseva [ 2023-08-11 ]

Branch for review: bb-10.5-MDEV-31460-vp

Comment by Oleksandr Byelkin [ 2023-09-12 ]

OK to push

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