Bug #22787 query: comments are not parsed
Submitted: 28 Sep 2006 16:11 Modified: 24 Nov 2006 7:12
Reporter: Maciej Pilichowski Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:5.0.24a OS:Linux (opensuse 10.0)
Assigned to: MySQL Verification Team CPU Architecture:Any

[28 Sep 2006 16:11] Maciej Pilichowski
Description:
Example:

CREATE TABLE biblio
(
  bibImie varchar(12),   
  bibNazwisko varchar(60),
  bibTytul varchar(100),
  bibWydanie int,
  bibCena decimal(5,2),
  bibZakup date
)
DEFAULT CHARSET = latin2, -- aspekt techniczny MySQL-a
ENGINE = InnoDB;          -- aspekt techniczny MySQL-a

This is perfectly legal SQL, but query browser shows "syntax error".

How to repeat:
See above.

Suggested fix:
Parse comments:
/**/
--
and
#
[29 Sep 2006 12:26] MySQL Verification Team
Thank you for the bug report. I was unable to repeat using a script tab,
Could you please try in this way. Thanks in advance.
[29 Sep 2006 12:42] Maciej Pilichowski
Now that's strange -- it does not work in query or in script. What's more even with stripped comments it shows errors (however comments still are incorrectly parsed).
But script mode has some other flaw -- the semicolon is exchanged to ":" on-fly! So, for example my input is this
create table t ( i int); 
not the ";" at the end and QB (in script mode) shows an error saying
Error while executing query: create table t ( i int):

Note the last character.

How did you manage to run this? Copy&paste?
[23 Nov 2006 16:19] MySQL Verification Team
QB on Ubuntu 6.10

Attachment: bug22787.png (image/png, text), 105.10 KiB.

[23 Nov 2006 16:22] MySQL Verification Team
Thank you for the feedback. Still I was unable to repeat, I attached
a screenshot please see if I did something different what are you are
reporting. Thanks in advance.
[24 Nov 2006 7:12] Maciej Pilichowski
I downloaded the last GUI Tools.

Script mode -- works, but on errors semicolon is replaced by ":". Very confusing.

Query mode -- still does not work ("create biblio...."). Attach a screenshot?