Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
Description
CREATE TABLE t1 AS SELECT 1 AS a; |
CREATE TEMPORARY TABLE tmp (b INT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MyISAM; |
INSERT INTO tmp VALUES (1); |
ALTER TABLE tmp FORCE; |
--error ER_WARN_DATA_OUT_OF_RANGE
|
UPDATE tmp, t1 SET b = -1; |
INSERT INTO tmp () VALUES (); |
|
|
# Cleanup
|
DROP TABLE t1; |
|
10.2 900a1475 |
mysqld: /data/src/10.2/sql/table.cc:4654: void TABLE::init(THD*, TABLE_LIST*): Assertion `!auto_increment_field_not_null' failed.
|
210127 16:19:26 [ERROR] mysqld got signal 6 ;
|
|
|
#7 0x00007f4566b4cf36 in __GI___assert_fail (assertion=0x56025af04b20 "!auto_increment_field_not_null", file=0x56025af035c6 "/data/src/10.2/sql/table.cc", line=4654, function=0x56025af04ac0 "void TABLE::init(THD*, TABLE_LIST*)") at assert.c:101
|
#8 0x000056025a585dd8 in TABLE::init (this=0x7f455018e0d0, thd=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/table.cc:4654
|
#9 0x000056025a673504 in THD::open_temporary_table (this=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/temporary_tables.cc:425
|
#10 0x000056025a673608 in THD::open_temporary_tables (this=0x7f4550000d90, tl=0x7f45500127d8) at /data/src/10.2/sql/temporary_tables.cc:462
|
#11 0x000056025a4778b9 in mysql_execute_command (thd=0x7f4550000d90) at /data/src/10.2/sql/sql_parse.cc:4185
|
#12 0x000056025a48303f in mysql_parse (thd=0x7f4550000d90, rawbuf=0x7f45500126f8 "INSERT INTO tmp () VALUES ()", length=28, parser_state=0x7f4560ca65f0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7763
|
#13 0x000056025a471318 in dispatch_command (command=COM_QUERY, thd=0x7f4550000d90, packet=0x7f4550008b51 "INSERT INTO tmp () VALUES ()", packet_length=28, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
|
#14 0x000056025a46fe13 in do_command (thd=0x7f4550000d90) at /data/src/10.2/sql/sql_parse.cc:1381
|
#15 0x000056025a5ca72e in do_handle_one_connection (connect=0x56025cad39c0) at /data/src/10.2/sql/sql_connect.cc:1336
|
#16 0x000056025a5ca493 in handle_one_connection (arg=0x56025cad39c0) at /data/src/10.2/sql/sql_connect.cc:1241
|
#17 0x000056025adf29ec in pfs_spawn_thread (arg=0x56025cab6dd0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
|
#18 0x00007f456705c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#19 0x00007f4566c38293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Reproducible on 10.2-10.6.
No obvious immediate problem on a non-debug build.