| Bug #112907 | Assertion `to->field_ptr() != from->field_ptr()' failed in MySQL 8.1.0 | ||
|---|---|---|---|
| Submitted: | 1 Nov 2023 6:31 | Modified: | 1 Nov 2023 7:10 |
| Reporter: | Wang Ke | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
| Version: | 8.1.0, 8.0.35, 8.2 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | assertion failure | ||
[1 Nov 2023 6:31]
Wang Ke
[1 Nov 2023 7:10]
MySQL Verification Team
Hello Wang Ke, Thank you for the report and test case. Observed that 8.0.35 debug build is affected with provided test case. regards, Umesh
[1 Nov 2023 7:11]
MySQL Verification Team
- debug build affected ./mtr --nocheck-testcases bug112907 --debug-server Logging: ./mtr --nocheck-testcases bug112907 --debug-server MySQL Version 8.0.35 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.35/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c0 CHAR ( 0 ) CHAR SET koi8r DEFAULT NULL , c1 VARCHAR ( 1 ) PRIMARY KEY , c2 INT GENERATED ALWAYS AS ( CAST( ( false < true ) AS FLOAT ) + 8.000000 ) STORED ) ENGINE = InnoDB ; INSERT IGNORE INTO t0 ( c0 , c1 ) VALUES ( 'fixme' , 'fixme' ) , ( 'SH' , 'SH' ) , ( t0.c1 , 'fixme' ) , ( NOW( ) - INTERVAL 1 SQL_TSI_DAY , CAST( t0.c2 + 1 + t0.c2 AS CHAR ) ) , ( CAST( + 0.000001 AS CHAR ) , 'honeypot' ) ; [ 50%] main.bug112907 [ fail ] Test ended at 2023-11-01 08:10:08 CURRENT_TEST: main.bug112907 mysqltest: At line 2: Query 'INSERT IGNORE INTO t0 ( c0 , c1 ) VALUES ( 'fixme' , 'fixme' ) , ( 'SH' , 'SH' ) , ( t0.c1 , 'fixme' ) , ( NOW( ) - INTERVAL 1 SQL_TSI_DAY , CAST( t0.c2 + 1 + t0.c2 AS CHAR ) ) , ( CAST( + 0.000001 AS CHAR ) , 'honeypot' ) ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query -- release build - not affected ./mtr --nocheck-testcases bug112907 Logging: ./mtr --nocheck-testcases bug112907 MySQL Version 8.0.35 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/mysql-8.0.35/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c0 CHAR ( 0 ) CHAR SET koi8r DEFAULT NULL , c1 VARCHAR ( 1 ) PRIMARY KEY , c2 INT GENERATED ALWAYS AS ( CAST( ( false < true ) AS FLOAT ) + 8.000000 ) STORED ) ENGINE = InnoDB ; INSERT IGNORE INTO t0 ( c0 , c1 ) VALUES ( 'fixme' , 'fixme' ) , ( 'SH' , 'SH' ) , ( t0.c1 , 'fixme' ) , ( NOW( ) - INTERVAL 1 SQL_TSI_DAY , CAST( t0.c2 + 1 + t0.c2 AS CHAR ) ) , ( CAST( + 0.000001 AS CHAR ) , 'honeypot' ) ; Warnings: Warning 1265 Data truncated for column 'c0' at row 1 Warning 1265 Data truncated for column 'c1' at row 1 Warning 1265 Data truncated for column 'c0' at row 2 Warning 1265 Data truncated for column 'c1' at row 2 Warning 1265 Data truncated for column 'c1' at row 3 Warning 1062 Duplicate entry 'f' for key 't0.PRIMARY' Warning 1265 Data truncated for column 'c0' at row 4 Warning 1048 Column 'c1' cannot be null Warning 1265 Data truncated for column 'c0' at row 5 Warning 1265 Data truncated for column 'c1' at row 5 [ 50%] main.bug112907 [ pass ] 28 [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.028 of 9 seconds executing testcases Completed: All 2 tests were successful.
[1 Nov 2023 7:11]
MySQL Verification Team
- debug build #0 0x00007fb0de44eaa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000003fbbfa6 in my_write_core(int) () #2 0x00000000032595e3 in handle_fatal_signal () #3 <signal handler called> #4 0x00007fb0dc513387 in raise () from /lib64/libc.so.6 #5 0x00007fb0dc514a78 in abort () from /lib64/libc.so.6 #6 0x00007fb0dc50c1a6 in __assert_fail_base () from /lib64/libc.so.6 #7 0x00007fb0dc50c252 in __assert_fail () from /lib64/libc.so.6 #8 0x000000000339fb29 in field_conv_with_cache(Field*, Field*, Field**, unsigned int*) () #9 0x000000000339fcf8 in Item_field::save_in_field_inner(Field*, bool) () #10 0x00000000033b60cf in Item::save_in_field(Field*, bool) () #11 0x000000000302f573 in fill_record(THD*, TABLE*, mem_root_deque<Item*> const&, mem_root_deque<Item*> const&, MY_BITMAP*, MY_BITMAP*, bool) () #12 0x000000000302f9dc in fill_record_n_invoke_before_triggers(THD*, COPY_INFO*, mem_root_deque<Item*> const&, mem_root_deque<Item*> const&, TABLE*, enum_trigger_event_type, int, bool, bool*) () #13 0x00000000035b3797 in Sql_cmd_insert_values::execute_inner(THD*) () #14 0x00000000031467cd in Sql_cmd_dml::execute(THD*) () #15 0x00000000030e497b in mysql_execute_command(THD*, bool) () #16 0x00000000030e8295 in dispatch_sql_command(THD*, Parser_state*) () #17 0x00000000030e99f9 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #18 0x00000000030eb737 in do_command(THD*) () #19 0x000000000324ab8b in handle_connection () #20 0x0000000004776b03 in pfs_spawn_thread () #21 0x00007fb0de449ea5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007fb0dc5dbb2d in clone () from /lib64/libc.so.6
