summaryrefslogtreecommitdiff
path: root/mysql-test/t/union.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2002-02-28 21:58:32 +0200
committerunknown <Sinisa@sinisa.nasamreza.org>2002-02-28 21:58:32 +0200
commita7df512a8f744fc94023a13c42d85203509ace5a (patch)
tree18196b0e2ec2b524138d6f04264ad5f06b431da5 /mysql-test/t/union.test
parentca2186187d4539460c183f6b9df6e118516b724b (diff)
downloadmariadb-git-a7df512a8f744fc94023a13c42d85203509ace5a.tar.gz
many fixes
libmysql/libmysql.c: Fixes a very rare bug when variable name (without '_') and it's value are at the very end of the config file. I have tested it , but would liek little mobster to test it further mysql-test/r/union.result: results for union test that proves that EXPLAIN UNION bugs are fixed mysql-test/t/union.test: additional tests for EXPLAIN on UNION's that have previously failed sql/sql_yacc.yy: Some small fixes for newer parsers. Only unsigned int yystacksize remains to be fixed. This I leave to Monty. Present fixes are only aesthetic and do not harm.
Diffstat (limited to 'mysql-test/t/union.test')
-rw-r--r--mysql-test/t/union.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test
index 8d98e6e0389..f782c61d97a 100644
--- a/mysql-test/t/union.test
+++ b/mysql-test/t/union.test
@@ -24,6 +24,12 @@ select 't1',b,count(*) from t1 group by b UNION select 't2',b,count(*) from t2 g
# Test some error conditions with UNION
explain select a,b from t1 union all select a,b from t2;
+--error 1054
+explain select xx from t1 union select 1;
+explain select a,b from t1 union select 1;
+explain select 1 union select a,b from t1 union select 1;
+explain select a,b from t1 union select 1 limit 0;
+
--error 1221
select a,b from t1 into outfile 'skr' union select a,b from t2;