blob: 1b3df3e937eb32fcfd4977ac671b74a17eba3539 [file]
-- Same predicate set and hidden selectivities as costsel/q01 ('rare' ~0.1%, the
-- rest 75-90%); only the string-column width differs across q40/q41/q42. Narrow:
-- PRED_FILL=2, ~12 chars/row.
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');