You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2011/06/02 15:33:47 UTC
[jira] [Created] (CONNECTORS-205) Database DISTINCT ON abstraction
needs to include ordering information in order to work for HSQLDB
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
[jira] [Resolved] (CONNECTORS-205) Database DISTINCT ON abstraction
needs to include ordering information in order to work for HSQLDB
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-205.
------------------------------------
Resolution: Fixed
Fix Version/s: ManifoldCF 0.3
Assignee: Karl Wright
r1130577.
> 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
> Assignee: Karl Wright
> Fix For: ManifoldCF 0.3
>
>
> 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