summaryrefslogtreecommitdiff
path: root/mysql-test/r/distinct.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2014-11-03 21:45:06 +0400
committerAlexander Barkov <bar@mariadb.org>2014-11-03 21:45:06 +0400
commit43f185e171eecdce41e71c548ce0bc2bd6969c0f (patch)
treeef2a7c8ea219bb66aeb1532eedfae9268f9f3ae1 /mysql-test/r/distinct.result
parenta245543bc8821b15409b839197d911302fb5bfb0 (diff)
downloadmariadb-git-43f185e171eecdce41e71c548ce0bc2bd6969c0f.tar.gz
MDEV-5528 Command line variable to choose MariaDB-5.3 vs MySQL-5.6 temporal data formats
Diffstat (limited to 'mysql-test/r/distinct.result')
-rw-r--r--mysql-test/r/distinct.result20
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result
index bd7deee43e9..34c702e15f3 100644
--- a/mysql-test/r/distinct.result
+++ b/mysql-test/r/distinct.result
@@ -925,9 +925,6 @@ set join_buffer_size=1024;
SELECT STRAIGHT_JOIN DISTINCT t1.id FROM
t1, v1, t2 WHERE v1.id = t2.i AND t1.i1 = v1.i1 AND t2.i != 3;
id
-7
-8
-9
18
20
24
@@ -937,34 +934,37 @@ id
51
61
64
+7
71
74
77
78
+8
+9
93
94
set join_buffer_size=1024*16;
SELECT STRAIGHT_JOIN DISTINCT t1.id FROM
t1, v1, t2 WHERE v1.id = t2.i AND t1.i1 = v1.i1 AND t2.i != 3;
id
-7
-9
18
20
24
-8
+43
+45
50
51
61
-43
-45
-71
64
+7
+71
74
77
78
-94
+8
+9
93
+94
set join_buffer_size=default;
SELECT STRAIGHT_JOIN DISTINCT t1.id FROM
t1, v1, t2 WHERE v1.id = t2.i AND t1.i1 = v1.i1 AND t2.i != 3;