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

Panic on ansi join with document keys when inside correlated subquery

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      Identified by Sitaram while investigating MB-53372:

      EXPLAIN SELECT  (SELECT RAW 1
      		 
               FROM  x AS l
      		 
               JOIN default AS r ON meta(r).id = "1")[0] AS d
      		 
      FROM [1] AS x ;

      Causes panic in Elixir.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-53372 UDF fails with error "No secondary index available for keyspace r in correlated subquery"

          • Major - Major loss of function.
          • Resolved
          mentioned in

          Page Loading...

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

          Activity

            Ascending order - Click to sort in descending order
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.2.0-1831 contains query commit 0faaadf with commit message:
            MB-53377 Proper set up of join keys when converting from ANSI join to lookup join

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-1831 contains query commit 0faaadf with commit message: MB-53377 Proper set up of join keys when converting from ANSI join to lookup join
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-8.0.0-1081 contains query commit 0faaadf with commit message:
            MB-53377 Proper set up of join keys when converting from ANSI join to lookup join

            build-team Couchbase Build Team added a comment - Build couchbase-server-8.0.0-1081 contains query commit 0faaadf with commit message: MB-53377 Proper set up of join keys when converting from ANSI join to lookup join
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.1.2-3420 contains query commit 2d179b2 with commit message:
            MB-53377 Proper set up of join keys when converting from ANSI join to lookup join

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.2-3420 contains query commit 2d179b2 with commit message: MB-53377 Proper set up of join keys when converting from ANSI join to lookup join
            ajay.bhullar Ajay Bhullar added a comment - - edited

            verified in 7.1.2-3420 using the following test cases

            EXPLAIN SELECT (SELECT RAW 1
            FROM x AS l
            JOIN default AS r ON meta(r).id = "1")[0] AS d
            FROM [1] AS x ;

            CREATE OR REPLACE FUNCTION udf1()

            {( SELECT (SELECT RAW 1 FROM x AS l JOIN default AS r ON meta(r).id = "1")[0] AS d FROM [1] AS x )}

            ;

            execute function udf1()

            CREATE OR REPLACE FUNCTION udf1(param)

            {( SELECT (SELECT RAW 1 FROM param AS l JOIN default AS r ON meta(r).id = "1")[0] AS d)}

            ;

            execute function udf1([1])

            no panic is observed in 7.1.2

            ajay.bhullar Ajay Bhullar added a comment - - edited verified in 7.1.2-3420 using the following test cases EXPLAIN SELECT (SELECT RAW 1 FROM x AS l JOIN default AS r ON meta(r).id = "1") [0] AS d FROM [1] AS x ; CREATE OR REPLACE FUNCTION udf1() {( SELECT (SELECT RAW 1 FROM x AS l JOIN default AS r ON meta(r).id = "1")[0] AS d FROM [1] AS x )} ; execute function udf1() CREATE OR REPLACE FUNCTION udf1(param) {( SELECT (SELECT RAW 1 FROM param AS l JOIN default AS r ON meta(r).id = "1")[0] AS d)} ; execute function udf1( [1] ) no panic is observed in 7.1.2
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.2.0-5000 contains query commit 2d179b2 with commit message:
            MB-53377 Proper set up of join keys when converting from ANSI join to lookup join

            build-team Couchbase Build Team added a comment - Build couchbase-server-7.2.0-5000 contains query commit 2d179b2 with commit message: MB-53377 Proper set up of join keys when converting from ANSI join to lookup join

            People

              ajay.bhullar Ajay Bhullar
              bingjie.miao Bingjie Miao
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty