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

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

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