blob: 7029a3d9f8f7d398edb30b7a3dca6f3445c3f078 [file]
-- Hidden: four regexp scans of about equal cost, all unselective ('aaa' ~90%,
-- 'bbb' ~86%, 'ccc' ~80%, 'ddd' ~75%). Like q60 the predicates are
-- interchangeable, but here each one is expensive.
SELECT count(*) FROM t
WHERE regexp_like(s, 'aaa')
AND regexp_like(s, 'bbb')
AND regexp_like(s, 'ccc')
AND regexp_like(s, 'ddd');