Hello,
There a problem in HSQLDB 1.7.1 creating a view that uses another view. I
checked with many alternatives but no result. I found out that it refuses to
accept views that reference other views. Is it a known bug?
The view that creates the problem is as follows
--------------------------------------------------------
CREATE VIEW "PriceHits" AS
SELECT "LastPrices"."Price" "Price2" FROM "LastPrices";
---------------------------------------------------------
Running the above statement in the Database Manager I get the error message
Column not found: Price in statement [CREATE VIEW .... etc] Error code -28,
state s0022
LastPrices is a View that is already defined with no problemo as follows
---------------------------------------------------------
CREATE VIEW "LastPrices" AS SELECT
"Prices".ISBN "ISBN",
"Books"."Title" "Title",
MAX("Prices"."DateTime") "DateTime",
"Prices"."Price" "Price",
"Prices"."Location" "Location"
FROM
"Prices", "BookSearchDetails", "Books"
WHERE
"Prices".ISBN = "BookSearchDetails".ISBN
AND "Prices".ISBN = "Books".ISBN
AND "BookSearchDetails"."SearchEnabled" = 1
GROUP BY
"Prices".ISBN;
-----------------------------------------------------------
Thanks for any hint
Jim
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers