Details
- 
    
Bug
 - 
    Status: Confirmed (View Workflow)
 - 
    
Major
 - 
    Resolution: Unresolved
 - 
    10.6, 10.11, 11.4, 11.8, 10.5(EOL), 12.0(EOL)
 
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
 
 -