diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2002-11-30 19:53:31 +0200 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2002-11-30 19:53:31 +0200 |
| commit | 25586e477ad0609b4030a8aca36c6c8eb8959996 (patch) | |
| tree | cba8ea432e644376637cbf2fa6247440d696cd0b /mysql-test/t/derived.test | |
| parent | a968d7c2eac9e1766f85cebf8d4aa4019c543a84 (diff) | |
| download | mariadb-git-25586e477ad0609b4030a8aca36c6c8eb8959996.tar.gz | |
some bug fixes and tests for those.
I am pushing now, because :
* I have a fix for crashing bug
* Sanja will destroy my changes in sub-select test ... ;)
Diffstat (limited to 'mysql-test/t/derived.test')
| -rw-r--r-- | mysql-test/t/derived.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test index 5c2d0157f14..8f187dd46ba 100644 --- a/mysql-test/t/derived.test +++ b/mysql-test/t/derived.test @@ -18,6 +18,8 @@ SELECT a,2 as a FROM (SELECT '1' as a) b HAVING a=1; SELECT 1 FROM (SELECT 1) a WHERE a=2; --error 1054 SELECT (SELECT 1) as a FROM (SELECT 1 FROM t1 HAVING a=1) as a; +select * from t1 as x1, (select * from t1) as x2; +explain select * from t1 as x1, (select * from t1) as x2; drop table if exists t1.t2,t3; select * from (select 1) as a; select a from (select 1 as a) as b; |