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:
None 
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
Description:
Hello,

Creating a view with name 'a' seems not to put a record in information_schema.views table

How to repeat:
mysql> create view t34343.a as (select '123');
Query OK, 0 rows affected (0.01 sec)

mysql> select `TABLE_NAME` from `INFORMATION_SCHEMA`.`VIEWS` where `TABLE_SCHEMA ` = 't34343';
Empty set (0.01 sec)

mysql> drop view t34343.a;
ERROR 29 (HY000): File '.\t34343\a.frm' not found (Errcode: 13)

mysql> create view t34343.a as (select '123');
ERROR 1050 (42S01): Table 'a' already exists

Suggested fix:
No idea :)
[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)