Hi,

Multiplication that produces numbers higher than Integer.MAX_VALUE produces error.
This applies to any expression.

Test case (done with version 1.3.174)

CALL 2*1073741823;
CALL 2*1073741824;
CALL 2147483648;

Result:

2147483646
(1 row, 1 ms)

Numeric value out of range: "2147483648"; SQL statement:
CALL 2*1073741824 [22003-174] 22003/22003 (Help)

2147483648
(1 row, 1 ms)

- Rami Ojares

--
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/groups/opt_out.

Reply via email to