[#DERBY-139] LOCAL as a reserved keyword does not match other databases

Derby

LOCAL as a reserved keyword does not match other databases

Created: 09/Feb/05 10:10 AM Updated: 04/Jun/05 03:07 PM

Return to search

Component/s:

SQL

Affects Version/s:

10.0.2.1

Fix Version/s:

10.0.2.2, 10.1.1.0

Time Tracking:

Not Specified

Resolution Date:

10/Feb/05 09:48 AM

Description

« Hide

While the SQL standard mandates LOCAL as a reserved keyword, most other databases such as Oracle, SQL Server, MySQL and DB2 do not enforce it.
Derby enforces this and limits application migration to Derby.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

[ Permlink | « Hide ]

Daniel John Debrunner added a comment - 10/Feb/05 04:42 AM

Fixed in the trunk
New Revision: 153095

URL: http://svn.apache.org/viewcvs?view=rev&rev=153095
Log:
Fix Derby-139 - remove LOCAL as a SQL reserved word.

Modified:
    incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/identifier.sql

[ Permlink | « Hide ]

Daniel John Debrunner added a comment - 10/Feb/05 09:47 AM

Merged to 10.0 branch as 153138.

Daniel John Debrunner made changes - 10/Feb/05 09:48 AM

Field	Original Value	New Value
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		10.1.0.0 [ 10993 ]

Andrew McIntyre made changes - 04/Jun/05 03:07 PM

Status

Resolved [ 5 ]

Closed [ 6 ]