I have a table test with an ID column integer and DESCRIPTION column
varchar2(10)
I'm doing a query of this type:
select id from test where 1 = 1 and
exists (select a.* from (select id from test t where t.id = test.id))
but obtain this error:
Column "TEST.ID" not found; SQL statement:
CREATE FORCE VIEW PUBLIC._40 AS
SELECT
ID
FROM PUBLIC.TEST T
WHERE T.ID = TEST.ID [42122-197] 42S22/42122
It seems that into inner subquery I cannot reference parent column name ID.
Is this a bug of H2?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
