[MDEV-18547] Assertion failure upon using session variable as INTERVAL parameter Created: 2019-02-12  Updated: 2019-02-15  Resolved: 2019-02-15

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Affects Version/s: 10.3, 10.4
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Aleksey Midenkov Assignee: Aleksey Midenkov
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-18136 Server crashes in Item_func_dyncol_cr... Closed

 Description   

Reproduce

set @a= 1;
create or replace table t1 (i int) with system versioning
partition by system_time interval @a day
(partition p0 history, partition pn current);

Result

mysqld: /home/midenok/src/mariadb/10.3/src/sql/item_func.cc:5284: virtual longlong Item_func_get_user_var::val_int(): Assertion `fixed == 1' failed.

#3  0x00007ffff6d14142 in __GI___assert_fail (assertion=0x15d05f1 "fixed == 1", file=0x15c837e "/home/midenok/src/mariadb/10.3/src/sql/item_func.cc", line=5284, function=0x15c9f9e "virtual longlong Item_func_get_user_var::val_int()") at assert.c:101
#4  0x0000000000b7b2e9 in Item_func_get_user_var::val_int (this=0x7fff84015830) at /home/midenok/src/mariadb/10.3/src/sql/item_func.cc:5284
#5  0x0000000000bf8e15 in get_interval_value (args=0x7fff84015830, int_type=INTERVAL_DAY, interval=0x7fff840157c8) at /home/midenok/src/mariadb/10.3/src/sql/item_timefunc.cc:1338
#6  0x0000000000a2698a in partition_info::vers_set_interval (this=0x7fff84015580, item=0x7fff84015830, int_type=INTERVAL_DAY, start=1549965985) at /home/midenok/src/mariadb/10.3/src/sql/partition_info.h:403
#7  0x00000000009f4d83 in MYSQLparse (thd=0x7fff84000cf8) at /home/midenok/src/mariadb/10.3/src/sql/sql_yacc.yy:6066
#8  0x000000000079477a in parse_sql (thd=0x7fff84000cf8, parser_state=0x7ffff4ab5640, creation_ctx=0x0, do_pfs_digest=true) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:10106
#9  0x000000000077fc40 in mysql_parse (thd=0x7fff84000cf8, rawbuf=0x7fff84014c50 "create or replace table t1 (i int) with system versioning partition by system_time interval @a day (partition p0 history, partition pn current)", length=143, parser_state=0x7ffff4ab5640, is_com_multi=false, is_next_command=false) at /home/midenok/src/mariadb/10.3/src/sql/sql_parse.cc:8048


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