Wail Y. Alkowaileet created ASTERIXDB-3328:
----------------------------------------------
Summary: Avoid removing cross-products in external data
Key: ASTERIXDB-3328
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3328
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Affects Versions: 0.9.9
Reporter: Wail Y. Alkowaileet
Assignee: Wail Y. Alkowaileet
Fix For: 0.9.9
Query
{noformat}
SELECT COUNT(*)
FROM ExtOrders o1, ExtOrders o2, ExtOrders o3 {noformat}
Plan:
{noformat}
distribute result [$$58] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- DISTRIBUTE_RESULT |UNPARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
project ([$$58]) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- STREAM_PROJECT |UNPARTITIONED|
assign [$$58] <- [{\"$1\": $$59}] [cardinality: 0.0, op-cost: 0.0,
total-cost: 0.0]
-- ASSIGN |UNPARTITIONED|
aggregate [$$59] <- [agg-sql-sum($$60)] [cardinality: 0.0, op-cost:
0.0, total-cost: 0.0]
-- AGGREGATE |UNPARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- RANDOM_MERGE_EXCHANGE |PARTITIONED|
aggregate [$$60] <- [agg-sql-count(1)] [cardinality: 0.0, op-cost:
0.0, total-cost: 0.0]
-- AGGREGATE |PARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$o3] <- ShopALot.ExtOrders [cardinality: 0.0,
op-cost: 0.0, total-cost: 0.0]
-- DATASOURCE_SCAN |PARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
empty-tuple-source [cardinality: 0.0, op-cost: 0.0,
total-cost: 0.0]
-- EMPTY_TUPLE_SOURCE |PARTITIONED| {noformat}
The plan is clearly incorrect and the joins should not be removed
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
