Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save JavierJF/314257aa7a689cd837e0c48edd907860 to your computer and use it in GitHub Desktop.
Save JavierJF/314257aa7a689cd837e0c48edd907860 to your computer and use it in GitHub Desktop.
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