Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL)
-
None
-
None
Description
--source include/have_partition.inc
|
set optimizer_switch="mrr=on,mrr_cost_based=off"; |
|
create table t1 ( pk int not null primary key, d1 date) engine=myisam partition by key () partitions 4 ; |
insert into t1 values (1,'1984-12-05'),(5,'1992-05-06'),(9,'2004-04-09'),(13,'1900-01-01'); |
|
select 1 from t1 where not (pk < '1') order by d1 ; |
|
10.3 8f4de38f65ba89c |
/10.3/sql/filesort.cc:382: SORT_INFO* filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, table_map): Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed.
|
|
sql/filesort.cc:384(filesort(THD*, TABLE*, Filesort*, Filesort_tracker*, JOIN*, unsigned long long))[0x55df496b31fa]
|
sql/sql_select.cc:22558(create_sort_index(THD*, JOIN*, st_join_table*, Filesort*))[0x55df4910a9b1]
|
sql/sql_select.cc:20371(st_join_table::sort_table())[0x55df490fb8b3]
|
sql/sql_select.cc:20312(join_init_read_record(st_join_table*))[0x55df490fadf8]
|
sql/sql_select.cc:19393(sub_select(JOIN*, st_join_table*, bool))[0x55df490f4c1f]
|
sql/sql_select.cc:18936(do_select(JOIN*, Procedure*))[0x55df490f3277]
|
sql/sql_select.cc:4040(JOIN::exec_inner())[0x55df4909225f]
|
sql/sql_select.cc:3835(JOIN::exec())[0x55df4908ff04]
|
sql/sql_select.cc:4241(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55df49093376]
|
sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55df4906e721]
|
sql/sql_parse.cc:6551(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55df48ff4f00]
|
sql/sql_parse.cc:3772(mysql_execute_command(THD*))[0x55df48fe365b]
|
sql/sql_parse.cc:8095(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55df48ffd91b]
|
sql/sql_parse.cc:1856(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55df48fd83e0]
|
sql/sql_parse.cc:1396(do_command(THD*))[0x55df48fd5502]
|
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x55df49329d52]
|
sql/sql_connect.cc:1310(handle_one_connection)[0x55df4932972f]
|
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55df4a655d6f]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f1612f386ba]
|
x86_64/clone.S:111(clone)[0x7f16123cd41d]
|
|
Query (0x62b000000288): select 1 from t1 where not (pk < '1') order by d1
|
Attachments
Issue Links
- relates to
-
MDEV-7585 Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in ha_rows filesort
- Closed
-
MDEV-10557 Assertion `thd->is_error() || kill_errno || thd->killed == ABORT_QUERY' failed in filesort
- Closed