New Topic: Sybase support not correct

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

New Topic: Sybase support not correct

by LiquiBase Community Forum :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

A new topic, 'Sybase support not correct', has been made on a board you are watching.

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

The text of the topic is shown below:

Hi,

I am using generating sybase db statements using liquibase jar.
For generated statements look like:
CREATE TABLE [AA774] (ID INT IDENTITY  NOT NULL, V1 INT NULL, CONSTRAINT [PKCN_AA774] PRIMARY KEY (ID))
(Class used to generate this statement is CreateTableStatement)

CREATE UNIQUE INDEX [X1_AA774] ON [AA774](V1)
(Class used to generate this statement is CreateTableStatement)

DROP INDEX [AA774].[X1_AA774]
(Class used to generate this statement is DropIndexStatement)

DROP VIEW [V_AA774]
(Class used to generate this statement is DropViewStatement)

ALTER TABLE [AA774] ADD F4 INT NULL
(Class used to generate this statement is AddColumnStatement)

CREATE VIEW [V_AA774] AS SELECT * FROM AA774
(Class used to generate this statement is CreateViewStatement)

All the above statemens use square brackets around the table/view/constraint name. This does not work in Sybase.
Is there any fix coming for this in the next version of liquibase?

Also there is another problem here, for SybaseDatabase.getIntType() gives "INT", it should be NUMERIC.

Regards,
Usha.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=2.0

Regards,
The LiquiBase Community Forum Team.
------------------------------------------------------------------------------

_______________________________________________
Liquibase-devel mailing list
Liquibase-devel@...
https://lists.sourceforge.net/lists/listinfo/liquibase-devel