summaryrefslogtreecommitdiff
path: root/mysql-test/include/common-tests.inc
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2009-12-22 15:33:21 +0300
committerSergey Petrunya <psergey@askmonty.org>2009-12-22 15:33:21 +0300
commitda5edf5057d392f3647570606220d80106c81a7b (patch)
tree922a9e1f2882014f8c5a5a5f524bf88e39ed41dd /mysql-test/include/common-tests.inc
parent19f6f52a21d48914a2542bcaf23806ace6870e8e (diff)
downloadmariadb-git-da5edf5057d392f3647570606220d80106c81a7b.tar.gz
MWL#67: MRR backport
- Make index condition pushdown be controlled by an @@optimizer_switch flag, not by @@engine_condition_pushdown - Make MRR buffer size be controlled by @@mrr_buffer_size, not by @@read_rnd_buffer_size - Move parts of code to separate files - Code cleanup - Add --sorted_result to some SELECTs in tests.
Diffstat (limited to 'mysql-test/include/common-tests.inc')
-rw-r--r--mysql-test/include/common-tests.inc2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/include/common-tests.inc b/mysql-test/include/common-tests.inc
index 882ac689498..2273d7d688d 100644
--- a/mysql-test/include/common-tests.inc
+++ b/mysql-test/include/common-tests.inc
@@ -1332,7 +1332,7 @@ explain select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 a
# Search with a key with LIKE constant
# If the like starts with a certain letter key will be used.
#
-
+--sorted_result
select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';
select fld3 from t2 where fld3 like "L%" and fld3 = "ok";
select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");