Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18628

Assertion `fixed == 1' failed in Item_singlerow_subselect::val_int()

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
      CREATE TABLE t1 (v1 int);
       
      ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT 4 FROM dual) HOUR 
         (PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT) ;
      

      10.3 a4cd91c526933e87d78a

      /10.3/sql/item_subselect.cc:1317: virtual longlong Item_singlerow_subselect::val_int(): Assertion `fixed == 1' failed.
      190218 14:50:08 [ERROR] mysqld got signal 6 ;
      stdlib/abort.c:91(__GI_abort)[0x7fe54786302a]
      assert/assert.c:92(__assert_fail_base)[0x7fe547859bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe547859c82]
      sql/item_subselect.cc:1318(Item_singlerow_subselect::val_int())[0x562b506728ba]
      sql/item_timefunc.cc:1338(get_interval_value(Item*, interval_type, INTERVAL*))[0x562b506e1369]
      sql/partition_info.h:404(partition_info::vers_set_interval(Item*, interval_type, long))[0x562b50332c62]
      sql/sql_yacc.yy:6066(MYSQLparse(THD*))[0x562b502c74b6]
      sql/sql_parse.cc:10106(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x562b4fdd1bb2]
      sql/sql_parse.cc:8048(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x562b4fdc571b]
      sql/sql_parse.cc:1856(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562b4fda064a]
      sql/sql_parse.cc:1396(do_command(THD*))[0x562b4fd9d76c]
      sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x562b500f0fe8]
      sql/sql_connect.cc:1310(handle_one_connection)[0x562b500f09c5]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x562b5141b0b1]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe54849e6ba]
      x86_64/clone.S:111(clone)[0x7fe54793341d]
      

      signal 11 on non-debug build:

      190218 15:02:52 [ERROR] mysqld got signal 11 ;
      Server version: 10.3.12-MariaDB
       
      sql/item_cmpfunc.h:3264(THD::is_error() const)[0x561ddee2d621]
      sql/item_subselect.cc:1320(Item_singlerow_subselect::val_int())[0x561ddee2dafe]
      sql/item_timefunc.cc:1339(get_interval_value(Item*, interval_type, INTERVAL*))[0x561ddee4af5f]
      sql/partition_info.h:407(partition_info::vers_set_interval(Item*, interval_type, long))[0x561dded50ba5]
      sql/sql_yacc.yy:6066(MYSQLparse(THD*))[0x561dded2d775]
      sql/sql_parse.cc:10103(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x561ddebe6205]
      sql/sql_parse.cc:8047(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561ddebe64a6]
      sql/sql_parse.cc:1851(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561ddebe86f5]
      sql/sql_parse.cc:1398(do_command(THD*))[0x561ddebe8e9e]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x561ddecb081f]
      sql/sql_connect.cc:1310(handle_one_connection)[0x561ddecb0944]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fdaac1bd6ba]
      x86_64/clone.S:111(clone)[0x7fdaab02241d]
       
      Query (0x7fda440115c0): ALTER TABLE t1 PARTITION BY system_time INTERVAL (SELECT 4 FROM dual) HOUR     (PARTITION ver_p1 HISTORY, PARTITION ver_pn CURRENT)
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.