diff options
| author | unknown <evgen@moonbone.local> | 2005-08-15 13:21:55 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-08-15 13:21:55 +0400 |
| commit | 6ed4935212ce5a3e8824ad25a9eb6718e2703537 (patch) | |
| tree | 7562b2623c103e6a4bd19999af2883e2b61d8b76 /mysql-test/r/derived.result | |
| parent | 7b91cd9a5866106d8f8c39c03302a59ea18b30ee (diff) | |
| parent | e66cd71698e033c788adb6364fdf261143fb5601 (diff) | |
| download | mariadb-git-6ed4935212ce5a3e8824ad25a9eb6718e2703537.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/mysql-5.0-bug-11864
mysql-test/r/derived.result:
Auto merged
sql/sql_derived.cc:
Auto merged
sql/sql_view.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 586be94301f..7c9d88acf90 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -111,7 +111,7 @@ a b 1 a 2 b 3 c -explain select * from (select * from t1,t2 where t1.a=t2.a) t1; +explain select * from (select t1.*, t2.a as t2a 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 @@ -363,3 +363,8 @@ a 3 3 drop table t1, t2, t3; +create table t1 (a int); +create table t2 (a int); +select * from (select * from t1,t2) foo; +ERROR 42S21: Duplicate column name 'a' +drop table t1,t2; |