gistfile1.txt

CREATE TABLE table2 (col2_0 INTERVAL);

CREATE TABLE table3 (
  col3_0 REGNAMESPACE, col3_1 FLOAT8, col3_2 DATE,
  UNIQUE (col3_1),
  INDEX (col3_1 ASC, col3_2 ASC, col3_0) PARTITION BY LIST (col3_1, col3_2) (
                                                                              PARTITION table3_part_0
                                                                                VALUES IN (
                                                                                  (
                                                                                    -0.7728263562402948,
                                                                                    '1983-10-29'
                                                                                  ),
                                                                                  (
                                                                                    -0.933068593926297,
                                                                                    '1971-04-07'
                                                                                  ),
                                                                                  (
                                                                                    1.7976931348623157e+308,
                                                                                    '1974-10-22'
                                                                                  ),
                                                                                  (
                                                                                    1.4232974000754588,
                                                                                    '1984-11-16'
                                                                                  ),
                                                                                  (
                                                                                    -0.8981077083684328,
                                                                                    '1975-04-26':::DATE
                                                                                  )
                                                                                ),
                                                                              PARTITION table3_part_1
                                                                                VALUES IN (
                                                                                  (
                                                                                    0.047871204448347165,
                                                                                    '1989-09-21'
                                                                                  ),
                                                                                  (
                                                                                    -0.23724931492000578,
                                                                                    '1976-10-15'
                                                                                  ),
                                                                                  (
                                                                                    0.21732315137849378,
                                                                                    '1978-07-23'
                                                                                  ),
                                                                                  (
                                                                                    -0.19290738509867467,
                                                                                    '1991-12-19'
                                                                                  ),
                                                                                  (
                                                                                    0.8603604195674025,
                                                                                    '1973-10-19'
                                                                                  )
                                                                                ),
                                                                              PARTITION table3_part_2
                                                                                VALUES IN (
                                                                                  (
                                                                                    -0.954228660338193,
                                                                                    '1978-08-27'
                                                                                  ),
                                                                                  (
                                                                                    -1.678534281995967,
                                                                                    '1976-12-19'
                                                                                  ),
                                                                                  (
                                                                                    -0.7099835737026714,
                                                                                    '1992-11-12'
                                                                                  ),
                                                                                  (
                                                                                    0.7205130423749591,
                                                                                    '1976-06-23'
                                                                                  ),
                                                                                  (
                                                                                    1.8071907960168254,
                                                                                    '1989-03-20'
                                                                                  )
                                                                                ),
                                                                              PARTITION table3_part_3
                                                                                VALUES IN (
                                                                                  (
                                                                                    -0.4676932445805901,
                                                                                    '1993-09-28'
                                                                                  ),
                                                                                  (
                                                                                    -0.43695723992398516,
                                                                                    '1988-03-07'
                                                                                  ),
                                                                                  (
                                                                                    1.0325049738544858,
                                                                                    '1977-03-06'
                                                                                  ),
                                                                                  (
                                                                                    -0.011796130183980402,
                                                                                    '1990-10-15'
                                                                                  ),
                                                                                  (
                                                                                    -0.553265009959894,
                                                                                    '4714-11-24 BC'
                                                                                  )
                                                                                ),
                                                                              PARTITION table3_part_4
                                                                                VALUES IN (
                                                                                  (
                                                                                    -0.8596060999623687,
                                                                                    '1971-07-06'
                                                                                  ),
                                                                                  (
                                                                                    -0.537162954883895,
                                                                                    '1971-12-02'
                                                                                  ),
                                                                                  (
                                                                                    -0.5763104558819903,
                                                                                    '1982-10-20'
                                                                                  ),
                                                                                  (
                                                                                    -0.7960612428671129,
                                                                                    '1989-01-12'
                                                                                  ),
                                                                                  (
                                                                                    0.12220430849701774,
                                                                                    '1970-01-01'
                                                                                  )
                                                                                ),
                                                                              PARTITION table3_part_5
                                                                                VALUES IN (
                                                                                  (
                                                                                    0.00561934626537966,
                                                                                    '1977-09-06'
                                                                                  ),
                                                                                  (
                                                                                    0.6163328083401913,
                                                                                    '1981-03-14'
                                                                                  ),
                                                                                  (
                                                                                    0.07476306458811,
                                                                                    '1978-05-31'
                                                                                  ),
                                                                                  (
                                                                                    1.401298464324817e-45,
                                                                                    '1979-05-16'
                                                                                  ),
                                                                                  (
                                                                                    -0.6242080002856019,
                                                                                    '1974-12-08'
                                                                                  )
                                                                                ),
                                                                              PARTITION "DEFAULT"
                                                                                VALUES IN (
                                                                                  (DEFAULT, DEFAULT)
                                                                                )
                                                                            ));


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) VALUES (2466559136, 0, '1995-12-16');

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


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));