Hi Thomas,

I'm getting a NullPointerException when altering an existing table
with the following statement:

ALTER TABLE Songs ALTER COLUMN playFrequency Double as
((cast(playCount as Double) * 60 * 60 * 24 * 100) /
(abs(datediff('SECOND', dateAdded, now()))+1))

The stacktrace is:

java.lang.NullPointerException
        at
org.h2.expression.ExpressionColumn.isEverything(ExpressionColumn.java:
269)
        at org.h2.expression.Function.isEverything(Function.java:2031)
        at org.h2.expression.Operation.isEverything(Operation.java:378)
        at org.h2.expression.Operation.isEverything(Operation.java:378)
        at org.h2.expression.Operation.isEverything(Operation.java:378)
        at org.h2.expression.Operation.isEverything(Operation.java:378)
        at org.h2.expression.Operation.isEverything(Operation.java:378)
        at
org.h2.command.ddl.AlterTableAlterColumn.checkDefaultReferencesTable(AlterTableAlterColumn.java:
161)
        at
org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:
83)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:212)
        ... 7 more

This first occurred with h2 1.3.159, it hasn't happened with 1.3.155
(which I was using prior to 1.3.159).

Cheers,

-hendrik

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

Reply via email to