# 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 database-issues#5536.

statement ok
CREATE TABLE t0(c0 FLOAT  DEFAULT (-1.77794611E9));

statement ok
CREATE TABLE t3(c0 smallint , c1 CHAR(111) , c2 REAL , c3 FLOAT );

statement ok
CREATE TABLE t5(c0 INT );

statement ok
CREATE VIEW v0(c0) AS (SELECT ALL (0.31161855206970124)::VARCHAR FROM t5 WHERE (t5.c0) BETWEEN (t5.c0) AND (t5.c0));

query T multiline
EXPLAIN OPTIMIZED PLAN WITH (humanized expressions) AS VERBOSE TEXT FOR SELECT
  t3.c0, t3.c1, t3.c3, t3.c2
FROM
  t0,
  v0
  FULL OUTER JOIN t3 ON (((-6.2850675E8)>(0.56364256))) IS FALSE
  RIGHT OUTER JOIN t5 ON ((- (t5.c0)) BETWEEN (t3.c2) AND (0.15850659265367217)) IS NOT UNKNOWN
WHERE (t3.c1) IN (CAST(((t3.c1)LIKE(v0.c0)) AS VARCHAR));
----
Explained Query:
  Project (#0{c0}, #1{c1}, #3{c3}, #2{c2})
    Filter (((integer_to_numeric(#5) <= 0.15850659265367217) AND (integer_to_real(#5) >= #2{c2}))) IS NOT NULL
      Map (-(#4{c0}))
        CrossJoin type=delta
          ArrangeBy keys=[[]]
            Project ()
              ReadStorage materialize.public.t0
          ArrangeBy keys=[[]]
            Project ()
              Filter (#0{c0} <= #0{c0}) AND (#0{c0} >= #0{c0})
                ReadStorage materialize.public.t5
          ArrangeBy keys=[[]]
            Filter (#1{c1} = text_to_char[len=unbounded](text_to_varchar[len=unbounded](boolean_to_text(like["0.31161855206970124"](padchar(#1{c1}))))))
              ReadStorage materialize.public.t3
          ArrangeBy keys=[[]]
            ReadStorage materialize.public.t5

Source materialize.public.t0
Source materialize.public.t3
  filter=((#1{c1} = text_to_char[len=unbounded](text_to_varchar[len=unbounded](boolean_to_text(like["0.31161855206970124"](padchar(#1{c1})))))))
Source materialize.public.t5

Target cluster: quickstart

EOF