Column comments not added

General Discussion
1

Hi all,

I’m using liquibase 1.9.3 against Oracle XE.

When I try to add a new column to an existing table, the remarks attribute value is not inserted as column comment. I’m using the following syntax:

[sup]

 
   


[/sup]

Any ideas?

Thanks,
Ruud

2

The problem is that we are re-using the element poorly in this case.  The remarks attribute is generated when you are creating a changelog file from an existing database, but we currently do not re-apply them back to the database in the addColumn change.

I created http://liquibase.jira.com/browse/CORE-420 so it will not be lost.

Nathan

3

Although there is a workaround (using the SQL tag), I would like to see this issue fixed with a higher priority than it currently has. What’s the procedure for changing the priority Nathan?

4

They best way is to implement and either commit the change or submit it as a patch :)  Otherwise, you can vote for it on jira.

Nathan

5

I looked at JIRA it says resolved for 2.0.4. I’m using 2.0.5 and MySQL 5.5 and it doesn’t seem to work during a create table
<column name=“SomeName” type=“VARCHAR(16)”  remarks=“remark”>

When I run the query "SHOW full COLUMNS FROM SomeName; " the comments column is empty

6

I USE comments TABLE. 

7

hi!

i have the same problem. my changeSet:


        <addColumn

                schemaName=“kliniki_test”

                tableName=“test_table”>

            <column

                    name=“test_column”

                    type=“tinyint(1)”

                    valueBoolean=“false”

                    remarks=“Test Comment”

                    />

       

Column has been created as expected but there is no comment in database.

I have mysql 5.6 and liquibase 2.0.5

8

I created https://liquibase.jira.com/browse/CORE-1451 to track the bug and will look into it.


Nathan

9

Thanks, I added that to the ticket.


Nathan