The query may look a little strange, but it is an example of a trick I use to create a 'virtual' table that I can select out of using sql criteria. The values can sometimes be null.
On Jun 1, 11:14 am, chenson42 <[email protected]> wrote: > This statement worked in 1.2.132. It does not in 1.2.135 or 1.2.136 > > select * from (select null as test from dual) where test='S'; > > It produces: > > java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 > at java.util.ArrayList.RangeCheck(ArrayList.java:572) > at java.util.ArrayList.get(ArrayList.java:347) > at org.h2.index.ViewIndex.find(ViewIndex.java:178) > at org.h2.index.IndexCursor.find(IndexCursor.java:136) > at org.h2.table.TableFilter.next(TableFilter.java:254) > at org.h2.command.dml.Select.queryGroup(Select.java:307) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:574) > at org.h2.command.dml.Query.query(Query.java:233) > at org.h2.command.CommandContainer.query(CommandContainer.java:80) > at org.h2.command.Command.executeQuery(Command.java:132) > at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76) -- 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.
