Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-205

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

    Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              kwright@metacarta.com Karl Wright
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: