Bug #10072 Query browser not able to select from a view

• Submitted: 21 Apr 2005 20:49
• Modified: 27 Apr 2005 20:55
• Reporter: [ name withheld ] (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Query Browser
• Severity: S1 (Critical)
• Version: 1.1.6
• OS: Windows (Windows 2000)
• Assigned to: Michael G. Zinner
• CPU Architecture: Any

[21 Apr 2005 20:49] [ name withheld ]

Description:
It seems that MySQL Query Browser is unable to display results of a select over a view (Server is MySQL 5.0.4).

How to repeat:
1. Create a view from command line:

mysql> create view time_now as select now();
Query OK, 0 rows affected (0.01 sec)

2. Select from that view from command line:

mysql> select * from time_now;
+---------------------+
| now()               |
+---------------------+
| 2005-04-21 22:39:04 |
+---------------------+
1 row in set (0.01 sec)

the same query run in MySQL Query Browser v. 1.1.6 leads to an empty resultset and a message of "No resultset returned"

[27 Apr 2005 20:55] Michael G. Zinner

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html