Trying out the newest version of H2, we hit errors with queries of the
form
SELECT COUNT(*)
FROM
(SELECT t.ID
FROM cc_check c,
cc_transaction t
WHERE c.Retired=0
AND t.Retired =0
AND c.ID =t.CheckID
AND c.GroupID IS NOT NULL
AND t.Status <> c.Status
AND c.Status IN (7, 11, 20, 9, 16)
AND t.ID NOT IN
(SELECT OffsetID
FROM cc_transactionoffsetonset txnoo
WHERE txnoo.OnsetID IS NULL
AND txnoo.TransactionID IN
(SELECT ID FROM cc_transaction WHERE CheckID = c.ID
)
)
) a
H2 throws an error saying Column C.ID not found. If needed, I could
come up with a simplified repro.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
