Details
-
Bug
-
Resolution: Duplicate
-
Major
-
7.6.0, 7.1.4, 7.2.1, 7.1.5
-
Untriaged
-
0
-
Unknown
Description
UPSERT INTO default VALUES("k01", {"cid": "c01", "status":"active", "pid": "p01"});
|
CREATE INDEX ix1 ON default(cid, status, pid);
|
CREATE OR REPLACE FUNCTION udf1(pObj, pcustId) {(
|
WITH pm as ( Select * from OBJECT_INNER_PAIRS(pObj) as m)
|
SELECT pid, count(1) AS numRows
|
FROM default
|
WHERE cid = pcustId AND status IN ['active']
|
GROUP BY pid
|
)};
|
SELECT a.* FROM udf1({"xx":"xx"}, "c01") AS a;
|
prepare p2 from SELECT a.* FROM udf1({"xx":"xx"}, "c07") AS a;
|
prepare p3 from SELECT a.* FROM udf1({"xx":"xx"}, "c01") AS a;
|
execute p3;
|
execute p2;
|
execute p3;
|
execute p2;
|
execute p3;
|
execute p2;
|
Note: multiple prepare statements alternative execution. This intermittent. repeat pattern of execution in loop