Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.0, 7.2.3
-
Untriaged
-
0
-
Unknown
Description
Identified while investigating MB-59078.
UPSERT INTO default (KEY k, VALUE v) SELECT "k00"||TO_STR(d) AS k, {"c1":d, "c2":d, "c3":d} AS v FROM ARRAY_RANGE(1,10) AS d;
|
CREATE INDEX ix1 ON default(c1,c2, c3);
|
|
|
CREATE OR REPLACE FUNCTION f11(data) {
|
( SELECT l, r
|
FROM default AS l
|
JOIN (SELECT default.* FROM default WHERE c1 > 0) AS r USE NL ON l.c3=r.c3
|
WHERE l.c1 > 0 AND r.c2 = data
|
)
|
};
|
|
|
SELECT f11(t.c1) FROM default AS t WHERE t.c1 > 0;
|
|
|
CREATE OR REPLACE FUNCTION f12(data) {
|
( SELECT l, r
|
FROM default AS l
|
JOIN data AS r USE NL ON l.c3=r.c3
|
WHERE l.c1 > 0
|
)
|
};
|
|
|
SELECT f12(t) FROM default AS t WHERE t.c1 > 0;
|
|
Attachments
Issue Links
- depends on
-
-
- Closed
-
- is a backport of
-
-
- Closed
-
- relates to
-
-
- Closed
-