Bug #13119 | Views with name 'a' seems to be getting corrupted | ||
---|---|---|---|
Submitted: | 12 Sep 2005 7:03 | Modified: | 12 Sep 2005 12:07 |
Reporter: | Ritesh Nadhani | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0 | OS: | Windows (Windows) |
Assigned to: | CPU Architecture: | Any |
[12 Sep 2005 7:03]
Ritesh Nadhani
[12 Sep 2005 12:07]
MySQL Verification Team
I guess you meant version 5.0 and I was unable to repeat the behavior reported with current source server: c:\mysql\bin>mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.13-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database t34343; Query OK, 1 row affected (0.00 sec) mysql> use t34343; Database changed mysql> create view t34343.a as (select '123'); Query OK, 0 rows affected (0.00 sec) mysql> select `TABLE_NAME` from `INFORMATION_SCHEMA`.`VIEWS` where `TABLE_SCHEMA` = 't34343'; +------------+ | TABLE_NAME | +------------+ | a | +------------+ 1 row in set (0.03 sec) mysql> drop view t34343.a; Query OK, 0 rows affected (0.01 sec) mysql> create view t34343.a as (select '123'); Query OK, 0 rows affected (0.02 sec)