gistfile1.txt

CREATE TABLE table2 (col2_0 INTERVAL);

CREATE TABLE table3 (
  col3_0 REGNAMESPACE, col3_1 FLOAT8, col3_2 DATE, i INT8,
  INDEX (col3_1 ASC, col3_2 ASC, col3_0) PARTITION BY LIST (col3_1, col3_2) (
                                                                              PARTITION table3_part_5
                                                                                VALUES IN (
                                                                                  (
                                                                                    1.401298464324817e-45,
                                                                                    '1979-05-16'
                                                                                  )
                                                                                )
                                                                            )
);

CREATE TABLE table4 (
  col4_3 NAME, col4_15 REGTYPE,
  INDEX ((CASE WHEN col4_15 IS NULL THEN '/' ELSE e'!!\x0fL_\x7f^' END), col4_3 ASC)
);

CREATE TYPE rand_typ_1 AS ENUM ('cgy', 'qg', 'crngy', 'k');

INSERT INTO table3 (col3_0, col3_1, col3_2, i) VALUES (2466559136, 0, '1995-12-16', 1);

INSERT INTO table3 (col3_0, col3_1, col3_2, i) VALUES (0, 1.311674919719814, '1993-03-29', 0);

SELECT MIN(first) FROM (SELECT * FROM defaultdb.public.table3 AS tab_15580) tab_15580(first);

SELECT MIN(agg) FROM (SELECT MIN(first) AS agg FROM (SELECT * FROM defaultdb.public.table3 AS tab_15580 WHERE (NULL OR EXISTS (WITH with_387 (col_1057) AS (SELECT * FROM (VALUES ((NULL, 0:::OID))) AS tab_15581 (col_1057)), with_388 (col_1058) AS (SELECT * FROM (VALUES (0.2983944561166533:::FLOAT8), ((-0.7761676685224073):::FLOAT8), ((-2.0824722316068613):::FLOAT8), (NULL), ((-0.820130187622559):::FLOAT8), (0.5816144538486323:::FLOAT8)) AS tab_15582 (col_1058)) SELECT CASE WHEN true THEN e'0b\x19x\x10.h':::STRING:::NAME ELSE e'Ay\x13':::STRING:::NAME END AS col_1059, 'k':::rand_typ_1 AS col_1060 FROM defaultdb.public.table2 AS tab_15583 JOIN defaultdb.public.table2 AS tab_15584 ON (tab_15583.col2_0) = (tab_15584.col2_0), defaultdb.public.table4@table4_expr_col4_3_idx AS tab_15585, with_388 AS cte_ref_125))) tab_15580(first) UNION ALL SELECT MIN(first) AS agg FROM (SELECT * FROM defaultdb.public.table3 AS tab_15580 WHERE NOT ((NULL OR EXISTS (WITH with_387 (col_1057) AS (SELECT * FROM (VALUES ((NULL, 0:::OID))) AS tab_15581 (col_1057)), with_388 (col_1058) AS (SELECT * FROM (VALUES (0.2983944561166533:::FLOAT8), ((-0.7761676685224073):::FLOAT8), ((-2.0824722316068613):::FLOAT8), (NULL), ((-0.820130187622559):::FLOAT8), (0.5816144538486323:::FLOAT8)) AS tab_15582 (col_1058)) SELECT CASE WHEN true THEN e'0b\x19x\x10.h':::STRING:::NAME ELSE e'Ay\x13':::STRING:::NAME END AS col_1059, 'k':::rand_typ_1 AS col_1060 FROM defaultdb.public.table2 AS tab_15583 JOIN defaultdb.public.table2 AS tab_15584 ON (tab_15583.col2_0) = (tab_15584.col2_0), defaultdb.public.table4@table4_expr_col4_3_idx AS tab_15585, with_388 AS cte_ref_125)))) tab_15580(first) UNION ALL SELECT MIN(first) AS agg FROM (SELECT * FROM defaultdb.public.table3 AS tab_15580 WHERE ((NULL OR EXISTS (WITH with_387 (col_1057) AS (SELECT * FROM (VALUES ((NULL, 0:::OID))) AS tab_15581 (col_1057)), with_388 (col_1058) AS (SELECT * FROM (VALUES (0.2983944561166533:::FLOAT8), ((-0.7761676685224073):::FLOAT8), ((-2.0824722316068613):::FLOAT8), (NULL), ((-0.820130187622559):::FLOAT8), (0.5816144538486323:::FLOAT8)) AS tab_15582 (col_1058)) SELECT CASE WHEN true THEN e'0b\x19x\x10.h':::STRING:::NAME ELSE e'Ay\x13':::STRING:::NAME END AS col_1059, 'k':::rand_typ_1 AS col_1060 FROM defaultdb.public.table2 AS tab_15583 JOIN defaultdb.public.table2 AS tab_15584 ON (tab_15583.col2_0) = (tab_15584.col2_0), defaultdb.public.table4@table4_expr_col4_3_idx AS tab_15585, with_388 AS cte_ref_125))) IS NULL) tab_15580(first));