Bug #5361 =: one-to-many display syntax doesn't allow a space
Submitted: 2 Sep 2004 3:47 Modified: 3 Nov 2004 12:31
Reporter: Mark McAulay Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.0.7 beta OS:Windows (Windows XP Pro)
Assigned to: Michael G. Zinner CPU Architecture:Any

[2 Sep 2004 3:47] Mark McAulay
Description:
Whilst viewing two tabs vertically split with a one-to-many relationship, the =: notation can't have a space between : and the field name, but the example in your documentation has a space.

eg. 
These will work:
SELECT * FROM table WHERE job_group_id=:job_group_id
SELECT * FROM table WHERE job_group_id= :job_group_id
SELECT * FROM table WHERE job_group_id =:job_group_id

But not:
SELECT * FROM table WHERE job_group_id =: job_group_id
SELECT * FROM table WHERE job_group_id = : job_group_id

How to repeat:
Try the =: notation in Query Browser with variations on spaces

Suggested fix:
Remove the spaces from the example in the documentation
[2 Sep 2004 10:10] Michael G. Zinner
Thanks for reporting. The : needs to be next to the column name, :variable. This is an error in the docs that will be fixed for the next release.
[3 Nov 2004 12:31] Michael G. Zinner
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/