Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.0
-
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
- is blocked by
-
MCOL-1654 Querystats table is broken
- Closed