39 lines
1.0 KiB
Plaintext
39 lines
1.0 KiB
Plaintext
# Test for PERFORMANCE_SCHEMA statement digests
|
||
#
|
||
# Test statements using different character sets.
|
||
# See Bug#13809293 - PERFSCHEMA.DML_ESMS_BY_DIGEST FAILS ON DAILY-TRUNK SPORADICALLY
|
||
#
|
||
--disable_warnings
|
||
DROP DATABASE IF EXISTS pfs_charset_test;
|
||
--enable_warnings
|
||
CREATE DATABASE pfs_charset_test;
|
||
USE pfs_charset_test;
|
||
--disable_query_log
|
||
SET DEFAULT_STORAGE_ENGINE=XENGINE;
|
||
--enable_query_log
|
||
|
||
#
|
||
# CP1251 - 8 bits, max multibyte length = 1
|
||
#
|
||
SET NAMES cp1251;
|
||
--character_set cp1251
|
||
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
|
||
CREATE TABLE äîëåí_ðåãèñòúð_1251a (s1 INT);
|
||
CREATE TABLE ÄîËåÍ_ðåãèñòúð_1251b (s1 INT, s2 INT);
|
||
|
||
#
|
||
# UTF8 - 8 bits, max multibyte length = 4
|
||
#
|
||
SET NAMES utf8;
|
||
--character_set utf8mb4
|
||
CREATE TABLE ДОЛЕÐ<E280A2>_региÑ<C2B8>Ñ‚ÑŠÑ€_утф8 (s1 INT);
|
||
|
||
#
|
||
# Incorrectly converted statement identifiers will result in a warning.
|
||
#
|
||
SET NAMES latin1;
|
||
SELECT * FROM performance_schema.events_statements_summary_by_digest
|
||
WHERE digest_text LIKE 'XXXYYY%' LIMIT 1;
|
||
|
||
DROP DATABASE pfs_charset_test;
|