Sign in
apache
/
datafusion
/
refs/heads/fix-disable-migration-aggregate-default
/
.
/
benchmarks
/
sql_benchmarks
/
predicate_eval
/
queries
/
width
/
q42.sql
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'
);