summaryrefslogtreecommitdiff
path: root/mysql-test/r/shm.result
diff options
context:
space:
mode:
authorSergey Vojtovich <svoj@mariadb.org>2013-08-14 12:50:17 +0400
committerSergey Vojtovich <svoj@mariadb.org>2013-08-14 12:50:17 +0400
commitf3d26cb1a72f0bb32e28940257f778cc46fd8b9e (patch)
tree8fcda10568c300c932a5b3da5f5d11c0dedf8d26 /mysql-test/r/shm.result
parentb7f9c894236c38cb40b5ca70e36d23497fcc01be (diff)
downloadmariadb-git-f3d26cb1a72f0bb32e28940257f778cc46fd8b9e.tar.gz
Adjusted test results after recent changes.
Diffstat (limited to 'mysql-test/r/shm.result')
-rw-r--r--mysql-test/r/shm.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/shm.result b/mysql-test/r/shm.result
index d4298fb2d09..a2c38627e9d 100644
--- a/mysql-test/r/shm.result
+++ b/mysql-test/r/shm.result
@@ -508,7 +508,7 @@ insert into tmp select * from t3;
insert into t3 select * from tmp;
alter table t3 add t2nr int not null auto_increment primary key first;
drop table tmp;
-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;
namn
Abraham Abraham
@@ -521,7 +521,7 @@ ammonium ammonium
analyzable analyzable
animals animals
animized animized
-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;
concat(fld3," ",fld3)
Abraham Abraham
@@ -558,7 +558,7 @@ attendants 1
bedlam 1
bedpost 1
boasted 1
-SET SQL_BIG_TABLES=1;
+SET BIG_TABLES=1;
select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10;
fld3 count(*)
affixed 1
@@ -571,7 +571,7 @@ attendants 1
bedlam 1
bedpost 1
boasted 1
-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;
fld3 repeat("a",length(fld3)) count(*)
circus aaaaaa 1