i believe since 3.23.39 it should not be? mysql> create table t1_b(i int unsigned primary key auto_increment, j int) type=bdb; mysql> create table t1_m(i int unsigned primary key auto_increment, j int) type=myisam; mysql> insert into t1_bdb(j)values(0); mysql> insert into t1_bdb(j)values(0); mysql> insert into t1_bdb(j)values(0); mysql> select * from t1_bdb; +---+------+ | i | j | +---+------+ | 1 | 0 | | 2 | 0 | | 3 | 0 | +---+------+ 3 rows in set (0.00 sec)
mysql> delete from t1_bdb where i=3; mysql> insert into t1_bdb(j)values(0); mysql> select * from t1_bdb; +---+------+ | i | j | +---+------+ | 1 | 0 | | 2 | 0 | | 3 | 0 | +---+------+ 3 rows in set (0.00 sec) mysql> insert into t1_myisam(j)values(0); mysql> insert into t1_myisam(j)values(0); mysql> insert into t1_myisam(j)values(0); mysql> select * from t1_myisam; +---+------+ | i | j | +---+------+ | 1 | 0 | | 2 | 0 | | 3 | 0 | +---+------+ 3 rows in set (0.00 sec) mysql> delete from t1_myisam where i=3; mysql> insert into t1_myisam(j)values(0); mysql> select * from t1_myisam; +---+------+ | i | j | +---+------+ | 1 | 0 | | 2 | 0 | | 4 | 0 | +---+------+ -- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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