Re: float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

2004-05-03 Thread Jeremy Zawodny
On Mon, May 03, 2004 at 05:56:03PM +0200, Hans-Peter Grimm wrote: > Hi, > > I think there is > > 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE > 2) a minor problem with CREATE TABLE(f FLOAT(,...)) I think that there is maybe: 3) a bug in PROCEDURE ANALYSE that you should report i

float in PROCEDURE ANALYSE() / misleading CREATE TABLE error

2004-05-03 Thread Hans-Peter Grimm
Hi, I think there is 1) a problem with FLOAT recommendations in PROCEDURE ANALYSE 2) a minor problem with CREATE TABLE(f FLOAT(,...)) Please correct me if I'm wrong. With MySQL 4.0.17, the query SELECT * FROM my_table PROCEDURE ANALYSE(); gives me the following result for a DOUBLE NOT NULL col