[CONNECTORS-205] Database DISTINCT ON abstraction needs to include ordering information in order to work for HSQLDB

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: ManifoldCF 0.3
• Component/s: Framework core, Framework crawler agent
• Assignee: Karl Wright
• Reporter: Karl Wright
• Created: 02/Jun/11 13:33
• Updated: 02/Jun/11 14:39
• Resolved: 02/Jun/11 14:39

Description

The constructDistinctOnClause database method cannot support HSQLDB because it presumes that the ORDER BY clause is already part of the base query. This blocks us from using the HSQLDB WITH/LATERAL temporary table solution for the functionality.

Adding ORDER BY information to the abstraction should work for all databases.