Loading...

XML

Word

Printable

CREATE OR REPLACE FUNCTION `FN_Test_Bad3` (data) LANGUAGE INLINE AS ( ( SELECT RAW (SELECT RAW data) ) ) ;

select a,test from [1,2,3] a let test = FN_Test_Bad3(a) ;

        "a": 1,

        "test": [

},

        "a": 2,

        "test": [

},

        "a": 3,

        "test": [

is a backport of

MB-57903 Deep nested correlation not properly detected and uses cached results

is triggering

MB-59541 [BP to 7.1.6-MP1 & 7.2.3-MP1]subquery cannot use nested CTE

relates to

MB-57904 correlation in CTE variables not detected

For Gerrit Dashboard: MB-59528
#	Subject	Branch	Project	Status	CR	V
200381,2	MB-59528 MB-59530 MB-59531 MB-59532 MB-59533 MB-59546: 7.1.6-MP1	7.1.x	query	Status: MERGED	+2	+1
200607,3	MB-59528 Keep track of correlation references	7.2.3	query	Status: MERGED	+2	+1

There are no open Gerrit changes

Hide There are 2 closed Gerrit changes

MB-59528 MB-59530 MB-59531 MB-59532 MB-59533 MB-59546: 7.1.6-MP1: Gerrit Review:

[BP to 7.1.6-MP1 & 7.2.3-MP1] Deep nested correlation not properly detected and uses cached results