Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
None
Description
CREATE TABLE t1 (c CHAR(255) NOT NULL DEFAULT '', KEY(c(8))); |
|
INSTALL SONAME 'ha_federatedx'; |
eval CREATE TABLE fed_t1 ENGINE=FEDERATED CONNECTION='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'; |
SELECT * FROM fed_t1 WHERE c NOT IN ('USA', 'CAN'); |
|
# Cleanup
|
DROP TABLE fed_t1, t1; |
UNINSTALL SONAME 'ha_federatedx'; |
10.1 db3bdca7c2982a |
mysqld: /data/src/10.1/storage/federatedx/ha_federatedx.cc:2674: virtual int ha_federatedx::read_range_first(const key_range*, const key_range*, bool, bool): Assertion `!(start_key == __null && end_key == __null)' failed.
|
180108 14:29:12 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f8f5189cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00007f8f4b9eefe9 in ha_federatedx::read_range_first (this=0x7f8f48caf888, start_key=0x0, end_key=0x0, eq_range_arg=false, sorted=true) at /data/src/10.1/storage/federatedx/ha_federatedx.cc:2674
|
#9 0x000055984f64eb4e in handler::multi_range_read_next (this=0x7f8f48caf888, range_info=0x7f8f5391f148) at /data/src/10.1/sql/multi_range_read.cc:290
|
#10 0x000055984f8446da in QUICK_RANGE_SELECT::get_next (this=0x7f8f48d3f280) at /data/src/10.1/sql/opt_range.cc:11218
|
#11 0x000055984f8548e1 in rr_quick (info=0x7f8f48c45900) at /data/src/10.1/sql/records.cc:350
|
#12 0x000055984f53e09d in join_init_read_record (tab=0x7f8f48c45840) at /data/src/10.1/sql/sql_select.cc:19323
|
#13 0x000055984f53bfa5 in sub_select (join=0x7f8f48c43d40, join_tab=0x7f8f48c45840, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18410
|
#14 0x000055984f53b86a in do_select (join=0x7f8f48c43d40, fields=0x7f8f4a8d9388, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18068
|
#15 0x000055984f51621e in JOIN::exec_inner (this=0x7f8f48c43d40) at /data/src/10.1/sql/sql_select.cc:3225
|
#16 0x000055984f5134af in JOIN::exec (this=0x7f8f48c43d40) at /data/src/10.1/sql/sql_select.cc:2512
|
#17 0x000055984f516a45 in mysql_select (thd=0x7f8f4a8d5070, rref_pointer_array=0x7f8f4a8d9518, tables=0x7f8f48c432a0, wild_num=1, fields=..., conds=0x7f8f48c43b18, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f8f48c43d20, unit=0x7f8f4a8d8b70, select_lex=0x7f8f4a8d9270) at /data/src/10.1/sql/sql_select.cc:3449
|
#18 0x000055984f50c44e in handle_select (thd=0x7f8f4a8d5070, lex=0x7f8f4a8d8aa8, result=0x7f8f48c43d20, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
|
#19 0x000055984f4dc4e8 in execute_sqlcom_select (thd=0x7f8f4a8d5070, all_tables=0x7f8f48c432a0) at /data/src/10.1/sql/sql_parse.cc:5926
|
#20 0x000055984f4d29be in mysql_execute_command (thd=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_parse.cc:2976
|
#21 0x000055984f4dfbf5 in mysql_parse (thd=0x7f8f4a8d5070, rawbuf=0x7f8f48c43088 "SELECT * FROM fed_t1 WHERE c NOT IN ('USA', 'CAN')", length=50, parser_state=0x7f8f539205e0) at /data/src/10.1/sql/sql_parse.cc:7347
|
#22 0x000055984f4ceaba in dispatch_command (command=COM_QUERY, thd=0x7f8f4a8d5070, packet=0x7f8f4d3f9071 "", packet_length=50) at /data/src/10.1/sql/sql_parse.cc:1477
|
#23 0x000055984f4cd83f in do_command (thd=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_parse.cc:1106
|
#24 0x000055984f606325 in do_handle_one_connection (thd_arg=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_connect.cc:1330
|
#25 0x000055984f606089 in handle_one_connection (arg=0x7f8f4a8d5070) at /data/src/10.1/sql/sql_connect.cc:1242
|
#26 0x000055984f9c075a in pfs_spawn_thread (arg=0x7f8f51039ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1861
|
#27 0x00007f8f535a0494 in start_thread (arg=0x7f8f53921b00) at pthread_create.c:333
|
#28 0x00007f8f5195993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible with at least MyISAM and InnoDB for the "remote" table.