Sign in
apache
/
datafusion
/
refs/heads/fix-disable-migration-aggregate-default
/
.
/
benchmarks
/
sql_benchmarks
/
predicate_eval
/
queries
/
width
/
q41.sql
blob: a03b576d9c959c3f312a8c1ad138b03ec2c7c815 [
file
]
-- q40 with wide strings: PRED_FILL=30, ~186 chars/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'
);