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

Assertion `0' failed in Field_new_decimal::get_equal_const_item

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t (a DECIMAL(5,2), b INT);
      SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t);
       
      # Cleanup
      DROP TABLE t;
      

      10.3 df4c3d96

      mysqld: /src/sql/field.cc:3624: virtual Item* Field_new_decimal::get_equal_const_item(THD*, const Value_source::Context&, Item*): Assertion `0' failed.
      221118 16:32:15 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007fcd5cbae662 in __GI___assert_fail (assertion=0x55a51741fa20 "0", file=0x55a517421fc0 "/src/sql/field.cc", line=3624, function=0x55a517424620 "virtual Item* Field_new_decimal::get_equal_const_item(THD*, const Value_source::Context&, Item*)") at assert.c:101
      #8  0x000055a515b95126 in Field_new_decimal::get_equal_const_item (this=0x619000081700, thd=0x62a000060208, ctx=..., const_item=0x62b000003e28) at /src/sql/field.cc:3624
      #9  0x000055a515ca30f1 in Item_field::propagate_equal_fields (this=0x62b000000ba8, thd=0x62a000060208, ctx=..., arg=0x62b000004260) at /src/sql/item.cc:6552
      #10 0x000055a515caaa91 in Item::propagate_equal_fields_and_change_item_tree (this=0x62b000000ba8, thd=0x62a000060208, ctx=..., cond=0x62b000004260, place=0x62b0000056f8) at /src/sql/item.cc:7593
      #11 0x000055a515d690b0 in Item_args::propagate_equal_fields (this=0x62b0000056f0, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.cc:561
      #12 0x000055a515392d02 in Item_func::propagate_equal_fields (this=0x62b000005668, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.h:324
      #13 0x000055a515caaa91 in Item::propagate_equal_fields_and_change_item_tree (this=0x62b000005668, thd=0x62a000060208, ctx=..., cond=0x62b000004260, place=0x62b0000025f8) at /src/sql/item.cc:7593
      #14 0x000055a515d690b0 in Item_args::propagate_equal_fields (this=0x62b0000025f0, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.cc:561
      #15 0x000055a515392d02 in Item_func::propagate_equal_fields (this=0x62b000002568, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.h:324
      #16 0x000055a5155e274f in Item_func::build_equal_items (this=0x62b000002568, thd=0x62a000060208, inherited=0x62b000004260, link_item_fields=false, cond_equal_ref=0x0) at /src/sql/sql_select.cc:14649
      #17 0x000055a5155e117e in Item_cond_and::build_equal_items (this=0x62b000004178, thd=0x62a000060208, inherited=0x62b000004260, link_item_fields=true, cond_equal_ref=0x62b000004830) at /src/sql/sql_select.cc:14504
      #18 0x000055a5155e2c99 in build_equal_items (join=0x62b0000043f8, cond=0x62b000004178, inherited=0x0, join_list=0x62a000064a20, ignore_on_conds=false, cond_equal_ref=0x62b000004830, link_equal_fields=true) at /src/sql/sql_select.cc:14751
      #19 0x000055a5155ec18e in optimize_cond (join=0x62b0000043f8, conds=0x62b000004178, join_list=0x62a000064a20, ignore_on_conds=false, cond_value=0x62b000004708, cond_equal=0x62b000004830, flags=1) at /src/sql/sql_select.cc:16397
      #20 0x000055a51557fc27 in JOIN::optimize_inner (this=0x62b0000043f8) at /src/sql/sql_select.cc:1787
      #21 0x000055a51557d256 in JOIN::optimize (this=0x62b0000043f8) at /src/sql/sql_select.cc:1542
      #22 0x000055a51559a56b in mysql_select (thd=0x62a000060208, tables=0x62b0000004e0, wild_num=1, fields=..., conds=0x62b000004178, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b0000043c8, unit=0x62a0000640c0, select_lex=0x62a000064880) at /src/sql/sql_select.cc:4368
      #23 0x000055a515570f0b in handle_select (thd=0x62a000060208, lex=0x62a000064000, result=0x62b0000043c8, setup_tables_done_option=0) at /src/sql/sql_select.cc:372
      #24 0x000055a5154e5d79 in execute_sqlcom_select (thd=0x62a000060208, all_tables=0x62b0000004e0) at /src/sql/sql_parse.cc:6340
      #25 0x000055a5154d3e4a in mysql_execute_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:3871
      #26 0x000055a5154ef676 in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t)", length=88, parser_state=0x7fcd51fc4950, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:7855
      #27 0x000055a5154c6cc4 in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000eb209 "SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t)", packet_length=88, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:1852
      #28 0x000055a5154c387c in do_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:1398
      #29 0x000055a515887236 in do_handle_one_connection (connect=0x608000000ca8) at /src/sql/sql_connect.cc:1403
      #30 0x000055a515886b32 in handle_one_connection (arg=0x608000000ca8) at /src/sql/sql_connect.cc:1308
      #31 0x000055a516e3388d in pfs_spawn_thread (arg=0x615000004e08) at /src/storage/perfschema/pfs.cc:1869
      #32 0x00007fcd5cd59ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #33 0x00007fcd5cc79aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Reproducible on all 10.3+ (also previous minor releases), with at least MyISAM and InnoDB.

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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