Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.2, 7.6.1
-
Untriaged
-
0
-
Yes
Description
UPSERT INTO default VALUES("k01", {"cid": "c01", "status":"active", "pid": "p01"});
|
CREATE INDEX ix11 ON default(cid, status, pid);
|
SELECT a.*
|
FROM default AS a
|
LEFT JOIN (SELECT b.pid, COUNT(1) AS cnt
|
FROM default AS b
|
WHERE b.cid > "c01" AND b.status IN ['active']
|
GROUP BY b.pid) AS m USE NL
|
ON m.pid = a.cid
|
WHERE a.cid IS NOT NULL;
|
"errors": [
|
{
|
"code": 5370,
|
"msg": "Unable to run subquery - cause: Nested aggregates are not allowed."
|
},
|
{
|
"code": 5010,
|
"msg": "Error evaluating ExpressionScan",
|
"reason": {
|
"_level": "exception",
|
"caller": "context:1154",
|
"code": 5370,
|
"icause": "Nested aggregates are not allowed.",
|
"key": "execution.subquery.build",
|
"message": "Unable to run subquery"
|
}
|
}
|
],
|
Hash JOIN works