summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sphinx/sphinx.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-12-16 13:32:03 +0100
committerSergei Golubchik <sergii@pisem.net>2013-12-16 13:32:03 +0100
commitce2fabe442fd731a3d265ff685bc4e5288a370d8 (patch)
treeccf71b3d1d11780252fa3f0e82dad2405496767c /mysql-test/suite/sphinx/sphinx.result
parentc1a65228757e25aabccfcf77c494811ed1e5a633 (diff)
downloadmariadb-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.result56
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