Details
Description
SET sql_mode=''; |
CREATE TABLE t (c INT); |
LOCK TABLE t WRITE; |
CREATE OR REPLACE TABLE t (a INT AS (CONNECTION_ID())); |
CREATE TRIGGER a BEFORE INSERT ON t FOR EACH ROW SET @a:=1; |
INSERT INTO t VALUES (''); |
Testcase is CLI/MTR compatible.
Leads to:
|
CS 13.1.0 02e1853c894906737fe0ea5f836adb087b1a72ad (Debug, Clang 22.1.6-20260529) Build 05/06/2026 |
mariadbd: /test/13.0_dbg/sql/item_func.h:1497: virtual longlong Item_func_connection_id::val_int(): Assertion `fixed()' failed.
|
|
CS 13.1.0 02e1853c894906737fe0ea5f836adb087b1a72ad (Debug, Clang 22.1.6-20260529) Build 05/06/2026 |
Core was generated by `/test/MD050626-mariadb-13.1.0-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
|
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 1023836)]
|
(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 0x00007835f3e4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007835f3e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007835f3e2881b in __assert_fail_base (fmt=0x7835f3fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5993fd532df4 "fixed()", file=file@entry=0x5993fd532017 "/test/13.0_dbg/sql/item_func.h", line=line@entry=1497, function=function@entry=0x5993fd5edc4b "virtual longlong Item_func_connection_id::val_int()") at ./assert/assert.c:94
|
#6 0x00007835f3e3b507 in __assert_fail (assertion=0x5993fd532df4 "fixed()", file=0x5993fd532017 "/test/13.0_dbg/sql/item_func.h", line=1497, function=0x5993fd5edc4b "virtual longlong Item_func_connection_id::val_int()") at ./assert/assert.c:103
|
#7 0x00005993fca2e9d5 in Item_func_connection_id::val_int (this=0x7034f0087630) at /test/13.0_dbg/sql/item_func.h:1497
|
#8 0x00005993fc9b1888 in Item::save_int_in_field (this=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/item.cc:7328
|
#9 0x00005993fc829fd0 in Type_handler_int_result::Item_save_in_field (this=0x5993fe2616a0 <type_handler_ulong>, item=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/sql_type.cc:4512
|
#10 0x00005993fc9b19c5 in Item::save_in_field (this=0x7034f0087630, field=0x7034f0086cc0, no_conversions=false)at /test/13.0_dbg/sql/item.cc:7348
|
#11 0x00005993fc6f621a in TABLE::update_virtual_fields (this=0x7034f0085fc0, h=0x7034f0086410, update_mode=VCOL_UPDATE_FOR_WRITE)at /test/13.0_dbg/sql/table.cc:9409
|
#12 0x00005993fc4c578c in fill_record_n_invoke_before_triggers (thd=0x7034f0000d60, table=0x7034f0085fc0, ptr=0x7034f0087f40, values=@0x7034f001b110: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7034f001b1d0, last = 0x7034f001b1d0, elements = 1}, <No data fields>}, ignore_errors=false, event=TRG_EVENT_INSERT, skip_row_indicator=0x7835ebffbe6f) at /test/13.0_dbg/sql/sql_base.cc:9712
|
#13 0x00005993fc515345 in mysql_insert (thd=0x7034f0000d60, table_list=0x7034f001a4c0, fields=@0x7034f0006248: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006248, elements = 0}, <No data fields>}, values_list=@0x7034f0006290: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7034f001b1e0, last = 0x7034f001b1e0, elements = 1}, <No data fields>}, update_fields=@0x7034f0006278: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006278, elements = 0}, <No data fields>}, update_values=@0x7034f0006260: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5993fe231480 <end_of_list>, last = 0x7034f0006260, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false, result=0x0)at /test/13.0_dbg/sql/sql_insert.cc:1193
|
#14 0x00005993fc57c453 in mysql_execute_command (thd=0x7034f0000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:4502
|
#15 0x00005993fc573208 in mysql_parse (thd=0x7034f0000d60, rawbuf=0x7034f001a3c0 "INSERT INTO t VALUES ('')", length=25, parser_state=0x7835ebffd9f0) at /test/13.0_dbg/sql/sql_parse.cc:7945
|
#16 0x00005993fc57095e in dispatch_command (command=COM_QUERY, thd=0x7034f0000d60, packet=0x7034f000b5f1 "INSERT INTO t VALUES ('')", packet_length=25, blocking=true) at /test/13.0_dbg/sql/sql_parse.cc:1903
|
#17 0x00005993fc573c8a in do_command (thd=0x7034f0000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
|
#18 0x00005993fc744fae in do_handle_one_connection (connect=0x5993ff601830, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1503
|
#19 0x00005993fc744d91 in handle_one_connection (arg=0x5993ff6040d0)at /test/13.0_dbg/sql/sql_connect.cc:1415
|
#20 0x00007835f3e9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#21 0x00007835f3f29c3c 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 100426 f39b634db715cd9dc1835653d1ce544df2aa1613 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 10.6 opt 100426 f39b634db715cd9dc1835653d1ce544df2aa1613 No bug found
|
CS 10.11 dbg 100426 ba774a0a90fac0163babe9d7a964aa36503e1711 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 10.11 opt 100426 ba774a0a90fac0163babe9d7a964aa36503e1711 No bug found
|
CS 11.4 dbg 100426 dc89915ad9bf3dcb67e66d2844c77ec0403373de fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 11.4 opt 100426 dc89915ad9bf3dcb67e66d2844c77ec0403373de No bug found
|
CS 11.8 dbg 100426 e47db94aea7f0d6e0177e948486fc8860331f05f fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 11.8 opt 100426 e47db94aea7f0d6e0177e948486fc8860331f05f No bug found
|
CS 12.3 dbg 100426 f5bb9922107672e88f7b5cbdb3d25151cc5744bb fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 12.3 opt 100426 f5bb9922107672e88f7b5cbdb3d25151cc5744bb No bug found
|
CS 13.0 dbg 210526 c8e8d33309606e682c98675d594dbd23ebc2ddf6 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 13.0 opt 210526 c8e8d33309606e682c98675d594dbd23ebc2ddf6 No bug found
|
CS 13.1 dbg 050626 02e1853c894906737fe0ea5f836adb087b1a72ad fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
CS 13.1 opt 050626 02e1853c894906737fe0ea5f836adb087b1a72ad No bug found
|
ES 10.6 dbg 100426 84a80c8b38208d362225496da08d86d8d454e453 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
ES 10.6 opt 100426 84a80c8b38208d362225496da08d86d8d454e453 No bug found
|
ES 11.4 dbg 100426 8b2bf17b733262409422ce7d039a0c021fc47077 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
ES 11.4 opt 100426 8b2bf17b733262409422ce7d039a0c021fc47077 No bug found
|
ES 11.8 dbg 100426 854cae81f52e477c7777a51db26ba640d8755b81 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
ES 11.8 opt 100426 854cae81f52e477c7777a51db26ba640d8755b81 No bug found
|
ES 12.3 dbg 220426 613a6253fe9efc12e166f83a97663ba263db8317 fixed()|SIGABRT|Item_func_connection_id::val_int|Item::save_int_in_field|Type_handler_int_result::Item_save_in_field|Item::save_in_field
|
ES 12.3 opt 220426 613a6253fe9efc12e166f83a97663ba263db8317 No bug found
|
MS 5.5 dbg 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.5 opt 070123 bac287c315b1792e7ae33f91add6a60292f9bae8 No bug found
|
MS 5.6 dbg 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.6 opt 070123 dab95781a1244104d6b87020ac2fc4d190ba2946 No bug found
|
MS 5.7 dbg 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 5.7 opt 070525 f7680e98b6bbe3500399fbad465d08a6b75d7a5c No bug found
|
MS 8.0 dbg 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 8.0 opt 060224 49ef33f7edadef3ae04665e73d1babd40179a4f1 No bug found
|
MS 9.1 dbg 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|
MS 9.1 opt 211024 61a3a1d8ef15512396b4c2af46e922a19bf2b174 No bug found
|
Attachments
Issue Links
- relates to
-
MDEV-29173 Assertion `fixed()' or fixed == 1 failed in Item_func_date_format::val_str on INSERT when using binary logging
-
- Open
-
-
MDEV-29357 Assertion (fixed) in Item_func_dayname on INSERT
-
- Closed
-
-
MDEV-31081 Assertion `fixed()' failed in virtual double Item_func_hybrid_field_type::val_real()
-
- Open
-