diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-12-16 13:32:03 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-12-16 13:32:03 +0100 |
commit | ce2fabe442fd731a3d265ff685bc4e5288a370d8 (patch) | |
tree | ccf71b3d1d11780252fa3f0e82dad2405496767c /mysql-test/suite/sphinx/sphinx.result | |
parent | c1a65228757e25aabccfcf77c494811ed1e5a633 (diff) | |
download | mariadb-git-ce2fabe442fd731a3d265ff685bc4e5288a370d8.tar.gz |
move oqgraph and sphinx suites into storage/*/mysql-test/
Diffstat (limited to 'mysql-test/suite/sphinx/sphinx.result')
-rw-r--r-- | mysql-test/suite/sphinx/sphinx.result | 56 |
1 files changed, 0 insertions, 56 deletions
diff --git a/mysql-test/suite/sphinx/sphinx.result b/mysql-test/suite/sphinx/sphinx.result deleted file mode 100644 index 5fe11f4671b..00000000000 --- a/mysql-test/suite/sphinx/sphinx.result +++ /dev/null @@ -1,56 +0,0 @@ -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 -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 2421 test;filter=gid,1;mode=extended -2 2421 test;filter=gid,1;mode=extended -select * from ts where q='test|one;mode=extended'; -id w q -1 3595 test|one;mode=extended -2 2460 test|one;mode=extended -4 1471 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 -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 2 -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 |