spider/bugfix.group_by_order_by_limit    [ fail ]

        Test ended at 2025-04-02 15:48:21

CURRENT_TEST: spider/bugfix.group_by_order_by_limit

--- /home/ycp/source/mariadb-server/10.5/src/storage/spider/mysql-test/spider/bugfix/r/group_by_order_by_limit.result	2024-10-14 17:39:33.521086990 +1100

+++ /home/ycp/source/mariadb-server/10.5/src/storage/spider/mysql-test/spider/bugfix/r/group_by_order_by_limit.reject	2025-04-02 15:48:21.350807203 +1100

@@ -60,12 +60,12 @@

 10	2

 SHOW STATUS LIKE 'Spider_direct_aggregate';

 Variable_name	Value

-Spider_direct_aggregate	60

+Spider_direct_aggregate	120

 set spider_direct_aggregate=@old_spider_direct_aggregate;

 connection child2_1;

 SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %';

 argument

-select count(0),`skey` from `auto_test_remote`.`tbl_a` group by `skey` order by `skey`

+select count(0),count(0),`skey` from `auto_test_remote`.`tbl_a` group by `skey` order by `skey`

 SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %'

 SELECT pkey, skey FROM tbl_a ORDER BY pkey;

 pkey	skey

@@ -87,7 +87,7 @@

 connection child2_2;

 SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %';

 argument

-select count(0),`skey` from `auto_test_remote2`.`tbl_a` group by `skey` order by `skey`

+select count(0),count(0),`skey` from `auto_test_remote2`.`tbl_a` group by `skey` order by `skey`

 SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %'

 SELECT pkey, skey FROM tbl_a ORDER BY pkey;

 pkey	skey

Result length mismatch