|
--source include/have_partition.inc
|
|
CREATE TABLE t1 (
|
a INT,
|
s TIMESTAMP(6) AS ROW START,
|
e TIMESTAMP(6) AS ROW END,
|
PERIOD FOR SYSTEM_TIME(s,e)
|
) WITH SYSTEM VERSIONING
|
ENGINE=MyISAM
|
PARTITION BY system_time ( PARTITION p1 HISTORY, PARTITION pn CURRENT );
|
|
INSERT INTO t1 () VALUES ();
|
SET SQL_MODE= 'SIMULTANEOUS_ASSIGNMENT';
|
--error 0,ER_WARNING_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN
|
UPDATE t1 SET e = NOW();
|
--error ER_NO_DEFAULT_FOR_FIELD
|
INSERT INTO t1 (a) VALUES (1);
|
|
# Cleanup
|
DROP TABLE t1;
|
|
10.4 09e9f884 debug
|
#3 <signal handler called>
|
#4 0x00005627cc6a8f37 in handler::ha_write_row (this=0xffffff7f7c1388c8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/handler.cc:6665
|
#5 0x00005627cce1cb76 in ha_partition::write_row (this=0x7ffb7c1378a8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/ha_partition.cc:4318
|
#6 0x00005627cc6a91a5 in handler::ha_write_row (this=0x7ffb7c1378a8, buf=0x7ffb7c1341f8 "\375\001") at /data/src/10.4/sql/handler.cc:6682
|
#7 0x00005627cc317a08 in write_record (thd=0x7ffb7c000b00, table=0x7ffb7c136a40, info=0x7ffb8d5de4b0) at /data/src/10.4/sql/sql_insert.cc:2037
|
#8 0x00005627cc314d17 in mysql_insert (thd=0x7ffb7c000b00, table_list=0x7ffb7c0131f0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1075
|
#9 0x00005627cc35f93c in mysql_execute_command (thd=0x7ffb7c000b00) at /data/src/10.4/sql/sql_parse.cc:4528
|
#10 0x00005627cc36b7ed in mysql_parse (thd=0x7ffb7c000b00, rawbuf=0x7ffb7c013108 "INSERT INTO t1 (a) VALUES (1)", length=29, parser_state=0x7ffb8d5df180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7908
|
#11 0x00005627cc357a96 in dispatch_command (command=COM_QUERY, thd=0x7ffb7c000b00, packet=0x7ffb7c008311 "INSERT INTO t1 (a) VALUES (1)", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1843
|
#12 0x00005627cc3561dc in do_command (thd=0x7ffb7c000b00) at /data/src/10.4/sql/sql_parse.cc:1360
|
#13 0x00005627cc4cf716 in do_handle_one_connection (connect=0x5627ceb82cb0) at /data/src/10.4/sql/sql_connect.cc:1404
|
#14 0x00005627cc4cf465 in handle_one_connection (arg=0x5627ceb82cb0) at /data/src/10.4/sql/sql_connect.cc:1306
|
#15 0x00005627ccdfab09 in pfs_spawn_thread (arg=0x5627cebe6630) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#16 0x00007ffb94f824a4 in start_thread (arg=0x7ffb8d5e0700) at pthread_create.c:456
|
#17 0x00007ffb934cad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|
10.4 09e9f884 non-debug
|
#3 <signal handler called>
|
#4 handler::mark_trx_read_write (this=0xffffff7f88081980) at /data/src/10.4/sql/handler.h:4512
|
#5 handler::ha_write_row (this=0xffffff7f88081980, buf=buf@entry=0x7f4288080670 "\375\001") at /data/src/10.4/sql/handler.cc:6671
|
#6 0x00005622a348606b in ha_partition::write_row (this=0x7f4288080a40, buf=0x7f4288080670 "\375\001") at /data/src/10.4/sql/ha_partition.cc:4318
|
#7 0x00005622a2fe518e in handler::ha_write_row (this=0x7f4288080a40, buf=0x7f4288080670 "\375\001") at /data/src/10.4/sql/handler.cc:6682
|
#8 0x00005622a2db4f66 in write_record (thd=thd@entry=0x7f42880009a8, table=table@entry=0x7f42880872b8, info=info@entry=0x7f4298f528d0) at /data/src/10.4/sql/sql_insert.cc:2037
|
#9 0x00005622a2dbc0dd in mysql_insert (thd=thd@entry=0x7f42880009a8, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>) at /data/src/10.4/sql/sql_insert.cc:1075
|
#10 0x00005622a2de8bac in mysql_execute_command (thd=thd@entry=0x7f42880009a8) at /data/src/10.4/sql/sql_parse.cc:4528
|
#11 0x00005622a2ded6c9 in mysql_parse (thd=thd@entry=0x7f42880009a8, rawbuf=<optimized out>, length=29, parser_state=parser_state@entry=0x7f4298f551c0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:7908
|
#12 0x00005622a2defa4e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f42880009a8, packet=packet@entry=0x7f4288007979 "INSERT INTO t1 (a) VALUES (1)", packet_length=packet_length@entry=29, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1843
|
#13 0x00005622a2df11c9 in do_command (thd=0x7f42880009a8) at /data/src/10.4/sql/sql_parse.cc:1360
|
#14 0x00005622a2ebf59e in do_handle_one_connection (connect=connect@entry=0x5622a59945c8) at /data/src/10.4/sql/sql_connect.cc:1404
|
#15 0x00005622a2ebf6b4 in handle_one_connection (arg=arg@entry=0x5622a59945c8) at /data/src/10.4/sql/sql_connect.cc:1306
|
#16 0x00005622a3467f44 in pfs_spawn_thread (arg=0x5622a59273b8) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#17 0x00007f42a08fa4a4 in start_thread (arg=0x7f4298f56700) at pthread_create.c:456
|
#18 0x00007f429ee42d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
|