"rename column" Oracle compatibility

[Steve Nester]

Hi

I am using Oracle for production and H2 as an in-memory test database.  I'm having trouble with Oracle compatibility for the "rename column" statement.

Specifically, the Oracle statement is:

alter table "SOME_TABLE" rename column "COLUMN_A" to "COLUMN_B" ;

I'm using Spring and Liquibase and I believe I have specified "use Oracle compatibility mode" correctly, but this statement is rejected by H2 as follows:

Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE ""SOME_TABLE"" RENAME COLUMN[*] ""COLUMN_A"" TO ""COLUMN_B"" "; expected "TO"; SQL statement:
alter table "SOME_TABLE" rename column "COLUMN_A" to "COLUMN_B" [42001-174]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
    at org.h2.message.DbException.getSyntaxError(DbException.java:197)
    at org.h2.command.Parser.getSyntaxError(Parser.java:504)
    at org.h2.command.Parser.read(Parser.java:2867)
    at org.h2.command.Parser.parseAlterTable(Parser.java:4971)
    at org.h2.command.Parser.parseAlter(Parser.java:4412)
    at org.h2.command.Parser.parsePrepared(Parser.java:316)
    at org.h2.command.Parser.parse(Parser.java:289)
    at org.h2.command.Parser.parse(Parser.java:265)
    at org.h2.command.Parser.prepareCommand(Parser.java:226)
    at org.h2.engine.Session.prepareLocal(Session.java:437)
    at org.h2.engine.Session.prepareCommand(Session.java:380)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1138)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:168)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:156)
    at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:294)

Is there H2 compatibility for a rename column statement?

Thanks for any suggestions!
Steve

[Thomas Mueller]

Hi,

As documented, for H2 the syntax is:

    ALTER TABLE ALTER COLUMN x RENAME TO y

I'm not sure if Oracle supports that as well. As for rename, only renaming the columns is currently supported:

    ALTER TABLE tableName RENAME TO newName

Patches are welcome!

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.