diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-05-31 18:31:57 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-05-31 18:31:57 +0300 |
| commit | c47c56452680e1bbdaa9d8ed4203470cf7f02c56 (patch) | |
| tree | 31770b2965c9dd5f4b6041695d572ccc894b39ce /mysql-test/r/derived.result | |
| parent | 4637832fa19b2866929c1e5cb7c9dd0a40db15c9 (diff) | |
| download | mariadb-git-c47c56452680e1bbdaa9d8ed4203470cf7f02c56.tar.gz | |
Fix for the optimiser problem caused by the fact that with derived
tables one (or more tables) is opened / closed twice.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index bfd4c544131..52a54ac7773 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -137,7 +137,7 @@ a t 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 PRIMARY NULL NULL NULL NULL NULL NULL NULL Select tables optimized away -2 DERIVED tt1 index NULL a 4 NULL 10000 Using index +2 DERIVED tt1 ALL NULL NULL NULL NULL 10000 drop table t1; SELECT * FROM (SELECT (SELECT * FROM (SELECT 1 as a) as a )) as b; (SELECT * FROM (SELECT 1 as a) as a ) |