[
https://issues.apache.org/jira/browse/ASTERIXDB-3522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peeyush Gupta updated ASTERIXDB-3522:
-------------------------------------
Description:
Following query when run with cbo generates an invalid sample query
{noformat}
{
"t1": [1, 2, 3][int32("0")],
"t2": [1, 2, 3][double("0")],
"t3": [1, 2, 3][[0, 1][0]],
"t4": [1, 2, 3][(select value 2)[0]],
"t5": [1, 2, 3][(select value id from test where id = 1)[0]]
};{noformat}
Invalid initial sample query plan
{noformat}
distribute result [$$40] -- |UNPARTITIONED|
aggregate [$$40] <- [agg-count(true)] -- |UNPARTITIONED|
select (eq($$39, 1)) -- |UNPARTITIONED|
aggregate [$$36] <- [listify($$39)] -- |UNPARTITIONED|
select (true) -- |PARTITIONED|
data-scan []<-[$$39, $$test] <- test.test.sample_idx_1_test --
|PARTITIONED|
empty-tuple-source -- |PARTITIONED|{noformat}
was:
Following query when run with cbo generates an invalid sample query
{noformat}
{
"t1": [1, 2, 3][int32("0")],
"t2": [1, 2, 3][double("0")],
"t3": [1, 2, 3][[0, 1][0]],
"t4": [1, 2, 3][(select value 2)[0]],
"t5": [1, 2, 3][(select value id from test where id = 1)[0]]
};{noformat}
Invalid initial sample query plan
{{}}
{noformat}
distribute result [$$40] -- |UNPARTITIONED|
aggregate [$$40] <- [agg-count(true)] -- |UNPARTITIONED|
select (eq($$39, 1)) -- |UNPARTITIONED|
aggregate [$$36] <- [listify($$39)] -- |UNPARTITIONED|
select (true) -- |PARTITIONED|
data-scan []<-[$$39, $$test] <- test.test.sample_idx_1_test --
|PARTITIONED|
empty-tuple-source -- |PARTITIONED|{noformat}
{{}}
> Invalid sample query generated
> ------------------------------
>
> Key: ASTERIXDB-3522
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3522
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Peeyush Gupta
> Priority: Major
>
> Following query when run with cbo generates an invalid sample query
>
> {noformat}
> {
> "t1": [1, 2, 3][int32("0")],
> "t2": [1, 2, 3][double("0")],
> "t3": [1, 2, 3][[0, 1][0]],
> "t4": [1, 2, 3][(select value 2)[0]],
> "t5": [1, 2, 3][(select value id from test where id = 1)[0]]
> };{noformat}
> Invalid initial sample query plan
> {noformat}
> distribute result [$$40] -- |UNPARTITIONED|
> aggregate [$$40] <- [agg-count(true)] -- |UNPARTITIONED|
> select (eq($$39, 1)) -- |UNPARTITIONED|
> aggregate [$$36] <- [listify($$39)] -- |UNPARTITIONED|
> select (true) -- |PARTITIONED|
> data-scan []<-[$$39, $$test] <- test.test.sample_idx_1_test --
> |PARTITIONED|
> empty-tuple-source -- |PARTITIONED|{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
