[ASTERIXDB-3328] Avoid removing cross-products in external data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.9
• Fix Version/s: 0.9.9
• Component/s: COMP - Compiler
• Labels: triaged
• Assignee: Wail Y. Alkowaileet
• Reporter: Wail Y. Alkowaileet
• Created: 05/Dec/23 20:47
• Updated: 05/Jan/24 21:26
• Resolved: 05/Jan/24 21:26

Description

Query

SELECT COUNT(*)
FROM ExtOrders o1, ExtOrders o2, ExtOrders o3  

Plan:

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| 

The plan is clearly incorrect and the joins should not be removed