is there any documentation for the new modifyDataType

General Discussion
1

Is there any documentation for modifyDataType?
I was using version 1.7.0, upgraded to 1.9.5 to take advantage of the parameter values but have issues with tinyint on oracle on this version.
Tried 2.0 but now my modifyColumn is not working any more.
I need to get this done a.s.a.p. so any help is appreciated.
Thanks,
Ion

2

I don’t think I have gotten to the docs on the new modifyDataType change yet. 

The available attributes are:
schemaName
tableName
columnName
newDataType
nullable

so it should be pretty straightforward to use.  You can get the old modifyColumn change from the extensions portal, though modifyDataType is the better option.

You can always fall back to the tag and specify what you want yourself if you cannot get the built-in tags to work right.

Nathan

3

Nathan,

I have tried to use the extension in 2.0 RC2 but it failed with the following error:
LiquiBase Update Failed: cvc-complex-type.2.4.a: Invalid content was found starting with element ‘modifyColumn’.

My change log looks like this:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<databaseChangeLog xmlns=“http://www.liquibase.org/xml/ns/dbchangelog”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xsi:schemaLocation=“http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd”>





I guess I am missing the schema for the extension. I could not figure out how to configure it.
What am I missing?
Ion

4

Yes, each extension change needs a different schema so it doesn’t conflict with the “core” tags. 

There is a generic “ext” schema you can add:

    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"

with schemaLocation: 

    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd

    <?xml version="1.0" encoding="UTF-8" standalone="no"?> http://www.liquibase.org/xml/ns/dbchangelog"   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd                     http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">                        

Nathan

5
Originally posted by: Nathan
The available attributes are: schemaName tableName columnName newDataType nullable

Please note that “nullable” is not recognized by the parser in 2.0rc6.  Doesn’t look like there’s a way to use modifyDataType to include null constraints.  I’m going to fall back on the tag.

Best,
Laird