Apache DataFusion SQL Query Engine
-- `ints.sql` widened to 64 integer columns, each uniform on [0,100), so `cN < k`
-- again has selectivity ~k%. c0..c15 reuse the same multipliers, so a predicate
-- over them has exactly the same selectivities as on `ints` and only the width of
-- the batches flowing through the filter changes. PRED_ROWS sizes the table.
CREATE TABLE t AS
SELECT
(value * 1) % 100 AS c0,
(value * 3) % 100 AS c1,
(value * 7) % 100 AS c2,
(value * 9) % 100 AS c3,
(value * 11) % 100 AS c4,
(value * 13) % 100 AS c5,
(value * 17) % 100 AS c6,
(value * 19) % 100 AS c7,
(value * 21) % 100 AS c8,
(value * 23) % 100 AS c9,
(value * 27) % 100 AS c10,
(value * 29) % 100 AS c11,
(value * 31) % 100 AS c12,
(value * 33) % 100 AS c13,
(value * 37) % 100 AS c14,
(value * 39) % 100 AS c15,
(value * 41) % 100 AS c16,
(value * 43) % 100 AS c17,
(value * 47) % 100 AS c18,
(value * 49) % 100 AS c19,
(value * 51) % 100 AS c20,
(value * 53) % 100 AS c21,
(value * 57) % 100 AS c22,
(value * 59) % 100 AS c23,
(value * 61) % 100 AS c24,
(value * 63) % 100 AS c25,
(value * 67) % 100 AS c26,
(value * 69) % 100 AS c27,
(value * 71) % 100 AS c28,
(value * 73) % 100 AS c29,
(value * 77) % 100 AS c30,
(value * 79) % 100 AS c31,
(value * 81) % 100 AS c32,
(value * 83) % 100 AS c33,
(value * 87) % 100 AS c34,
(value * 89) % 100 AS c35,
(value * 91) % 100 AS c36,
(value * 93) % 100 AS c37,
(value * 97) % 100 AS c38,
(value * 99) % 100 AS c39,
(value * 101) % 100 AS c40,
(value * 103) % 100 AS c41,
(value * 107) % 100 AS c42,
(value * 109) % 100 AS c43,
(value * 111) % 100 AS c44,
(value * 113) % 100 AS c45,
(value * 117) % 100 AS c46,
(value * 119) % 100 AS c47,
(value * 121) % 100 AS c48,
(value * 123) % 100 AS c49,
(value * 127) % 100 AS c50,
(value * 129) % 100 AS c51,
(value * 131) % 100 AS c52,
(value * 133) % 100 AS c53,
(value * 137) % 100 AS c54,
(value * 139) % 100 AS c55,
(value * 141) % 100 AS c56,
(value * 143) % 100 AS c57,
(value * 147) % 100 AS c58,
(value * 149) % 100 AS c59,
(value * 151) % 100 AS c60,
(value * 153) % 100 AS c61,
(value * 157) % 100 AS c62,
(value * 159) % 100 AS c63
FROM generate_series(1, ${PRED_ROWS:-1000000});