Bug #10315 Doesn't Return View Resultsets
Submitted: 2 May 2005 15:16 Modified: 2 May 2005 16:48
Reporter: Joseph Opacki Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.6 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[2 May 2005 15:16] Joseph Opacki 
Description:
Using MySQL beta 5 and MySQL Query Browser 1.1.6.  When creating a view with the following syntax:

CREATE OR REPLACE VIEW v_msg AS
SELECT username, count(*) as total
FROM users
GROUP BY username

Then writing a SELECT statement for that view returns no results, such as:

SELECT * FROM v_msg WHERE username like '%joe%'

How to repeat:
Create a view for any table then try to select something from that view.

Suggested fix:
Modify next iteration of MySQL Query Browser to support views.
[2 May 2005 16:15] [ name withheld ] 
Seems duplicate of bug 10072
[2 May 2005 16:48] MySQL Verification Team 
Duplicate  of:
http://bugs.mysql.com/bug.php?id=10072