Hello Rik, I thought the JIRA references would help.
In response to your comment. > Is it fair to say that you want to give users a programmatic way to list out > all of the Derby keywords, reserved and non-reserved, regardless of whether > they are keywords in the 2003 rev of the SQL Standard? The point of > producing this list is to help developers and IDEs avoid using these words > as names of tables, columns, routines, etc.. > Exactly. As I say I already have the java / sql statements to do this (although I have copy / pasted the values from the web page rather than grabbing them from the system), I just need to know where I should plant them, and how to test that I don't break anything in the process ;) ! There are a few other interesting 'beginner' problems on the issues page that I may have a go at afterwards, for now I have an itch I want to scratch! David. On Thu, Aug 30, 2012 at 2:53 PM, Rick Hillegas <[email protected]> wrote: > Hi David, > > Welcome to Derby development! A couple comments inline... > > > On 8/29/12 4:38 PM, david myers wrote: >> >> Hello all, >> >> This is my first post, and my first try at 'contributing' to a project... >> >> I've come across an issue with 'keywords' in derby. Bear in mind the >> functionality as it currently stands does exactly what I would expect (and >> as is described in the docs, as far as I can tell!). >> >> My issue relates to 2 that are currently on jira >> https://issues.apache.org/jira/browse/DERBY-2245 >> https://issues.apache.org/jira/browse/DERBY-3256 >> >> Bryan Pendleton made a comment on Derby2245 >> >> https://issues.apache.org/jira/browse/DERBY-2245?focusedCommentId=12539961&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-12539961 >> >> Which encompasses my expectations exactly. > > Thanks for listing these related JIRAs. This is very helpful for framing the > discussion. > >> >> Background. >> I'm converting (albeit slowly) a number of MS Access DB's to derbyDB. I >> came across the problem that MS Access seems not to care about SQL keywords >> as names for tables or columns! >> I was unable to find a 'neat' solution to test names against all the >> keywords that are reserved by Derby (so as I could then simply prepend the >> name of the table to the field). >> I did some searching and found the following page. >> http://db.apache.org/derby/javadoc/language/sqlgrammar.html >> This has 2 functions (or I assume they are functions or static variables) >> in it: reservedKeyword and nonReservedKeyword > > Is it fair to say that you want to give users a programmatic way to list out > all of the Derby keywords, reserved and non-reserved, regardless of whether > they are keywords in the 2003 rev of the SQL Standard? The point of > producing this list is to help developers and IDEs avoid using these words > as names of tables, columns, routines, etc.. > > Thanks, > -Rick >
