-- numeric predicates on numeric(18, 0) and numeric(18, 6): constants at the edges of int64 and of the scaled range, half a unit, and trailing zeros
-- shape: notes-path-exists
-- expect: agg
-- key: -
SELECT
       count(*) FILTER (WHERE n0 = 2.5::numeric) AS eq_n0_0,
       count(*) FILTER (WHERE n0 <> 2.5::numeric) AS ne_n0_0,
       count(*) FILTER (WHERE n0 < 2.5::numeric) AS lt_n0_0,
       count(*) FILTER (WHERE n0 <= 2.5::numeric) AS le_n0_0,
       count(*) FILTER (WHERE n0 > 2.5::numeric) AS gt_n0_0,
       count(*) FILTER (WHERE n0 >= 2.5::numeric) AS ge_n0_0,
       count(*) FILTER (WHERE n0 = 999999999999999999::numeric) AS eq_n0_1,
       count(*) FILTER (WHERE n0 <> 999999999999999999::numeric) AS ne_n0_1,
       count(*) FILTER (WHERE n0 < 999999999999999999::numeric) AS lt_n0_1,
       count(*) FILTER (WHERE n0 <= 999999999999999999::numeric) AS le_n0_1,
       count(*) FILTER (WHERE n0 > 999999999999999999::numeric) AS gt_n0_1,
       count(*) FILTER (WHERE n0 >= 999999999999999999::numeric) AS ge_n0_1,
       count(*) FILTER (WHERE n0 = 999999999999999999.5::numeric) AS eq_n0_2,
       count(*) FILTER (WHERE n0 <> 999999999999999999.5::numeric) AS ne_n0_2,
       count(*) FILTER (WHERE n0 < 999999999999999999.5::numeric) AS lt_n0_2,
       count(*) FILTER (WHERE n0 <= 999999999999999999.5::numeric) AS le_n0_2,
       count(*) FILTER (WHERE n0 > 999999999999999999.5::numeric) AS gt_n0_2,
       count(*) FILTER (WHERE n0 >= 999999999999999999.5::numeric) AS ge_n0_2,
       count(*) FILTER (WHERE n0 = 9223372036854775807::numeric) AS eq_n0_3,
       count(*) FILTER (WHERE n0 <> 9223372036854775807::numeric) AS ne_n0_3,
       count(*) FILTER (WHERE n0 < 9223372036854775807::numeric) AS lt_n0_3,
       count(*) FILTER (WHERE n0 <= 9223372036854775807::numeric) AS le_n0_3,
       count(*) FILTER (WHERE n0 > 9223372036854775807::numeric) AS gt_n0_3,
       count(*) FILTER (WHERE n0 >= 9223372036854775807::numeric) AS ge_n0_3,
       count(*) FILTER (WHERE n0 = 9223372036854775808::numeric) AS eq_n0_4,
       count(*) FILTER (WHERE n0 <> 9223372036854775808::numeric) AS ne_n0_4,
       count(*) FILTER (WHERE n0 < 9223372036854775808::numeric) AS lt_n0_4,
       count(*) FILTER (WHERE n0 <= 9223372036854775808::numeric) AS le_n0_4,
       count(*) FILTER (WHERE n0 > 9223372036854775808::numeric) AS gt_n0_4,
       count(*) FILTER (WHERE n0 >= 9223372036854775808::numeric) AS ge_n0_4,
       count(*) FILTER (WHERE n0 = 1e19::numeric) AS eq_n0_5,
       count(*) FILTER (WHERE n0 <> 1e19::numeric) AS ne_n0_5,
       count(*) FILTER (WHERE n0 < 1e19::numeric) AS lt_n0_5,
       count(*) FILTER (WHERE n0 <= 1e19::numeric) AS le_n0_5,
       count(*) FILTER (WHERE n0 > 1e19::numeric) AS gt_n0_5,
       count(*) FILTER (WHERE n0 >= 1e19::numeric) AS ge_n0_5,
       count(*) FILTER (WHERE n0 = -1e19::numeric) AS eq_n0_6,
       count(*) FILTER (WHERE n0 <> -1e19::numeric) AS ne_n0_6,
       count(*) FILTER (WHERE n0 < -1e19::numeric) AS lt_n0_6,
       count(*) FILTER (WHERE n0 <= -1e19::numeric) AS le_n0_6,
       count(*) FILTER (WHERE n0 > -1e19::numeric) AS gt_n0_6,
       count(*) FILTER (WHERE n0 >= -1e19::numeric) AS ge_n0_6,
       count(*) FILTER (WHERE n0 = -999999999999999999.5::numeric) AS eq_n0_7,
       count(*) FILTER (WHERE n0 <> -999999999999999999.5::numeric) AS ne_n0_7,
       count(*) FILTER (WHERE n0 < -999999999999999999.5::numeric) AS lt_n0_7,
       count(*) FILTER (WHERE n0 <= -999999999999999999.5::numeric) AS le_n0_7,
       count(*) FILTER (WHERE n0 > -999999999999999999.5::numeric) AS gt_n0_7,
       count(*) FILTER (WHERE n0 >= -999999999999999999.5::numeric) AS ge_n0_7,
       count(*) FILTER (WHERE n6 = 0.1::numeric) AS eq_n6_0,
       count(*) FILTER (WHERE n6 <> 0.1::numeric) AS ne_n6_0,
       count(*) FILTER (WHERE n6 < 0.1::numeric) AS lt_n6_0,
       count(*) FILTER (WHERE n6 <= 0.1::numeric) AS le_n6_0,
       count(*) FILTER (WHERE n6 > 0.1::numeric) AS gt_n6_0,
       count(*) FILTER (WHERE n6 >= 0.1::numeric) AS ge_n6_0,
       count(*) FILTER (WHERE n6 = 0.0000005::numeric) AS eq_n6_1,
       count(*) FILTER (WHERE n6 <> 0.0000005::numeric) AS ne_n6_1,
       count(*) FILTER (WHERE n6 < 0.0000005::numeric) AS lt_n6_1,
       count(*) FILTER (WHERE n6 <= 0.0000005::numeric) AS le_n6_1,
       count(*) FILTER (WHERE n6 > 0.0000005::numeric) AS gt_n6_1,
       count(*) FILTER (WHERE n6 >= 0.0000005::numeric) AS ge_n6_1,
       count(*) FILTER (WHERE n6 = 0.0000015::numeric) AS eq_n6_2,
       count(*) FILTER (WHERE n6 <> 0.0000015::numeric) AS ne_n6_2,
       count(*) FILTER (WHERE n6 < 0.0000015::numeric) AS lt_n6_2,
       count(*) FILTER (WHERE n6 <= 0.0000015::numeric) AS le_n6_2,
       count(*) FILTER (WHERE n6 > 0.0000015::numeric) AS gt_n6_2,
       count(*) FILTER (WHERE n6 >= 0.0000015::numeric) AS ge_n6_2,
       count(*) FILTER (WHERE n6 = -0.5::numeric) AS eq_n6_3,
       count(*) FILTER (WHERE n6 <> -0.5::numeric) AS ne_n6_3,
       count(*) FILTER (WHERE n6 < -0.5::numeric) AS lt_n6_3,
       count(*) FILTER (WHERE n6 <= -0.5::numeric) AS le_n6_3,
       count(*) FILTER (WHERE n6 > -0.5::numeric) AS gt_n6_3,
       count(*) FILTER (WHERE n6 >= -0.5::numeric) AS ge_n6_3,
       count(*) FILTER (WHERE n6 = 123456789012.1234565::numeric) AS eq_n6_4,
       count(*) FILTER (WHERE n6 <> 123456789012.1234565::numeric) AS ne_n6_4,
       count(*) FILTER (WHERE n6 < 123456789012.1234565::numeric) AS lt_n6_4,
       count(*) FILTER (WHERE n6 <= 123456789012.1234565::numeric) AS le_n6_4,
       count(*) FILTER (WHERE n6 > 123456789012.1234565::numeric) AS gt_n6_4,
       count(*) FILTER (WHERE n6 >= 123456789012.1234565::numeric) AS ge_n6_4,
       count(*) FILTER (WHERE n6 = 1e12::numeric) AS eq_n6_5,
       count(*) FILTER (WHERE n6 <> 1e12::numeric) AS ne_n6_5,
       count(*) FILTER (WHERE n6 < 1e12::numeric) AS lt_n6_5,
       count(*) FILTER (WHERE n6 <= 1e12::numeric) AS le_n6_5,
       count(*) FILTER (WHERE n6 > 1e12::numeric) AS gt_n6_5,
       count(*) FILTER (WHERE n6 >= 1e12::numeric) AS ge_n6_5,
       count(*) FILTER (WHERE n6 = -1e12::numeric) AS eq_n6_6,
       count(*) FILTER (WHERE n6 <> -1e12::numeric) AS ne_n6_6,
       count(*) FILTER (WHERE n6 < -1e12::numeric) AS lt_n6_6,
       count(*) FILTER (WHERE n6 <= -1e12::numeric) AS le_n6_6,
       count(*) FILTER (WHERE n6 > -1e12::numeric) AS gt_n6_6,
       count(*) FILTER (WHERE n6 >= -1e12::numeric) AS ge_n6_6,
       count(*) FILTER (WHERE n6 = 0.100000::numeric) AS eq_n6_7,
       count(*) FILTER (WHERE n6 <> 0.100000::numeric) AS ne_n6_7,
       count(*) FILTER (WHERE n6 < 0.100000::numeric) AS lt_n6_7,
       count(*) FILTER (WHERE n6 <= 0.100000::numeric) AS le_n6_7,
       count(*) FILTER (WHERE n6 > 0.100000::numeric) AS gt_n6_7,
       count(*) FILTER (WHERE n6 >= 0.100000::numeric) AS ge_n6_7
FROM t_num