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