summaryrefslogtreecommitdiff
path: root/mysql-test/r/union.result
diff options
context:
space:
mode:
authorSinisa@sinisa.nasamreza.org <>2004-05-03 19:15:26 +0300
committerSinisa@sinisa.nasamreza.org <>2004-05-03 19:15:26 +0300
commit333eadf1b21698779f6a574786986c3b846f2958 (patch)
treefe523909dc9847c894ba088b73e2c731d8a7ae18 /mysql-test/r/union.result
parent0a6da89f712c69a4393caddb523f9a4e52028151 (diff)
downloadmariadb-git-333eadf1b21698779f6a574786986c3b846f2958.tar.gz
Fix for a bug involving UNION's and SET SQL_SELECT_LIMIT
Diffstat (limited to 'mysql-test/r/union.result')
-rw-r--r--mysql-test/r/union.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result
index fbd4624a57c..8a5e5e5b6e3 100644
--- a/mysql-test/r/union.result
+++ b/mysql-test/r/union.result
@@ -924,3 +924,14 @@ a
1
2
2
+set sql_select_limit=1;
+select 1 union select 2;
+1
+1
+(select 1) union (select 2);
+1
+1
+(select 1) union (select 2) union (select 3) limit 2;
+1
+1
+2