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
        Karl Wright added a comment -

        r1130577.

        Show
        Karl Wright added a comment - r1130577.

          People

          • Assignee:
            Karl Wright
            Reporter:
            Karl Wright
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development