summaryrefslogtreecommitdiff
path: root/mysql-test/t/index_intersect.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-02-29 21:55:04 +0100
committerSergei Golubchik <sergii@pisem.net>2012-02-29 21:55:04 +0100
commite4bfb6f161b77a8c5801ba71b4ffd980066a1399 (patch)
treea48bbc4154695db34ba124f07a70bef5cabab48d /mysql-test/t/index_intersect.test
parente293bdb2c19cacad91d4f5a846568ac595b3a48e (diff)
downloadmariadb-git-e4bfb6f161b77a8c5801ba71b4ffd980066a1399.tar.gz
pbxt suite is now a main-pbxt overlay
Diffstat (limited to 'mysql-test/t/index_intersect.test')
-rw-r--r--mysql-test/t/index_intersect.test8
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/t/index_intersect.test b/mysql-test/t/index_intersect.test
index c2834e685eb..001c698029e 100644
--- a/mysql-test/t/index_intersect.test
+++ b/mysql-test/t/index_intersect.test
@@ -158,6 +158,7 @@ SELECT * FROM City
SELECT * FROM City USE INDEX ()
WHERE Name BETWEEN 'G' AND 'J' AND Population > 1000000 AND Country LIKE 'B%';
+--sorted_result
SELECT * FROM City
WHERE Name BETWEEN 'G' AND 'J' AND Population > 1000000 AND Country LIKE 'B%';
@@ -165,6 +166,7 @@ SELECT * FROM City
SELECT * FROM City USE INDEX ()
WHERE Name BETWEEN 'G' AND 'K' AND Population > 500000 AND Country LIKE 'C%';
+--sorted_result
SELECT * FROM City
WHERE Name BETWEEN 'G' AND 'K' AND Population > 500000 AND Country LIKE 'C%';
@@ -316,13 +318,15 @@ SELECT * FROM City
SELECT * FROM City WHERE
Name LIKE 'C%' AND Population > 1000000;
+--sorted_result
SELECT * FROM City WHERE
Name LIKE 'M%' AND Population > 1500000;
-
+--sorted_result
SELECT * FROM City
WHERE Name BETWEEN 'G' AND 'J' AND Population > 700000 AND Country LIKE 'B%';
+--sorted_result
SELECT * FROM City
WHERE Name BETWEEN 'G' AND 'J' AND Population > 500000 AND Country LIKE 'C%';
@@ -393,6 +397,7 @@ SELECT * FROM City
SELECT * FROM City USE INDEX ()
WHERE Country='CHN' AND Population > 1500000 AND Name LIKE 'C%';
+--sorted_result
SELECT * FROM City
WHERE Country='CHN' AND Population > 1500000 AND Name LIKE 'C%';
@@ -445,6 +450,7 @@ EXPLAIN
SELECT * FROM t1
WHERE (f1 < 535 OR f1 > 985) AND ( f4='r' OR f4 LIKE 'a%' ) ;
+--sorted_result
SELECT * FROM t1
WHERE (f1 < 535 OR f1 > 985) AND ( f4='r' OR f4 LIKE 'a%' ) ;