mysql inconsistent output

[Anthony]

Hi,

Has anyone any ideas why the select below shows me that a record with
the id 32711 exists and yet the max() function is wrong and the last
select that I try does not return anything? The version of mysql is
3.23.54 running on OS X 10.2. Any suggestions on how I might solve
this would be much appreciated... thanks..

mysql> use rt2
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select id, created from tickets;
+-------+---------------------+
| id | created |
+-------+---------------------+
| 28456 | 2003-10-06 16:28:57 |
| 28457 | 2003-10-06 17:06:36 |
| 28458 | 2003-10-06 17:35:10 |
| 28459 | 2003-10-06 17:47:17 |
| 28460 | 2003-10-06 23:17:49 |
| 31776 | 2003-10-07 06:47:19 |
| 32341 | 2003-10-07 08:51:40 |
| 32706 | 2003-10-07 16:34:05 |
| 32707 | 2003-10-08 07:04:11 |
| 32708 | 2003-10-08 08:38:54 |
| 32709 | 2003-10-08 09:53:18 |
| 32710 | 2003-10-08 13:06:17 |
| 32711 | 2003-10-08 15:20:00 |
+-------+---------------------+
13 rows in set (0.05 sec)

mysql> select max(id) from tickets;
+---------+
| max(id) |
+---------+
| 32708 |
+---------+
1 row in set (0.00 sec)

mysql> select * from tickets where id=32711;
Empty set (0.00 sec)