Hi, You are using version 1.0.65 from 2008-01-18. (The -65 in the exception code HY000-65 is the version). Could you try again using a newer version please?
Regards, Thomas On Sun, Dec 14, 2008 at 8:28 PM, Harpal Grover <[email protected]> wrote: > > Hello all, > > I am executing a rather simple SQL Query and running into a General > error: java.lang.NullPointerException [HY000-65]. > > STACKTRACE > ================================ > > java.lang.NullPointerException > at org.h2.table.TableFilter.getValue(TableFilter.java:553) > at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java: > 163) > at org.h2.expression.Alias.getValue(Alias.java:33) > at org.h2.command.dml.Select.queryGroup(Select.java:181) > at org.h2.command.dml.Select.queryWithoutCache(Select.java:382) > at org.h2.command.dml.Query.query(Query.java:226) > at org.h2.command.dml.SelectUnion.queryWithoutCache(SelectUnion.java: > 113) > at org.h2.command.dml.SelectUnion.query(SelectUnion.java:323) > at org.h2.command.dml.Insert.update(Insert.java:95) > at org.h2.command.ddl.CreateTable.update(CreateTable.java:169) > at org.h2.command.CommandContainer.update(CommandContainer.java:68) > at org.h2.command.Command.executeUpdate(Command.java:171) > at org.h2.jdbc.JdbcPreparedStatement.execute > (JdbcPreparedStatement.java:161) > > SQL QUERY > ===================================== > CREATE TABLE TEST AS > SELECT * FROM ORDERS O, ORDERS_INFO OI WHERE O.ID = OI.ORDERID AND > OI.DATE BETWEEN '20081201' AND '20081209' > > The result should be no rows returned because there are no orders. > However I get the exception above instead. When I change the date > values to fall in a wider range, then I am able to successfully > retrieve records because the orders fall into the specified date > range. > > I altered the query as follows: > > CREATE TABLE TEST AS > SELECT * FROM ORDERS O, ORDERS_INFO OI WHERE O.ID = OI.ORDERID AND > OI.DATE > '20081201' AND OI.DATE < '20081209'; > > And ran it again and got the same exception. Is this a bug or is there > a flaw in my logic? > > Thanks > > Harpal > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
