Details
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
- relates to
-
MDEV-24346 valgrind error in main.precedence
-
- Closed
-