What happens?

Weirdly, REGEXP_MATCH for '[A]' fails to match for a single character.

The first where clause emits no results, the second emits (correctly) two results.

To Reproduce

SELECT word
FROM (SELECT UNNEST(['FLASH','TOAST','BELL' ]) as word)
WHERE REGEXP_MATCHES(word, '[A]')
-- WHERE REGEXP_MATCHES(word, '[AS]')

OS:

linux

DuckDB Version:

0.7.1

DuckDB Client:

cli

Full Name:

lloyd tabb

Affiliation:

google

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree