Skip to content

PostgreSQL compatibility: SIMILAR TO should treat % as a wildcard #22263

Closed
#23188
Closed
PostgreSQL compatibility: SIMILAR TO should treat % as a wildcard#22263
#23188
Labels
bugSomething isn't workinggood first issueGood for newcomersv56.0.0

Description

@Dandandan
Dandandan
opened on May 16, 2026

Split out from #22247.

Mismatch

SIMILAR TO should treat % as a wildcard.

SELECT 'abc' SIMILAR TO 'a%';

PostgreSQL:

true

DataFusion:

false

Expected behavior

For PostgreSQL-compatible SQL semantics, DataFusion should either match PostgreSQL's result or raise the same class of domain/semantic error.

Activity

  1. Dandandan
    added
    bugSomething isn't working
    good first issueGood for newcomers
    on May 16, 2026

  2. kumarUjjawal commented on May 18, 2026

    @kumarUjjawal
    kumarUjjawal
    on May 18, 2026
    Contributor

    DuckDb

    memory D SELECT 'abc' SIMILAR TO 'a%';
┌────────────────────────────────┐
│ regexp_full_match('abc', 'a%') │
│            boolean             │
├────────────────────────────────┤
│ false                          │
└────────────────────────────────┘

    duckdb/duckdb#17056

  3. oc7o commented on Jun 25, 2026

    @oc7o
    oc7o
    on Jun 25, 2026
    Contributor

    I submitted a PR for this. Feel free to review ☺️

  4. kosiew
    closed this as completedin #23188on Aug 17, 2026
  5. ryux1
    added a commit that references this issue on Aug 17, 2026

    fix: translate SQL wildcards in SIMILAR TO patterns (apache#22263) (a…

    83be77c
  6. nuno-faria
    added
    v56.0.0
    on Oct 3, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workinggood first issueGood for newcomersv56.0.0

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions