Logging: /home/ppandith/test2/mysql-test/mariadb-test-run.pl --force --max-test-fail=0 --retry-failure=0 --replay-server federated.federatedx_create_handlers federated.federatedx federated.optimizer connect.part_file connect.part_table connect.index connect.mysql_index connect.upd spider/bugfix.mdev_32907 spider/bugfix.mdev_37484 spider/bugfix.quick_mode_1 spider/feature.pushdown_case spider/feature.pushdown_timestamp_diff archive.rnd_pos archive.archive archive.archive_gis mroonga/wrapper.count_star_with_index mroonga/storage.geometry_contains mroonga/storage.optimization_count_skip_index_not_equal mroonga/storage.variable_max_n_records_for_estimate_global mroonga/storage.variable_max_n_records_for_estimate_not_found_in_limit mroonga/storage.variable_max_n_records_for_estimate_session videx.set-debug-skip-http VS config: vardir: /home/ppandith/test2/bld/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/home/ppandith/test2/bld/mysql-test/var'... Checking supported features... MariaDB Version 12.3.0-MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Collecting tests... Installing system database... Starting replay server... Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029 Copying /home/ppandith/test2/bld/mysql-test/var/install.db to /home/ppandith/test2/bld/mysql-test/var/extra_server_1/data... Starting mysqld on port 19011 with socket /home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.sock... Command: /home/ppandith/test2/bld/sql/mariadbd --no-defaults --datadir=/home/ppandith/test2/bld/mysql-test/var/extra_server_1/data --port=19011 --socket=/home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.sock --pid-file=/home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.pid --log-error=/home/ppandith/test2/bld/mysql-test/var/log/extra_server_1.err --general-log=1 --general-log-file=/home/ppandith/test2/bld/mysql-test/var/log/extra_server_1.log --skip-networking=0 --skip-grant-tables --key-buffer-size=1M --sort-buffer-size=256K --max-heap-table-size=1M --gdb Server process started with PID 35334 Waiting for server to be ready... Socket file created: /home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.sock Extra server 1 started successfully Connection info written to /home/ppandith/test2/bld/mysql-test/var/tmp/extra_server_1.info Host: 127.0.0.1 Port: 19011 Socket: /home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.sock Datadir: /home/ppandith/test2/bld/mysql-test/var/extra_server_1/data General log: /home/ppandith/test2/bld/mysql-test/var/log/extra_server_1.log Replay server started on socket: /home/ppandith/test2/bld/mysql-test/var/extra_server_1/mysqld.sock ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- videx.set-debug-skip-http [ skipped ] No VIDEX ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 77 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 80 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 84 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 106 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 112 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 131 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 153 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 185 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 190 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 203 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 210 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( `a` varchar(100) NOT NULL DEFAULT '123' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 287 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t1_local` ( `a` varchar(100) NOT NULL DEFAULT '123' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 297 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `federated`.`t3` ( `a` int(11) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mariadb://root@127.0.0.1:$SLAVE_MYPORT/federated/t3' PARTITION BY LIST (`a`) (PARTITION `p1` VALUES IN (1) CONNECTION = 'fedlink/t3' ENGINE = FEDERATED, PARTITION `p2` VALUES IN (2) CONNECTION = 'fedlink/t4' ENGINE = FEDERATED): Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 324 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(20) NOT NULL, `name` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 369 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 541 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 546 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 550 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 552 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 564 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 567 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 573 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 576 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 586 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 592 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 609 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 625 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 630 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 662 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 668 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 677 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 687 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 693 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 702 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t11` ( `a` smallint(6) NOT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t11': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 735 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t11` ( `a` smallint(6) NOT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t11': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 743 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t14` ( `a` varchar(8) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t14': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 777 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t13` ( `a` char(6) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t13': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 786 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 853 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `a` varchar(16) NOT NULL DEFAULT '' ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 863 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 876 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 882 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` varchar(10) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 891 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `product_tag` ( `product_id` bigint(20) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/product_tag': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 955 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 994 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) DEFAULT NULL ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.test" ReplayTest: At line 1008 federated.federatedx_create_handlers 'X' [ fail ] Test ended at 2026-07-24 16:55:05 CURRENT_TEST: federated.federatedx_create_handlers --- /home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.result 2026-02-12 12:19:16.950546384 +0530 +++ /home/ppandith/test2/mysql-test/suite/federated/federatedx_create_handlers.reject 2026-07-24 16:55:05.200741684 +0530 @@ -91,25 +91,22 @@ 1 zzz EXPLAIN SELECT id FROM federated.t1 WHERE id < 5; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' EXPLAIN EXTENDED SELECT id FROM federated.t1 WHERE id < 5; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 select `federated`.`t1`.`id` AS `id` from `federated`.`t1` where `federated`.`t1`.`id` < 5 +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT id FROM federated.t1 WHERE id < 5; -EXPLAIN -{ - "query_block": { - "select_id": 1, - "table": { - "message": "Pushed select" - } - } -} +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ANALYZE SELECT id FROM federated.t1 WHERE id < 5; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra @@ -149,56 +146,18 @@ SELECT * FROM federated.t3, (SELECT * FROM federated.t1 WHERE id > 3) t WHERE federated.t3.name=t.name; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t3 ALL NULL NULL NULL NULL 7 -1 PRIMARY ref key0 key0 18 federated.t3.name 1 -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT * FROM federated.t3, (SELECT * FROM federated.t1 WHERE id > 3) t WHERE federated.t3.name=t.name; -EXPLAIN -{ - "query_block": { - "select_id": 1, - "cost": "COST_REPLACED", - "nested_loop": [ - { - "table": { - "table_name": "t3", - "access_type": "ALL", - "loops": 1, - "rows": 7, - "cost": "COST_REPLACED", - "filtered": 100 - } - }, - { - "table": { - "table_name": "", - "access_type": "ref", - "possible_keys": ["key0"], - "key": "key0", - "key_length": "18", - "used_key_parts": ["name"], - "ref": ["federated.t3.name"], - "loops": 7, - "rows": 1, - "cost": "COST_REPLACED", - "filtered": 100, - "materialized": { - "query_block": { - "select_id": 2, - "table": { - "message": "Pushed derived" - } - } - } - } - } - ] - } -} +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ANALYZE SELECT * FROM federated.t3, (SELECT * FROM federated.t1 WHERE id > 3) t @@ -220,10 +179,9 @@ WHERE id IN (SELECT count(*) FROM federated.t2 GROUP BY name)) t WHERE federated.t3.name=t.name; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t3 ALL NULL NULL NULL NULL 7 -1 PRIMARY ref key0 key0 18 federated.t3.name 1 -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ANALYZE FORMAT=JSON SELECT * FROM federated.t3, (SELECT t1.name FROM federated.t1 @@ -310,10 +268,10 @@ UNION SELECT * FROM federated.t1 WHERE id >= 5) t WHERE federated.t3.name=t.name; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t3 ALL NULL NULL NULL NULL 7 -1 PRIMARY ref key1,distinct_key key1 18 federated.t3.name 1 -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' # # MDEV-21887: federatedx crashes on SELECT ... INTO query in select_handler code # @@ -340,20 +298,15 @@ explain select * from federated.t1 where name in (select name from federated.t2); -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' explain format=json select * from federated.t1 where name in (select name from federated.t2); -EXPLAIN -{ - "query_block": { - "select_id": 1, - "table": { - "message": "Pushed select" - } - } -} +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # # MDEV-22993, testcase #2: EXPLAIN output doesn't make sense when # derived table pushdown is used. @@ -365,57 +318,17 @@ select * from t5, (select id from federated.t1 where name in (select name from federated.t2) or name like 'foo%') as TQ; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t5 ALL NULL NULL NULL NULL 2 -1 PRIMARY ALL NULL NULL NULL NULL 5 Using join buffer (flat, BNL join) -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # Must not show elements with select_id=3 explain format=json select * from t5, (select id from federated.t1 where name in (select name from federated.t2) or name like 'foo%') as TQ; -EXPLAIN -{ - "query_block": { - "select_id": 1, - "cost": "COST_REPLACED", - "nested_loop": [ - { - "table": { - "table_name": "t5", - "access_type": "ALL", - "loops": 1, - "rows": 2, - "cost": "COST_REPLACED", - "filtered": 100 - } - }, - { - "block-nl-join": { - "table": { - "table_name": "", - "access_type": "ALL", - "loops": 2, - "rows": 5, - "cost": "COST_REPLACED", - "filtered": 100 - }, - "buffer_type": "flat", - "buffer_size": "65", - "join_type": "BNL", - "materialized": { - "query_block": { - "select_id": 2, - "table": { - "message": "Pushed derived" - } - } - } - } - } - ] - } -} +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' drop table t5; DROP TABLE federated.t1, federated.t2, federated.t3, federated.t4; connection slave; @@ -472,8 +385,9 @@ connection master; # Use tables from the previous test. Make sure pushdown works: EXPLAIN SELECT COUNT(DISTINCT a) FROM federated.t2; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `federated`.`t2` ( + `a` varchar(100) NOT NULL DEFAULT '123' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' SELECT COUNT(DISTINCT a) FROM federated.t2; COUNT(DISTINCT a) 70000 @@ -482,8 +396,9 @@ CONNECTION='mysql://root@127.0.0.1:SLAVE_PORT/federated/t1'; # No pushdown here due to table names mismatch, retrieve data as usual: EXPLAIN SELECT COUNT(DISTINCT a) FROM federated.t1_local; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1_local ALL NULL NULL NULL NULL 70000 +ReplayTest: Query error: CREATE TABLE `federated`.`t1_local` ( + `a` varchar(100) NOT NULL DEFAULT '123' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' SELECT COUNT(DISTINCT a) FROM federated.t1_local; COUNT(DISTINCT a) 70000 @@ -507,8 +422,12 @@ (PARTITION p1 VALUES IN (1) CONNECTION='fedlink/t3', PARTITION p2 VALUES IN (2) CONNECTION='fedlink/t4'); EXPLAIN SELECT * FROM federated.t3; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t3 ALL NULL NULL NULL NULL 3 +ReplayTest: Query error: CREATE TABLE `federated`.`t3` ( + `a` int(11) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mariadb://root@127.0.0.1:$SLAVE_MYPORT/federated/t3' + PARTITION BY LIST (`a`) +(PARTITION `p1` VALUES IN (1) CONNECTION = 'fedlink/t3' ENGINE = FEDERATED, + PARTITION `p2` VALUES IN (2) CONNECTION = 'fedlink/t4' ENGINE = FEDERATED): Unknown storage engine 'FEDERATED' SELECT * FROM federated.t3; a 1 @@ -554,8 +473,10 @@ EXPLAIN SELECT * FROM (SELECT * FROM (SELECT * FROM (SELECT * FROM t1 where id=3) dt3 WHERE id=3) dt2) dt; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(20) NOT NULL, + `name` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' connection slave; CREATE TABLE federated.t10 (a INT,b INT); CREATE TABLE federated.t11 (a INT, b INT); @@ -702,8 +623,9 @@ def efg EXPLAIN SELECT * from federated.t1 UNION SELECT * from federated.t2; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # Pushdown of a part of the UNION SELECT * from federated.t1 UNION SELECT * from t3; a @@ -714,10 +636,9 @@ t3_myisam2 t3_myisam3 EXPLAIN SELECT * from federated.t1 UNION SELECT * from t3; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 UNION t3 ALL NULL NULL NULL NULL 3 -NULL UNION RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' SELECT * from federated.t1 UNION ALL SELECT * from federated.t2; a abc @@ -729,18 +650,14 @@ def efg EXPLAIN SELECT * from federated.t1 UNION ALL SELECT * from federated.t2; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT * from federated.t1 UNION ALL SELECT * from federated.t2; -EXPLAIN -{ - "query_block": { - "union_result": { - "message": "PUSHED UNION" - } - } -} +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' ANALYZE SELECT * from federated.t1 UNION ALL SELECT * from federated.t2; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL @@ -761,20 +678,14 @@ a EXPLAIN EXTENDED SELECT * from federated.t1 EXCEPT SELECT * from federated.t2; -id select_type table type possible_keys key key_len ref rows filtered Extra -NULL PUSHED EXCEPT NULL NULL NULL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 /* select#1 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1` except /* select#2 */ select `federated`.`t2`.`a` AS `a` from `federated`.`t2` +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT * from federated.t1 EXCEPT SELECT * from federated.t2; -EXPLAIN -{ - "query_block": { - "union_result": { - "message": "PUSHED EXCEPT" - } - } -} +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' SELECT * from federated.t1 INTERSECT SELECT * from federated.t2; a abc @@ -782,18 +693,14 @@ cde EXPLAIN PARTITIONS SELECT * from federated.t1 INTERSECT SELECT * from federated.t2; -id select_type table partitions type possible_keys key key_len ref rows Extra -NULL PUSHED INTERSECT NULL NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT * from federated.t1 INTERSECT SELECT * from federated.t2; -EXPLAIN -{ - "query_block": { - "union_result": { - "message": "PUSHED INTERSECT" - } - } -} +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # More than two SELECTs in a UNIT: SELECT * from federated.t1 INTERSECT SELECT * from federated.t2 UNION ALL @@ -807,21 +714,17 @@ SELECT count(*) from federated.t2 UNION ALL SELECT count(*)+20 from federated.t2 EXCEPT SELECT count(*)+5 from federated.t1; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNIT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT count(*) from federated.t1 INTERSECT SELECT count(*) from federated.t2 UNION ALL SELECT count(*)+20 from federated.t2 EXCEPT SELECT count(*)+5 from federated.t1; -EXPLAIN -{ - "query_block": { - "union_result": { - "message": "PUSHED UNIT" - } - } -} +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' ANALYZE SELECT count(*) from federated.t1 INTERSECT SELECT count(*) from federated.t2 UNION @@ -844,8 +747,9 @@ EXPLAIN SELECT * FROM (SELECT a FROM federated.t1 UNION ALL SELECT * FROM federated.t2) q; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # There is an uncacheable side effect due to fetch into @var, # so the UNION cannot be pushed down as a whole. # But separate SELECTs can be pushed, and the results are combined @@ -858,52 +762,16 @@ SELECT count(*) FROM federated.t2 EXCEPT SELECT count(*)+1 FROM federated.t1 INTO @var; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -3 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -NULL UNIT RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' EXPLAIN FORMAT=JSON SELECT count(*) FROM federated.t1 UNION SELECT count(*) FROM federated.t2 EXCEPT SELECT count(*)+2 FROM federated.t2 INTO @var; -EXPLAIN -{ - "query_block": { - "union_result": { - "table_name": "", - "access_type": "ALL", - "query_specifications": [ - { - "query_block": { - "select_id": 1, - "table": { - "message": "Pushed select" - } - } - }, - { - "query_block": { - "select_id": 2, - "operation": "UNION", - "table": { - "message": "Pushed select" - } - } - }, - { - "query_block": { - "select_id": 3, - "operation": "EXCEPT", - "table": { - "message": "Pushed select" - } - } - } - ] - } - } -} +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # Prepared statements PREPARE stmt FROM "SELECT * from federated.t1 INTERSECT SELECT * from federated.t2 UNION ALL @@ -941,10 +809,9 @@ t3_myisam2 t3_myisam3 EXPLAIN SELECT * FROM federated.t1 UNION SELECT * FROM t3; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 UNION t3 ALL NULL NULL NULL NULL 3 -NULL UNION RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' SELECT * FROM federated.t1 UNION ALL SELECT * FROM t3 EXCEPT SELECT * FROM federated.t2; @@ -955,11 +822,9 @@ EXPLAIN SELECT * FROM federated.t1 UNION ALL SELECT * FROM t3 EXCEPT SELECT * FROM federated.t2; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 UNION t3 ALL NULL NULL NULL NULL 3 -3 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -NULL UNIT RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' SELECT * FROM t3 UNION ALL SELECT * FROM federated.t1 EXCEPT SELECT * FROM t4 INTERSECT @@ -975,14 +840,9 @@ SELECT * FROM federated.t1 EXCEPT SELECT * FROM t4 INTERSECT SELECT * FROM federated.t2; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t3 ALL NULL NULL NULL NULL 3 -2 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -5 EXCEPT ALL NULL NULL NULL NULL 3 -3 DERIVED t4 ALL NULL NULL NULL NULL 3 -4 INTERSECT t2 ALL NULL NULL NULL NULL 5 -NULL INTERSECT RESULT ALL NULL NULL NULL NULL NULL -NULL UNIT RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' SELECT * FROM federated.t2 UNION ALL SELECT * FROM t3 EXCEPT SELECT * FROM t4 INTERSECT @@ -1000,20 +860,16 @@ SELECT * FROM t3 EXCEPT SELECT * FROM t4 INTERSECT SELECT * FROM federated.t1; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 UNION t3 ALL NULL NULL NULL NULL 3 -5 EXCEPT ALL NULL NULL NULL NULL 3 -3 DERIVED t4 ALL NULL NULL NULL NULL 3 -4 INTERSECT t1 ALL NULL NULL NULL NULL 3 -NULL INTERSECT RESULT ALL NULL NULL NULL NULL NULL -NULL UNIT RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' # Parenthesis must not prevent the whole UNIONs pushdown EXPLAIN (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2) UNION ALL SELECT * FROM federated.t1; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2) UNION ALL SELECT * FROM federated.t1; @@ -1028,8 +884,9 @@ efg EXPLAIN (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2) UNION ALL (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2); -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2) UNION ALL (SELECT * FROM federated.t1 UNION SELECT * FROM federated.t2); a @@ -1066,8 +923,9 @@ 1 32767 EXPLAIN SELECT a FROM federated.t12 UNION ALL SELECT a FROM federated.t11; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t11` ( + `a` smallint(6) NOT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t11': Unknown storage engine 'FEDERATED' SELECT a FROM federated.t11 UNION SELECT a FROM federated.t12; a -1 @@ -1087,11 +945,9 @@ EXPLAIN SELECT a FROM federated.t12 UNION SELECT a FROM federated.t11 UNION SELECT 123; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -3 UNION NULL NULL NULL NULL NULL NULL NULL No tables used -NULL UNION RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t11` ( + `a` smallint(6) NOT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t11': Unknown storage engine 'FEDERATED' SELECT a FROM federated.t12 EXCEPT SELECT 1 UNION ALL SELECT a FROM federated.t11 EXCEPT @@ -1121,8 +977,9 @@ t14abcde t14xyzzz EXPLAIN SELECT * FROM federated.t13 UNION SELECT * FROM federated.t14; -id select_type table type possible_keys key key_len ref rows Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t14` ( + `a` varchar(8) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t14': Unknown storage engine 'FEDERATED' SELECT * FROM federated.t14 UNION ALL SELECT * FROM federated.t13; a common @@ -1144,11 +1001,9 @@ EXPLAIN SELECT * FROM federated.t14 UNION SELECT * FROM federated.t13 UNION SELECT '123456789000'; -id select_type table type possible_keys key key_len ref rows Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -2 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL -3 UNION NULL NULL NULL NULL NULL NULL NULL No tables used -NULL UNION RESULT ALL NULL NULL NULL NULL NULL +ReplayTest: Query error: CREATE TABLE `t13` ( + `a` char(6) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t13': Unknown storage engine 'FEDERATED' SELECT * FROM federated.t13 UNION SELECT '123456789000' UNION SELECT * FROM federated.t14; @@ -1255,10 +1110,9 @@ cde explain extended WITH cte AS (SELECT * FROM federated.t1) SELECT * FROM cte; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 with cte as (/* select#2 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1`)/* select#1 */ select `cte`.`a` AS `a` from `cte` +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' # Pushdown of a UNION having CTE's WITH cte AS (SELECT * FROM federated.t1), cte2 AS (SELECT * FROM federated.t2) @@ -1276,10 +1130,9 @@ SELECT * FROM cte UNION SELECT * FROM cte2; -id select_type table type possible_keys key key_len ref rows filtered Extra -NULL PUSHED UNION NULL NULL NULL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 with cte as (/* select#2 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1`), cte2 as (/* select#3 */ select `federated`.`t2`.`a` AS `a` from `federated`.`t2`)/* select#1 */ select `cte`.`a` AS `a` from `cte` union /* select#4 */ select `cte2`.`a` AS `a` from `cte2` +ReplayTest: Query error: CREATE TABLE `t2` ( + `a` varchar(16) NOT NULL DEFAULT '' +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t2': Unknown storage engine 'FEDERATED' # Partial pushdown is not allowed for unions with CTE's, however a CTE # may be pushed down a derived table WITH cte AS (SELECT * FROM federated.t1) @@ -1297,12 +1150,9 @@ SELECT * FROM cte UNION ALL SELECT * FROM t3; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 PRIMARY ALL NULL NULL NULL NULL 3 100.00 -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL NULL -3 UNION t3 ALL NULL NULL NULL NULL 3 100.00 -Warnings: -Note 1003 with cte as (/* select#2 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1`)/* select#1 */ select `cte`.`a` AS `a` from `cte` union all /* select#3 */ select `federated`.`t3`.`a` AS `a` from `federated`.`t3` +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' WITH cte AS (SELECT * FROM federated.t1 UNION SELECT * FROM t3) SELECT * FROM cte; a @@ -1314,13 +1164,9 @@ t3_myisam3 explain extended WITH cte AS (SELECT * FROM federated.t1 UNION SELECT * FROM t3) SELECT * FROM cte; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 PRIMARY ALL NULL NULL NULL NULL 6 100.00 -2 DERIVED t1 ALL NULL NULL NULL NULL 3 100.00 -3 UNION t3 ALL NULL NULL NULL NULL 3 100.00 -NULL UNION RESULT ALL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 with cte as (/* select#2 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1` union /* select#3 */ select `federated`.`t3`.`a` AS `a` from `federated`.`t3`)/* select#1 */ select `cte`.`a` AS `a` from `cte` +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' # Two CTE's where one CTE refers to another WITH cte AS (SELECT * FROM federated.t1), cte2 AS (SELECT * FROM t3 @@ -1340,14 +1186,9 @@ cte2 AS (SELECT * FROM t3 WHERE t3.a NOT IN (SELECT * FROM cte)) SELECT * FROM cte JOIN cte2; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 PRIMARY ALL NULL NULL NULL NULL 3 100.00 -1 PRIMARY t3 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer (flat, BNL join) -5 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL NULL -4 MATERIALIZED ALL NULL NULL NULL NULL 3 100.00 -2 PUSHED DERIVED NULL NULL NULL NULL NULL NULL NULL NULL NULL -Warnings: -Note 1003 with cte as (/* select#2 */ select `federated`.`t1`.`a` AS `a` from `federated`.`t1`), cte2 as (/* select#3 */ select `federated`.`t3`.`a` AS `a` from `federated`.`t3` where !<`federated`.`t3`.`a`>((`federated`.`t3`.`a`,`federated`.`t3`.`a` in ( (/* select#4 */ select `cte`.`a` from `cte` ), (`federated`.`t3`.`a` in on distinct_key where `federated`.`t3`.`a` = ``.`a`)))))/* select#1 */ select `cte`.`a` AS `a`,`federated`.`t3`.`a` AS `a` from `cte` join `federated`.`t3` where !<`federated`.`t3`.`a`>((`federated`.`t3`.`a`,`federated`.`t3`.`a` in ( (/* select#4 */ select `cte`.`a` from `cte` ), (`federated`.`t3`.`a` in on distinct_key where `federated`.`t3`.`a` = ``.`a`)))) +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` varchar(10) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' connection master; DROP TABLES federated.t1, federated.t2, t3, t4, t5, t6, federated.t11, federated.t12, federated.t13, federated.t14; @@ -1397,49 +1238,9 @@ (select product_id from federated.product_tag limit 1000) t using (product_id) set brand=p.product_id, price=555, modified_dtm='2011-12-15 15:15:30', short_description=concat(short_description,modified_by); -EXPLAIN -{ - "query_block": { - "select_id": 1, - "cost": 1000.010933, - "nested_loop": [ - { - "table": { - "table_name": "p", - "access_type": "ALL", - "loops": 1, - "rows": 2, - "cost": 1000.010388, - "filtered": 100, - "attached_condition": "p.product_id is not null" - } - }, - { - "table": { - "table_name": "", - "access_type": "ref", - "possible_keys": ["key0"], - "key": "key0", - "key_length": "9", - "used_key_parts": ["product_id"], - "ref": ["federated.p.product_id"], - "loops": 2, - "rows": 1, - "cost": 0.000545388, - "filtered": 100, - "materialized": { - "query_block": { - "select_id": 2, - "table": { - "message": "Pushed derived" - } - } - } - } - } - ] - } -} +ReplayTest: Query error: CREATE TABLE `product_tag` ( + `product_id` bigint(20) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/product_tag': Unknown storage engine 'FEDERATED' update federated.product p join (select product_id from federated.product_tag limit 1000) t using (product_id) @@ -1476,37 +1277,9 @@ explain format=json update federated.t2 inner join federated.t1 on t2.id = t1.id set t2.op = 'updated', t2.op_count = t2.op_count + 1 where t2.id in (1, 2); -EXPLAIN -{ - "query_block": { - "select_id": 1, - "cost": 2000.022975, - "nested_loop": [ - { - "table": { - "table_name": "t2", - "access_type": "ALL", - "loops": 1, - "rows": 4, - "cost": 1000.010655, - "filtered": 100, - "attached_condition": "t2.`id` in (1,2)" - } - }, - { - "table": { - "table_name": "t1", - "access_type": "ALL", - "loops": 4, - "rows": 4, - "cost": 1000.012319, - "filtered": 100, - "attached_condition": "t1.`id` = t2.`id`" - } - } - ] - } -} +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' update federated.t2 inner join federated.t1 on t2.id = t1.id set t2.op = 'updated', t2.op_count = t2.op_count + 1 where t2.id in (1, 2); @@ -1530,37 +1303,9 @@ # Delete tests explain format=json delete federated.t2 from federated.t2 inner join federated.t1 on t2.id = t1.id and t2.op = 'updated'; -EXPLAIN -{ - "query_block": { - "select_id": 1, - "cost": 2000.023025, - "nested_loop": [ - { - "table": { - "table_name": "t2", - "access_type": "ALL", - "loops": 1, - "rows": 4, - "cost": 1000.010705, - "filtered": 100, - "attached_condition": "t2.op = 'updated'" - } - }, - { - "table": { - "table_name": "t1", - "access_type": "ALL", - "loops": 4, - "rows": 4, - "cost": 1000.012319, - "filtered": 100, - "attached_condition": "t1.`id` = t2.`id`" - } - } - ] - } -} +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) DEFAULT NULL +) ENGINE=FEDERATED DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CONNECTION='mysql://root@127.0.0.1:19001/federated/t1': Unknown storage engine 'FEDERATED' delete federated.t2 from federated.t2 inner join federated.t1 on t2.id = t1.id and t2.op = 'updated'; select * from federated.t2 order by id; id op op_count Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/federated.federatedx_create_handlers-X/' to '/home/ppandith/test2/bld/mysql-test/var/log/federated.federatedx_create_handlers-X/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2_fed` ( `pk` int(11) NOT NULL, PRIMARY KEY (`pk`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='s/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx.test" ReplayTest: At line 2080 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2_fed` ( `pk` int(11) NOT NULL, PRIMARY KEY (`pk`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='s/t2': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/federatedx.test" ReplayTest: At line 2083 federated.federatedx 'X' [ fail ] Test ended at 2026-07-24 16:55:11 CURRENT_TEST: federated.federatedx --- /home/ppandith/test2/mysql-test/suite/federated/federatedx.result 2026-03-16 21:34:29.225895007 +0530 +++ /home/ppandith/test2/mysql-test/suite/federated/federatedx.reject 2026-07-24 16:55:11.261915249 +0530 @@ -2338,18 +2338,20 @@ set optimizer_switch="materialization=off"; CREATE TABLE t2_fed ENGINE=FEDERATED CONNECTION='s/t2'; explain SELECT * FROM t2_fed WHERE pk IN ( SELECT a FROM t1 ); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t2_fed ALL NULL NULL NULL NULL 4 Using where -2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 3 Using where +ReplayTest: Query error: CREATE TABLE `t2_fed` ( + `pk` int(11) NOT NULL, + PRIMARY KEY (`pk`) +) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='s/t2': Unknown storage engine 'FEDERATED' SELECT * FROM t2_fed WHERE pk IN ( SELECT a FROM t1 ); pk 2 3 SET optimizer_switch='semijoin=off'; explain SELECT * FROM t2_fed WHERE pk IN ( SELECT a FROM t1 ); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t2_fed ALL NULL NULL NULL NULL 4 Using where -2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 3 Using where +ReplayTest: Query error: CREATE TABLE `t2_fed` ( + `pk` int(11) NOT NULL, + PRIMARY KEY (`pk`) +) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='s/t2': Unknown storage engine 'FEDERATED' SELECT * FROM t2_fed WHERE pk IN ( SELECT a FROM t1 ); pk 2 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/federated.federatedx-X/' to '/home/ppandith/test2/bld/mysql-test/var/log/federated.federatedx-X/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `fed_t1` ( `foo_id` bigint(20) unsigned NOT NULL, `foo_name` varchar(255) DEFAULT NULL, `parent_foo_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`foo_id`), KEY `foo_name` (`foo_name`), KEY `parent_foo_id` (`parent_foo_id`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='mysql://root@127.0.0.1:19000/test/t1': Unknown storage engine 'FEDERATED' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/federated/optimizer.test" ReplayTest: At line 34 federated.optimizer 'X' [ fail ] Test ended at 2026-07-24 16:55:12 CURRENT_TEST: federated.optimizer --- /home/ppandith/test2/mysql-test/suite/federated/optimizer.result 2026-04-23 16:48:24.959938399 +0530 +++ /home/ppandith/test2/mysql-test/suite/federated/optimizer.reject 2026-07-24 16:55:12.267944058 +0530 @@ -33,8 +33,14 @@ 822857 NULL STRING explain select foo_id,parent_foo_id,foo_name from fed_t1 where parent_foo_id = 822857 or foo_name like 'STRING%'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE fed_t1 ALL foo_name,parent_foo_id NULL NULL NULL 6 Using where +ReplayTest: Query error: CREATE TABLE `fed_t1` ( + `foo_id` bigint(20) unsigned NOT NULL, + `foo_name` varchar(255) DEFAULT NULL, + `parent_foo_id` bigint(20) unsigned DEFAULT NULL, + PRIMARY KEY (`foo_id`), + KEY `foo_name` (`foo_name`), + KEY `parent_foo_id` (`parent_foo_id`) +) ENGINE=FEDERATED DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci CONNECTION='mysql://root@127.0.0.1:19000/test/t1': Unknown storage engine 'FEDERATED' select foo_id,parent_foo_id,foo_name from fed_t1 where parent_foo_id = 822857 or foo_name like 'STRING%'; foo_id parent_foo_id foo_name 968903 822857 STRING - 0 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/federated.optimizer-X/' to '/home/ppandith/test2/bld/mysql-test/var/log/federated.optimizer-X/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AVG_ROW_LENGTH=10 `TABLE_TYPE`=CSV PARTITION BY RANGE (`id`) (PARTITION `first` VALUES LESS THAN (10) ENGINE = CONNECT, PARTITION `middle` VALUES LESS THAN (50) ENGINE = CONNECT, PARTITION `last` VALUES LESS THAN MAXVALUE ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 28 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AVG_ROW_LENGTH=10 `TABLE_TYPE`=CSV PARTITION BY RANGE (`id`) (PARTITION `first` VALUES LESS THAN (11) ENGINE = CONNECT, PARTITION `middle` VALUES LESS THAN (50) ENGINE = CONNECT, PARTITION `last` VALUES LESS THAN MAXVALUE ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 46 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' PARTITION BY RANGE COLUMNS(`id`) (PARTITIOReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 83 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' PARTITION BY RANGE COLUMNS(`id`) (PARTITIOReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 85 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' PARTITION BY RANGE COLUMNS(`id`) (PARTITIOReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 90 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, KEY `XID` (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' PARTITION BY RANGE COLUMNS(`id`) (PARTITION `1` VALUES LESS THAN (11) ENGINE = CONNECT, PARTITION `2` VALUES LESS THAN (70) ENGINE = CONNECT, PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 141 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' PARTITION BY RANGE COLUMNS(`id`) (PARTITION `1` VALUES LESS THAN (11) ENGINE = CONNECT, PARTITION `2` VALUES LESS THAN (70) ENGINE = CONNECT, PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_file.test" ReplayTest: At line 148 connect.part_file [ fail ] Test ended at 2026-07-24 16:55:13 CURRENT_TEST: connect.part_file --- /home/ppandith/test2/storage/connect/mysql-test/connect/r/part_file.result 2026-02-12 12:11:30.029533732 +0530 +++ /home/ppandith/test2/storage/connect/mysql-test/connect/r/part_file.reject 2026-07-24 16:55:13.286973238 +0530 @@ -33,8 +33,14 @@ 60 sixty 81 eighty one EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id > 50; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 last ALL NULL NULL NULL NULL 3 Using where +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AVG_ROW_LENGTH=10 `TABLE_TYPE`=CSV + PARTITION BY RANGE (`id`) +(PARTITION `first` VALUES LESS THAN (10) ENGINE = CONNECT, + PARTITION `middle` VALUES LESS THAN (50) ENGINE = CONNECT, + PARTITION `last` VALUES LESS THAN MAXVALUE ENGINE = CONNECT): Unknown storage engine 'CONNECT' SELECT * FROM t1 WHERE id > 50; id msg 60 sixty @@ -66,8 +72,14 @@ t1#P#last .csv t1#P#middle .csv EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id=10; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 first ALL NULL NULL NULL NULL 3 Using where +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AVG_ROW_LENGTH=10 `TABLE_TYPE`=CSV + PARTITION BY RANGE (`id`) +(PARTITION `first` VALUES LESS THAN (11) ENGINE = CONNECT, + PARTITION `middle` VALUES LESS THAN (50) ENGINE = CONNECT, + PARTITION `last` VALUES LESS THAN MAXVALUE ENGINE = CONNECT): Unknown storage engine 'CONNECT' SELECT * FROM t1 WHERE id=10; id msg 10 ten @@ -140,15 +152,33 @@ 3 3 3 t1 part3 72 seventy two 2 2 3 t1 part3 81 eighty one EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 2 const PRIMARY PRIMARY 4 const 1 -SELECT * FROM t1 WHERE id = 10; +ReplayTest: Query error: CREATE TABLE `t1` ( + `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, + `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, + `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, + `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, + `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITIOSELECT * FROM t1 WHERE id = 10; rwid rnum prtn tbn fid id msg 1 1 2 t1 part2 10 ten EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id >= 40; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 2,3 range PRIMARY PRIMARY 4 NULL 4 Using where -SELECT * FROM t1 WHERE id >= 40; +ReplayTest: Query error: CREATE TABLE `t1` ( + `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, + `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, + `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, + `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, + `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITIOSELECT * FROM t1 WHERE id >= 40; rwid rnum prtn tbn fid id msg 2 2 2 t1 part2 40 forty 1 1 3 t1 part3 60 sixty @@ -168,9 +198,18 @@ 2 4 3 3 EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id > 50; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 3 range PRIMARY PRIMARY 4 NULL 3 Using where -SELECT * FROM t1 WHERE id = 35; +ReplayTest: Query error: CREATE TABLE `t1` ( + `rwid` int(6) DEFAULT 0 `SPECIAL`=ROWID, + `rnum` int(6) DEFAULT 0 `SPECIAL`=ROWNUM, + `prtn` varchar(64) DEFAULT '' `SPECIAL`=PARTID, + `tbn` varchar(64) DEFAULT '' `SPECIAL`=TABID, + `fid` varchar(256) DEFAULT '' `SPECIAL`=FNAME, + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITIOSELECT * FROM t1 WHERE id = 35; rwid rnum prtn tbn fid id msg 4 4 2 t1 part2 35 thirty five SELECT * FROM dr1 ORDER BY fname, ftype; @@ -305,8 +344,15 @@ part3 .fnx part3 .txt EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 1 ref XID XID 4 const 1 +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + KEY `XID` (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITION `1` VALUES LESS THAN (11) ENGINE = CONNECT, + PARTITION `2` VALUES LESS THAN (70) ENGINE = CONNECT, + PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' DROP INDEX XID ON t1; SHOW INDEX FROM t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored @@ -328,8 +374,15 @@ part3 .fnx part3 .txt EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 1 const PRIMARY PRIMARY 4 const 1 +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='part%s.txt' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITION `1` VALUES LESS THAN (11) ENGINE = CONNECT, + PARTITION `2` VALUES LESS THAN (70) ENGINE = CONNECT, + PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' ALTER TABLE t1 DROP PRIMARY KEY; SHOW INDEX FROM t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/connect.part_file/' to '/home/ppandith/test2/bld/mysql-test/var/log/connect.part_file/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `TABLE_TYPE`=PROXY `TABNAME`='xt%s' PARTITION BY RANGE COLUMNS(`id`) (PARTITION `1` VALUES LESS THAN (10) ENGINE = CONNECT, PARTITION `2` VALUES LESS THAN (50) ENGINE = CONNECT, PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_table.test" ReplayTest: At line 50 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `id` int(11) NOT NULL, `msg` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `TABLE_TYPE`=MYSQL `TABNAME`='xt%s' PARTITION BY RANGE COLUMNS(`id`) (PARTITION `1` VALUES LESS THAN (10) ENGINE = CONNECT, PARTITION `2` VALUES LESS THAN (50) ENGINE = CONNECT, PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/part_table.test" ReplayTest: At line 73 connect.part_table [ fail ] Test ended at 2026-07-24 16:55:17 CURRENT_TEST: connect.part_table --- /home/ppandith/test2/storage/connect/mysql-test/connect/r/part_table.result 2026-02-12 12:11:30.029533732 +0530 +++ /home/ppandith/test2/storage/connect/mysql-test/connect/r/part_table.reject 2026-07-24 16:55:16.726071719 +0530 @@ -91,8 +91,14 @@ 72 seventy two EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 81; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 3 ALL NULL NULL NULL NULL 6 Using where +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL +) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `TABLE_TYPE`=PROXY `TABNAME`='xt%s' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITION `1` VALUES LESS THAN (10) ENGINE = CONNECT, + PARTITION `2` VALUES LESS THAN (50) ENGINE = CONNECT, + PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' DELETE FROM t1; Warnings: Note 1105 xt1: 4 affected rows @@ -136,8 +142,15 @@ 60 sixty 81 eighty one EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 81; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 3 const PRIMARY PRIMARY 4 const 1 +ReplayTest: Query error: CREATE TABLE `t1` ( + `id` int(11) NOT NULL, + `msg` varchar(32) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `TABLE_TYPE`=MYSQL `TABNAME`='xt%s' + PARTITION BY RANGE COLUMNS(`id`) +(PARTITION `1` VALUES LESS THAN (10) ENGINE = CONNECT, + PARTITION `2` VALUES LESS THAN (50) ENGINE = CONNECT, + PARTITION `3` VALUES LESS THAN (MAXVALUE) ENGINE = CONNECT): Unknown storage engine 'CONNECT' SELECT * FROM t1 WHERE id = 7; id msg 7 seven Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/connect.part_table/' to '/home/ppandith/test2/bld/mysql-test/var/log/connect.part_table/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `sexe` int(1) NOT NULL, `genre` char(8) NOT NULL, PRIMARY KEY (`sexe`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=CSV `FILE_NAME`='sexe.csv' `SEP_CHAR`=';' `ENDING`=2: Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/index.test" ReplayTest: At line 62 connect.index [ fail ] Test ended at 2026-07-24 16:55:18 CURRENT_TEST: connect.index --- /home/ppandith/test2/storage/connect/mysql-test/connect/r/index.result 2026-02-12 12:11:30.028145714 +0530 +++ /home/ppandith/test2/storage/connect/mysql-test/connect/r/index.reject 2026-07-24 16:55:17.895105194 +0530 @@ -99,9 +99,11 @@ # t2 has only 3 rows. Force eq_ref by increasing table scan cost! set @@optimizer_scan_setup_cost=10000; explain SELECT nom, prenom, genre FROM t1 NATURAL JOIN t2 order by nom,prenom LIMIT 10; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 4545 Using filesort -1 SIMPLE t2 eq_ref PRIMARY PRIMARY 4 test.t1.sexe 1 Using where +ReplayTest: Query error: CREATE TABLE `t2` ( + `sexe` int(1) NOT NULL, + `genre` char(8) NOT NULL, + PRIMARY KEY (`sexe`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=CSV `FILE_NAME`='sexe.csv' `SEP_CHAR`=';' `ENDING`=2: Unknown storage engine 'CONNECT' SELECT nom, prenom, genre FROM t1 NATURAL JOIN t2 order by nom,prenom LIMIT 10; nom prenom genre ABBADIE MONIQUE Feminin Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/connect.index/' to '/home/ppandith/test2/bld/mysql-test/var/log/connect.index/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `id` int(11) NOT NULL, `msg` char(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=MYSQL `TABNAME`=t1: Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/mysql_index.test" ReplayTest: At line 57 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `matricule` int(4) NOT NULL, `nom` varchar(16) NOT NULL, `prenom` varchar(20) NOT NULL, `sexe` smallint(1) NOT NULL, `aanais` int(4) NOT NULL, `mmnais` int(2) NOT NULL, `ddentree` date NOT NULL `date_format`='YYYYMM', `ddnom` date NOT NULL `date_format`='YYYYMM', `brut` int(5) NOT NULL, `net` double(8,2) NOT NULL, `service` int(2) NOT NULL, `sitmat` char(1) NOT NULL, `formation` char(5) NOT NULL, PRIMARY KEY (`matricule`), KEY `NP` ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/mysql_index.test" ReplayTest: At line 117 connect.mysql_index [ fail ] Test ended at 2026-07-24 16:55:20 CURRENT_TEST: connect.mysql_index --- /home/ppandith/test2/storage/connect/mysql-test/connect/r/mysql_index.result 2026-02-12 12:11:30.028533772 +0530 +++ /home/ppandith/test2/storage/connect/mysql-test/connect/r/mysql_index.reject 2026-07-24 16:55:20.616183114 +0530 @@ -70,8 +70,11 @@ 6 Six 7 seven explain SELECT * FROM t2 WHERE id <= 3; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range PRIMARY PRIMARY 4 NULL 2 Using where +ReplayTest: Query error: CREATE TABLE `t2` ( + `id` int(11) NOT NULL, + `msg` char(100) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=MYSQL `TABNAME`=t1: Unknown storage engine 'CONNECT' SELECT * FROM t2 WHERE id <= 3; id msg 1 Un @@ -183,9 +186,22 @@ 4080 FOCH SERGE 3368 MOGADOR ALAIN explain SELECT matricule, nom, prenom FROM t2 WHERE nom IN ('FOCH','MOGADOR'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range NP NP 18 NULL 4 Using where -SELECT matricule, nom, prenom FROM t2 WHERE nom = 'FOCH' OR nom = 'MOGADOR'; +ReplayTest: Query error: CREATE TABLE `t2` ( + `matricule` int(4) NOT NULL, + `nom` varchar(16) NOT NULL, + `prenom` varchar(20) NOT NULL, + `sexe` smallint(1) NOT NULL, + `aanais` int(4) NOT NULL, + `mmnais` int(2) NOT NULL, + `ddentree` date NOT NULL `date_format`='YYYYMM', + `ddnom` date NOT NULL `date_format`='YYYYMM', + `brut` int(5) NOT NULL, + `net` double(8,2) NOT NULL, + `service` int(2) NOT NULL, + `sitmat` char(1) NOT NULL, + `formation` char(5) NOT NULL, + PRIMARY KEY (`matricule`), + KEY `NP` SELECT matricule, nom, prenom FROM t2 WHERE nom = 'FOCH' OR nom = 'MOGADOR'; matricule nom prenom 1977 FOCH BERNADETTE 5707 FOCH DENIS Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/connect.mysql_index/' to '/home/ppandith/test2/bld/mysql-test/var/log/connect.mysql_index/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `_id` int(2) NOT NULL, `name_first` char(9) NOT NULL `JPATH`='$.name.first', `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', `name_last` char(10) NOT NULL `JPATH`='$.name.last', `title` char(12) DEFAULT NULL, `birth` char(20) DEFAULT NULL, `death` char(20) DEFAULT NULL, `contribs` char(50) NOT NULL `JPATH`='$.contribs', `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 199 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `_id` int(2) NOT NULL, `name_first` char(9) NOT NULL `JPATH`='$.name.first', `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', `name_last` char(10) NOT NULL `JPATH`='$.name.last', `title` char(12) DEFAULT NULL, `birth` char(20) DEFAULT NULL, `death` char(20) DEFAULT NULL, `contribs` char(50) NOT NULL `JPATH`='$.contribs', `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 210 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `name` char(12) NOT NULL, `city` char(11) NOT NULL, `birth` date NOT NULL `date_format`='DD/MM/YYYY', `hired` date NOT NULL `date_format`='DD/MM/YYYY' `flag`=36 ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='boys.txt' `ENDING`=1: Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 220 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `_id` int(2) NOT NULL, `name_first` char(9) NOT NULL `JPATH`='$.name.first', `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', `name_last` char(10) NOT NULL `JPATH`='$.name.last', `title` char(12) DEFAULT NULL, `birth` char(20) DEFAULT NULL, `death` char(20) DEFAULT NULL, `contribs` char(50) NOT NULL `JPATH`='$.contribs', `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 226 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t2` ( `_id` int(2) NOT NULL, `name_first` char(9) NOT NULL `JPATH`='$.name.first', `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', `name_last` char(10) NOT NULL `JPATH`='$.name.last', `title` char(12) DEFAULT NULL, `birth` char(20) DEFAULT NULL, `death` char(20) DEFAULT NULL, `contribs` char(50) NOT NULL `JPATH`='$.contribs', `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 234 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `name` char(12) NOT NULL, `city` char(11) NOT NULL, `birth` date NOT NULL `date_format`='DD/MM/YYYY', `hired` date NOT NULL `date_format`='DD/MM/YYYY' `flag`=36 ) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='boys.txt' `ENDING`=1: Unknown storage engine 'CONNECT' ReplayTest: In file "/home/ppandith/test2/storage/connect/mysql-test/connect/t/upd.test" ReplayTest: At line 239 connect.upd [ fail ] Test ended at 2026-07-24 16:55:22 CURRENT_TEST: connect.upd --- /home/ppandith/test2/storage/connect/mysql-test/connect/r/upd.result 2026-02-12 12:11:30.029533732 +0530 +++ /home/ppandith/test2/storage/connect/mysql-test/connect/r/upd.reject 2026-07-24 16:55:21.759215846 +0530 @@ -1679,10 +1679,17 @@ explain update t1, t2 set t1.city='Washington', t2.name_aka='von' where t1.name=t2.name_first and t1.birth BETWEEN '1992-01-01' and '1995-01-01'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using where -1 SIMPLE t2 ALL NULL NULL NULL NULL 10 Using where -update t1, t2 +ReplayTest: Query error: CREATE TABLE `t2` ( + `_id` int(2) NOT NULL, + `name_first` char(9) NOT NULL `JPATH`='$.name.first', + `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', + `name_last` char(10) NOT NULL `JPATH`='$.name.last', + `title` char(12) DEFAULT NULL, + `birth` char(20) DEFAULT NULL, + `death` char(20) DEFAULT NULL, + `contribs` char(50) NOT NULL `JPATH`='$.contribs', + `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', + `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeupdate t1, t2 set t1.city='Washington', t2.name_aka='von' where t1.name=t2.name_first and t1.birth BETWEEN '1992-01-01' and '1995-01-01'; select t1.name, t2.name_last, t2.name_aka, t1.city from t1, t2 where t1.name=t2.name_first and t1.birth @@ -1700,10 +1707,17 @@ Bill Boston explain update t1 set t1.city='New York' where t1.name in (select t2.name_first from t2); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 6 -1 PRIMARY t2 ALL NULL NULL NULL NULL 10 Using where; FirstMatch(t1) -update t1 +ReplayTest: Query error: CREATE TABLE `t2` ( + `_id` int(2) NOT NULL, + `name_first` char(9) NOT NULL `JPATH`='$.name.first', + `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', + `name_last` char(10) NOT NULL `JPATH`='$.name.last', + `title` char(12) DEFAULT NULL, + `birth` char(20) DEFAULT NULL, + `death` char(20) DEFAULT NULL, + `contribs` char(50) NOT NULL `JPATH`='$.contribs', + `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', + `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yeupdate t1 set t1.city='New York' where t1.name in (select t2.name_first from t2); select t1.name, t1.city from t1; name city @@ -1719,9 +1733,12 @@ George San Jose explain update t1 set t1.city='Los Angeles' where t1.name in (select a.name from t1 as a where a.birth BETWEEN '1981-01-01' and '1982-01-01'); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 6 -1 PRIMARY a ALL NULL NULL NULL NULL 6 Using where; FirstMatch(t1) +ReplayTest: Query error: CREATE TABLE `t1` ( + `name` char(12) NOT NULL, + `city` char(11) NOT NULL, + `birth` date NOT NULL `date_format`='DD/MM/YYYY', + `hired` date NOT NULL `date_format`='DD/MM/YYYY' `flag`=36 +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='boys.txt' `ENDING`=1: Unknown storage engine 'CONNECT' update t1 set t1.city='Los Angeles' where t1.name in (select a.name from t1 as a where a.birth BETWEEN '1981-01-01' and '1982-01-01'); select t1.name, t1.city from t1 where t1.name in (select a.name from t1 as a where a.birth @@ -1731,10 +1748,17 @@ # Multi-delete explain delete t1.*, t2.* from t1, t2 where t1.name=t2.name_first and t1.birth BETWEEN '1992-01-01' and '1995-01-01'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using where -1 SIMPLE t2 ALL NULL NULL NULL NULL 10 Using where -delete t1.*, t2.* from t1, t2 where t1.name=t2.name_first and t1.birth +ReplayTest: Query error: CREATE TABLE `t2` ( + `_id` int(2) NOT NULL, + `name_first` char(9) NOT NULL `JPATH`='$.name.first', + `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', + `name_last` char(10) NOT NULL `JPATH`='$.name.last', + `title` char(12) DEFAULT NULL, + `birth` char(20) DEFAULT NULL, + `death` char(20) DEFAULT NULL, + `contribs` char(50) NOT NULL `JPATH`='$.contribs', + `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', + `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yedelete t1.*, t2.* from t1, t2 where t1.name=t2.name_first and t1.birth BETWEEN '1992-01-01' and '1995-01-01'; select t1.name, t1.city from t1; name city @@ -1756,10 +1780,17 @@ 10 Martin NULL Odersky # Conversion to multi-delete explain delete from t1 where t1.name in (select t2.name_first from t2); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 5 -1 PRIMARY t2 ALL NULL NULL NULL NULL 9 Using where; FirstMatch(t1) -delete from t1 where t1.name in (select t2.name_first from t2); +ReplayTest: Query error: CREATE TABLE `t2` ( + `_id` int(2) NOT NULL, + `name_first` char(9) NOT NULL `JPATH`='$.name.first', + `name_aka` char(4) DEFAULT NULL `JPATH`='$.name.aka', + `name_last` char(10) NOT NULL `JPATH`='$.name.last', + `title` char(12) DEFAULT NULL, + `birth` char(20) DEFAULT NULL, + `death` char(20) DEFAULT NULL, + `contribs` char(50) NOT NULL `JPATH`='$.contribs', + `awards_award` char(42) DEFAULT NULL `JPATH`='$.awards.award', + `awards_year` char(4) DEFAULT NULL `JPATH`='$.awards.yedelete from t1 where t1.name in (select t2.name_first from t2); select t1.name, t1.city from t1; name city Henry Boston @@ -1768,9 +1799,12 @@ Bill Boston explain delete from t1 where t1.name in (select a.name from t1 as a where a.birth BETWEEN '1981-01-01' and '1982-01-01'); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 4 -1 PRIMARY a ALL NULL NULL NULL NULL 4 Using where; FirstMatch(t1) +ReplayTest: Query error: CREATE TABLE `t1` ( + `name` char(12) NOT NULL, + `city` char(11) NOT NULL, + `birth` date NOT NULL `date_format`='DD/MM/YYYY', + `hired` date NOT NULL `date_format`='DD/MM/YYYY' `flag`=36 +) ENGINE=CONNECT DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `TABLE_TYPE`=FIX `FILE_NAME`='boys.txt' `ENDING`=1: Unknown storage engine 'CONNECT' delete from t1 where t1.name in (select a.name from t1 as a where a.birth BETWEEN '1981-01-01' and '1982-01-01'); select t1.name, t1.city from t1; Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/connect.upd/' to '/home/ppandith/test2/bld/mysql-test/var/log/connect.upd/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_32907.test" ReplayTest: At line 16 spider/bugfix.mdev_32907 'group_by_handler' [ fail ] Test ended at 2026-07-24 16:55:23 CURRENT_TEST: spider/bugfix.mdev_32907 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_32907.result 2026-02-12 12:11:30.239525353 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_32907.reject 2026-07-24 16:55:22.813246028 +0530 @@ -11,8 +11,9 @@ Warning 138 Spider table params in COMMENT or CONNECTION strings have been deprecated and will be removed in a future release. Please use table options instead. insert into t1 values (3), (NULL); explain select nvl(sum(c), 0) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select nvl(sum(c), 0) from t1; nvl(sum(c), 0) 3 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.mdev_32907-group_by_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.mdev_32907-group_by_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `product_tag_spider` ( `product_id` bigint(20) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=product_tag: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 49 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( `id` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 73 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( `id` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 86 spider/bugfix.mdev_37484 'group_by_handler' [ fail ] Test ended at 2026-07-24 16:55:25 CURRENT_TEST: spider/bugfix.mdev_37484 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_37484.result 2026-02-12 12:19:17.174544635 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_37484.reject 2026-07-24 16:55:24.595297058 +0530 @@ -38,10 +38,9 @@ (select product_id from product_tag_spider limit 1000) t using (product_id) set brand=p.product_id, price=555, modified_dtm='2011-12-15 15:15:30', short_description=concat(short_description,modified_by); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY p ALL NULL NULL NULL NULL 2 Using where with pushed condition -1 PRIMARY ref key0 key0 9 test.p.product_id 1 -2 DERIVED product_tag_spider ALL NULL NULL NULL NULL 4 +ReplayTest: Query error: CREATE TABLE `product_tag_spider` ( + `product_id` bigint(20) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=product_tag: Unknown storage engine 'SPIDER' update product_spider p join (select product_id from product_tag_spider limit 1000) t using (product_id) @@ -68,9 +67,9 @@ explain update t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id set t2_SPIDER.op = 'updated', t2_SPIDER.op_count = t2_SPIDER.op_count + 1 where t2_SPIDER.id in (1, 2); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2_SPIDER ALL NULL NULL NULL NULL 4 Using where with pushed condition -1 SIMPLE t1_SPIDER ALL NULL NULL NULL NULL 4 Using where +ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( + `id` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' update t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id set t2_SPIDER.op = 'updated', t2_SPIDER.op_count = t2_SPIDER.op_count + 1 where t2_SPIDER.id in (1, 2); @@ -93,9 +92,9 @@ # Delete tests explain delete t2_SPIDER from t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id and t2_SPIDER.op = 'updated'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2_SPIDER ALL NULL NULL NULL NULL 4 Using where with pushed condition -1 SIMPLE t1_SPIDER ALL NULL NULL NULL NULL 4 Using where +ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( + `id` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' delete t2_SPIDER from t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id and t2_SPIDER.op = 'updated'; select * from t2_SPIDER order by id; id op op_count Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.mdev_37484-group_by_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.mdev_37484-group_by_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_32907.test" ReplayTest: At line 16 spider/bugfix.mdev_32907 'usual_handler' [ fail ] Test ended at 2026-07-24 16:55:26 CURRENT_TEST: spider/bugfix.mdev_32907 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_32907.result 2026-02-12 12:11:30.239525353 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_32907.reject 2026-07-24 16:55:25.916334887 +0530 @@ -11,8 +11,9 @@ Warning 138 Spider table params in COMMENT or CONNECTION strings have been deprecated and will be removed in a future release. Please use table options instead. insert into t1 values (3), (NULL); explain select nvl(sum(c), 0) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select nvl(sum(c), 0) from t1; nvl(sum(c), 0) 3 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.mdev_32907-usual_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.mdev_32907-usual_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `product_tag_spider` ( `product_id` bigint(20) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=product_tag: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 49 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( `id` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 73 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( `id` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/mdev_37484.test" ReplayTest: At line 86 spider/bugfix.mdev_37484 'usual_handler' [ fail ] Test ended at 2026-07-24 16:55:28 CURRENT_TEST: spider/bugfix.mdev_37484 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_37484.result 2026-02-12 12:19:17.174544635 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/mdev_37484.reject 2026-07-24 16:55:27.751387434 +0530 @@ -38,10 +38,9 @@ (select product_id from product_tag_spider limit 1000) t using (product_id) set brand=p.product_id, price=555, modified_dtm='2011-12-15 15:15:30', short_description=concat(short_description,modified_by); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY p ALL NULL NULL NULL NULL 2 Using where with pushed condition -1 PRIMARY ref key0 key0 9 test.p.product_id 1 -2 DERIVED product_tag_spider ALL NULL NULL NULL NULL 4 +ReplayTest: Query error: CREATE TABLE `product_tag_spider` ( + `product_id` bigint(20) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=product_tag: Unknown storage engine 'SPIDER' update product_spider p join (select product_id from product_tag_spider limit 1000) t using (product_id) @@ -68,9 +67,9 @@ explain update t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id set t2_SPIDER.op = 'updated', t2_SPIDER.op_count = t2_SPIDER.op_count + 1 where t2_SPIDER.id in (1, 2); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2_SPIDER ALL NULL NULL NULL NULL 4 Using where with pushed condition -1 SIMPLE t1_SPIDER ALL NULL NULL NULL NULL 4 Using where +ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( + `id` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' update t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id set t2_SPIDER.op = 'updated', t2_SPIDER.op_count = t2_SPIDER.op_count + 1 where t2_SPIDER.id in (1, 2); @@ -93,9 +92,9 @@ # Delete tests explain delete t2_SPIDER from t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id and t2_SPIDER.op = 'updated'; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2_SPIDER ALL NULL NULL NULL NULL 4 Using where with pushed condition -1 SIMPLE t1_SPIDER ALL NULL NULL NULL NULL 4 Using where +ReplayTest: Query error: CREATE TABLE `t1_SPIDER` ( + `id` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci `REMOTE_SERVER`=s `REMOTE_TABLE`=t1: Unknown storage engine 'SPIDER' delete t2_SPIDER from t2_SPIDER inner join t1_SPIDER on t2_SPIDER.id = t1_SPIDER.id and t2_SPIDER.op = 'updated'; select * from t2_SPIDER order by id; id op op_count Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.mdev_37484-usual_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.mdev_37484-usual_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `tbl_b` ( `pkey` int(11) NOT NULL, PRIMARY KEY (`pkey`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='table "tbl_b", srv "s_2_2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/quick_mode_1.test" ReplayTest: At line 89 spider/bugfix.quick_mode_1 'group_by_handler' [ fail ] Test ended at 2026-07-24 16:55:30 CURRENT_TEST: spider/bugfix.quick_mode_1 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/quick_mode_1.result 2026-02-12 12:11:30.239525353 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/quick_mode_1.reject 2026-07-24 16:55:29.757444878 +0530 @@ -62,9 +62,10 @@ TRUNCATE TABLE mysql.general_log; connection master_1; explain SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE a index PRIMARY PRIMARY 4 NULL 2 Using index -1 SIMPLE b eq_ref PRIMARY PRIMARY 4 auto_test_local.a.pkey 1 Using index +ReplayTest: Query error: CREATE TABLE `tbl_b` ( + `pkey` int(11) NOT NULL, + PRIMARY KEY (`pkey`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='table "tbl_b", srv "s_2_2"': Unknown storage engine 'SPIDER' SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; pkey 0 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.quick_mode_1-group_by_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.quick_mode_1-group_by_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `tbl_b` ( `pkey` int(11) NOT NULL, PRIMARY KEY (`pkey`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='table "tbl_b", srv "s_2_2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/t/quick_mode_1.test" ReplayTest: At line 89 spider/bugfix.quick_mode_1 'usual_handler' [ fail ] Test ended at 2026-07-24 16:55:32 CURRENT_TEST: spider/bugfix.quick_mode_1 --- /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/quick_mode_1.result 2026-02-12 12:11:30.239525353 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/bugfix/r/quick_mode_1.reject 2026-07-24 16:55:31.836504413 +0530 @@ -62,9 +62,10 @@ TRUNCATE TABLE mysql.general_log; connection master_1; explain SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE a index PRIMARY PRIMARY 4 NULL 2 Using index -1 SIMPLE b eq_ref PRIMARY PRIMARY 4 auto_test_local.a.pkey 1 Using index +ReplayTest: Query error: CREATE TABLE `tbl_b` ( + `pkey` int(11) NOT NULL, + PRIMARY KEY (`pkey`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='table "tbl_b", srv "s_2_2"': Unknown storage engine 'SPIDER' SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; pkey 0 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/bugfix.quick_mode_1-usual_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/bugfix.quick_mode_1-usual_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 20 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 26 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 32 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 38 spider/feature.pushdown_case 'group_by_handler' [ fail ] Test ended at 2026-07-24 16:55:33 CURRENT_TEST: spider/feature.pushdown_case --- /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_case.result 2026-02-12 12:11:30.245843563 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_case.reject 2026-07-24 16:55:33.333547282 +0530 @@ -14,8 +14,9 @@ Warning 138 Spider table params in COMMENT or CONNECTION strings have been deprecated and will be removed in a future release. Please use table options instead. insert into t1 values (42), (3), (848), (100); explain select case c when 3 then "three" when 42 then "answer" else "other" end as exp from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case c when 3 then "three" when 42 then "answer" else "other" end as exp from t1; exp answer @@ -23,8 +24,9 @@ other other explain select case c when 3 then "three" when 42 then "answer" end from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case c when 3 then "three" when 42 then "answer" end from t1; case c when 3 then "three" when 42 then "answer" end answer @@ -32,8 +34,9 @@ NULL NULL explain select case when c = 3 then "three" when c = 42 then "answer" else "other" end as exp from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case when c = 3 then "three" when c = 42 then "answer" else "other" end as exp from t1; exp answer @@ -41,8 +44,9 @@ other other explain select case when c = 3 then "three" when c = 42 then "answer" end from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case when c = 3 then "three" when c = 42 then "answer" end from t1; case when c = 3 then "three" when c = 42 then "answer" end answer Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/feature.pushdown_case-group_by_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/feature.pushdown_case-group_by_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 35 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 41 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 47 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 53 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 59 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 65 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 71 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 77 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 83 spider/feature.pushdown_timestamp_diff 'group_by_handler' [ fail ] Test ended at 2026-07-24 16:55:35 CURRENT_TEST: spider/feature.pushdown_timestamp_diff --- /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_timestamp_diff.result 2026-02-12 12:11:30.245843563 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_timestamp_diff.reject 2026-07-24 16:55:34.994594847 +0530 @@ -27,8 +27,12 @@ (3, 'c', '2013-11-01 01:01:01'); interval year explain select a, b, timestampdiff(year, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(year, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(year, '2000-01-01 00:00:00', c) 1 a 18 @@ -36,8 +40,12 @@ 3 c 13 interval quarter explain select a, b, timestampdiff(quarter, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(quarter, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(quarter, '2000-01-01 00:00:00', c) 1 a 75 @@ -45,8 +53,12 @@ 3 c 55 interval month explain select a, b, timestampdiff(month, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(month, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(month, '2000-01-01 00:00:00', c) 1 a 226 @@ -54,8 +66,12 @@ 3 c 166 interval week explain select a, b, timestampdiff(week, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(week, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(week, '2000-01-01 00:00:00', c) 1 a 982 @@ -63,8 +79,12 @@ 3 c 721 interval day explain select a, b, timestampdiff(day, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(day, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(day, '2000-01-01 00:00:00', c) 1 a 6879 @@ -72,8 +92,12 @@ 3 c 5053 internal hour explain select a, b, timestampdiff(hour, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(hour, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(hour, '2000-01-01 00:00:00', c) 1 a 165106 @@ -81,8 +105,12 @@ 3 c 121273 internal minute explain select a, b, timestampdiff(minute, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(minute, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(minute, '2000-01-01 00:00:00', c) 1 a 9906381 @@ -90,8 +118,12 @@ 3 c 7276381 internal second explain select a, b, timestampdiff(second, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(second, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(second, '2000-01-01 00:00:00', c) 1 a 594382899 @@ -99,8 +131,12 @@ 3 c 436582861 internal microsecond explain select a, b, timestampdiff(microsecond, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Storage engine handles GROUP BY +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(microsecond, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(microsecond, '2000-01-01 00:00:00', c) 1 a 594382899000000 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/feature.pushdown_timestamp_diff-group_by_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/feature.pushdown_timestamp_diff-group_by_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 20 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 26 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 32 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_case.test" ReplayTest: At line 38 spider/feature.pushdown_case 'usual_handler' [ fail ] Test ended at 2026-07-24 16:55:37 CURRENT_TEST: spider/feature.pushdown_case --- /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_case,usual_handler.result~ 2026-07-24 16:55:35.866619818 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_case,usual_handler.reject 2026-07-24 16:55:36.464636942 +0530 @@ -14,8 +14,9 @@ Warning 138 Spider table params in COMMENT or CONNECTION strings have been deprecated and will be removed in a future release. Please use table options instead. insert into t1 values (42), (3), (848), (100); explain select case c when 3 then "three" when 42 then "answer" else "other" end as exp from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case c when 3 then "three" when 42 then "answer" else "other" end as exp from t1; exp answer @@ -23,8 +24,9 @@ other other explain select case c when 3 then "three" when 42 then "answer" end from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case c when 3 then "three" when 42 then "answer" end from t1; case c when 3 then "three" when 42 then "answer" end answer @@ -32,8 +34,9 @@ NULL NULL explain select case when c = 3 then "three" when c = 42 then "answer" else "other" end as exp from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case when c = 3 then "three" when c = 42 then "answer" else "other" end as exp from t1; exp answer @@ -41,8 +44,9 @@ other other explain select case when c = 3 then "three" when c = 42 then "answer" end from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `c` int(11) DEFAULT NULL +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select case when c = 3 then "three" when c = 42 then "answer" end from t1; case when c = 3 then "three" when c = 42 then "answer" end answer Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/feature.pushdown_case-usual_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/feature.pushdown_case-usual_handler/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 35 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 41 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 47 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 53 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 59 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 65 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 71 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 77 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` char(1) DEFAULT NULL, `c` datetime DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' ReplayTest: In file "/home/ppandith/test2/storage/spider/mysql-test/spider/feature/t/pushdown_timestamp_diff.test" ReplayTest: At line 83 spider/feature.pushdown_timestamp_diff 'usual_handler' [ fail ] Test ended at 2026-07-24 16:55:38 CURRENT_TEST: spider/feature.pushdown_timestamp_diff --- /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_timestamp_diff,usual_handler.result~ 2026-07-24 16:55:37.335661885 +0530 +++ /home/ppandith/test2/storage/spider/mysql-test/spider/feature/r/pushdown_timestamp_diff,usual_handler.reject 2026-07-24 16:55:38.193686455 +0530 @@ -27,8 +27,12 @@ (3, 'c', '2013-11-01 01:01:01'); interval year explain select a, b, timestampdiff(year, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(year, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(year, '2000-01-01 00:00:00', c) 1 a 18 @@ -36,8 +40,12 @@ 3 c 13 interval quarter explain select a, b, timestampdiff(quarter, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(quarter, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(quarter, '2000-01-01 00:00:00', c) 1 a 75 @@ -45,8 +53,12 @@ 3 c 55 interval month explain select a, b, timestampdiff(month, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(month, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(month, '2000-01-01 00:00:00', c) 1 a 226 @@ -54,8 +66,12 @@ 3 c 166 interval week explain select a, b, timestampdiff(week, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(week, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(week, '2000-01-01 00:00:00', c) 1 a 982 @@ -63,8 +79,12 @@ 3 c 721 interval day explain select a, b, timestampdiff(day, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(day, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(day, '2000-01-01 00:00:00', c) 1 a 6879 @@ -72,8 +92,12 @@ 3 c 5053 internal hour explain select a, b, timestampdiff(hour, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(hour, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(hour, '2000-01-01 00:00:00', c) 1 a 165106 @@ -81,8 +105,12 @@ 3 c 121273 internal minute explain select a, b, timestampdiff(minute, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(minute, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(minute, '2000-01-01 00:00:00', c) 1 a 9906381 @@ -90,8 +118,12 @@ 3 c 7276381 internal second explain select a, b, timestampdiff(second, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(second, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(second, '2000-01-01 00:00:00', c) 1 a 594382899 @@ -99,8 +131,12 @@ 3 c 436582861 internal microsecond explain select a, b, timestampdiff(microsecond, '2000-01-01 00:00:00', c) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL NULL NULL NULL NULL 2 +ReplayTest: Query error: CREATE TABLE `t1` ( + `a` int(11) NOT NULL, + `b` char(1) DEFAULT NULL, + `c` datetime DEFAULT NULL, + PRIMARY KEY (`a`) +) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='WRAPPER "mysql", srv "srv",TABLE "t2"': Unknown storage engine 'SPIDER' select a, b, timestampdiff(microsecond, '2000-01-01 00:00:00', c) from t1; a b timestampdiff(microsecond, '2000-01-01 00:00:00', c) 1 a 594382899000000 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/spider/feature.pushdown_timestamp_diff-usual_handler/' to '/home/ppandith/test2/bld/mysql-test/var/log/feature.pushdown_timestamp_diff-usual_handler/' ReplayTest: Loading context ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `diaries_mroonga` ( `id` int(11) NOT NULL AUTO_INCREMENT, `body` text DEFAULT NULL, `flag` tinyint(2) DEFAULT NULL, PRIMARY KEY (`id`), KEY `flag` (`flag`) ) ENGINE=Mroonga AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='ENGINE "InnoDB"': Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/wrapper/t/count_star_with_index.test" ReplayTest: At line 52 mroonga/wrapper.count_star_with_index [ fail ] Test ended at 2026-07-24 16:55:40 CURRENT_TEST: mroonga/wrapper.count_star_with_index --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.result 2026-02-12 12:11:30.145832755 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/wrapper/r/count_star_with_index.reject 2026-07-24 16:55:39.436722050 +0530 @@ -20,7 +20,12 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE diaries_innodb index NULL flag 2 NULL # Using index EXPLAIN SELECT COUNT(*) FROM diaries_mroonga; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE diaries_mroonga index NULL flag 2 NULL # Using index +ReplayTest: Query error: CREATE TABLE `diaries_mroonga` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `body` text DEFAULT NULL, + `flag` tinyint(2) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `flag` (`flag`) +) ENGINE=Mroonga AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci COMMENT='ENGINE "InnoDB"': Unknown storage engine 'Mroonga' DROP TABLE diaries_innodb; DROP TABLE diaries_mroonga; Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/wrapper.count_star_with_index/' to '/home/ppandith/test2/bld/mysql-test/var/log/wrapper.count_star_with_index/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` double NOT NULL, `c3` char(255) NOT NULL ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/archive/rnd_pos.test" ReplayTest: At line 10 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` double NOT NULL, `c3` char(255) NOT NULL ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/archive/rnd_pos.test" ReplayTest: At line 12 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` double NOT NULL, `c3` char(255) NOT NULL ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (`c1`) PARTITIONS 3: Unknown storage engine 'ARCHIVE' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/archive/rnd_pos.test" ReplayTest: At line 25 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t1` ( `c1` int(11) NOT NULL, `c2` double NOT NULL, `c3` char(255) NOT NULL ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PARTITION BY HASH (`c1`) PARTITIONS 3: Unknown storage engine 'ARCHIVE' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/archive/rnd_pos.test" ReplayTest: At line 27 archive.rnd_pos [ fail ] Test ended at 2026-07-24 16:55:40 CURRENT_TEST: archive.rnd_pos --- /home/ppandith/test2/mysql-test/suite/archive/rnd_pos.result 2026-02-12 12:11:29.470556116 +0530 +++ /home/ppandith/test2/mysql-test/suite/archive/rnd_pos.reject 2026-07-24 16:55:40.607755583 +0530 @@ -1,12 +1,18 @@ create table t1(c1 int not null, c2 double not null, c3 char(255) not null) engine=archive charset=latin1; insert t1 select seq, seq+0.7, concat('row with c1 = ', seq) from seq_1_to_10; explain partitions select c1,c3 from t1 order by c2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 10 Using filesort +ReplayTest: Query error: CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` double NOT NULL, + `c3` char(255) NOT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' set max_length_for_sort_data = 4; explain partitions select c1,c3 from t1 order by c2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 10 Using temporary; Using filesort +ReplayTest: Query error: CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` double NOT NULL, + `c3` char(255) NOT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' flush status; select c1,c3 from t1 order by c2; c1 c3 @@ -28,12 +34,22 @@ Rows_tmp_read 20 alter table t1 partition by hash (c1) partitions 3; explain partitions select c1,c3 from t1 order by c2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1,p2 ALL NULL NULL NULL NULL 10 Using filesort +ReplayTest: Query error: CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` double NOT NULL, + `c3` char(255) NOT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + PARTITION BY HASH (`c1`) +PARTITIONS 3: Unknown storage engine 'ARCHIVE' set max_length_for_sort_data = 4; explain partitions select c1,c3 from t1 order by c2; -id select_type table partitions type possible_keys key key_len ref rows Extra -1 SIMPLE t1 p0,p1,p2 ALL NULL NULL NULL NULL 10 Using temporary; Using filesort +ReplayTest: Query error: CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + `c2` double NOT NULL, + `c3` char(255) NOT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci + PARTITION BY HASH (`c1`) +PARTITIONS 3: Unknown storage engine 'ARCHIVE' flush status; select c1,c3 from t1 order by c2; c1 c3 Result length mismatch - saving '/home/ppandith/test2/bld/mysql-test/var/log/archive.rnd_pos/' to '/home/ppandith/test2/bld/mysql-test/var/log/archive.rnd_pos/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `t5` ( `a` int(11) NOT NULL AUTO_INCREMENT, `b` tinyblob DEFAULT NULL, KEY `a` (`a`) ) ENGINE=ARCHIVE AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In file "/home/ppandith/test2/mysql-test/suite/archive/archive.test" ReplayTest: At line 1448 archive.archive [ fail ] Test ended at 2026-07-24 16:55:42 CURRENT_TEST: archive.archive --- /home/ppandith/test2/mysql-test/suite/archive/archive.result 2026-04-24 16:46:52.749795491 +0530 +++ /home/ppandith/test2/mysql-test/suite/archive/archive.reject 2026-07-24 16:55:42.272803263 +0530 @@ -12490,8 +12490,11 @@ foo this is mine to think about explain SELECT b FROM t5 WHERE a IN (32, 23, 5); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t5 ALL a NULL NULL NULL 11 Using where +ReplayTest: Query error: CREATE TABLE `t5` ( + `a` int(11) NOT NULL AUTO_INCREMENT, + `b` tinyblob DEFAULT NULL, + KEY `a` (`a`) +) ENGINE=ARCHIVE AUTO_INCREMENT=36 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci: Unknown storage engine 'ARCHIVE' SELECT b FROM t5 WHERE a IN (32, 23, 5); b foo grok Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/archive.archive/' ***Warnings generated in error logs during shutdown after running tests: archive.archive 2026-07-24 16:55:41 4 [ERROR] mariadbd: Table 't1' is marked as crashed and should be repaired 2026-07-24 16:55:41 4 [ERROR] mariadbd: Table 't1' is marked as crashed and should be repaired 2026-07-24 16:55:42 4 [ERROR] Got error 127 when reading table './test/t1' 2026-07-24 16:55:42 4 [ERROR] mariadbd: Table 't1' is marked as crashed and should be repaired ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_geometry` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` geometry DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 101 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_point` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` point DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 105 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_line` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` linestring DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 113 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_polygon` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` polygon DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 120 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_multi_point` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` multipoint DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 131 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_multi_point` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` multipoint DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 138 ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `gis_geometrycollection` ( `fid` int(11) NOT NULL AUTO_INCREMENT, `g` geometrycollection DEFAULT NULL, PRIMARY KEY (`fid`) ) ENGINE=ARCHIVE AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' ReplayTest: In included file "./include/gis_generic.inc": ReplayTest: included from /home/ppandith/test2/mysql-test/suite/archive/archive_gis.test at line 4: ReplayTest: At line 146 archive.archive_gis [ fail ] Test ended at 2026-07-24 16:55:43 CURRENT_TEST: archive.archive_gis --- /home/ppandith/test2/mysql-test/suite/archive/archive_gis.result 2026-02-12 12:11:29.469556156 +0530 +++ /home/ppandith/test2/mysql-test/suite/archive/archive_gis.reject 2026-07-24 16:55:43.306832873 +0530 @@ -233,10 +233,11 @@ 120 POLYGON((0 0,10 0,10 10,0 10,0 0)) 121 POLYGON((3 6,44 6,44 9,3 9,3 6)) explain extended select Dimension(g), GeometryType(g), IsEmpty(g), AsText(Envelope(g)) from gis_geometry; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_geometry ALL NULL NULL NULL NULL 21 100.00 -Warnings: -Note 1003 select st_dimension(`test`.`gis_geometry`.`g`) AS `Dimension(g)`,st_geometrytype(`test`.`gis_geometry`.`g`) AS `GeometryType(g)`,st_isempty(`test`.`gis_geometry`.`g`) AS `IsEmpty(g)`,st_astext(st_envelope(`test`.`gis_geometry`.`g`)) AS `AsText(Envelope(g))` from `test`.`gis_geometry` +ReplayTest: Query error: CREATE TABLE `gis_geometry` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` geometry DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT fid, X(g) FROM gis_point ORDER by fid; fid X(g) 101 10 @@ -250,10 +251,11 @@ 103 20 104 20 explain extended select X(g),Y(g) FROM gis_point; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_point ALL NULL NULL NULL NULL 4 100.00 -Warnings: -Note 1003 select st_x(`test`.`gis_point`.`g`) AS `X(g)`,st_y(`test`.`gis_point`.`g`) AS `Y(g)` from `test`.`gis_point` +ReplayTest: Query error: CREATE TABLE `gis_point` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` point DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT fid, AsText(StartPoint(g)) FROM gis_line ORDER by fid; fid AsText(StartPoint(g)) 105 POINT(0 0) @@ -285,10 +287,11 @@ 106 1 107 0 explain extended select AsText(StartPoint(g)),AsText(EndPoint(g)),GLength(g),NumPoints(g),AsText(PointN(g, 2)),IsClosed(g) FROM gis_line; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_line ALL NULL NULL NULL NULL 3 100.00 -Warnings: -Note 1003 select st_astext(st_startpoint(`test`.`gis_line`.`g`)) AS `AsText(StartPoint(g))`,st_astext(st_endpoint(`test`.`gis_line`.`g`)) AS `AsText(EndPoint(g))`,st_length(`test`.`gis_line`.`g`) AS `GLength(g)`,st_numpoints(`test`.`gis_line`.`g`) AS `NumPoints(g)`,st_astext(st_pointn(`test`.`gis_line`.`g`,2)) AS `AsText(PointN(g, 2))`,st_isclosed(`test`.`gis_line`.`g`) AS `IsClosed(g)` from `test`.`gis_line` +ReplayTest: Query error: CREATE TABLE `gis_line` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` linestring DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT fid, AsText(Centroid(g)) FROM gis_polygon ORDER by fid; fid AsText(Centroid(g)) 108 POINT(15 15) @@ -315,10 +318,11 @@ 109 LINESTRING(10 10,20 10,20 20,10 20,10 10) 110 NULL explain extended select AsText(Centroid(g)),Area(g),AsText(ExteriorRing(g)),NumInteriorRings(g),AsText(InteriorRingN(g, 1)) FROM gis_polygon; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_polygon ALL NULL NULL NULL NULL 3 100.00 -Warnings: -Note 1003 select st_astext(st_centroid(`test`.`gis_polygon`.`g`)) AS `AsText(Centroid(g))`,st_area(`test`.`gis_polygon`.`g`) AS `Area(g)`,st_astext(st_exteriorring(`test`.`gis_polygon`.`g`)) AS `AsText(ExteriorRing(g))`,st_numinteriorrings(`test`.`gis_polygon`.`g`) AS `NumInteriorRings(g)`,st_astext(st_interiorringn(`test`.`gis_polygon`.`g`,1)) AS `AsText(InteriorRingN(g, 1))` from `test`.`gis_polygon` +ReplayTest: Query error: CREATE TABLE `gis_polygon` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` polygon DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT fid, IsClosed(g) FROM gis_multi_line ORDER by fid; fid IsClosed(g) 114 0 @@ -354,10 +358,11 @@ 120 2 121 2 explain extended SELECT fid, NumGeometries(g) from gis_multi_point; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_multi_point ALL NULL NULL NULL NULL 3 100.00 -Warnings: -Note 1003 select `test`.`gis_multi_point`.`fid` AS `fid`,st_numgeometries(`test`.`gis_multi_point`.`g`) AS `NumGeometries(g)` from `test`.`gis_multi_point` +ReplayTest: Query error: CREATE TABLE `gis_multi_point` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` multipoint DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT fid, AsText(GeometryN(g, 2)) from gis_multi_point ORDER by fid; fid AsText(GeometryN(g, 2)) 111 POINT(10 10) @@ -382,10 +387,11 @@ 120 POINT(0 0) 121 POINT(44 6) explain extended SELECT fid, AsText(GeometryN(g, 2)) from gis_multi_point; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE gis_multi_point ALL NULL NULL NULL NULL 3 100.00 -Warnings: -Note 1003 select `test`.`gis_multi_point`.`fid` AS `fid`,st_astext(st_geometryn(`test`.`gis_multi_point`.`g`,2)) AS `AsText(GeometryN(g, 2))` from `test`.`gis_multi_point` +ReplayTest: Query error: CREATE TABLE `gis_multi_point` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` multipoint DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' SELECT g1.fid as first, g2.fid as second, Within(g1.g, g2.g) as w, Contains(g1.g, g2.g) as c, Overlaps(g1.g, g2.g) as o, Equals(g1.g, g2.g) as e, Disjoint(g1.g, g2.g) as d, Touches(g1.g, g2.g) as t, @@ -401,11 +407,11 @@ Equals(g1.g, g2.g) as e, Disjoint(g1.g, g2.g) as d, Touches(g1.g, g2.g) as t, Intersects(g1.g, g2.g) as i, Crosses(g1.g, g2.g) as r FROM gis_geometrycollection g1, gis_geometrycollection g2 ORDER BY first, second; -id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE g1 ALL NULL NULL NULL NULL 2 100.00 Using temporary; Using filesort -1 SIMPLE g2 ALL NULL NULL NULL NULL 2 100.00 Using join buffer (flat, BNL join) -Warnings: -Note 1003 select `test`.`g1`.`fid` AS `first`,`test`.`g2`.`fid` AS `second`,st_within(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `w`,st_contains(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `c`,mbroverlaps(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `o`,st_equals(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `e`,mbrdisjoint(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `d`,st_touches(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `t`,mbrintersects(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `i`,st_crosses(`test`.`g1`.`g`,`test`.`g2`.`g`) AS `r` from `test`.`gis_geometrycollection` `g1` join `test`.`gis_geometrycollection` `g2` order by `test`.`g1`.`fid`,`test`.`g2`.`fid` +ReplayTest: Query error: CREATE TABLE `gis_geometrycollection` ( + `fid` int(11) NOT NULL AUTO_INCREMENT, + `g` geometrycollection DEFAULT NULL, + PRIMARY KEY (`fid`) +) ENGINE=ARCHIVE AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'ARCHIVE' DROP TABLE gis_point, gis_line, gis_polygon, gis_multi_point, gis_multi_line, gis_multi_polygon, gis_geometrycollection, gis_geometry; CREATE TABLE t1 ( a INTEGER PRIMARY KEY AUTO_INCREMENT, Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/archive.archive_gis/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `shops` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text DEFAULT NULL, `location` geometry NOT NULL, PRIMARY KEY (`id`), SPATIAL KEY `location_index` (`location`) ) ENGINE=Mroonga AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/t/geometry_contains.test" ReplayTest: At line 147 mroonga/storage.geometry_contains [ fail ] Test ended at 2026-07-24 16:55:44 CURRENT_TEST: mroonga/storage.geometry_contains --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.result 2026-02-12 12:11:30.131529662 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/geometry_contains.reject 2026-07-24 16:55:44.189858158 +0530 @@ -162,6 +162,11 @@ SELECT id, name, ST_AsText(location) AS location_text FROM shops WHERE MBRContains(ST_GeomFromText('LineString(139.7727 35.6684, 139.7038 35.7121)'), location) ORDER BY id; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE shops range location_index location_index 34 NULL 36 Using where; Using filesort +ReplayTest: Query error: CREATE TABLE `shops` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `name` text DEFAULT NULL, + `location` geometry NOT NULL, + PRIMARY KEY (`id`), + SPATIAL KEY `location_index` (`location`) +) ENGINE=Mroonga AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci: Unknown storage engine 'Mroonga' DROP TABLE shops; Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/storage.geometry_contains/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `users` ( `age` int(11) DEFAULT NULL, KEY `age` (`age`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/t/optimization_count_skip_index_not_equal.test" ReplayTest: At line 37 mroonga/storage.optimization_count_skip_index_not_equal [ fail ] Test ended at 2026-07-24 16:55:45 CURRENT_TEST: mroonga/storage.optimization_count_skip_index_not_equal --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/optimization_count_skip_index_not_equal.result 2026-02-12 12:11:30.133529582 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/optimization_count_skip_index_not_equal.reject 2026-07-24 16:55:45.090883960 +0530 @@ -10,8 +10,10 @@ INSERT INTO users (age) VALUES (29); INSERT INTO users (age) VALUES (29); explain SELECT COUNT(*) FROM users WHERE age <> 29; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE users range age age 5 NULL 4 Using where; Using index +ReplayTest: Query error: CREATE TABLE `users` ( + `age` int(11) DEFAULT NULL, + KEY `age` (`age`) +) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' SELECT COUNT(*) FROM users WHERE age <> 29; COUNT(*) 2 Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/storage.optimization_count_skip_index_not_equal/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `ids` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=Mroonga AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/t/variable_max_n_records_for_estimate_global.test" ReplayTest: At line 47 mroonga/storage.variable_max_n_records_for_estimate_global [ fail ] Test ended at 2026-07-24 16:55:46 CURRENT_TEST: mroonga/storage.variable_max_n_records_for_estimate_global --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.result 2026-02-12 12:11:30.135529502 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_global.reject 2026-07-24 16:55:45.966909045 +0530 @@ -14,7 +14,9 @@ INSERT INTO ids VALUES (10); SET GLOBAL mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range PRIMARY PRIMARY 4 NULL 1 Using where; Using index +ReplayTest: Query error: CREATE TABLE `ids` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`id`) +) ENGINE=Mroonga AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' SET GLOBAL mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/storage.variable_max_n_records_for_estimate_global/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `ids` ( `id` int(11) DEFAULT NULL, KEY `id` (`id`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/t/variable_max_n_records_for_estimate_not_found_in_limit.test" ReplayTest: At line 38 mroonga/storage.variable_max_n_records_for_estimate_not_found_in_limit [ fail ] Test ended at 2026-07-24 16:55:47 CURRENT_TEST: mroonga/storage.variable_max_n_records_for_estimate_not_found_in_limit --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.result 2026-02-12 12:11:30.135529502 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_not_found_in_limit.reject 2026-07-24 16:55:46.863934732 +0530 @@ -10,7 +10,9 @@ DELETE FROM ids WHERE id < 2; SET mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 0; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range id id 5 NULL 1 Using where; Using index +ReplayTest: Query error: CREATE TABLE `ids` ( + `id` int(11) DEFAULT NULL, + KEY `id` (`id`) +) ENGINE=Mroonga DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' SET mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/storage.variable_max_n_records_for_estimate_not_found_in_limit/' ReplayTest: Loading context ReplayTest: Query error: CREATE TABLE `ids` ( `id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) ENGINE=Mroonga AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' ReplayTest: In file "/home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/t/variable_max_n_records_for_estimate_session.test" ReplayTest: At line 41 mroonga/storage.variable_max_n_records_for_estimate_session [ fail ] Test ended at 2026-07-24 16:55:48 CURRENT_TEST: mroonga/storage.variable_max_n_records_for_estimate_session --- /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.result 2026-02-12 12:11:30.135529502 +0530 +++ /home/ppandith/test2/storage/mroonga/mysql-test/mroonga/storage/r/variable_max_n_records_for_estimate_session.reject 2026-07-24 16:55:47.761960447 +0530 @@ -14,7 +14,9 @@ INSERT INTO ids VALUES (10); SET mroonga_max_n_records_for_estimate = 1; EXPLAIN SELECT * FROM ids WHERE id > 5; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE ids range PRIMARY PRIMARY 4 NULL 1 Using where; Using index +ReplayTest: Query error: CREATE TABLE `ids` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`id`) +) ENGINE=Mroonga AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci: Unknown storage engine 'Mroonga' SET mroonga_max_n_records_for_estimate = DEFAULT; DROP TABLE ids; Result length mismatch - skipping '/home/ppandith/test2/bld/mysql-test/var/log/mroonga/storage.variable_max_n_records_for_estimate_session/' -------------------------------------------------------------------------- The servers were restarted 26 times Spent 0.000 of 61 seconds executing testcases Completed: Failed 27/27 tests, 0.00% were successful. Failing test(s): federated.federatedx_create_handlers federated.federatedx federated.optimizer connect.part_file connect.part_table connect.index connect.mysql_index connect.upd spider/bugfix.mdev_32907 spider/bugfix.mdev_37484 spider/bugfix.quick_mode_1 spider/feature.pushdown_case spider/feature.pushdown_timestamp_diff mroonga/wrapper.count_star_with_index archive.rnd_pos archive.archive archive.archive_gis mroonga/storage.geometry_contains mroonga/storage.optimization_count_skip_index_not_equal mroonga/storage.variable_max_n_records_for_estimate_global mroonga/storage.variable_max_n_records_for_estimate_not_found_in_limit mroonga/storage.variable_max_n_records_for_estimate_session The log files in var/log may give you some hint of what went wrong. If you want to report this error, MariaDB's bug tracker is found at https://jira.mariadb.org Errors/warnings were found in logfiles during server shutdown after running the following sequence(s) of tests: archive.archive 1 tests were skipped, 0 by the test itself. Stopping replay server... Replay server stopped