Loading...

XML

Word

Printable

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.

is a backport of

MB-48954 select executing a function executing a select returns the same results

For Gerrit Dashboard: MB-51447
#	Subject	Branch	Project	Status	CR	V
164250,3	MB-51447 select calling udf executing a select mistakenly marks subselect as not correlated	cheshire-cat	query	Status: MERGED	+2	+1

There are no open Gerrit changes

Hide There is 1 closed Gerrit change

MB-51447 select calling udf executing a select mistakenly marks subselect as not correlated: Gerrit Review:

[BP to 7.0.4] select executing a function executing a select returns the same results