db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2245) DatabaseMetaData.getSQLKeywords() contains words that are not keywords in Derby.
Date Sat, 03 Nov 2007 18:15:50 GMT

    [ 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.


Mime
View raw message