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

select executing a function executing a select returns the same results

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      Testcase:

      create function l(...)

      { (select length(args[0]))[0] }

      select a.type, l(a.type) from `travel-sample` a

      the second statement returns 7 for all rows.

      This is due to the subquery code mistakenly caching the result.

      Attachments

        Issue Links

          backports to

          Bug - A problem which impairs or prevents the functions of the product. MB-51447 [BP to 7.0.4] select executing a function executing a select returns the same results

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          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
          For Gerrit Dashboard: MB-48954
          # Subject Branch Project Status CR V
          164074,2 MB-48954 select calling udf executing a select mistakenly marks subselect as not correlated master query Status: MERGED +2 +1

          Activity

            People

              ajay.bhullar Ajay Bhullar
              marco.greco Marco Greco (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty