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

Common table expression, simple case

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • query

    Description

      Implement common table expression:

      WITH variable AS (
      <select or expression>
      ) SELECT .... FROM variable ....

      Currently we have a similar feature with the LET clause, but LET is dependent on the FROM clause (ie you can only have a LET variable after FROM), and you cannot have the FROM clause depend on the variable. CTE bridges this gap.

      Attachments

        Issue Links

          Activity

            People

              mihir.kamdar Mihir Kamdar (Inactive)
              marco.greco Marco Greco (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty