[MDEV-18136] Server crashes in Item_func_dyncol_create::prepare_arguments Created: 2019-01-04  Updated: 2019-05-23  Resolved: 2019-05-20

Status: Closed
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.3.16, 10.4.5

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-18547 Assertion failure upon using session ... Closed
is duplicated by MDEV-18628 Assertion `fixed == 1' failed in Item... Closed
Relates
relates to MDEV-19569 Assertion `table_list->table' failed ... Closed

 Description   

--source include/have_partition.inc
 
CREATE TABLE t1 (pk int) WITH SYSTEM versioning partition BY system_time interval 7 second (partition `ver_p1` history,partition `ver_pn` CURRENT) ;
ALTER TABLE t1 partition BY system_time interval column_get(column_create(7,7),7 AS int) second (partition ver_p1 history, partition ver_pn CURRENT);

10.3 d27bea9e9a8a89861870980

#3  <signal handler called>
#4  0x0000558dbe2c75ab in Item_func_dyncol_create::prepare_arguments (this=0x7f91f4015988, thd=0x7f91f4000b00, force_names_arg=false) at /git/10.3/sql/item_strfunc.cc:4491
#5  0x0000558dbe2c8021 in Item_func_dyncol_create::val_str (this=0x7f91f4015988, str=0x7f924a0c5f00) at /git/10.3/sql/item_strfunc.cc:4578
#6  0x0000558dbe2c8ca2 in Item_dyncol_get::get_dyn_value (this=0x7f91f4015b08, thd=0x7f91f4000b00, val=0x7f924a0c5f20, tmp=0x7f924a0c5f00) at /git/10.3/sql/item_strfunc.cc:4827
#7  0x0000558dbe2c929f in Item_dyncol_get::val_int (this=0x7f91f4015b08) at /git/10.3/sql/item_strfunc.cc:4943
#8  0x0000558dbe2ccc45 in Item_dyncol_get::val_int_signed_typecast (this=0x7f91f4015b08) at /git/10.3/sql/item_strfunc.h:1756
#9  0x0000558dbe29b305 in Item_func_signed::val_int (this=0x7f91f4015bc8) at /git/10.3/sql/item_func.h:897
#10 0x0000558dbe2ff139 in get_interval_value (args=0x7f91f4015bc8, int_type=INTERVAL_SECOND, interval=0x7f91f4015748) at /git/10.3/sql/item_timefunc.cc:1338
#11 0x0000558dbe17790a in partition_info::vers_set_interval (this=0x7f91f4015500, item=0x7f91f4015bc8, int_type=INTERVAL_SECOND, start=1546865683) at /git/10.3/sql/partition_info.h:403
#12 0x0000558dbe146f11 in MYSQLparse (thd=0x7f91f4000b00) at /git/10.3/sql/sql_yacc.yy:6066
#13 0x0000558dbdf1e168 in parse_sql (thd=0x7f91f4000b00, parser_state=0x7f924a0c8470, creation_ctx=0x0, do_pfs_digest=true) at /git/10.3/sql/sql_parse.cc:10103
#14 0x0000558dbdf192c1 in mysql_parse (thd=0x7f91f4000b00, rawbuf=0x7f91f4014cd8 "ALTER TABLE t1 partition BY system_time interval column_get(column_create(7,7),7 AS int) second (partition ver_p1 history, partition ver_pn CURRENT)", length=148, parser_state=0x7f924a0c8470, is_com_multi=false, is_next_command=false) at /git/10.3/sql/sql_parse.cc:8045
#15 0x0000558dbdf06307 in dispatch_command (command=COM_QUERY, thd=0x7f91f4000b00, packet=0x7f91f4161121 "ALTER TABLE t1 partition BY system_time interval column_get(column_create(7,7),7 AS int) second (partition ver_p1 history, partition ver_pn CURRENT)", packet_length=148, is_com_multi=false, is_next_command=false) at /git/10.3/sql/sql_parse.cc:1851
#16 0x0000558dbdf04d24 in do_command (thd=0x7f91f4000b00) at /git/10.3/sql/sql_parse.cc:1396
#17 0x0000558dbe06c930 in do_handle_one_connection (connect=0x558dc1d28cc0) at /git/10.3/sql/sql_connect.cc:1402
#18 0x0000558dbe06c681 in handle_one_connection (arg=0x558dc1d28cc0) at /git/10.3/sql/sql_connect.cc:1308
#19 0x0000558dbe946c78 in pfs_spawn_thread (arg=0x558dc1d31260) at /git/10.3/storage/perfschema/pfs.cc:1862
#20 0x00007f92516f96ba in start_thread (arg=0x7f924a0c9700) at pthread_create.c:333
#21 0x00007f9250b8e41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Repeatable with Innodb/MyIsam



 Comments   
Comment by Alexander Barkov [ 2019-05-20 ]

Reviewed and merged to 10.3.

Generated at Thu Feb 08 08:41:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.