Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.4, 11.8, 12.0
Description
--source include/have_innodb.inc
|
|
SET transaction_isolation='READ-UNCOMMITTED'; |
CREATE TABLE t (a VARCHAR(10),b INT,c CHAR(10) GENERATED ALWAYS AS (a) VIRTUAL,KEY(b,c)) ENGINE=InnoDB; |
INSERT INTO t (a) VALUES ('A'); |
SELECT * FROM t WHERE b IS NULL ORDER BY a; |
Leads to:
CS 11.4.8 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 (Debug) Build 26/05/2025 |
mariadbd: /test/11.4_dbg/sql/field.cc:8038: virtual String *Field_varstring::val_str(String *, String *): Assertion `marked_for_read()' failed.
|
CS 11.4.8 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 (Debug) Build 26/05/2025 |
Core was generated by `/test/MD260525-mariadb-11.4.8-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (LWP 1536204)]
|
(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 0x000075704ec4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x000075704ec288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x000075704ec2881b in __assert_fail_base (fmt=0x75704edd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5fe73271f710 "marked_for_read()", file=file@entry=0x5fe73271f1fa "/test/11.4_dbg/sql/field.cc", line=line@entry=8038, function=function@entry=0x5fe732721c88 "virtual String *Field_varstring::val_str(String *, String *)") at ./assert/assert.c:96
|
#6 0x000075704ec3b517 in __assert_fail (assertion=0x5fe73271f710 "marked_for_read()", file=0x5fe73271f1fa "/test/11.4_dbg/sql/field.cc", line=8038, function=0x5fe732721c88 "virtual String *Field_varstring::val_str(String *, String *)") at ./assert/assert.c:105
|
#7 0x00005fe731a994af in Field_varstring::val_str (this=0x755170030438, val_buffer=0x75704c1dda48, val_ptr=0x75704c1dda48)at /test/11.4_dbg/sql/field.cc:8038
|
#8 0x00005fe731a99a52 in Field_varstring::sort_string (this=0x755170030438, to=0x755170079409 '\245' <repeats 200 times>..., length=10)at /test/11.4_dbg/sql/field.cc:8184
|
#9 0x00005fe731a7cda7 in Field::make_sort_key_part (this=0x755170030438, buff=0x755170079409 '\245' <repeats 200 times>..., length=10)at /test/11.4_dbg/sql/field.cc:1080
|
#10 0x00005fe731abe1bb in make_sortkey (param=0x75704c1de378, to=0x755170079408 "\001", '\245' <repeats 199 times>...)at /test/11.4_dbg/sql/filesort.cc:2969
|
#11 0x00005fe731ab726f in make_sortkey (param=0x75704c1de378, to=0x755170079408 "\001", '\245' <repeats 199 times>..., ref_pos=0x755170031250 "", using_packed_sortkeys=false)at /test/11.4_dbg/sql/filesort.cc:1434
|
#12 0x00005fe731ab7d46 in find_all_keys (thd=0x755170000d58, param=0x75704c1de378, select=0x75517001ecb8, fs_info=0x7551700779a0, buffpek_pointers=0x75704c1de030, tempfile=0x75704c1de1a0, pq=0x0, found_rows=0x755170077b90) at /test/11.4_dbg/sql/filesort.cc:1050
|
#13 0x00005fe731ab58fd in filesort (thd=0x755170000d58, table=0x755170028478, filesort=0x75517001f640, tracker=0x75517001fdc0, join=0x75517001b5a8, first_table_bit=1) at /test/11.4_dbg/sql/filesort.cc:407
|
#14 0x00005fe73176920a in create_sort_index (thd=0x755170000d58, join=0x75517001b5a8, tab=0x75517001dc40, fsort=0x75517001f640)at /test/11.4_dbg/sql/sql_select.cc:27808
|
#15 0x00005fe731768e6a in st_join_table::sort_table (this=0x75517001dc40)at /test/11.4_dbg/sql/sql_select.cc:25320
|
#16 0x00005fe73173fd34 in join_init_read_record (tab=0x75517001dc40)at /test/11.4_dbg/sql/sql_select.cc:25240
|
#17 0x00005fe73171bfe1 in sub_select (join=0x75517001b5a8, join_tab=0x75517001dc40, end_of_records=false)at /test/11.4_dbg/sql/sql_select.cc:24235
|
#18 0x00005fe7317434f5 in do_select (join=0x75517001b5a8, procedure=0x0)at /test/11.4_dbg/sql/sql_select.cc:23749
|
#19 0x00005fe73174283a in JOIN::exec_inner (this=0x75517001b5a8)at /test/11.4_dbg/sql/sql_select.cc:5052
|
#20 0x00005fe73174171e in JOIN::exec (this=0x75517001b5a8)at /test/11.4_dbg/sql/sql_select.cc:4838
|
#21 0x00005fe73171c95d in mysql_select (thd=0x755170000d58, tables=0x75517001a1b0, fields=@0x755170019e30: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x75517001a160, last = 0x75517001c130, elements = 3}, <No data fields>}, conds=0x75517001a9f8, og_num=1, order=0x75517001b438, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x75517001b580, unit=0x755170005000, select_lex=0x755170019b78)at /test/11.4_dbg/sql/sql_select.cc:5368
|
#22 0x00005fe73171c3e5 in handle_select (thd=0x755170000d58, lex=0x755170004f20, result=0x75517001b580, setup_tables_done_option=0)at /test/11.4_dbg/sql/sql_select.cc:642
|
#23 0x00005fe7316c4431 in execute_sqlcom_select (thd=0x755170000d58, all_tables=0x75517001a1b0) at /test/11.4_dbg/sql/sql_parse.cc:6183
|
#24 0x00005fe7316b93c0 in mysql_execute_command (thd=0x755170000d58, is_called_from_prepared_stmt=false) at /test/11.4_dbg/sql/sql_parse.cc:3975
|
#25 0x00005fe7316b1544 in mysql_parse (thd=0x755170000d58, rawbuf=0x755170019ac0 "SELECT * FROM t WHERE b IS NULL ORDER BY a", length=42, parser_state=0x75704c1e0a30)at /test/11.4_dbg/sql/sql_parse.cc:7898
|
#26 0x00005fe7316ae9f4 in dispatch_command (command=COM_QUERY, thd=0x755170000d58, packet=0x75517000afd9 "", packet_length=42, blocking=true) at /test/11.4_dbg/sql/sql_parse.cc:1904
|
#27 0x00005fe7316b20f3 in do_command (thd=0x755170000d58, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1417
|
#28 0x00005fe731894919 in do_handle_one_connection (connect=0x5fe750b5e408, put_in_cache=true) at /test/11.4_dbg/sql/sql_connect.cc:1408
|
#29 0x00005fe7318946b2 in handle_one_connection (arg=0x5fe750c2e878)at /test/11.4_dbg/sql/sql_connect.cc:1320
|
#30 0x000075704ec9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#31 0x000075704ed29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
|
CS 10.5 dbg 280425 c461188ca6ad6ec3a54201eb87ebd75797d296df No bug found
|
CS 10.5 opt 280425 c461188ca6ad6ec3a54201eb87ebd75797d296df No bug found
|
CS 10.6 dbg 260525 8a4d3a044f9de992eabe725522bceea49fdd0e61 No bug found
|
CS 10.6 opt 260525 8a4d3a044f9de992eabe725522bceea49fdd0e61 No bug found
|
CS 10.11 dbg 260525 db188083c38a9aeba146c9d591e3ed12cce0b200 No bug found
|
CS 10.11 opt 260525 db188083c38a9aeba146c9d591e3ed12cce0b200 No bug found
|
CS 11.4 dbg 260525 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
|
CS 11.4 opt 260525 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 No bug found
|
CS 11.8 dbg 220425 805e7ca3adef50e17889ea17a1b86da6c3fb8580 marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
|
CS 11.8 opt 220425 805e7ca3adef50e17889ea17a1b86da6c3fb8580 No bug found
|
CS 12.0 dbg 130525 00a9afb5818433c26537ccaf6b2c59ad493dd473 marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
|
ES 10.5 dbg 050525 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found
|
ES 10.5 opt 050525 0d368ec0042a81d9549fc939fb742f82350b20ab No bug found
|
ES 10.6 dbg 050525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 10.6 opt 050525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 No bug found
|
ES 11.4 dbg 050525 9cd12544ebfd0d52d2158af66b5aced58121cf1f marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
|
ES 11.4 opt 050525 9cd12544ebfd0d52d2158af66b5aced58121cf1f No bug found
|
Attachments
Issue Links
- relates to
-
MDEV-21242 Wrong result or failed assertion upon SELECT under READ UNCOMMITTED with index on virtual column
-
- Confirmed
-