| Bug #112480 | Assertion Failure in /mysql-8.0.34/sql/handler.cc:2966 | ||
|---|---|---|---|
| Submitted: | 26 Sep 2023 10:31 | Modified: | 26 Sep 2023 14:06 |
| Reporter: | xin wen | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
| Version: | 8.0.34 | OS: | Ubuntu (20.04) |
| Assigned to: | CPU Architecture: | Any | |
[26 Sep 2023 10:31]
xin wen
[26 Sep 2023 14:06]
MySQL Verification Team
Hello xin wen, Thank you for the report and test case. Observed that 8.0.34 debug build is affected. regards, Umesh
[26 Sep 2023 14:07]
MySQL Verification Team
./mtr --nocheck-testcases bug112480 --debug-server Logging: ./mtr --nocheck-testcases bug112480 --debug-server MySQL Version 8.0.34 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/mysql-8.0.34/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c21 BOOL ) ; INSERT INTO t0 VALUES ( 84 ) , ( 67 ) ; CREATE INDEX i0 ON t0 ( c21 ) ; INSERT INTO t0 VALUES ( 111 ) , ( -124 ) ; SELECT t3 . c21 AS c33 FROM ( SELECT FORMAT ( 18 , 6720516515493625017 ) AS c61 ) AS t1 JOIN ( SELECT c21 AS c50 FROM t0 ) AS t2 ON c50 = c50 LEFT OUTER JOIN t0 AS t3 ON EXISTS ( WITH t4 AS ( SELECT -73 AS c9 , -44 AS c24 WHERE -1 < 122 AND -50 < -16 GROUP BY c50 WITH ROLLUP ) SELECT t1 . c61 AS c4 FROM t4 CROSS JOIN t4 AS t5 WHERE NULL > RAND ( ) - REPLACE ( t2 . c50 , RAND ( ) IN ( RAND ( ) ) , 'd"S~' ) ) ; [ 50%] main.bug112480 [ fail ] Test ended at 2023-09-26 16:06:48 CURRENT_TEST: main.bug112480 mysqltest: At line 5: Query 'SELECT t3 . c21 AS c33 FROM ( SELECT FORMAT ( 18 , 6720516515493625017 ) AS c61 ) AS t1 JOIN ( SELECT c21 AS c50 FROM t0 ) AS t2 ON c50 = c50 LEFT OUTER JOIN t0 AS t3 ON EXISTS ( WITH t4 AS ( SELECT -73 AS c9 , -44 AS c24 WHERE -1 < 122 AND -50 < -16 GROUP BY c50 WITH ROLLUP ) SELECT t1 . c61 AS c4 FROM t4 CROSS JOIN t4 AS t5 WHERE NULL > RAND ( ) - REPLACE ( t2 . c50 , RAND ( ) IN ( RAND ( ) ) , 'd"S~' ) ) ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query safe_process[6843]: Child process: 6844, exit: 1 -bt Thread 1 (Thread 0x7f03341f7700 (LWP 6850)): #0 0x00007f035581eaa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000402c28e in my_write_core(int) () #2 0x00000000032d235e in handle_fatal_signal () #3 <signal handler called> #4 0x00007f0353b69387 in raise () from /lib64/libc.so.6 #5 0x00007f0353b6aa78 in abort () from /lib64/libc.so.6 #6 0x00007f0353b621a6 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007f0353b62252 in __assert_fail () from /lib64/libc.so.6 #8 0x00000000033de8c9 in handler::ha_rnd_next(unsigned char*) () #9 0x00000000034ff92a in TableScanIterator::Read() () #10 0x0000000003669356 in MaterializeIterator<DummyIteratorProfiler>::Read() () #11 0x00000000036674a4 in NestedLoopIterator::Read() () #12 0x00000000036674a4 in NestedLoopIterator::Read() () #13 0x000000000366752f in NestedLoopIterator::Read() () #14 0x000000000322d193 in Query_expression::ExecuteIteratorQuery(THD*) () #15 0x000000000322d2aa in Query_expression::execute(THD*) () #16 0x00000000031b71dc in Sql_cmd_dml::execute_inner(THD*) () #17 0x00000000031c0beb in Sql_cmd_dml::execute(THD*) () #18 0x0000000003161263 in mysql_execute_command(THD*, bool) () #19 0x00000000031626a2 in dispatch_sql_command(THD*, Parser_state*) () #20 0x0000000003163cd5 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #21 0x000000000316596c in do_command(THD*) () #22 0x00000000032c437c in handle_connection () #23 0x00000000047e1af5 in pfs_spawn_thread () #24 0x00007f0355819ea5 in start_thread () from /lib64/libpthread.so.0 #25 0x00007f0353c31b2d in clone () from /lib64/libc.so.6
