fredt (DevLead) has posted the following at: http://sourceforge.net/forum/message.php?msg_id=1464805
Please reply there. QUOTE: Would the users of the product please comment on the type promotion issue, especially for integral types. This is a candidate for the next point release. If I expand the example of 1000*1000 to (1000*1000)/1000 when the column type is SMALLINT what should the result be? Currently it is not 1000 (the 1000*1000 gets truncated first, and then divided by 1000). One idea is to follow an integer promotion scheme more akin to Java's so that the SMALLINT values are first promoted to Java int, then the operations are performed and the result is truncated back to SMALLINT. Any comments? ENDQUOTE Thank you. --dedmike-- __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
