Bug #13559 view

• Submitted: 28 Sep 2005 9:48
• Modified: 28 Oct 2005 9:57
• Reporter: sonali shah
• Status: No Feedback
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Windows (Windows 2000)
• CPU Architecture: Any

[28 Sep 2005 9:48] sonali shah

Description:
At MySql Server 5.0, Create View query works, but 'Select * from View' query returns no resultset. Even if the corresponding table has records. On the other hand on Client machine, there is access denied for Creating View, but we can fire all types of valied queries on particular view. eg. 'Select * from view'

How to repeat:
Install one machine client & one machine server

[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".