[Hsqldb-developers] Quoting problem

[Tim P. <ti...@pa...>]

Hi Fred, 

Here is another little one, I have quoted everything and come up with this 

SELECT * FROM "groupmembership" WHERE "user" = 1 AND EXISTS ( SELECT 
"groupcapability"."group" FROM "groupcapability", "groupmembership" WHERE 
"groupcapability"."group" = "groupmembership"."group" AND "capability" = 0)
Error reported by jdbc driver
Column not found: S0022 Column not found: group in statement [SELECT * FROM 
"groupmembership" WHERE "user" = 1 AND EXISTS ( SELECT 
"groupcapability"."group" FROM "groupcapability", "groupmembership" WHERE 
"groupcapability"."group" = "groupmembership"."group" AND "capability" = 0)]

Is there an obvious way around this problem?

cheers
timp


On Saturday 25 May 2002 17:22, Fred Toussi wrote:
> Thanks Tim,
>
> We have made a big effort to extend support for SQL and JDBC standards as
> well as improvements in other areas so that HSQLDB can be used with other
> products with fewer problems. Please let us know about any other potential
> issues.
>
> Fred