Hi, PostgreSQL will get you the same results. See http://sqlfiddle.com/#!1/d41d8/1435
Regards, Thomas On Wed, Nov 6, 2013 at 6:05 PM, Rami Ojares <[email protected]> wrote: > 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. > -- 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.
