At 14:29 +0700 2/11/02, Steven Haryanto wrote:
>At 11/02/2002 05:21, Paul DuBois wrote:
>>At 4:10 +0700 2/11/02, Steven Haryanto wrote:
>>>i believe since 3.23.39 it should not be?
>>
>>BDB and MyISAM tables have different properties with respect to
>>AUTO_INCREMENT behavior.
>
>i see, so this is an "undocumented feature" (i haven't seen this in
>http://www.mysql.com/doc/B/D/BDB_characteristics.html , for
>example). any idea how i can get non-recycling auto_increment field
>with bdb table (aside from having to maintain another "dummy" myisam
>table to generate non-recycling sequence for it)?
Unfortunately, no. You might try your experiment with an InnoDB table,
though. I believe then you will find that values deleted from the top of
the sequence are not reused.
>
>--
>sh
>
>
>---------------------------------------------------------------------
>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 <mysql-thread99110@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
