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

[BP to 7.2.0 MB-54495] ORDER BY after UNION requires explicitly aliased terms

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.2.0
    • 7.2.0
    • query
    • Security Level: Public
    • Untriaged
    • 0
    • Unknown

    Description

       

      upsert into default.s1.c1 values("k0",{"a":1,"b":1}),("k1",{"a":3,"b":3});
      upsert into default.s1.c2 values("k0",{"a":2,"b":2}),("k1",{"a":4,"b":4});
      (SELECT a, b FROM default.s1.c1)
      UNION
      (SELECT a, b FROM default.s1.c2)
      ORDER BY b
      ;
      

      Should produce ordered results but doesn't.

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty