Forum: bugs

RE: Problem converting CREATE TABLE with doub [ reply ] By: Niccolo Rigacci on 2007-10-30 12:25	[forum:1002795]
You are right: the current CVS version is fixed. Many thanks.

RE: Problem converting CREATE TABLE with doub [ reply ] By: Jose Duarte on 2007-10-30 10:40	[forum:1002794]
This was fixed already in a recent revision. Did you take the latest revision from CVS? Jose

Problem converting CREATE TABLE with double [ reply ]
By: Niccolo Rigacci on 2007-10-30 09:31

[forum:1002792]

This is the MySQL snippet:

CREATE TABLE rra (
id mediumint(8) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
name varchar(100) NOT NULL default '',
x_files_factor double NOT NULL default '0.1',
steps mediumint(8) default '1',
rows int(12) NOT NULL default '600',
timespan int(12) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

The double field is not handled correctly:

CREATE TABLE "rra" (
...
"double" precision NOT NULL default '0.1',
...