Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-21869

Relax ORDER BY Ambiguity check for SET-Operators

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • feature-backlog
    • 4.6.0
    • query
    • None

    Description

      Relax checking for set-operators ORDER BY

      select q1.* from default q1 UNION ALL select q2.* from default  q2 ORDER BY a;
      {
          "requestID": "959878f2-c038-4b9a-9e60-8c5361ab1001",
          "errors": [
              {
                  "code": 3000,
                  "msg": "Ambiguous reference to field a."
              }
          ],
          "status": "fatal",
          "metrics": {
              "elapsedTime": "706.904µs",
              "executionTime": "683.289µs",
              "resultCount": 0,
              "resultSize": 0,
              "errorCount": 1
          }
      }
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            keshav Keshav Murthy
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty