summaryrefslogtreecommitdiff
path: root/mysql-test/t/select.test
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-08-13 13:35:36 +0200
committerSergei Golubchik <sergii@pisem.net>2013-08-13 13:35:36 +0200
commitfcf87600a2d7ae03f7bda16c2f16cdec980d2a56 (patch)
tree0dd158f601c1b38f1b5e80eab137cd406c4499cb /mysql-test/t/select.test
parenta6617eb341c9598f1247e8ddc5c66b7bec55129d (diff)
downloadmariadb-git-fcf87600a2d7ae03f7bda16c2f16cdec980d2a56.tar.gz
MDEV-4865 Change related to --log option/variable was merged partially
Complete the merge of magne.mahre@oracle.com-20101102115354-vxcaxminmzglzalk (WL#5185 Remove deprecated 5.1 features)
Diffstat (limited to 'mysql-test/t/select.test')
-rw-r--r--mysql-test/t/select.test8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test
index 6a82a2901c5..1cc3badc93f 100644
--- a/mysql-test/t/select.test
+++ b/mysql-test/t/select.test
@@ -1424,9 +1424,9 @@ drop table tmp;
# big table done
-SET SQL_BIG_TABLES=1;
+SET BIG_TABLES=1;
select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10;
-SET SQL_BIG_TABLES=0;
+SET BIG_TABLES=0;
select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10;
select distinct fld5 from t2 limit 10;
@@ -1435,9 +1435,9 @@ select distinct fld5 from t2 limit 10;
#
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
-SET SQL_BIG_TABLES=1; # Force use of MyISAM
+SET BIG_TABLES=1; # Force use of MyISAM
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
-SET SQL_BIG_TABLES=0;
+SET BIG_TABLES=0;
select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10;
#