A new topic, 'BUG: MySQL double data type handled incorrectly by
generateChangeLog', has been made on a board you are watching.
You can see it at
http://liquibase.org/forum/index.php?topic=28.new#new
The text of the topic is shown below:
I've run into the following problem, and searching, here, in the archives or in
google in general, doesn't seem to be helping:
I have a table with a column of type DOUBLE, see
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html regarding mysql-isms.
Using liquibase 1.9.3, the latest mysql jdbc connector (5.1.7), against a mysql
5.0.45 server, generateChangeLog is creating the following bit of xml
describing a DOUBLE column data type:
<column defaultValueNumeric="0.0" name="zoom_coefficient" type="DOUBLE(22)">
<constraints nullable="false"/>
</column>
Which generates the following DDL when attempting to update:
`zoom_coefficient` DOUBLE (22) DEFAULT 0 NOT NULL,
The problem is that MySQL sees that as a syntax error, when attempting a
update. I've run the query manually via Eclipse:SQL Explorer, and I got the
same syntax error, just to make sure it wasn't something else. MySQL expects no
size to be provided along with DOUBLE. This is what should be generated:
`zoom_coefficient` DOUBLE DEFAULT 0 NOT NULL,
Running that in Eclipse:SQL Explorer allows the query to execute without issue.
As an aside, Eclipse:SQL Explorer which also uses JDBC, and using the same
version and against the same database, reports a size for the column, in the
reference database schema, as 22; however, when I ask it to generate the create
table statement, it correctly outputs:
`zoom_coefficient` DOUBLE DEFAULT 0 NOT NULL,
Unsubscribe to new topics from this board by clicking here:
http://liquibase.org/forum/index.php?action=notifyboard;board=1.0
Regards,
The LiquiBase Community Forum Team.------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________
Liquibase-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/liquibase-user
