Re: Insert BUG into MyISAM table (Linux + MySQL 3.23.56)

2003-08-14 Thread David Bordas
> Hi, > > I don't know if it has anything to do with your problem, I just wanted to > comment on the use of a timestamp column in a primary key... > > * David Bordas > > +--+--+--+-+-+ > > + > > > > | Field| Type

Re: Insert BUG into MyISAM table (Linux + MySQL 3.23.56)

2003-08-14 Thread David Bordas
> Hi list, > > I've got a little bug with MySQL. > I can insert a row into my table but this row will not appear in the table > :( > Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz > from MySQL team. > > Table Description : > mysql> desc Log_Forums; > +--+---

Re: Insert BUG into MyISAM table (Linux + MySQL 3.23.56)

2003-08-14 Thread Roger Baklund
Hi, I don't know if it has anything to do with your problem, I just wanted to comment on the use of a timestamp column in a primary key... * David Bordas > +--+--+--+-+-+ > + > > > | Field| Type | Null | Key |

Re: Insert BUG into MyISAM table (Linux + MySQL 3.23.56)

2003-08-14 Thread David Bordas
> > Can you create a repeatable test case ? > > Regards, > Sergei > On the server where i've got problem, I tried making a dump and import dump into a table with same name but into a different database. There it works ... So, i come back to my production database and table. I've always got the sam

Re: Insert bug into MyISAM table (Linux + MySQL 3.23.56)

2003-08-12 Thread David Bordas
Hi, >> mysql> select * from Log_Forums where Date="2003080611"; >> mysql> insert into Log_Forums (pseudo,date,Type_Message) values >> > ("doss08",2003080611,"0"); > > insert into Log_Forums (pseudo,date,Type_Message) values > ("doss08","2003080611","0"); > Same thing here. But i "sol

Insert bug into MyISAM table (Linux + MySQL 3.23.56)

2003-08-07 Thread David Bordas
Hi list, I've got a little bug with MySQL. I can insert a row into my table but this row will not appear in the table :( Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz from MySQL team. Table Description : mysql> desc Log_Forums; +--+--+

Re: Insert BUG into MyISAM table (Linux + MySQL 3.23.56)

2003-08-06 Thread Sergei Golubchik
Hi! On Aug 06, David Bordas wrote: > > Hi list, > > > > I've got a little bug with MySQL. > > I can insert a row into my table but this row will not appear in the table > > :( > > Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz > > from MySQL team. > > > > Table Descrip