[MCOL-1666] Comparisation with non latin chars in query stats not possible Created: 2018-08-21  Updated: 2020-04-01  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.0.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
Resolution: Fixed Votes: 1
Labels: querystats
Environment:

tested on Red Hat, Ubuntu and Docker

Issue Links:
Blocks
is blocked by MCOL-1654 Querystats table is broken Closed

 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`;



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-09-13 ]

Fix will likely be having the QueryStats create table as UTF8 and making the connection UTF8.

Comment by Richard Stracke [ 2019-04-09 ]

Issue seems fixed in 1.2

Comment by Andrew Hutchings (Inactive) [ 2019-07-10 ]

Fixed in 1.2

Generated at Thu Feb 08 02:30:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.