#55 Hangs on Parsing problems

[William Rogers]

The context of this bug is when using SQL file importer
to import an script file generated by the HyperSonic SQL
100% Pure Java database (also a SourceForge project).

The import hangs (goes to 99% CPU utilization) when
the following are encountered in an SQL file:

1. the default value contains a space as in:
CREATE TABLE STUDENTS(FULLNAME VARCHAR
DEFAULT 'First Last');

2. IDENTITY keyword is encountered

3. CONSTRAINT keyword is encountered

4. If there is no separating semi-colon between sql table
statements.

Application should know how to abort parsing and give a
meaningful error message such as reporting what it
choked on.

Ideally, a database script file generated by HSQLDB
could be read by dbViZ. Currently, I have to hand edit
the file until it will import, with dbViZ freezing at 99%
CPU utilization if an error is encountered.

Other than that, a great app.

[William Rogers]

SQL script generated by HyperSonic SQL database engine