Hello guys...
I'm having problem with the auto_increment feature.
I have a table like this...
+--------+-----------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------+-----------------+------+-----+------------+----------------+
| Data | date | | | 0000-00-00 |
|
| Edicao | int(3) unsigned | | PRI | NULL | auto_increment
|
| Status | varchar(6) | | | |
|
+--------+-----------------+------+-----+------------+----------------+
When I make entries to this table, the column Edition goes...
+--------+
| Edicao |
+--------+
| 1 |
| 2 |
| 3 |
+--------+
as expected.
The problem is...if I delete the third entry (Edicao = 3), the next
entry inserted should be 3, right?! Well it is not! It is 4. So I get a
table like this...
+--------+
| Edicao |
+--------+
| 1 |
| 2 |
| 4 |
+--------+
Well, I tested it on 2.33.37, 2.33.38 and 2.33.39. In 2.33.37 it was
right...the entry was 3. But in the newer versions the number was 4.
It's like the auto_increment pointer didn't do the decrement when I
deleted the last entry.
Is this a bug?! Where should it be reported to?
Thank you all...
William N. Zanatta
---------------------------------------------------------------------
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
