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

Assertion `escape != -1000` failed in Item_func_like::val_bool() on CREATE VIEW with LIKE ... ESCAPE

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      MTR/CLI compatible test case

      CREATE VIEW v1 AS SELECT 1 WHERE 1 AND 'a' LIKE 'a' ESCAPE CURRENT_USER;
      

      Leads to:

      CS 11.4.13 eccf9ca5f15bdca5b8e887396d9a570d580eb4ee (Debug, Clang 18.1.3-11) Build 29/07/2026

      mariadbd: /test/11.4_dbg/sql/item_cmpfunc.cc:5870: virtual bool Item_func_like::val_bool(): Assertion `escape != -1000' failed.
      

      CS 11.4.13 eccf9ca5f15bdca5b8e887396d9a570d580eb4ee (Debug, Clang 18.1.3-11) Build 29/07/2026

      Core was generated by `/test/MD290726-mariadb-11.4.13-linux-x86_64-dbg/bin/mariadbd --no-defaults --lo'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 2323420)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000077696e84527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000077696e8288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000077696e82881b in __assert_fail_base (fmt=0x77696e9d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x649f64c0fe76 "escape != -1000", file=file@entry=0x649f64c0e6bd "/test/11.4_dbg/sql/item_cmpfunc.cc", line=line@entry=5870, function=function@entry=0x649f64c0fe2d "virtual bool Item_func_like::val_bool()") at ./assert/assert.c:96
      #6  0x000077696e83b517 in __assert_fail (assertion=0x649f64c0fe76 "escape != -1000", file=0x649f64c0e6bd "/test/11.4_dbg/sql/item_cmpfunc.cc", line=5870, function=0x649f64c0fe2d "virtual bool Item_func_like::val_bool()")at ./assert/assert.c:105
      #7  0x0000649f63fd6352 in Item_func_like::val_bool (this=0x6f68b801ad50)at /test/11.4_dbg/sql/item_cmpfunc.cc:5870
      #8  0x0000649f63c26284 in Item::eval_const_cond (this=0x6f68b801ad50)at /test/11.4_dbg/sql/item.h:1753
      #9  0x0000649f63fd408f in Item_cond::eval_not_null_tables (this=0x6f68b801ae98, opt_arg=0x0)at /test/11.4_dbg/sql/item_cmpfunc.cc:5208
      #10 0x0000649f63fd3e09 in Item_cond::fix_fields (this=0x6f68b801ae98, thd=0x6f68b8000d58, ref=0x6f68b801bee8)at /test/11.4_dbg/sql/item_cmpfunc.cc:5125
      #11 0x0000649f63a235da in Item::fix_fields_if_needed (this=0x6f68b801ae98, thd=0x6f68b8000d58, ref=0x6f68b801bee8) at /test/11.4_dbg/sql/item.h:1185
      #12 0x0000649f63a22889 in Item::fix_fields_if_needed_for_scalar (this=0x6f68b801ae98, thd=0x6f68b8000d58, ref=0x6f68b801bee8)at /test/11.4_dbg/sql/item.h:1194
      #13 0x0000649f63ab1df5 in Item::fix_fields_if_needed_for_bool (this=0x6f68b801ae98, thd=0x6f68b8000d58, ref=0x6f68b801bee8)at /test/11.4_dbg/sql/item.h:1198
      #14 0x0000649f63aaaebd in setup_conds (thd=0x6f68b8000d58, tables=0x0, leaves=@0x6f68b801a7b8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x649f657074e0 <end_of_list>, last = 0x6f68b801a7b8, elements = 0}, <No data fields>}, conds=0x6f68b801bee8) at /test/11.4_dbg/sql/sql_base.cc:9062
      #15 0x0000649f63bc4bc6 in setup_without_group (thd=0x6f68b8000d58, ref_pointer_array={m_array = 0x6f68b801c218, m_size = 5}, tables=0x0, leaves=@0x6f68b801a7b8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x649f657074e0 <end_of_list>, last = 0x6f68b801a7b8, elements = 0}, <No data fields>}, fields=@0x6f68b801a858: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6f68b801aaf0, last = 0x6f68b801aaf0, elements = 1}, <No data fields>}, all_fields=@0x6f68b801be00: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6f68b801aaf0, last = 0x6f68b801aaf0, elements = 1}, <No data fields>}, conds=0x6f68b801bee8, order=0x0, group=0x0, win_specs=@0x6f68b801aa20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x649f657074e0 <end_of_list>, last = 0x6f68b801aa20, elements = 0}, <No data fields>}, win_funcs=@0x6f68b801aa40: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x649f657074e0 <end_of_list>, last = 0x6f68b801aa40, elements = 0}, <No data fields>}, hidden_group_fields=0x6f68b801bdaf)at /test/11.4_dbg/sql/sql_select.cc:965
      #16 0x0000649f63bc338c in JOIN::prepare (this=0x6f68b801ba58, tables_init=0x0, conds_init=0x6f68b801ae98, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x6f68b801a5a0, unit_arg=0x6f68b8005018)at /test/11.4_dbg/sql/sql_select.cc:1603
      #17 0x0000649f63cae05b in st_select_lex_unit::prepare_join (this=0x6f68b8005018, thd_arg=0x6f68b8000d58, sl=0x6f68b801a5a0, tmp_result=0x0, additional_options=0, is_union_select=false)at /test/11.4_dbg/sql/sql_union.cc:1113
      #18 0x0000649f63ca9014 in st_select_lex_unit::prepare (this=0x6f68b8005018, derived_arg=0x0, sel_result=0x0, additional_options=0)at /test/11.4_dbg/sql/sql_union.cc:1587
      #19 0x0000649f63cc86aa in mysql_create_view (thd=0x6f68b8000d58, views=0x6f68b8019e88, mode=VIEW_CREATE_NEW)at /test/11.4_dbg/sql/sql_view.cc:563
      #20 0x0000649f63b62246 in mysql_execute_command (thd=0x6f68b8000d58, is_called_from_prepared_stmt=false) at /test/11.4_dbg/sql/sql_parse.cc:5718
      #21 0x0000649f63b520e4 in mysql_parse (thd=0x6f68b8000d58, rawbuf=0x6f68b8019d30 "CREATE VIEW v1 AS SELECT 1 WHERE 1 AND 'a' LIKE 'a' ESCAPE CURRENT_USER", length=71, parser_state=0x77696c0c9b30)at /test/11.4_dbg/sql/sql_parse.cc:7941
      #22 0x0000649f63b4f509 in dispatch_command (command=COM_QUERY, thd=0x6f68b8000d58, packet=0x6f68b800afa9 "CREATE VIEW v1 AS SELECT 1 WHERE 1 AND 'a' LIKE 'a' ESCAPE CURRENT_USER", packet_length=71, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1925
      #23 0x0000649f63b52c93 in do_command (thd=0x6f68b8000d58, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1433
      #24 0x0000649f63d39799 in do_handle_one_connection (connect=0x649f72beeaf8, put_in_cache=true) at /test/11.4_dbg/sql/sql_connect.cc:1508
      #25 0x0000649f63d39532 in handle_one_connection (arg=0x649f72bcd3b8)at /test/11.4_dbg/sql/sql_connect.cc:1420
      #26 0x000077696e89cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #27 0x000077696e929d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed
      CS  10.6   dbg  270726  67ea07dd3400004e4f7ae01bf977f4344bbe064b  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  10.6   opt  310726  67ea07dd3400004e4f7ae01bf977f4344bbe064b  No bug found
      CS  10.11  dbg  310726  cea98ec09dd9a226047b09bc1f8516003b416e1c  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  10.11  opt  270726  cea98ec09dd9a226047b09bc1f8516003b416e1c  No bug found
      CS  11.4   dbg  290726  eccf9ca5f15bdca5b8e887396d9a570d580eb4ee  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  11.4   opt  290726  eccf9ca5f15bdca5b8e887396d9a570d580eb4ee  No bug found
      CS  11.8   dbg  310726  eaca80bf3208fb9657b7304b940a6726b4c86213  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  11.8   opt  310726  eaca80bf3208fb9657b7304b940a6726b4c86213  No bug found
      CS  12.3   dbg  310726  33240f3c96c3ced4698b33d2c6d51a520a1d9613  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  12.3   opt  310726  33240f3c96c3ced4698b33d2c6d51a520a1d9613  No bug found
      CS  13.0   dbg  310726  1a4bb1bbfde5fa17ba148cb62678902f11c66a1a  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  13.0   opt  310726  1a4bb1bbfde5fa17ba148cb62678902f11c66a1a  No bug found
      CS  13.1   dbg  310726  cded2b25e65853a75c2213cfe0832819832708bd  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      CS  13.1   opt  310726  9b794f34b48fb7eee490b6da44edc0f33a947447  No bug found
      ES  10.6   dbg  040825  90f707057d44f1b5c013a0c3672fd12f32ea7085  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      ES  10.6   opt  040825  9b794f34b48fb7eee490b6da44edc0f33a947447  No bug found
      ES  11.4   dbg  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      ES  11.4   opt  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found
      ES  11.8   dbg  060526  1499789de285a8109d68d79347de0281865b28f4  escape != -1000|SIGABRT|Item_func_like::val_bool|Item::eval_const_cond|Item_cond::eval_not_null_tables|Item_cond::fix_fields
      ES  11.8   opt  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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