On Monday, August 17, 2015 at 6:58:07 PM UTC+8, Noel Grandin wrote:
>
> What does the actual stack trace look like?
>
The stack trace from the .trace.db file looks like this:
2015-08-18 11:25:15 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.NullPointerException"; SQL statement:
SELECT * FROM master_data WHERE my_id IN (
SELECT my_id FROM stats_table
WHERE my_keyword IN ('Abra', 'Cadabra', 'Abracadabra')
GROUP BY my_id
ORDER BY COUNT(*)
LIMIT 10
) [50000-188]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.command.Command.executeQuery(Command.java:209)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:179)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at
net.sourceforge.squirrel_sql.client.session.StatementWrapper.execute(StatementWrapper.java:165)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:369)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
at org.h2.value.Value.compareTo(Value.java:945)
at org.h2.engine.Database.areEqual(Database.java:332)
at org.h2.result.ResultTempTable.find(ResultTempTable.java:307)
at org.h2.result.ResultTempTable.addRow(ResultTempTable.java:151)
at org.h2.result.ResultTempTable.addRows(ResultTempTable.java:170)
at org.h2.result.LocalResult.addRow(LocalResult.java:289)
at org.h2.command.dml.Select.queryGroup(Select.java:385)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:638)
at org.h2.command.dml.Query.query(Query.java:322)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.expression.ConditionInSelect.getValue(ConditionInSelect.java:47)
at org.h2.expression.Expression.getBooleanValue(Expression.java:178)
at org.h2.command.dml.Select.queryFlat(Select.java:533)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:643)
at org.h2.command.dml.Query.query(Query.java:322)
at org.h2.command.dml.Query.query(Query.java:290)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:90)
at org.h2.command.Command.executeQuery(Command.java:197)
... 7 more
FYI, I used squirrel SQL client to make the query.
Thanks!
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
