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

[BP to 7.1.6-MP1 & 7.2.3-MP1]USE hints will be lost in UDF/prepare that has subquery sent to another node

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Unknown

    Description

       

      UPSERT INTO default (KEY k, VALUE v) SELECT "k00"||TO_STR(d) AS k, {"c1":d, "c2":d, "c3":d} AS v FROM ARRAY_RANGE(1,10) AS d;
      		 
      CREATE INDEX ix1 ON default(c1,c2, c3);
      		 
      CREATE OR REPLACE FUNCTION f11() {
      		 
      ( SELECT l, r
      		 
      FROM default AS l
      		 
      JOIN default AS r USE HASH (BUILD) ON l.c3=r.c3
      		 
      WHERE l.c1 > 0 AND r.c1 > 0 AND r.c2 = 1
      		 
      )
      		 
      };

      UDF texts are prepared from  expression.

      If there are hints or optimizer texts those will be lost and no way provide hint.

      May be use text vs expression.

       

      Attachments

        Issue Links

          is a backport of

          Bug - A problem which impairs or prevents the functions of the product. MB-59078 USE hints will be lost in UDF/prepare that has subquery sent to another node

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MB-59540 [BP to 7.1.6-MP1 & 7.2.3-MP1]ExpressionScan incorrectly use cached result if inside UDF

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MB-59543 [BP to 7.1.6.MP1 & 7.2.3.MP1]UDF text is incorrect when directives are used in the body

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              Sitaram.Vemulapalli Sitaram Vemulapalli
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty