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

SQL++ in CBAS doesn't support UNION (and friends)

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.1.3
    • analytics
    • 0

    Description

      -- We should improve our coverage of SQL set operations sometime!

      USE TinySocial;

      SELECT VALUE user
      FROM GleambookUsers user
      WHERE user.id BETWEEN 1 AND 2
      UNION
      SELECT VALUE user
      FROM GleambookUsers user
      WHERE user.id BETWEEN 5 AND 6;

       

      ERROR: Code: 1 "ASX1079: Compilation error: Operation UNION with set semantics is not supported. (in line 3, at column 1)"

      Attachments

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

        Activity

          People

            vijay.sarathy Vijay Sarathy
            mike.carey Mike Carey
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty