On Thu, Aug 01, 2002 at 12:30:13PM +0300, Valentin Nechayev wrote:
Wed, Jul 31, 2002 at 23:03:09, paul wrote about "[uanog] mysql":
mysql> select sum(some)+1 from test; +----------------------+ | sum(some)+1 | +----------------------+ | 18446744073709551616 | +----------------------+
Это равно ровно 2**64
По-моему, вполне логично ;)))))))
нет, я не понял почему n+1 и сумма из того же единственного n +1 не равны mysql> select sum(some)=some from test; +----------------+ | sum(some)=some | +----------------+ | 1 | +----------------+ 1 row in set (0.00 sec) mysql> select (sum(some)+1)=(some+1) from test; +------------------------+ | (sum(some)+1)=(some+1) | +------------------------+ | 0 | +------------------------+ 1 row in set (0.01 sec) mysql>
/netch =================================================================== uanog mailing list. To Unsubscribe: send mail to majordomo@uanog.kiev.ua with "unsubscribe uanog" in the body of the message
-- -------- Regards, Pavel. "He's the kind of man for the times that need the kind of man he is ..." =================================================================== uanog mailing list. To Unsubscribe: send mail to majordomo@uanog.kiev.ua with "unsubscribe uanog" in the body of the message