diff options
author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-02-28 21:58:32 +0200 |
---|---|---|
committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-02-28 21:58:32 +0200 |
commit | a7df512a8f744fc94023a13c42d85203509ace5a (patch) | |
tree | 18196b0e2ec2b524138d6f04264ad5f06b431da5 /mysql-test/r/union.result | |
parent | ca2186187d4539460c183f6b9df6e118516b724b (diff) | |
download | mariadb-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/r/union.result')
-rw-r--r-- | mysql-test/r/union.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 6a27df648b5..e842bb3b447 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -86,6 +86,21 @@ explain select a,b from t1 union all select a,b from t2; table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 t2 ALL NULL NULL NULL NULL 4 +explain select xx from t1 union select 1; +Unknown column 'xx' in 'field list' +explain select a,b from t1 union select 1; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 + 0 0 No tables used +explain select 1 union select a,b from t1 union select 1; +table type possible_keys key key_len ref rows Extra + 0 0 No tables used +t1 ALL NULL NULL NULL NULL 4 + 0 0 No tables used +explain select a,b from t1 union select 1 limit 0; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 + 0 0 Impossible WHERE select a,b from t1 into outfile 'skr' union select a,b from t2; Wrong usage of UNION and INTO select a,b from t1 order by a union select a,b from t2; |