Skip to content

SQL: LIKE/RLIKE don't produce painless scripts #53486

@matriv

Description

@matriv

LIKE/RLIKE don't produce painless scripts and wrong results are returned, e.g.:

SELECT count(*), CASE WHEN text.keyword LIKE '%a%' then 1 ELSE 2 END as c FROM test_termvector GROUP BY t

will return one group with value 2.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions