Bug #13393 Syntax error in generated query

• Submitted: 22 Sep 2005 0:23
• Modified: 22 Sep 2005 4:10
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.14
• OS: Windows (WinXP SP2)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[22 Sep 2005 0:23] [ name withheld ]

Description:
Connected to a 4.1.11 server on linux.

Sometimes, QB generates queries using invalid syntax.

How to repeat:
1) Drag a table from the schemata list and drop it on the tab area. The default query generated in the command field is incorrectly using " character around database and table names, which is invalid syntax:

select * from "database"."table"

2) When dropping the table on the command area, the generated query uses correct syntax, though it could enclose the names between backticks:

select * from database.table t

Suggested fix:
The generated query should be:

select * from `database`.`table` t

[22 Sep 2005 0:44] MySQL Verification Team

I was unable to repeat connecting with a Suse box from a XP Pro.
Could you please provide a screenshot showing how you got that
behavior.

Thanks in advance.

[22 Sep 2005 2:05] [ name withheld ]

You are right! I had closed my QB session when I received your update, and since then, I'm unable to reproduce this behaviour. I had also referenced this in another bug, because it produced memory access error...

I think you can close it as unreproducible...

[22 Sep 2005 4:10] MySQL Verification Team

Thank you for the feedback.