Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
mysql@lists.mysql.com > Cc: Andrew Braithwaite > Subject: Re: possible MySQL bug - insert into 'double' column problem > with mysql 4.1 > > Andrew Braithwaite wrote: >> Hi All, >> >> I have a strange error when trying to insert into a table with 2 >

RE: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
MySQL bug - insert into 'double' column problem with mysql 4.1 Andrew Braithwaite wrote: > Hi All, > > I have a strange error when trying to insert into a table with 2 > 'double' fields. It inserts into the 1st field OK but fills the 2nd one > with nines. See

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Roger Baklund
Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL|

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Martijn Tonies
Hello Andrew, > I have a strange error when trying to insert into a table with 2 > 'double' fields. It inserts into the 1st field OK but fills the 2nd one > with nines. See below for a complete recreate. > > Is this a known problem? Does anyone have a solution? > > I'm running standard MySQL bi

possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat l