Comment 2 for bug 898517

Revision history for this message
Simon J Mudd (sjmudd) wrote :

I found the comments from a colleague about this:

Hi
This is from a run I've made today.

Before the run

AUTO_INCREMENT=776754726

root@host1 [db1]> select max(id) from __old_Arch_MessageData_201101;
+-----------+
| max(id) |
+-----------+
| 776713349 |
+-----------+
1 row in set (0.00 sec)

After the run :

AUTO_INCREMENT=776713350

root@host1 [db1]> select max(id) from Arch_MessageData_201101;
+-----------+
| max(id) |
+-----------+
| 776713349 |
+-----------+
1 row in set (0.00 sec)

In this case, I don't think any problem is caused from this. but I'm wondering if there might be cases where it will...