[JCR-2996] QOM to SQL2 doesn't cast numeric literals

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.2.8
• Component/s: jackrabbit-jcr-commons
• Assignee: Thomas Mueller
• Reporter: Thomas Mueller
• Created: 20/Jun/11 09:24
• Updated: 23/Sep/11 08:51
• Resolved: 20/Jun/11 14:09

Description

SQL2 statements generated by the QueryObjectModel.getStatement() don't contain CAST(... AS ...) for numeric literals of types DECIMAL, DOUBLE, and LONG. The type information is lost, which can result in incorrect query results (depending on the query engine) if the generated SQL2 statement is executed.