Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-495

Make string comparison not case sensitive

    XMLWordPrintable

    Details

      Description

      ColumnStore is case sensitive for string comparisons in queries.
      I know that the following query

      select * from table1 where field1='aaa';

      can be made not case sensitive writing

      select * from table1 where field1 collate utf8_general_ci='aaa';

      but, is there a way to make the engine not cs by default, without changing the client code?
      There should be an option for this.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              SuperC SuperC
              Votes:
              8 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration