[CAY-1506] Reserverd words mapping in WHERE clause

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0.2
• Component/s: Core Library
• Environment: Cayenne 3.0 + MSSQLServer (running in an OSGi environment)
• Assignee: Olga Tkacheva
• Reporter: Lautaro Brasseur
• Created: 11/Nov/10 14:58
• Updated: 18/Feb/11 14:32
• Resolved: 10/Jan/11 10:50

Description

I need to map a database schema which has reserverd words in column names. For example, the USER table has a column called GROUP.

I solved partially the problem, by setting Cayenne to quote identifiers:

DataMap dataMap = new DataMap(DUMMY_NAME);
dataMap.setQuotingSQLIdentifiers(true);

but this just quotes columns in the SELECT section. This generated query fails:

SELECT [t0].[NAME], [t0].[GROUP], [t0].[ID] FROM [USER] [t0] WHERE t0.GROUP = ? [bind: 1->GROUP:29]

because the GROUP column is used in the WHERE clause and it is not quoted.

Issue Links

• is duplicated by: CAY-1541 Qualifier clause does not quote identifiers