Hi Gaspar,
OK, thanks for the info. Seems like procedure analyse() has some other
bugs, for example despite controlling the number of possible enum
fields to e.g. 16, it returns an enum with 256 elements.
By the way, I opened a bug for this issue:
http://bugs.mysql.com/20305
Regards
t; sprintf(buff, "DOUBLE(%d,%d)", num_info.integers,
> num_info.decimals);
> <<<<<
OK, thanks for the info. Seems like procedure analyse() has some other
bugs, for example despite controlling the number of possible enum
fields to e.g. 16, it returns an enum
Hi Gaspar,
The following command returns recommended type FLOAT(3,6) for a
double(10,6) column:
mysql CAT -t -u catadmin -p -e \
"select * from temp procedure analyse(16,8192)" > temp.log
Optimal_fieldtype = FLOAT(3,6) NOT NULL.
The trouble is that FLOAT(3,6) does n
Hi,
The following command returns recommended type FLOAT(3,6) for a
double(10,6) column:
mysql CAT -t -u catadmin -p -e \
"select * from temp procedure analyse(16,8192)" > temp.log
Optimal_fieldtype = FLOAT(3,6) NOT NULL.
The trouble is that FLOAT(3,6) does not make sense,
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
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
Hi!
On Aug 10, Bernhard Doebler wrote:
> Hi,
>
> I try to optimize my tables. To see possible "errors" I use SELECT
> statements with PROCEDURE ANALYSE. I have a table that holds unique
> strings and an index by whitch it's referenced to another table.
> PROC
Hi,
I try to optimize my tables. To see possible "errors" I use SELECT statements with
PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch
it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the
strings to take an e
