On 10/24/07, Daniel John Debrunner (JIRA) <[EMAIL PROTECTED]> wrote: > > [ > https://issues.apache.org/jira/browse/DERBY-2245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537469 > ] > > Daniel John Debrunner commented on DERBY-2245: > ---------------------------------------------- > > Does a keyword being reserved has anything to do with this method, the JDBC > javadoc as Knut Anders points out just says non-SQL 2003 keywords? > > In the list Myrna provides at least these are SQL 2003 keywords: > > BIGINT,BOOLEAN,CALL,CURRENT_ROLE,ROLE,NONE > > The XML words are part of standard SQL, but maybe not SQL2003. > > I'm not sure though what the correct list should be, I can't figure out a use > for this method so it's hard to tell what it should do. > > Thx for your input, Dan...
I've not tried to find a real JDBC spec yet, but the api doc (for 1.4.2) indicates this method needs to return keywords not part of SQL92: "Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL92 keywords". And, the plot thickens when one looks at the 1.6 api doc, which says: "Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords" Does that mean we are supposed to return something different with 1.6 than earlier versions? I know we're not supposed to base ourselves on other products, but a little googleing found a MySQL 5.0 bug that was fixed by making this method return reserved non-sql92 keywords...Another website suggests that 'keyword' implies a reserved word...Just saying that if we return (of course non-sql) reserved words here, it's not unusual. I am hoping someone with better knowledge of the JDBC spec can indicate if this is supposed to be *reserved* keywords or not, or if it's totally up to the implementation. Also, I would like it if someone could explain what it means if a keyword is in the 'reserved-Non-SQL 92' section of sqlgrammar.jj; I'm wondering if some of those are maybe in the wrong place. Thx, Myrna
