Bug #10692 MySql 5.0.4 Views

• Submitted: 17 May 2005 18:13
• Modified: 17 May 2005 21:35
• Reporter: NOT_FOUND NOT_FOUND
• Status: Can't repeat
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: MySql 5.0.4
• OS: Windows (Windows)
• CPU Architecture: Any

[17 May 2005 18:13] NOT_FOUND NOT_FOUND

Description:
My English is bad, but we go there.

When I use one view, that in turn he is using another one view, the server mysql I am knocked down and I do not obtain more to startar the service.  Exactly that I restart the machine I do not obtain to make the connection with database, view is necessary I to exclude the referring archive created.

-----------------------------------------------------------------------------
Em portugûes.

Quando eu utilizo uma view, que por sua vez está utilizando outra view, o servidor mysql é derrubado e não consigo mais startar o serviço. Mesmo que eu reinicio a máquina não consigo fazer a conexão com o database, é necessário eu excluir o arquivo referente a view criada.

Att[]'s

Stiven Fabiano da Câmara
Analista de Sistemas

How to repeat:
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: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>