Comments - case insensitive columns

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.