CREATE TABLE t1 ( a varchar(30) , i int , id int, UNIQUE KEY id (id), KEY (i ,id ,a), KEY (a(1),i)) engine=myisam;

INSERT INTO t1 VALUES('fej',NULL,1),('jeyw',8,2),(NULL,181,3),('wrkovd',9,4),('',NULL,5),('ko',NULL,6),('vdgzyxkop',217,7),('',7,8),('zy',0,9),('yxkopv',8,10),('kopv',1,11),('opv',4,12),('vc',9,13),('ri',1,14),('tkcn',1,15),('cnm',6,16),('m',0,17),('d',9,18),('e',28,19),(NULL,0,20);

SELECT i, MAX( id ) FROM t1 

WHERE ( a IS NULL OR a IN ('o','h') ) AND ( id BETWEEN 6 AND 7  OR id IN ( 8, 1) ) 

GROUP BY i;

Version: '11.0.2-MariaDB-debug-log'  

mariadbd: /11.0/src/sql/sql_select.cc:24092: int join_read_first(JOIN_TAB*): Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index' failed.

230328 14:15:23 [ERROR] mysqld got signal 6 ;

Server version: 11.0.2-MariaDB-debug-log source revision: 6c3b1dced41c238f814aeabbc725e31c3106c0f4

??:0(gsignal)[0x7fc82b8b100b]

??:0(abort)[0x7fc82b890859]

/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fc82b890729]

??:0(__assert_fail)[0x7fc82b8a1fd6]

sql/sql_select.cc:24095(join_read_first(st_join_table*))[0x561e247410f9]

sql/sql_select.cc:23033(sub_select(JOIN*, st_join_table*, bool))[0x561e247393f9]

sql/sql_select.cc:22568(do_select(JOIN*, Procedure*))[0x561e24737336]

sql/sql_select.cc:4895(JOIN::exec_inner())[0x561e246b8157]

sql/sql_select.cc:4672(JOIN::exec())[0x561e246b5508]

sql/sql_select.cc:5153(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561e246b9c16]

sql/sql_select.cc:611(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x561e24689819]

sql/sql_parse.cc:6267(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561e245abac5]

sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x561e2459a374]

sql/sql_parse.cc:7999(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x561e245b6848]

sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x561e2458ca9e]

sql/sql_parse.cc:1407(do_command(THD*, bool))[0x561e245897da]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x561e24a56c33]

sql/sql_connect.cc:1320(handle_one_connection)[0x561e24a56590]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x561e2566fcd8]

nptl/pthread_create.c:478(start_thread)[0x7fc82bdbc609]

Query (0x6290001092a8): SELECT i, MAX( id ) FROM t1 

WHERE ( a IS NULL OR a IN ('o','h') ) AND ( id BETWEEN 6 AND 7  OR id IN ( 8, 1) ) 

GROUP BY i