Hi group!
We have a working query (working on oracle that is) which throws the
above SQL error in H2 v1.3.154. The query is designed to return two
values from a subquery. This seems to be defunct in H2.
The query is:
select * from organization as org
where (org.id, org.timestamp) in
( select org1.id, max(org1.timestamp) from organization as ges1
group by org1.id)
and org.state=1
order by org.name;
Is this designed as such or are we facing a bug?
Thanks
Karsten
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
