| Bug #111373 | Assertion `!sl->order_list.first' failed | ||
|---|---|---|---|
| Submitted: | 13 Jun 2023 2:27 | Modified: | 13 Jun 2023 7:21 |
| Reporter: | Yu Liang | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S6 (Debug Builds) |
| Version: | 8.0.33 | OS: | Ubuntu (20.04 LTS) |
| Assigned to: | CPU Architecture: | x86 (Intel(R) Core(TM) i7-10700 CPU) | |
[13 Jun 2023 2:27]
Yu Liang
[13 Jun 2023 7:21]
MySQL Verification Team
Hello Yu Liang, Thank you for the report and test case. Observed that 8.0.33 only debug build is affected. regards, Umesh
[13 Jun 2023 7:23]
MySQL Verification Team
-- release build ./mtr bug111373 --nocheck-testcases Logging: ./mtr bug111373 --nocheck-testcases MySQL Version 8.0.33 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/binaries/mysql-8.0.33/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ drop database if exists test123; Warnings: Note 1008 Can't drop database 'test123'; database doesn't exist create database test123; use test123; create table v0(c1 INT); CREATE TABLE IF NOT EXISTS v3 ( c4 INT ) AS TABLE v0 ORDER BY c1 > ALL (VALUES ROW ( TRUE ) ORDER BY TRUE ) ; [ 50%] main.bug111373 [ pass ] 111 [100%] shutdown_report [ pass ] -- debug build - affected ./mtr bug111373 --nocheck-testcases --debug-server Logging: ./mtr bug111373 --nocheck-testcases --debug-server MySQL Version 8.0.33 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/binaries/mysql-8.0.33/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ drop database if exists test123; Warnings: Note 1008 Can't drop database 'test123'; database doesn't exist create database test123; use test123; create table v0(c1 INT); CREATE TABLE IF NOT EXISTS v3 ( c4 INT ) AS TABLE v0 ORDER BY c1 > ALL (VALUES ROW ( TRUE ) ORDER BY TRUE ) ; [ 50%] main.bug111373 [ fail ] Test ended at 2023-06-13 09:20:30 CURRENT_TEST: main.bug111373 mysqltest: At line 6: Query 'CREATE TABLE IF NOT EXISTS v3 ( c4 INT ) AS TABLE v0 ORDER BY c1 > ALL (VALUES ROW ( TRUE ) ORDER BY TRUE ) ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query -bt #0 0x00007fc2f0cbeaa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000004005426 in my_write_core(int) () #2 0x00000000032b0166 in handle_fatal_signal () #3 <signal handler called> #4 0x00007fc2ef17f387 in raise () from /lib64/libc.so.6 #5 0x00007fc2ef180a78 in abort () from /lib64/libc.so.6 #6 0x00007fc2ef1781a6 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fc2ef178252 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000034a920d in Item_in_subselect::select_in_like_transformer(THD*, Query_block*, Comp_creator*) () #9 0x00000000034a9418 in Item_allany_subselect::select_transformer(THD*, Query_block*) () #10 0x000000000317f116 in Query_block::resolve_subquery(THD*) () #11 0x000000000317f460 in Query_block::prepare_values(THD*) () #12 0x0000000003187e04 in Query_block::prepare(THD*, mem_root_deque<Item*>*) () #13 0x0000000003209cd7 in Query_expression::prepare(THD*, Query_result*, mem_root_deque<Item*>*, unsigned long long, unsigned long long) () #14 0x00000000034a374a in SubqueryWithResult::prepare(THD*) () #15 0x00000000034a9cb6 in Item_subselect::fix_fields(THD*, Item**) () #16 0x00000000034a9ea5 in Item_in_subselect::fix_fields(THD*, Item**) () #17 0x00000000034583d5 in Item_func::fix_func_arg(THD*, Item**) () #18 0x00000000034585b8 in Item_func::fix_fields(THD*, Item**) () #19 0x000000000317e357 in find_order_in_list(THD*, Bounds_checked_array<Item*>, Table_ref*, ORDER*, mem_root_deque<Item*>*, bool, bool) () #20 0x000000000317e5ab in setup_order(THD*, Bounds_checked_array<Item*>, Table_ref*, mem_root_deque<Item*>*, ORDER*) () #21 0x00000000031884b7 in Query_block::prepare(THD*, mem_root_deque<Item*>*) () #22 0x0000000003209cd7 in Query_expression::prepare(THD*, Query_result*, mem_root_deque<Item*>*, unsigned long long, unsigned long long) () #23 0x00000000035eea00 in Sql_cmd_create_table::execute(THD*) () #24 0x000000000313d2da in mysql_execute_command(THD*, bool) () #25 0x0000000003140bc8 in dispatch_sql_command(THD*, Parser_state*) () #26 0x00000000031421fb in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #27 0x0000000003143e97 in do_command(THD*) () #28 0x00000000032a219e in handle_connection () #29 0x00000000047b1601 in pfs_spawn_thread () #30 0x00007fc2f0cb9ea5 in start_thread () from /lib64/libpthread.so.0 #31 0x00007fc2ef247b2d in clone () from /lib64/libc.so.6
