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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.0.2.2, 10.1.1.0
• Component/s: SQL
• Assignee: Daniel John Debrunner
• Reporter: Daniel John Debrunner
• Created: 09/Feb/05 10:10
• Updated: 04/Jun/05 15:07
• Resolved: 10/Feb/05 09:48

Description

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.