Menu

#1301 Create view based on selection from another view

closed-fixed
1
2013-05-31
2013-05-21
MadKroLL
No

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

Discussion

  • Fred Toussi

    Fred Toussi - 2013-05-21
    • assigned_to: nobody --> fredt
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Fred Toussi

    Fred Toussi - 2013-05-21

    This works with the latest snapshot jars for 2.3.0.

     
  • MadKroLL

    MadKroLL - 2013-05-21

    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.

     
  • Fred Toussi

    Fred Toussi - 2013-05-31
    • status: open-fixed --> closed-fixed
     

Log in to post a comment.