Skip to content

Adding case insensitive equals comparison for Clickhouse #9637

Closed
@NaythenF

Description

@NaythenF

Is your feature request related to a problem? Please describe.
Currently while using Cube with Clickhouse, it seems that equal comparisons are not case insensitive, while contains, startsWith, and other filter operations are.

Describe the solution you'd like
I think implementing a similar approach for equals as used for the other comparison operators would make sense to me (casting values to uppercase/lowercase and then doing the comparison).

Describe alternatives you've considered
I have considered doing this on the model side by lowercasing input for filters and the data itself, but then displaying the data is worse since it would all be lower case.

Additional context
Currently using Cube 1.3.10 where I am seeing this
Let me know if any extra context or information is needed!

Metadata

Metadata

Assignees

No one assigned

    Labels

    driver:clickhouseIssues related to the ClickHouse driver

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions