Peter Zaitsev writes:
> 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]
>
>
>
Hi!
Yes, the above is well known behaviour.
What do you suggest, how should we change that ??
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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
