diff options
| author | Sinisa@sinisa.nasamreza.org <> | 2003-04-10 21:05:28 +0300 |
|---|---|---|
| committer | Sinisa@sinisa.nasamreza.org <> | 2003-04-10 21:05:28 +0300 |
| commit | 47f67214d98c854f05b31bde72e0ec57440e8561 (patch) | |
| tree | 5124388a4487f309bc776ce29a80ffd8b3d94ad1 /mysql-test/r/derived.result | |
| parent | 3cef0070f9529b281d6380f27fa1a3c9f863b8a0 (diff) | |
| download | mariadb-git-47f67214d98c854f05b31bde72e0ec57440e8561.tar.gz | |
A fix for a crashing bug in EXPLAIN on derived tables with a join.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index e335e316170..bfd4c544131 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -105,6 +105,11 @@ a b 1 a 2 b 3 c +explain select * from (select * from t1,t2 where t1.a=t2.a) t1; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY <derived2> system NULL NULL NULL NULL 1 +2 DERIVED t2 system NULL NULL NULL NULL 1 +2 DERIVED t1 ALL NULL NULL NULL NULL 4 Using where drop table t1, t2; create table t1(a int not null, t char(8), index(a)); SELECT * FROM (SELECT * FROM t1) as b ORDER BY a ASC LIMIT 0,20; |