Exception when using a function with the DETERMINISTIC feature

[GoogleCodeExporter]

What steps will reproduce the problem?
(simple SQL scripts or simple standalone applications are preferred)
1. See the attached test

What is the expected output? What do you see instead?
SQL statements should execute, but an exception is thrown.

What version of the product are you using? On what operating system, file
system, and virtual machine?
Windows XP, JDK 1.6, h2-1.1.109.jar

Do you know a workaround?
No

In your view, is this a defect or a feature request?
A defect

Please provide any additional information below.

It looks like a bug with the new create alias feature 'DETERMINISTIC'
Removing this keyword suppress the bug.

Cheers,

Olivier

Original issue reported on code.google.com by opar...@gmail.com on 24 Mar 2009 at 12:07

[GoogleCodeExporter]

Hi,

Thanks a lot for your help and for the great test case! I found and fixed the
problem. The change (JavaFunction) is committed to the trunk and will be 
included in
the next release.

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 25 Mar 2009 at 8:35

• Changed state: Accepted

[GoogleCodeExporter]

This should be fixed with todays release (1.1.110).

Original comment by thomas.t...@gmail.com on 3 Apr 2009 at 3:58

• Changed state: Fixed