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

Assertion `fixed || state == NO_VALUE' failed in Item_param::basic_const_item

    XMLWordPrintable

Details

    Description

      Setting to minor, as it's an old 10.3-only debug failure. 10.3 goes EOL anyway, so it won't be fixed, filing it for the record.

      CREATE TABLE t (a INT);
      INSERT INTO t VALUES (1),(2);
      PREPARE stmt FROM 'SELECT * FROM t ORDER BY ?';
      ALTER TABLE t ADD INDEX (a);
      EXECUTE stmt USING 1;
       
      # Cleanup
      DROP TABLE t;
      

      10.3 55a53949

      mysqld: /data/src/10.3/sql/item.cc:4956: virtual bool Item_param::basic_const_item() const: Assertion `fixed || state == NO_VALUE' failed.
      230503 19:04:55 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f0747e53df2 in __GI___assert_fail (assertion=0x5635f86479a0 "fixed || state == NO_VALUE", file=0x5635f8643800 "/data/src/10.3/sql/item.cc", line=4956, function=0x5635f86479e0 "virtual bool Item_param::basic_const_item() const") at ./assert/assert.c:101
      #10 0x00005635f6db33c4 in Item_param::basic_const_item (this=0x62b0000412e8) at /data/src/10.3/sql/item.cc:4956
      #11 0x00005635f673483c in find_order_in_list (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, order=0x62b0000414b0, fields=..., all_fields=..., is_group_field=false, add_to_all_fields=true, from_window_spec=false) at /data/src/10.3/sql/sql_select.cc:23681
      #12 0x00005635f6735be5 in setup_order (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, fields=..., all_fields=..., order=0x62b0000414b0, from_window_spec=false) at /data/src/10.3/sql/sql_select.cc:23846
      #13 0x00005635f6684503 in setup_without_group (thd=0x62a000060208, ref_pointer_array=..., tables=0x62b000040c30, leaves=..., fields=..., all_fields=..., conds=0x62b000000fe8, order=0x62b0000414b0, group=0x0, win_specs=..., win_funcs=..., hidden_group_fields=0x62b000000ec7, reserved=0x62b00003fdc4) at /data/src/10.3/sql/sql_select.cc:691
      #14 0x00005635f668a45b in JOIN::prepare (this=0x62b000000be0, tables_init=0x62b000040c30, wild_num=0, conds_init=0x0, og_num=1, order_init=0x62b0000414b0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x62b00003fab8, unit_arg=0x62b00003f2f8) at /data/src/10.3/sql/sql_select.cc:1181
      #15 0x00005635f66abec6 in mysql_select (thd=0x62a000060208, tables=0x62b000040c30, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x62b0000414b0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x62b000041520, unit=0x62b00003f2f8, select_lex=0x62b00003fab8) at /data/src/10.3/sql/sql_select.cc:4371
      #16 0x00005635f668205b in handle_select (thd=0x62a000060208, lex=0x62b00003f238, result=0x62b000041520, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:372
      #17 0x00005635f65f66e6 in execute_sqlcom_select (thd=0x62a000060208, all_tables=0x62b000040c30) at /data/src/10.3/sql/sql_parse.cc:6340
      #18 0x00005635f65e44b7 in mysql_execute_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:3871
      #19 0x00005635f6650b29 in Prepared_statement::execute (this=0x619000082088, expanded_query=0x7f073f041dd0, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:5029
      #20 0x00005635f664bf58 in Prepared_statement::execute_loop (this=0x619000082088, expanded_query=0x7f073f041dd0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4457
      #21 0x00005635f6646148 in mysql_sql_stmt_execute (thd=0x62a000060208) at /data/src/10.3/sql/sql_prepare.cc:3545
      #22 0x00005635f65e44fc in mysql_execute_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:3887
      #23 0x00005635f6600180 in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "EXECUTE stmt USING 1", length=20, parser_state=0x7f073f0439b0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7855
      #24 0x00005635f65d6faf in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000dc209 "EXECUTE stmt USING 1", packet_length=20, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1852
      #25 0x00005635f65d3b47 in do_command (thd=0x62a000060208) at /data/src/10.3/sql/sql_parse.cc:1398
      #26 0x00005635f699bf5c in do_handle_one_connection (connect=0x6080000006a8) at /data/src/10.3/sql/sql_connect.cc:1404
      #27 0x00005635f699b889 in handle_one_connection (arg=0x6080000006a8) at /data/src/10.3/sql/sql_connect.cc:1309
      #28 0x00005635f7f82bd5 in pfs_spawn_thread (arg=0x615000003008) at /data/src/10.3/storage/perfschema/pfs.cc:1869
      #29 0x00007f0747ea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #30 0x00007f0747f285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.