db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4268) "SECURITY" is reserved as SQL keyword.
Date Tue, 16 Jun 2009 16:17:07 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden updated DERBY-4268:
----------------------------------

       Derby Info: [Regression]  (was: [Regression, Patch Available])
    Fix Version/s: 10.6.0.0

Hi Lily, I committed your patch  for this issue:
Date: Tue Jun 16 16:01:58 2009
New Revision: 785271

URL: http://svn.apache.org/viewvc?rev=785271&view=rev
Log:
DERBY-4268 "SECURITY" is reserved as SQL keyword.
Made security unreserved and added a regression test.

Contributed by Lily Wei (lilywei at yahoo dot com)

The replication tests passed for me with your patch, so I do think that failure was unrelated.

Please keep an eye on the regression tests for any issues.

Would you be willing to test this on 10.5?  It would be great to get it in for the upcoming
10.5.2 release.  Instructions for backporting are at http://wiki.apache.org/db-derby/MoveAChangeBetweenBranches

I am also interested in porting it all the way back to 10.2 where the regression was introduced.
I can take care of this unless you are particularly interested in setting up all those workspaces
and dealing with getting your environment setup to handle all the old releases. 

Thanks again for the contribution.

> "SECURITY" is reserved as SQL keyword.
> --------------------------------------
>
>                 Key: DERBY-4268
>                 URL: https://issues.apache.org/jira/browse/DERBY-4268
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Kan Ogawa
>            Assignee: Lily Wei
>            Priority: Blocker
>             Fix For: 10.6.0.0
>
>         Attachments: derby-4268-diff.txt, derby-4268-diff.txt, error-stacktrace-ReplicationRun_Local.out,
error-stacktrace-ReplicationRun_Local_StateTest_part1.out
>
>
> The word "SECURITY" is NOT described in SQL reserved words section of Derby Reference
Manual.
> I think that it should be able to use this word without quotes in SQL statement.

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