diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-29 14:49:07 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-29 14:49:07 +0200 |
| commit | 1b921a995e3defb62aa51fc09fc4eaed9b0f4eab (patch) | |
| tree | 2296c7002f19725e5df14900abb3708b44f792fc /mysql-test/r/derived.result | |
| parent | 802705f957011aebbb03ca988080f914bf39a57e (diff) | |
| download | mariadb-git-1b921a995e3defb62aa51fc09fc4eaed9b0f4eab.tar.gz | |
many bug fixes
mysql-test/r/derived.result:
test for a bug fix which caused a deadlock !
Also test for a bug fix with using() on derived tables
mysql-test/r/subselect.result:
correcting previous changes caused by a bug ..
mysql-test/t/derived.test:
test for a bug fix which caused a deadlock !
Also test for a bug fix with using() on derived tables
mysql-test/t/subselect.test:
corrections of previous changes caused by a bug ..
sql/sql_base.cc:
A for for a bug which caused a deadlock !
Also fix for a bug with using() on derived tables
sql/sql_derived.cc:
code cleanup
sql/sql_lex.cc:
fix for deadlock
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 10d86f7107a..0dce2b50819 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -64,7 +64,13 @@ a t 18 18 19 19 20 20 +explain select count(*) from t1 as tt1, (select * from t1) as tt2; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE Select tables optimized away drop table if exists t1; SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a) as a )) as b; (SELECT * FROM (SELECT 1 as a) as a ) 1 +select * from (select 1 as a) b left join (select 2 as a) c using(a); +a a +1 NULL |