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

Debug assertion failure during pushdown_cond_for_derived

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5
    • 10.5, 10.6
    • None
    • None

    Description

      Test case

      CREATE VIEW t AS SELECT 1 AS a;
      		 
      SELECT a FROM t WHERE CASE WHEN a THEN DEFAULT (a) END=0;

      Reproducible only after MDEV-34683 is merged.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31007 Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)' failed in find_producing_item

          • Major - Major loss of function.
          • Confirmed
          split from

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34683 Types mismatch when cloning items causes debug assertion

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova added a comment -

            For search:

            10.5 f41a120298aa17ca80eecaa68614a6addf91ebc6

            		 
            mariadbd: /data/bld/10.5-asan/sql/item.cc:7873: Item* find_producing_item(Item*, st_select_lex*): Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)' failed.
            		 
            240819 15:44:20 [ERROR] mysqld got signal 6 ;
            		 
             
            		 
            #9  0x00007f3a02053e32 in __GI___assert_fail (assertion=0x55d02a0a9120 "item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)", file=0x55d02a0a33e0 "/data/bld/10.5-asan/sql/item.cc", line=7873, function=0x55d02a0a9260 "Item* find_producing_item(Item*, st_select_lex*)") at ./assert/assert.c:101
            		 
            #10 0x000055d028292aa9 in find_producing_item (item=0x62900023a680, sel=0x62b00003bf70) at /data/bld/10.5-asan/sql/item.cc:7873
            		 
            #11 0x000055d028292f95 in Item_field::derived_field_transformer_for_where (this=0x62900023a680, thd=0x62b000069218, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item.cc:7909
            		 
            #12 0x000055d0282a6f80 in Item_default_value::transform (this=0x62900023a680, thd=0x62b000069218, transformer=&virtual Item::derived_field_transformer_for_where(THD*, unsigned char*), args=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item.cc:9841
            		 
            #13 0x000055d028358211 in Item_args::transform_args (this=0x62900023a860, thd=0x62b000069218, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:503
            		 
            #14 0x000055d0283584a2 in Item_func::transform (this=0x62900023a7d0, thd=0x62b000069218, transformer=&virtual table offset 1344, argument=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:539
            		 
            #15 0x000055d028358211 in Item_args::transform_args (this=0x62900023aa08, thd=0x62b000069218, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:503
            		 
            #16 0x000055d0283584a2 in Item_func::transform (this=0x62900023a978, thd=0x62b000069218, transformer=&virtual table offset 1344, argument=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:539
            		 
            #17 0x000055d0278d4462 in transform_condition_or_part (thd=0x62b000069218, cond=0x62900023a978, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/sql_derived.cc:1390
            		 
            #18 0x000055d02796a10b in st_select_lex::pushdown_cond_into_where_clause (this=0x62b00003bf70, thd=0x62b000069218, cond=0x62900023a978, remaining_cond=0x7f39f8865130, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/sql_lex.cc:10757
            		 
            #19 0x000055d0278d51e8 in pushdown_cond_for_derived (thd=0x62b000069218, cond=0x62b0000396f0, derived=0x62b0000389b8) at /data/bld/10.5-asan/sql/sql_derived.cc:1583
            		 
            #20 0x000055d027a73f17 in JOIN::optimize_inner (this=0x62b00003d380) at /data/bld/10.5-asan/sql/sql_select.cc:2229
            		 
            #21 0x000055d027a6ee09 in JOIN::optimize (this=0x62b00003d380) at /data/bld/10.5-asan/sql/sql_select.cc:1765
            		 
            #22 0x000055d027a8fe00 in mysql_select (thd=0x62b000069218, tables=0x62b0000389b8, fields=..., conds=0x62b0000396f0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b00003d350, unit=0x62b00006d3c8, select_lex=0x62b000038318) at /data/bld/10.5-asan/sql/sql_select.cc:4900
            		 
            #23 0x000055d027a603bc in handle_select (thd=0x62b000069218, lex=0x62b00006d300, result=0x62b00003d350, setup_tables_done_option=0) at /data/bld/10.5-asan/sql/sql_select.cc:449
            		 
            #24 0x000055d0279c77de in execute_sqlcom_select (thd=0x62b000069218, all_tables=0x62b0000389b8) at /data/bld/10.5-asan/sql/sql_parse.cc:6431
            		 
            #25 0x000055d0279b5aed in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4030
            		 
            #26 0x000055d0279d25ed in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "SELECT a FROM t WHERE CASE WHEN a THEN DEFAULT (a) END=0", length=56, parser_state=0x7f39f8866c10, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8229
            		 
            #27 0x000055d0279a7799 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "SELECT a FROM t WHERE CASE WHEN a THEN DEFAULT (a) END=0", packet_length=56, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1892
            		 
            #28 0x000055d0279a412c in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1376
            		 
            #29 0x000055d027dfc2b9 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1417
            		 
            #30 0x000055d027dfbc81 in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319
            		 
            #31 0x000055d028a59046 in pfs_spawn_thread (arg=0x615000005318) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201
            		 
            #32 0x00007f3a020a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
            		 
            #33 0x00007f3a0212861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

            elenst Elena Stepanova added a comment - For search: 10.5 f41a120298aa17ca80eecaa68614a6addf91ebc6 mariadbd: /data/bld/10.5-asan/sql/item.cc:7873: Item* find_producing_item(Item*, st_select_lex*): Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)' failed. 240819 15:44:20 [ERROR] mysqld got signal 6 ;   #9 0x00007f3a02053e32 in __GI___assert_fail (assertion=0x55d02a0a9120 "item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)", file=0x55d02a0a33e0 "/data/bld/10.5-asan/sql/item.cc", line=7873, function=0x55d02a0a9260 "Item* find_producing_item(Item*, st_select_lex*)") at ./assert/assert.c:101 #10 0x000055d028292aa9 in find_producing_item (item=0x62900023a680, sel=0x62b00003bf70) at /data/bld/10.5-asan/sql/item.cc:7873 #11 0x000055d028292f95 in Item_field::derived_field_transformer_for_where (this=0x62900023a680, thd=0x62b000069218, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item.cc:7909 #12 0x000055d0282a6f80 in Item_default_value::transform (this=0x62900023a680, thd=0x62b000069218, transformer=&virtual Item::derived_field_transformer_for_where(THD*, unsigned char*), args=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item.cc:9841 #13 0x000055d028358211 in Item_args::transform_args (this=0x62900023a860, thd=0x62b000069218, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:503 #14 0x000055d0283584a2 in Item_func::transform (this=0x62900023a7d0, thd=0x62b000069218, transformer=&virtual table offset 1344, argument=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:539 #15 0x000055d028358211 in Item_args::transform_args (this=0x62900023aa08, thd=0x62b000069218, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:503 #16 0x000055d0283584a2 in Item_func::transform (this=0x62900023a978, thd=0x62b000069218, transformer=&virtual table offset 1344, argument=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/item_func.cc:539 #17 0x000055d0278d4462 in transform_condition_or_part (thd=0x62b000069218, cond=0x62900023a978, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/sql_derived.cc:1390 #18 0x000055d02796a10b in st_select_lex::pushdown_cond_into_where_clause (this=0x62b00003bf70, thd=0x62b000069218, cond=0x62900023a978, remaining_cond=0x7f39f8865130, transformer=&virtual table offset 1344, arg=0x62b00003bf70 "") at /data/bld/10.5-asan/sql/sql_lex.cc:10757 #19 0x000055d0278d51e8 in pushdown_cond_for_derived (thd=0x62b000069218, cond=0x62b0000396f0, derived=0x62b0000389b8) at /data/bld/10.5-asan/sql/sql_derived.cc:1583 #20 0x000055d027a73f17 in JOIN::optimize_inner (this=0x62b00003d380) at /data/bld/10.5-asan/sql/sql_select.cc:2229 #21 0x000055d027a6ee09 in JOIN::optimize (this=0x62b00003d380) at /data/bld/10.5-asan/sql/sql_select.cc:1765 #22 0x000055d027a8fe00 in mysql_select (thd=0x62b000069218, tables=0x62b0000389b8, fields=..., conds=0x62b0000396f0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b00003d350, unit=0x62b00006d3c8, select_lex=0x62b000038318) at /data/bld/10.5-asan/sql/sql_select.cc:4900 #23 0x000055d027a603bc in handle_select (thd=0x62b000069218, lex=0x62b00006d300, result=0x62b00003d350, setup_tables_done_option=0) at /data/bld/10.5-asan/sql/sql_select.cc:449 #24 0x000055d0279c77de in execute_sqlcom_select (thd=0x62b000069218, all_tables=0x62b0000389b8) at /data/bld/10.5-asan/sql/sql_parse.cc:6431 #25 0x000055d0279b5aed in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4030 #26 0x000055d0279d25ed in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "SELECT a FROM t WHERE CASE WHEN a THEN DEFAULT (a) END=0", length=56, parser_state=0x7f39f8866c10, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8229 #27 0x000055d0279a7799 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "SELECT a FROM t WHERE CASE WHEN a THEN DEFAULT (a) END=0", packet_length=56, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1892 #28 0x000055d0279a412c in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1376 #29 0x000055d027dfc2b9 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1417 #30 0x000055d027dfbc81 in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319 #31 0x000055d028a59046 in pfs_spawn_thread (arg=0x615000005318) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201 #32 0x00007f3a020a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442 #33 0x00007f3a0212861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
            elenst Elena Stepanova added a comment -

            And it appears to be a duplicate of, or very similar to, MDEV-31007.

            elenst Elena Stepanova added a comment - And it appears to be a duplicate of, or very similar to, MDEV-31007 .

            People

              Johnston Rex Johnston
              oleg.smirnov Oleg Smirnov
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.