Failed to create view which based on selection from another already created view.
If it is based on selection from existent table - there is no any problem, it works well.
Environment:
- HSQLDB 2.2.9
- PostgreSQL compatibility mode enabled
- java 1.6
Script:
CREATE VIEW ab AS (
SELECT 'a' as fst, 'b' as snd
);
CREATE VIEW ab_wrapper AS (
SELECT fst, snd FROM ab
);
Error:
Could not execute statement '
CREATE VIEW ab_wrapper AS (
SELECT fst, snd FROM ab
)'
java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: FST
This works with the latest snapshot jars for 2.3.0.
Ok, Thanks for response!
Unfortunately I have no chance to use snapshot version. So I decided to avoid of such view creation and use tables directly.