[OPENJPA-2207] Problems with numeric column name

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0, 2.2.0
• Fix Version/s: 1.2.3
• Assignee: Dianne E. Richards
• Reporter: Dianne E. Richards
• Created: 04/Jun/12 16:52
• Updated: 10/Apr/13 21:05

Description

When a numeric column name is specified with a single number (ex: "1"), incorrect sql is generated. The sql is supposed to have a single set of double quotes around the name. Different incorrect sql is generated, depending on the release. For JPA 1.0 releases, there are no quotes (ex: 1). For JPA 2.0 releases, there are 2 sets of double quotes (ex: ""1""). This problem appears to exist for other DB identifiers also.