[ 
https://issues.apache.org/jira/browse/DERBY-2245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599337#comment-14599337
 ] 

Andreas Jim-Hartmann commented on DERBY-2245:
---------------------------------------------

Is there any news on this issue?

I'm migrating the Liquibase changelogs of a PostgreSQL database to Derby. Some 
tables contain columns which are reserved words in Derby (year, hour, minute, 
second), therefore the changelogs fail. Liquibase uses the 
DatabaseMetaData.getSQLKeywords() to determine which table/column names to 
escape, so it would help if the Derby DB metadata would return all keywords 
which have to be escaped when used as table/column names.

TIA for your feedback!

> DatabaseMetaData.getSQLKeywords() contains words that are not keywords in 
> Derby.
> --------------------------------------------------------------------------------
>
>                 Key: DERBY-2245
>                 URL: https://issues.apache.org/jira/browse/DERBY-2245
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 
> 10.2.1.6, 10.2.2.0
>            Reporter: Daniel John Debrunner
>            Priority: Minor
>              Labels: derby_triage10_5_2
>
> Such as REFRESH and PUBLICATION.
> Not sure what the exact contents should be.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to