db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2245) DatabaseMetaData.getSQLKeywords() contains words that are not keywords in Derby.
Date Thu, 01 Nov 2007 17:26:50 GMT

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

Myrna van Lunteren commented on DERBY-2245:

After lack of response on the list (except from Dan, thx) and some more thought:

- there is no mention of 'reserved' in the javadoc, and it's not clear what the behavior is
supposed to be if you use a reserved keyword. So it's hard to verify what are
  really the reserved keywords. So we'll just take the current split between reserved and
non-reserved in sqlgrammar.jj as truth.
- Wikipedia says: 'A keyword is a word or concept with special significance' and 'an identifier
in a computer language that indicates a specific command '. So again, this suggests all keywords,
not just reserved.
- the spirit of the call is to return non-sql keywords, not specific to which SQL spec. So,
let's not make a difference between jdk16 and jdk14/15 (jdk16 says non-SQL2003, earlier says

So, I propose to:
-  move the XML related (and any other non SQL99, but SQL2003 - which would they be?) keywords
into the SQL reserved keywords area
-  modify the javadoc to say, SQL2003, rather than SQL92.
-  update any relevant docs
-  make getSQLKeywords return all non SQL keywords (i.e. both those in the reserved, and non-reserved

> 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:,,,,,,
>            Reporter: Daniel John Debrunner
>            Assignee: Saurabh Vyas
>            Priority: Minor
> 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.

View raw message