# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

# Regression test for https://github.com/MaterializeInc/database-issues/issues/2799
mode cockroach

statement ok
create table t1(f1 int, f2 int);

query T multiline
EXPLAIN OPTIMIZED PLAN WITH(humanized expressions, arity, join implementations) AS VERBOSE TEXT FOR SELECT * FROM t1 WHERE 1 in (SELECT 1 FROM (VALUES (0)) CONSTANT WHERE f1 > 1);
----
Explained Query:
  Project (#0{f1}, #1{f2}) // { arity: 2 }
    Join on=(#0{f1} = #2{f1}) type=differential // { arity: 3 }
      implementation
        %1[#0]UKA » %0:t1[#0]K
      ArrangeBy keys=[[#0{f1}]] // { arity: 2 }
        ReadStorage materialize.public.t1 // { arity: 2 }
      ArrangeBy keys=[[#0{f1}]] // { arity: 1 }
        Distinct project=[#0{f1}] // { arity: 1 }
          Project (#0{f1}) // { arity: 1 }
            Filter (#0{f1} > 1) // { arity: 2 }
              ReadStorage materialize.public.t1 // { arity: 2 }

Source materialize.public.t1

Target cluster: quickstart

EOF


query T multiline
EXPLAIN OPTIMIZED PLAN WITH(humanized expressions, arity, join implementations) AS VERBOSE TEXT FOR SELECT jsonb_array_elements('[1,2,3]'::jsonb);
----
Explained Query (fast path):
  Constant
    - (1)
    - (2)
    - (3)

Target cluster: quickstart

EOF