summaryrefslogtreecommitdiff
path: root/mysql-test/r/union.result
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2004-05-03 19:15:26 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2004-05-03 19:15:26 +0300
commit19c91b79203ebaa1f5ac557bf3684d1f48c0a90e (patch)
treefe523909dc9847c894ba088b73e2c731d8a7ae18 /mysql-test/r/union.result
parent4bde9b834af10823f5d13f2c22c571e318474277 (diff)
downloadmariadb-git-19c91b79203ebaa1f5ac557bf3684d1f48c0a90e.tar.gz
Fix for a bug involving UNION's and SET SQL_SELECT_LIMIT
mysql-test/r/union.result: Results for a test case for bug involving UNION's and SET SQL_SELECT_LIMIT mysql-test/t/union.test: Test case for bug involving UNION's and SET SQL_SELECT_LIMIT sql/sql_union.cc: Patch 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