Hi,
I found a bug about bigint and max(), here is error result caused by
bigint & max():
--------------------------------------------------------------------------------------
mysql> create table dick ( big bigint );
Query OK, 0 rows affected (0.00 sec)
mysql> insert into dick values ( '12345678901234567');
Query OK, 1 row affected (0.00 sec)
mysql> select max(big) from dick;
+-------------------+
| max(big) |
+-------------------+
| 12345678901234568 |
+-------------------+
1 row in set (0.00 sec)
---------------------------------------------------------------------------------------
By the way, Mysql version is 3.23.41.
Please check it! Thank you!
Plan
_________________________________________________________________
您可以在 MSN Hotmail 站点 http://www.hotmail.com/cn 免费收发电子邮件
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
