Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
#3 <signal handler called>
|
#4 0x00007fa0aababc9c in spider_mysql_handler::append_match_against (this=0x7fa09c06d890, str=0x7fa09c06d8d0, ft_info=0x7fa09c0765d8, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6595
|
#5 0x00007fa0aabac2fe in spider_mysql_handler::append_match_select (this=0x7fa09c06d890, str=0x7fa09c06d8d0, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6693
|
#6 0x00007fa0aabac225 in spider_mysql_handler::append_match_select_part (this=0x7fa09c06d890, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/spd_db_mysql.cc:6676
|
#7 0x00007fa0aab8f720 in ha_spider::append_match_select_sql_part (this=0x7fa09c068c00, sql_type=1, alias=0x0, alias_length=0) at 10.0/storage/spider/ha_spider.cc:12532
|
#8 0x00007fa0aab06a41 in spider_db_append_select_columns (spider=0x7fa09c068c00) at 10.0/storage/spider/spd_db_conn.cc:1334
|
#9 0x00007fa0aab80206 in ha_spider::rnd_next_internal (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:6833
|
#10 0x00007fa0aab8128a in ha_spider::rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/storage/spider/ha_spider.cc:7104
|
#11 0x000000000080859f in handler::ha_rnd_next (this=0x7fa09c068c00, buf=0x7fa09c0f8b10 "\377") at 10.0/sql/handler.cc:2441
|
#12 0x0000000000935b35 in rr_sequential (info=0x7fa09c075bd0) at 10.0/sql/records.cc:458
|
#13 0x0000000000683b16 in join_init_read_record (tab=0x7fa09c075b20) at 10.0/sql/sql_select.cc:17661
|
#14 0x0000000000681b7e in sub_select (join=0x7fa09c0743d0, join_tab=0x7fa09c075b20, end_of_records=false) at 10.0/sql/sql_select.cc:16773
|
#15 0x0000000000681499 in do_select (join=0x7fa09c0743d0, fields=0x240a5c0, table=0x0, procedure=0x0) at 10.0/sql/sql_select.cc:16446
|
#16 0x00000000006601f4 in JOIN::exec_inner (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2993
|
#17 0x000000000065d4a1 in JOIN::exec (this=0x7fa09c0743d0) at 10.0/sql/sql_select.cc:2291
|
#18 0x0000000000660a98 in mysql_select (thd=0x24063a8, rref_pointer_array=0x240a758, tables=0x7fa09c06eda0, wild_num=1, fields=..., conds=0x7fa09c06f4d0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fa09c04f390, unit=0x2409db0, select_lex=0x240a4a8) at 10.0/sql/sql_select.cc:3221
|
#19 0x00000000006571fb in handle_select (thd=0x24063a8, lex=0x2409cf8, result=0x7fa09c04f390, setup_tables_done_option=0) at 10.0/sql/sql_select.cc:371
|
#20 0x000000000062adc1 in execute_sqlcom_select (thd=0x24063a8, all_tables=0x7fa09c06eda0) at 10.0/sql/sql_parse.cc:5043
|
#21 0x0000000000623381 in mysql_execute_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:2483
|
#22 0x000000000062d680 in mysql_parse (thd=0x24063a8, rawbuf=0x7fa09c027cc0 "SELECT * FROM t1 WHERE MATCH(v2) AGAINST ('abc' IN BOOLEAN MODE)", length=64, parser_state=0x7fa0b80ec500) at 10.0/sql/sql_parse.cc:6176
|
#23 0x0000000000620556 in dispatch_command (command=COM_QUERY, thd=0x24063a8, packet=0x240b5a9 "", packet_length=64) at 10.0/sql/sql_parse.cc:1274
|
#24 0x000000000061f9cc in do_command (thd=0x24063a8) at 10.0/sql/sql_parse.cc:983
|
#25 0x000000000073d820 in do_handle_one_connection (thd_arg=0x24063a8) at 10.0/sql/sql_connect.cc:1267
|
#26 0x000000000073d573 in handle_one_connection (arg=0x24063a8) at 10.0/sql/sql_connect.cc:1181
|
#27 0x00000000009d32b4 in pfs_spawn_thread (arg=0x227aeb8) at 10.0/storage/perfschema/pfs.cc:1800
|
#28 0x00007fa0bd220e9a in start_thread (arg=0x7fa0b80ed700) at pthread_create.c:308
|
#29 0x00007fa0bc2fecbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
bzr version-info
revision-id: svoj@mariadb.org-20130627111848-b8kc0z60ywwpqavz
|
revno: 3762
|
branch-nick: 10.0
|
Test case:
CREATE TABLE mysql.spider_tables( |
db_name char(64) not null default '', |
table_name char(64) not null default '', |
link_id int not null default 0, |
priority bigint not null default 0, |
server char(64) default null, |
scheme char(64) default null, |
host char(64) default null, |
port char(5) default null, |
socket text default null, |
username char(64) default null, |
password char(64) default null, |
ssl_ca text default null, |
ssl_capath text default null, |
ssl_cert text default null, |
ssl_cipher char(64) default null, |
ssl_key text default null, |
ssl_verify_server_cert tinyint not null default 0, |
default_file text default null, |
default_group char(64) default null, |
tgt_db_name char(64) default null, |
tgt_table_name char(64) default null, |
link_status tinyint not null default 1, |
PRIMARY KEY (db_name, table_name, link_id), |
KEY idx1 (priority) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
install soname 'ha_spider.so'; |
create database remote; |
|
CREATE TABLE remote.t1 ( |
v2 TEXT
|
) ENGINE=MyISAM;
|
|
eval CREATE TABLE t1 ( |
v2 TEXT
|
) ENGINE=SPIDER CONNECTION='host "localhost", socket "$MASTER_MYSOCK", user "root", password "", prt "2000000"' COMMENT='database "remote", table "t1"'; |
INSERT INTO t1 VALUES ('foo'),('bar'); |
|
SELECT * FROM t1 WHERE MATCH(v2) AGAINST ('abc' IN BOOLEAN MODE); |
Attachments
Issue Links
- relates to
-
MDEV-4438 Spider storage engine
- Closed