github-5536.slt

# 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 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, #1, #3, #2)
    Filter (((integer_to_numeric(#5) <= 0.15850659265367217) AND (integer_to_real(#5) >= #2))) IS NOT NULL
      Map (-(#4))
        CrossJoin type=delta
          ArrangeBy keys=[[]]
            Project ()
              ReadStorage materialize.public.t0
          ArrangeBy keys=[[]]
            Project ()
              Filter (#0 <= #0) AND (#0 >= #0)
                ReadStorage materialize.public.t5
          ArrangeBy keys=[[]]
            Filter (#1 = text_to_char(text_to_varchar(boolean_to_text(like["0.31161855206970124"](padchar(#1))))))
              ReadStorage materialize.public.t3
          ArrangeBy keys=[[]]
            ReadStorage materialize.public.t5

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

Target cluster: quickstart

EOF