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

              dleeyh Daniel Lee (Inactive)
              SuperC SuperC
              Votes:
              8 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.