summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2002-10-27 21:29:40 +0200
committerunknown <bell@sanja.is.com.ua>2002-10-27 21:29:40 +0200
commitd2c7f44ff638ab28970f25baccc87210388588cd (patch)
treed2ce1d2c09a200b3dc296e46b22eef59598dbf41 /mysql-test
parent5a3fe219fb6e094f194f5dacf89020955db46c8e (diff)
downloadmariadb-git-d2c7f44ff638ab28970f25baccc87210388588cd.tar.gz
fixed union rexecution bug
mysql-test/r/subselect.result: test for union rexecution bug mysql-test/t/subselect.test: test for union rexecution bug
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/subselect.result3
-rw-r--r--mysql-test/t/subselect.test2
2 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index 5c5b8984102..b1bf134fdde 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -5,6 +5,9 @@ SELECT (SELECT 1) UNION SELECT (SELECT 2);
(SELECT 1)
1
2
+SELECT (SELECT (SELECT 0 UNION SELECT 0));
+(SELECT (SELECT 0 UNION SELECT 0))
+0
drop table if exists t1,t2,t3,t4,t5,attend,clinic,inscrit;
create table t1 (a int);
create table t2 (a int, b int);
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index c74922d3d9e..841e98dd96c 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -1,6 +1,6 @@
-
select (select 2);
SELECT (SELECT 1) UNION SELECT (SELECT 2);
+SELECT (SELECT (SELECT 0 UNION SELECT 0));
drop table if exists t1,t2,t3,t4,t5,attend,clinic,inscrit;
create table t1 (a int);
create table t2 (a int, b int);