Database DISTINCT ON abstraction needs to include ordering information in order 
to work for HSQLDB
--------------------------------------------------------------------------------------------------

                 Key: CONNECTORS-205
                 URL: https://issues.apache.org/jira/browse/CONNECTORS-205
             Project: ManifoldCF
          Issue Type: Bug
          Components: Framework core, Framework crawler agent
            Reporter: Karl Wright


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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to