Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11
-
Can result in hang or crash
Description
CREATE TABLE t1 (c1 INT); |
UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1; |
Leads to:
|
CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026 |
mariadbd: /test/10.11_dbg/sql/sql_update.cc:1498: bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *): Assertion `!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()' failed.
|
|
CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026 |
Core was generated by `/test/MD140926-mariadb-10.11.19-linux-x86_64-dbg/bin/mariadbd --no-defaults --l'.
|
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 1893950)]
|
(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 0x00007d8aa7e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007d8aa7e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007d8aa7e2881b in __assert_fail_base (fmt=0x7d8aa7fd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x618807eee60d "!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()", file=file@entry=0x618807f0fc1a "/test/10.11_dbg/sql/sql_update.cc", line=line@entry=1498, function=function@entry=0x618807f0fddf "bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *)") at ./assert/assert.c:96
|
#6 0x00007d8aa7e3b517 in __assert_fail (assertion=0x618807eee60d "!table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()", file=0x618807f0fc1a "/test/10.11_dbg/sql/sql_update.cc", line=1498, function=0x618807f0fddf "bool mysql_prepare_update(THD *, TABLE_LIST *, Item **, uint, ORDER *)") at ./assert/assert.c:105
|
#7 0x0000618807057043 in mysql_prepare_update (thd=0x7589c4000d58, table_list=0x7589c40136b0, conds=0x7d8aa42f3290, order_num=0, order=0x0)at /test/10.11_dbg/sql/sql_update.cc:1497
|
#8 0x0000618807052ca1 in mysql_update (thd=0x7589c4000d58, table_list=0x7589c40136b0, fields=@0x7589c4005b20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7589c4013f80, last = 0x7589c4013f80, elements = 1}, <No data fields>}, values=@0x7589c4005f88: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7589c4013f90, last = 0x7589c4013f90, elements = 1}, <No data fields>}, conds=0x7589c4013fa8, order_num=0, order=0x0, limit=18446744073709551615, ignore=false, found_return=0x7d8aa42f4158, updated_return=0x7d8aa42f4150)at /test/10.11_dbg/sql/sql_update.cc:485
|
#9 0x0000618806ef856b in mysql_execute_command (thd=0x7589c4000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:4497
|
#10 0x0000618806eee5b4 in mysql_parse (thd=0x7589c4000d58, rawbuf=0x7589c40134c0 "UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1", length=54, parser_state=0x7d8aa42f4ae0)at /test/10.11_dbg/sql/sql_parse.cc:8210
|
#11 0x0000618806eebaa9 in dispatch_command (command=COM_QUERY, thd=0x7589c4000d58, packet=0x7589c400af49 "UPDATE t1 FOR SYSTEM_TIME AS OF NOW() SET c1=1 WHERE 1", packet_length=54, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1924
|
#12 0x0000618806eef163 in do_command (thd=0x7589c4000d58, blocking=true)at /test/10.11_dbg/sql/sql_parse.cc:1434
|
#13 0x00006188070d0a99 in do_handle_one_connection (connect=0x618846663008, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1486
|
#14 0x00006188070d0832 in handle_one_connection (arg=0x6188467441c8)at /test/10.11_dbg/sql/sql_connect.cc:1398
|
#15 0x00007d8aa7e9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x00007d8aa7f29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.11 dbg 140926 6ab0036cf354c5b79284fd0007993a1171b94f6c !table_list->vers_conditions.need_setup() || !*conds || thd->stmt_arena->is_stmt_execute()|SIGABRT|mysql_prepare_update|mysql_update|mysql_execute_command|mysql_parse
|
CS 10.11 opt 140926 6ab0036cf354c5b79284fd0007993a1171b94f6c No bug found
|
CS 11.4 dbg 140926 03acdd67d599ab7136ef18c36f3479a306870290 No bug found
|
CS 11.4 opt 140926 03acdd67d599ab7136ef18c36f3479a306870290 No bug found
|
CS 11.8 dbg 140926 08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3 No bug found
|
CS 11.8 opt 140926 08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3 No bug found
|
CS 12.3 dbg 140926 0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f No bug found
|
CS 12.3 opt 140926 0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f No bug found
|
CS 13.1 dbg 140926 e30f2bd21e463d5f5f9f9210b75193a0257b8a8c No bug found
|
CS 13.1 opt 140926 e30f2bd21e463d5f5f9f9210b75193a0257b8a8c No bug found
|
CS 13.2 dbg 240926 45717ef4c736a6a92e0acf49399ce677bfcaea89 No bug found
|
CS 13.2 opt 240926 45717ef4c736a6a92e0acf49399ce677bfcaea89 No bug found
|
ES 11.4 dbg 060526 90f707057d44f1b5c013a0c3672fd12f32ea7085 No bug found
|
ES 11.4 opt 060526 90f707057d44f1b5c013a0c3672fd12f32ea7085 No bug found
|
ES 11.8 dbg 060526 1499789de285a8109d68d79347de0281865b28f4 No bug found
|
ES 11.8 opt 060526 1499789de285a8109d68d79347de0281865b28f4 No bug found
|
ES 12.3 dbg 280926 082387a5f3cbb877157998bb4baa95928f4aa121 No bug found
|
ES 12.3 opt 280926 082387a5f3cbb877157998bb4baa95928f4aa121 No bug found
|