Testcase (sporadic, needs to be run in high concurrency, pasted here to get an idea of queries involved)
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; SELECT CONNECTION_ID(); SELECT CASE WHEN table_schema = 'information_schema' THEN 'INFORMATION_SCHEMA' ELSE table_schema END, table_name, CASE WHEN table_type = 'BASE TABLE' THEN''WHEN table_type = 'VIEW' THEN''WHEN table_type = 'SYSTEM VIEW' then''ELSE''END, column_name, CASE WHEN column_key = 'PRI' THEN''WHEN column_key = 'MUL' THEN''WHEN column_key = 'UNI' THEN''ELSE''END FROM information_schema.tables INNER JOIN information_schema.columns USING(table_schema, table_name) WHERE table_name <> 'DUMMY'; SELECT collation_name,character_set_name FROM information_schema.collations;
And, server was running with these parameters:
--loose-new --sql-mode=no_engine_substitution --relay-log=slave-relay-bin --loose-innodb --secure-file-priv= --max-allowed-packet=16Mb --loose-innodb-status-file=1 --master-retry-count=65535 --loose-debug-assert-if-crashed-table --loose-debug-assert-on-error --skip-name-resolve --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --innodb_file_per_table=1 --innodb_adaptive_hash_index_partitions=1 --core
Testcase (sporadic, needs to be run in high concurrency, pasted here to get an idea of queries involved)
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; schema' THEN 'INFORMATION_ SCHEMA' ELSE table_schema END, table_name, CASE WHEN table_type = 'BASE TABLE' THEN''WHEN table_type = 'VIEW' THEN''WHEN table_type = 'SYSTEM VIEW' then''ELSE''END, column_name, CASE WHEN column_key = 'PRI' THEN''WHEN column_key = 'MUL' THEN''WHEN column_key = 'UNI' THEN''ELSE''END FROM information_ schema. tables INNER JOIN information_ schema. columns USING(table_schema, table_name) WHERE table_name <> 'DUMMY'; name,character_ set_name FROM information_ schema. collations;
SELECT CONNECTION_ID();
SELECT CASE WHEN table_schema = 'information_
SELECT collation_
And, server was running with these parameters:
--loose-new --sql-mode= no_engine_ substitution --relay- log=slave- relay-bin --loose-innodb --secure-file-priv= --max-allowed- packet= 16Mb --loose- innodb- status- file=1 --master- retry-count= 65535 --loose- debug-assert- if-crashed- table --loose- debug-assert- on-error --skip-name-resolve --log-output=none --sql_mode= ONLY_FULL_ GROUP_BY --innodb_ file_per_ table=1 --innodb_ adaptive_ hash_index_ partitions= 1 --core