Re: auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-14 Thread Sinisa Milivojevic
Thank you, we shall investigate this problem. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com

Re: auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-12 Thread Steven Haryanto
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

auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-12 Thread Steven Haryanto
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

auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-10 Thread Steven Haryanto
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

Re: auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-10 Thread Paul DuBois
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. mysql create table t1_b(i int unsigned primary key auto_increment, j int) type=bdb; mysql create table t1_m(i int

Re: auto_increment value recycled/reset in BDB table? [3.23.46]

2002-02-10 Thread Steven Haryanto
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