blob: cb55d828e32abdf169eba47fd41f69858c1100fc [file]
-- q40 with extra-wide strings: PRED_FILL=170, ~1KB/row. See q40.
SELECT count(*) FROM t
WHERE regexp_like(s, 'aaa')
AND regexp_like(s, 'bbb')
AND regexp_like(s, 'ccc')
AND regexp_like(s, 'ddd')
AND regexp_like(s, 'rare');