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

Comparisation with non latin chars in query stats not possible

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.0
    • Icebox
    • ?
    • tested on Red Hat, Ubuntu and Docker

    Description

      This also happens, even if Columnstore is configured in UTF-8 and table querystats is created with charset utf-8.

      CREATE TABLE `utf8testmcs` (
      	`somestring` VARCHAR(10) NULL DEFAULT NULL
      )
      ENGINE=Columnstore
      ;
       
      select "€" from test.utf8testmcs;
      

      In Querystats the query will be saved:

      MariaDB [(none)]> select query from infinidb_querystats.querystats; 
      +----------------------------------------+
      | query                                  |
      +----------------------------------------+
      | select "€" from test.utf8testmcs     |
      
      

      This query gives no result:

      select * from infinidb_querystats.querystats where instr(query,'€');
      

      With this workaround it works;

      ALTER TABLE `querystats`
      	CHANGE COLUMN `query` `query` VARBINARY(5000) NULL DEFAULT NULL AFTER `queryType`;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              Votes:
              1 Vote for this issue
              Watchers:
              3 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.