asterixdb/asterix-app/src/test/resources/optimizerts/results/any-and-every-2.plan

distribute result [$$42]
-- DISTRIBUTE_RESULT  |PARTITIONED|
  exchange
  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
    project ([$$42])
    -- STREAM_PROJECT  |PARTITIONED|
      assign [$$42] <- [{"D": $$D}]
      -- ASSIGN  |PARTITIONED|
        project ([$$D])
        -- STREAM_PROJECT  |PARTITIONED|
          select (and($$38, eq($$39, 0)))
          -- STREAM_SELECT  |PARTITIONED|
            project ([$$D, $$38, $$39])
            -- STREAM_PROJECT  |PARTITIONED|
              subplan {
                        aggregate [$$38, $$39] <- [non-empty-stream(), agg-sql-count(switch-case(and($$35, eq($$36, 0)), true, null, true))]
                        -- AGGREGATE  |LOCAL|
                          subplan {
                                    aggregate [$$35, $$36] <- [non-empty-stream(), agg-sql-count(switch-case(eq($$J, 1), true, null, true))]
                                    -- AGGREGATE  |LOCAL|
                                      unnest $$J <- scan-collection($$45)
                                      -- UNNEST  |LOCAL|
                                        nested tuple source
                                        -- NESTED_TUPLE_SOURCE  |LOCAL|
                                 }
                          -- SUBPLAN  |LOCAL|
                            assign [$$45] <- [$$I.getField("items")]
                            -- ASSIGN  |LOCAL|
                              unnest $$I <- scan-collection($$44)
                              -- UNNEST  |LOCAL|
                                nested tuple source
                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                     }
              -- SUBPLAN  |PARTITIONED|
                assign [$$44] <- [$$D.getField("items")]
                -- ASSIGN  |PARTITIONED|
                  project ([$$D])
                  -- STREAM_PROJECT  |PARTITIONED|
                    exchange
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      data-scan []<-[$$43, $$D] <- TestDataverse.Dataset1
                      -- DATASOURCE_SCAN  |PARTITIONED|
                        exchange
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          empty-tuple-source
                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|