defaultValueNumeric="0" or defaultValue="0" is translated to 0.0

Description

<column name="VideoId" type="INT" defaultValue="0">
</column>
or
<column name="VideoId" type="INT" defaultValueNumeric="0">
</column>

translates in PostgeSQL to "VideoId" INT4 DEFAULT '0.0' and I get the following error:

ERROR: invalid input syntax for integer: "0.0"

It also translates to 0.0 in mysql, but there it's more liberal and doesn't give an error (although I think if I wanted to write 0.0 I would, and if I wrote 0 I meant 0)

Environment

postgresql, mysql

Activity

Show:

Nathan Voxland July 23, 2014 at 2:46 PM

Final fixes should be in 3.2.2

Nathan Voxland July 23, 2014 at 2:46 PM

Still some cases where this converts in 3.2.1. Fixed in 3.2.2

Nathan Voxland July 10, 2014 at 8:12 PM

Fixed.

Janning June 27, 2014 at 1:23 PM

I have the same problem. liquibase 3.2.0 and postgresql 9.3.4

Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created June 18, 2014 at 6:48 AM
Updated July 23, 2014 at 2:46 PM
Resolved July 23, 2014 at 2:46 PM