summaryrefslogtreecommitdiff
path: root/mysql-test/r/limit.result
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2005-02-10 18:01:06 +0200
committerunknown <bell@sanja.is.com.ua>2005-02-10 18:01:06 +0200
commit72eb17f18d7e8094152aa2c3757f6d5ab24f9f76 (patch)
tree828e47008d5e9d854ff445efdc1768f3619981f4 /mysql-test/r/limit.result
parentc02f4c5b6c1ee39b62a2074db476cde0632d5f62 (diff)
parent7684e10018503eba3bf281d587993761fae6e5fb (diff)
downloadmariadb-git-72eb17f18d7e8094152aa2c3757f6d5ab24f9f76.tar.gz
merge
include/mysql_com.h: Auto merged mysql-test/r/view.result: Auto merged mysql-test/t/view.test: Auto merged sql/item.cc: Auto merged sql/protocol.cc: Auto merged sql/sql_parse.cc: Auto merged sql/sql_select.cc: Auto merged
Diffstat (limited to 'mysql-test/r/limit.result')
-rw-r--r--mysql-test/r/limit.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/limit.result b/mysql-test/r/limit.result
index c82105e6a49..6a3d2bffab0 100644
--- a/mysql-test/r/limit.result
+++ b/mysql-test/r/limit.result
@@ -67,3 +67,12 @@ SELECT * FROM t1;
id id2
3 0
DROP TABLE t1;
+create table t1 (a integer);
+insert into t1 values (1);
+select 1 as a from t1 union all select 1 from dual limit 1;
+a
+1
+(select 1 as a from t1) union all (select 1 from dual) limit 1;
+a
+1
+drop table t1;