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.

        Activity

        Hide
        kwright@metacarta.com Karl Wright added a comment -

        r1130577.

        Show
        kwright@metacarta.com Karl Wright added a comment - r1130577.

          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:

              Development