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.
SQL script generated by HyperSonic SQL database engine