Created
June 17, 2020 10:27
-
-
Save JavierJF/314257aa7a689cd837e0c48edd907860 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Test failed for this case "latin7"->character_set_results. | |
mysql data { | |
"autocommit": "OFF", | |
"character_set_client": "utf8mb4", | |
"character_set_connection": "latin7", | |
"character_set_database": "utf8mb4", | |
"character_set_results": "latin7", | |
"collation_connection": "latin7_general_ci", | |
"group_concat_max_len": "4096", | |
"hostname": "mysql1", | |
"init_connect": "", | |
"max_join_size": "10000", | |
"net_write_timeout": "60", | |
"session_track_gtids": "OWN_GTID", | |
"sql_auto_is_null": "OFF", | |
"sql_log_bin": "ON", | |
"sql_mode": "", | |
"sql_safe_updates": "OFF", | |
"sql_select_limit": "18446744073709551615", | |
"time_zone": "+01:00", | |
"transaction_isolation": "SERIALIZABLE", | |
"transaction_read_only": "OFF" | |
} | |
proxysql data { | |
"address": "0x7f7ebb63d800", | |
"age_ms": 27729, | |
"autocommit": false, | |
"autocommit_on_hostgroup": -1, | |
"backends": [ | |
{ | |
"conn": { | |
"CHARSET": "", | |
"MultiplexDisabled": false, | |
"action": "", | |
"address": "0x7f7ebb63e100", | |
"auto_increment_delay_token": 0, | |
"autocommit": "OFF", | |
"bytes_recv": 0, | |
"bytes_sent": 696, | |
"character_set_client": "utf8", | |
"character_set_connection": "utf8", | |
"character_set_database": "utf8mb4", | |
"character_set_results": "", | |
"client_flag": { | |
"client_found_rows": 0, | |
"client_multi_statements": 0, | |
"value": 2157486733 | |
}, | |
"collation_connection": "utf8_general_ci", | |
"group_concat_max_len": "4096", | |
"init_connect": "", | |
"init_connect_sent": true, | |
"isolation_level": "SERIALIZABLE", | |
"last_set_autocommit": 0, | |
"max_join_size": "10000", | |
"myconnpoll_get": 1, | |
"myconnpoll_put": 0, | |
"mysql": { | |
"address": "0x7f7ebb681500", | |
"affected_rows": 18446744073709551615, | |
"charset": 45, | |
"db": "information_schema", | |
"host": "127.0.0.1", | |
"host_info": "127.0.0.1 via TCP/IP", | |
"insert_id": 0, | |
"net": { | |
"fd": 113, | |
"last_errno": 1065, | |
"max_packet_size": 1073741824, | |
"sqlstate": "42000" | |
}, | |
"options": { | |
"charset_name": "utf8", | |
"use_ssl": 0 | |
}, | |
"port": 13306, | |
"server_status": 0, | |
"server_version": "5.7.29-log", | |
"thread_id": 152, | |
"unix_socket": "", | |
"user": "root" | |
}, | |
"names": "", | |
"net_write_timeout": "", | |
"no_backslash_escapes": false, | |
"ps": { | |
"backend_stmt_to_global_ids": [], | |
"global_stmt_to_backend_ids": [] | |
}, | |
"questions": 24, | |
"session_track_gtids": "OWN_GTID", | |
"sql_auto_is_null": "OFF", | |
"sql_log_bin": "ON", | |
"sql_mode": "", | |
"sql_safe_updates": "OFF", | |
"sql_select_limit": "", | |
"status": { | |
"found_rows": false, | |
"get_lock": false, | |
"has_savepoint": false, | |
"lock_tables": false, | |
"no_multiplex": false, | |
"temporary_table": false, | |
"user_variable": false | |
}, | |
"time_zone": "+01:00", | |
"transaction_read": "", | |
"wsrep_sync_wait": "" | |
}, | |
"gtid": "", | |
"hostgroup_id": 0, | |
"stream": { | |
"DSS": 26, | |
"address": "0x7f7ebb649380", | |
"bytes_recv": 0, | |
"bytes_sent": 696, | |
"myconnpoll_get": 1, | |
"myconnpoll_put": 0, | |
"questions": 2 | |
} | |
}, | |
{ | |
"gtid": "", | |
"hostgroup_id": 1, | |
"stream": { | |
"DSS": 0, | |
"address": "0x7f7ebb648c00", | |
"bytes_recv": 26265, | |
"bytes_sent": 44288, | |
"myconnpoll_get": 94, | |
"myconnpoll_put": 94, | |
"questions": 94 | |
} | |
} | |
], | |
"client": { | |
"DSS": 6, | |
"client_addr": { | |
"address": "127.0.0.1", | |
"port": 35312 | |
}, | |
"encrypted": false, | |
"proxy_addr": { | |
"address": "0.0.0.0", | |
"port": 6033 | |
}, | |
"stream": { | |
"bytes_recv": 31335, | |
"bytes_sent": 211131, | |
"pkts_recv": 199, | |
"pkts_sent": 383 | |
}, | |
"userinfo": { | |
"password": "*81F5E21E35407D884A6CD4A731AEBFB6AF209E1B", | |
"username": "root" | |
} | |
}, | |
"conn": { | |
"CHARSET": "41", | |
"action": "1", | |
"autocommit": "OFF", | |
"character_set_client": "utf8mb4", | |
"character_set_connection": "latin7", | |
"character_set_database": "utf8mb4", | |
"character_set_results": "", | |
"client_flag": { | |
"client_found_rows": 0, | |
"client_multi_results": 0, | |
"client_multi_statements": 0, | |
"value": 10003085 | |
}, | |
"collation_connection": "latin7_general_ci", | |
"group_concat_max_len": "4096", | |
"max_join_size": "10000", | |
"names": "", | |
"net_write_timeout": "", | |
"no_backslash_escapes": false, | |
"ps": { | |
"client_stmt_to_global_ids": [] | |
}, | |
"session_track_gtids": "OWN_GTID", | |
"sql_auto_is_null": "OFF", | |
"sql_log_bin": "ON", | |
"sql_mode": "", | |
"sql_safe_updates": "OFF", | |
"sql_select_limit": "", | |
"status": { | |
"compression": false, | |
"transaction": false | |
}, | |
"time_zone": "+01:00", | |
"transaction_isolation": "SERIALIZABLE", | |
"transaction_read": "", | |
"wsrep_sync_wait": "1" | |
}, | |
"current_hostgroup": 0, | |
"default_hostgroup": 0, | |
"default_schema": "", | |
"gtid": { | |
"hid": -1, | |
"last": "" | |
}, | |
"last_HG_affected_rows": -1, | |
"last_insert_id": 0, | |
"locked_on_hostgroup": -1, | |
"status": 4, | |
"thread": "0x7f7ebb600000", | |
"thread_session_id": 65, | |
"transaction_persistent": true | |
} | |
csv data { | |
"autocommit": "OFF", | |
"character_set_client": "utf8mb4", | |
"character_set_connection": "latin7", | |
"character_set_results": "latin7", | |
"collation_connection": "latin7_general_ci", | |
"group_concat_max_len": "4096" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment