Hello mysql,
Mysql 3.23.32 running on Linux.
I've got a table with auto_increment command stuck, well this is no
problem there is a record in this table with MAX_UINT value.
I'm not really shure if this is a bug or correct behavior, but still
it leads to toe problems in this case:
insert into g02layers_stat_hits set counter=1, type=1, page_group=1;
ERROR 1062: Duplicate entry '4294967295' for key 1
This is quite well result, but if we use replace in this case (which
works quite OK then the table has not maximum number of rows:
mysql> replace into g02layers_stat_hits set counter=1, type=1, page_group=1;
Query OK, 2 rows affected (0.33 sec)
and in this case the old row with id=4294967295 is destroyed.
There for this works quite nice then the table does not have last_id
used:
mysql> replace into g02layers_stat_hits set counter=1, type=1, page_group=1;
Query OK, 1 row affected (0.02 sec)
in this case the new ID is generated and everything is just fine :)
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
