[
https://issues.apache.org/jira/browse/DERBY-2245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539961
]
Bryan Pendleton commented on DERBY-2245:
----------------------------------------
Myrna suggests: "- make getSQLKeywords return all non SQL keywords (i.e. both
those in the reserved, and non-reserved area). "
This seems very reasonable to me. My expectation of this call is that it returns
information about words that this database might treat specially, so that I
might
need to put them in quotation marks if I used them as the names of columns,
tables, views, etc. I could see this sort of information being useful if I was
trying
to write a generic tool, like a DBA tool for creating tables, etc. -- I might
want my
tool to warn my user that their chosen column name is a keyword in this
database,
and did they want to choose a different name. So your proposed
implementation seems good to me.
> 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
> Assignee: Saurabh Vyas
> Priority: Minor
>
> Such as REFRESH and PUBLICATION.
> Not sure what the exact contents should be.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
