Comments - case insensitive columns

7 years, 2 months ago Stephen Goodey

I'm also in the same boat, after importing data into ColumnStore I wanted to check that a few of our usual queries would work but the string comparisons are always case sensitive despite the table collation been set to utf8_general_ci

If anyone has a solution I would love to hear about it

 
6 years, 10 months ago David Thompson

A key thing to remember is that columnstore implements its own set of 'distributed functions' that are executed at the pm level for scaling out query execution. At this point in time we don't support the collations that allow case insensitive matching. https://jira.mariadb.org/browse/MCOL-495 tracks an enhancement request to allow case insensitive matching.

The only solution for now is to store another column where you convert the text to lower case (or upper case) and then match on that with a lower case value.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.