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
-~----------~----~----~----~------~----~------~--~---
