Bug #10692 | MySql 5.0.4 Views | ||
---|---|---|---|
Submitted: | 17 May 2005 18:13 | Modified: | 17 May 2005 21:35 |
Reporter: | NOT_FOUND NOT_FOUND | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | MySql 5.0.4 | OS: | Windows (Windows) |
Assigned to: | CPU Architecture: | Any |
[17 May 2005 18:13]
NOT_FOUND NOT_FOUND
[17 May 2005 21:19]
Hartmut Holzgraefe
On linux this just gives me ERROR 1060 (42S21): Duplicate column name 'idtable1' (as expected). The full reproducing script i used was: create table table1 (idtable1 int); create table table2 (idtable1 int); create view vw_table1 as select * from table1; create view vw_table2 as select * from table2 t2 inner join vw_table1 t1 on t1.idtable1 = t2.idtable1;
[17 May 2005 21:35]
MySQL Verification Team
Also I was unable to repeat on Windows: c:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.4-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create table table1 (idtable1 int); Query OK, 0 rows affected (0.09 sec) mysql> create table table2 (idtable1 int); Query OK, 0 rows affected (0.08 sec) mysql> mysql> create view vw_table1 as select * from table1; Query OK, 0 rows affected (0.00 sec) mysql> mysql> create view vw_table2 as -> select * -> from table2 t2 inner join vw_table1 t1 -> on t1.idtable1 = t2.idtable1; ERROR 1060 (42S21): Duplicate column name 'idtable1' mysql>