MySQL single-line comments with '#' causes next statement to be skipped

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Migration SQL script for MySQL with a comment starting with '#'

What is the expected output? What do you see instead?
Expected build. Instead the first statement following the comment seems to
be skipped.

What version of the product are you using? On what operating system?
Version 'RELEASE' on Windows XP, running through Maven2 using Cygwin.

Please provide any additional information below.
Example SQL script:

# A singleline comment

create table Test1 (
    id bigint not null auto_increment, 
    name varchar(64) not null
) ENGINE=InnoDB;

create table Test2 (
    id bigint not null auto_increment, 
    name varchar(64) not null
) ENGINE=InnoDB;
-------
mysql> show tables;
+--------------------------+
| Tables_in_test           |
+--------------------------+
| schema_version           |
| test2                    |
+--------------------------+
2 rows in set (0.00 sec)

Note that a comment denoted by '--' seems to work.

Original issue reported on code.google.com by joe.tre...@gmail.com on 4 Sep 2008 at 10:26

[GoogleCodeExporter]

Incidentally - thank you for the project!

Original comment by joe.tre...@gmail.com on 4 Sep 2008 at 10:26

[GoogleCodeExporter]

Thanks Joe... I'll take a look at this soon!

Original comment by christia...@gmail.com on 9 Sep 2008 at 4:56

[GoogleCodeExporter]

Original comment by christia...@gmail.com on 9 Sep 2008 at 8:37

[GoogleCodeExporter]

Original comment by christia...@gmail.com on 9 Sep 2008 at 8:37

• Changed state: Accepted

[GoogleCodeExporter]

Will be in the next SNAPSHOT build.

Original comment by christia...@gmail.com on 26 Oct 2008 at 2:33

• Changed state: Fixed