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

DISTINCT on column is should give syntax error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 7.1.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      select c1, c2, DISTINCT c3 from default USE KEYS ["1","2"];

      Above statement gives syntax error. Not Below.

      select c1, c2, (DISTINCT c3) from default USE KEYS ["1","2"];

      DISTINCT on all projection is possible. Not sure what is meaning on DISTINCT on single column of multi column projection (It should return error too).

      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:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty