Script stops working on HSQLDB 1.9.0-rc6

Posted by jacklty on Stack Overflow See other posts from Stack Overflow or by jacklty
Published on 2009-11-20T21:19:41Z Indexed on 2010/06/08 1:02 UTC
Read the original article Hit count: 430

Filed under:

DROP VIEW V1 IF EXISTS;
DROP TABLE T1 IF EXISTS;

CREATE TABLE T1 (id INT, name VARCHAR(32), age int);
CREATE VIEW V1 AS (SELECT * FROM T1 WHERE age < 21);


I have no problem to execute the SQL statement above in one JDBC statement or on the SWING Manager from HSQLDB. Now it stops working on 1.9.0-rc6. This is error message I got - "user lacks privilege or object not found: T1 / Error Code: -5501 / State: 42501"

Does anyone know what have changed in 1.9.0-XX which made it not working?

Thanks

© Stack Overflow or respective owner

Related posts about hsqldb