Bug #13559 | view | ||
---|---|---|---|
Submitted: | 28 Sep 2005 9:48 | Modified: | 28 Oct 2005 9:57 |
Reporter: | sonali shah | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.0 | OS: | Windows (Windows 2000) |
Assigned to: | CPU Architecture: | Any |
[28 Sep 2005 9:48]
sonali shah
[28 Sep 2005 9:57]
Vasily Kishkin
Could you please provide definition of table, definition of view and so on ? I mean could you please create some test case ?
[28 Sep 2005 10:59]
Valeriy Kravchuk
Just for your information, I was not able to repeat with 5.0.12-nt server and 4.1.14 client: D:\Documents and Settings\informix>mysql --version mysql Ver 14.7 Distrib 4.1.14, for Win32 (ia32) D:\Documents and Settings\informix>mysql -uroot -p -P3307 Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.12-beta-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Database changed mysql> create table t1 (c1 char(10)); ERROR 1050 (42S01): Table 't1' already exists mysql> drop table t1; Query OK, 0 rows affected (0.06 sec) mysql> create table t1 (c1 char(10)); Query OK, 0 rows affected (0.03 sec) mysql> insert into t1 values('abc'); Query OK, 1 row affected (0.00 sec) mysql> select * from t1; +------+ | c1 | +------+ | abc | +------+ 1 row in set (0.01 sec) mysql> create view v1 as select * from t1; Query OK, 0 rows affected (0.01 sec) mysql> select * from v1; +------+ | c1 | +------+ | abc | +------+ 1 row in set (0.01 sec) As far as I remember, only old (3.23.xx) clients complained about views... So, if you will not provide a repetable test case similar to mine, I suppose this to be not a MySQL bug really.
[28 Oct 2005 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".