Peeyush Gupta created ASTERIXDB-3490:
----------------------------------------
Summary: Could not modify UNORDERED_PARTITIONED exception on query
compilation
Key: ASTERIXDB-3490
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3490
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Peeyush Gupta
The following query fails compilation
{noformat}
SELECT *
FROM collection1 a1
WHERE (
SELECT value count(*)
FROM collection2 a2
WHERE a1.t=a2.t and a1.p=3 and (
SELECT value count(*)
FROM collection3 a3
WHERE a2.t1=a3.t1 and a2.p1=3 and (
SELECT value count(*)
FROM collection4 a4
WHERE a3.t2=a4.t2 and a3.p2=3 and (
SELECT value count(*)
FROM collection5 a5
WHERE a4.t=a5.t and a4.p=3 and (
SELECT value count(*)
FROM collection6 a6
WHERE a5.t1=a6.t1 and a5.p1=3
)[0] >= 1
)[0] >= 1
)[0] >= 1
)[0] >= 1
)[0] >= 1;{noformat}
With exception
{noformat}
Could not modify UNORDERED_PARTITIONED{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
