New Topic: SQL Alter table modify is not supported (to change existent column datatype)

View: New views
1 Messages — Rating Filter:   Alert me  

New Topic: SQL Alter table modify is not supported (to change existent column datatype)

by LiquiBase Community Forum :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

A new topic, 'SQL Alter table modify is not supported (to change existent column datatype)', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=212.new#new

The text of the topic is shown below:

(I apologize if this theme is mentioned in another forum thread)

I know that diff-database (delta sql script) is so limited. I test on oracle 11g database with columns that their datatypes have been changed (many different types of datatypes changes). The generated sql file, or liquibase file, with the diff-database does not present these datatypes modifications in any case.
But I think a diff-database that supports the modification of datatypes can be simply developed (only viewing if the datatype is different, putting the appropiate sql statement, and letting the database driver the responsability to produce a sql exception if there is a syntax fail/error). Could the problem arise from the information that is provided by the driver?

I always work with sql script and so I put the sql syntax, but liquibase presents a modify column refactoring but I think this tag is producing too many controversies...

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.
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Liquibase-user mailing list
Liquibase-user@...
https://lists.sourceforge.net/lists/listinfo/liquibase-user