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

Panic with recursive CTE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Major
    • None
    • None
    • query
    • None
    • Untriaged
    • 0
    • Unknown

    Description

       

      2024-02-06T10:38:51.193 Q S request text: <ud>WITH RECURSIVE rcte AS (SELECT * FROM default UNION SELECT * FROM rcte) SELECT * FROM default LEFT OUTER JOIN rcte ON true;</ud>
      2024-02-06T10:38:51.193 Q S query context: <ud></ud>
      2024-02-06T10:38:51.193 Q S stack: goroutine 22450 [running]:
      github.com/couchbase/query/server.(*Server).serviceRequest.func1()
              /home/dhaggart/code/src/github.com/couchbase/query/server/server.go:1242 +0x8c
      panic({0x2d184e0?, 0x4f0f400?})
              /usr/lib/go-1.21.1/src/runtime/panic.go:914 +0x21f
      github.com/couchbase/query/planner.ClassifyExprKeyspace({0x0, 0x0}, 0xc0020416b0, 0xc0020417a0, {0xc0022a4930, 0x4}, 0x1, 0x1, 0x0, 0xc000722870)
              /home/dhaggart/code/src/github.com/couchbase/query/planner/expr_classifier.go:47 +0xef
      github.com/couchbase/query/planner.(*builder).AddOuterOnclause(0xc000984dc0, {0x0, 0x0}, {0xc0022a4930, 0x4}, 0xc000722870?, 0xc001901c80?)
              /home/dhaggart/code/src/github.com/couchbase/query/planner/optimizer.go:79 +0xce
      github.com/couchbase/query-ee/optimizer.(*optimizer).getBaseLevel(0xc0007227e0, {0x39e24c0, 0xc00198a480})
              /home/dhaggart/code/src/github.com/couchbase/query-ee/optimizer/join_enumerate.go:200 +0x6a2
      github.com/couchbase/query-ee/optimizer.(*optimizer).enumerateJoins(0xc0007227e0, {0x39e24c0?, 0xc00198a480?})
              /home/dhaggart/code/src/github.com/couchbase/query-ee/optimizer/join_enumerate.go:30 +0x3a
      github.com/couchbase/query-ee/optimizer.(*optimizer).OptimizeQueryBlock(0xc0007227e0, {0x3a0b0a0, 0xc000984dc0}, {0x39e24c0, 0xc00198a480}, {0x0?, 0x0}, {0x0?, 0x0}, 0x0, ...)
              /home/dhaggart/code/src/github.com/couchbase/query-ee/optimizer/optimizer.go:123 +0x6b6
      ...
      

       

      Attachments

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

        Activity

          People

            Donald.haggart Donald Haggart
            Donald.haggart Donald Haggart
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty