mirror of
https://github.com/MariaDB/server.git
synced 2025-04-21 14:45:34 +02:00
fd5cd073cc
- Enable the test `sphinx.sphinx` which was disabled by MDEV 10986,
comit ee0094d2fd
- Add test case to `sphinx.sphinx` to cover host as localhost instead of `127.0.0.1`
- Add result file for single test
97 lines
3.5 KiB
Text
97 lines
3.5 KiB
Text
create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/*";
|
|
select * from ts where q='test';
|
|
id w q
|
|
1 2 test
|
|
2 2 test
|
|
4 1 test
|
|
5 1 test
|
|
drop table ts;
|
|
create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/*";
|
|
select * from ts where q='test;filter=gid,1;mode=extended';
|
|
id w q
|
|
1 2379 test;filter=gid,1;mode=extended
|
|
2 2379 test;filter=gid,1;mode=extended
|
|
5 1412 test;filter=gid,1;mode=extended
|
|
select * from ts where q='test|one;mode=extended';
|
|
id w q
|
|
1 3579 test|one;mode=extended
|
|
2 2439 test|one;mode=extended
|
|
4 1456 test|one;mode=extended
|
|
5 1456 test|one;mode=extended
|
|
select * from ts where q='test;offset=1;limit=1';
|
|
id w q
|
|
2 2 test;offset=1;limit=1
|
|
alter table ts connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/test1";
|
|
select id, w from ts where q='one';
|
|
id w
|
|
1 2
|
|
drop table ts;
|
|
create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, gid int not null, _sph_count int not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/test1";
|
|
select * from ts;
|
|
id w q gid _sph_count
|
|
select * from ts where q='';
|
|
id w q gid _sph_count
|
|
1 1 1 0
|
|
2 1 1 0
|
|
3 1 2 0
|
|
4 1 2 0
|
|
5 1 1 0
|
|
select * from ts where q=';groupby=attr:gid';
|
|
id w q gid _sph_count
|
|
3 1 ;groupby=attr:gid 2 2
|
|
1 1 ;groupby=attr:gid 1 3
|
|
explain select * from ts where q=';groupby=attr:gid';
|
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
1 SIMPLE ts ref q q 257 const 3 Using where with pushed condition
|
|
SET @save_optimizer_switch=@@optimizer_switch;
|
|
SET optimizer_switch='index_condition_pushdown=off';
|
|
explain select * from ts where q=';groupby=attr:gid';
|
|
id select_type table type possible_keys key key_len ref rows Extra
|
|
1 SIMPLE ts ref q q 257 const 3 Using where with pushed condition
|
|
SET optimizer_switch=@save_optimizer_switch;
|
|
drop table ts;
|
|
show status like "sphinx_total%";
|
|
Variable_name Value
|
|
Sphinx_total 2
|
|
Sphinx_total_found 2
|
|
show status like "sphinx_word%";
|
|
Variable_name Value
|
|
Sphinx_word_count 0
|
|
Sphinx_words
|
|
create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://127.0.0.1:SPHINXSEARCH_PORT/*";
|
|
select * from ts where q=';filter=meta.foo_count,100';
|
|
id w q
|
|
1 1 ;filter=meta.foo_count,100
|
|
select * from ts where q='test;filter=meta.sub.int,7';
|
|
id w q
|
|
5 1 test;filter=meta.sub.int,7
|
|
select * from ts where q=';filter=meta.sub.list[0],4';
|
|
id w q
|
|
select * from ts where q=';filter=meta.sub.list[1],4';
|
|
id w q
|
|
5 1 ;filter=meta.sub.list[1],4
|
|
select * from ts where q='test;range=meta.foo_count,100,500';
|
|
id w q
|
|
1 2 test;range=meta.foo_count,100,500
|
|
5 1 test;range=meta.foo_count,100,500
|
|
drop table ts;
|
|
#
|
|
# MDEV-19205: Sphinx unable to connect using a host name
|
|
#
|
|
create table ts ( id bigint unsigned not null, w int not null, q varchar(255) not null, index(q) ) engine=sphinx connection="sphinx://localhost:SPHINXSEARCH_PORT/*";
|
|
select * from ts where q=';filter=meta.foo_count,100';
|
|
id w q
|
|
1 1 ;filter=meta.foo_count,100
|
|
select * from ts where q='test;filter=meta.sub.int,7';
|
|
id w q
|
|
5 1 test;filter=meta.sub.int,7
|
|
select * from ts where q=';filter=meta.sub.list[0],4';
|
|
id w q
|
|
select * from ts where q=';filter=meta.sub.list[1],4';
|
|
id w q
|
|
5 1 ;filter=meta.sub.list[1],4
|
|
select * from ts where q='test;range=meta.foo_count,100,500';
|
|
id w q
|
|
1 2 test;range=meta.foo_count,100,500
|
|
5 1 test;range=meta.foo_count,100,500
|
|
drop table ts;
|