Details
-
Bug
-
Resolution: Not a Bug
-
Major
-
6.5.0
-
Untriaged
-
No
Description
Build : 6.5.0-3633
On a 1-node cluster having kv+index+query services, with beer-sample bucket installed, run the following queries.
create function getnames(typevar, lim) language inline as (select raw name from `beer-sample` where `type`=typevar limit lim)
select * from `beer-sample` where name in (getnames("beer",1)) --> returns in 4m5s
Now run its equivalent query with subquery:
select * from `beer-sample` a where a.name in (select raw (b.`name`) from `beer-sample` b where ((b.`type`) = $typevar) limit $lim) -> returns in 860ms