| 1 |
--source include/have_debug.inc |
| 2 |
--source include/mysql_have_debug.inc |
| 3 |
|
| 4 |
--echo # |
| 5 |
--echo # These tests verify that MySQL supports hostname with maximum of 255 |
| 6 |
--echo # char length in various performance schema tables. |
| 7 |
--echo # |
| 8 |
|
| 9 |
--echo # Setup |
| 10 |
CREATE USER some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890; |
| 11 |
GRANT ALL ON *.* TO some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890; |
| 12 |
|
| 13 |
SET GLOBAL DEBUG='+d,vio_peer_addr_fake_hostname1'; |
| 14 |
--echo # Execute test with long hostname in GRANTOR. |
| 15 |
--exec $MYSQL --user=some_user_name --ssl-mode=DISABLED --host=host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890 -#d,vio_client_use_localhost -v test < $MYSQL_TEST_DIR/std_data/hostname_in_perfschema.sql |
| 16 |
|
| 17 |
# |
| 18 |
# Verify that Host column shows 255 character in SHOW PROCESSLIST output. |
| 19 |
# |
| 20 |
|
| 21 |
let MYSQL_LOG= $MYSQL_TMP_DIR/mysql.log; |
| 22 |
--exec $MYSQL --user=some_user_name --ssl-mode=DISABLED --host=host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890 -#d,vio_client_use_localhost -v test -e "SHOW PROCESSLIST;" > $MYSQL_LOG |
| 23 |
--let SEARCH_FILE= $MYSQL_LOG |
| 24 |
--let SEARCH_PATTERN= host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij123456789 |
| 25 |
--source include/search_pattern.inc |
| 26 |
--remove_file $MYSQL_LOG |
| 27 |
|
| 28 |
# |
| 29 |
# Verify that Host column shows 255 character in INFORMATION_SCHEMA.PROCESSLIST output. |
| 30 |
# |
| 31 |
|
| 32 |
--exec $MYSQL --user=some_user_name --ssl-mode=DISABLED --host=host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890 -#d,vio_client_use_localhost -v test -e "SELECT Host FROM INFORMATION_SCHEMA.PROCESSLIST WHERE User='some_user_name';" > $MYSQL_LOG |
| 33 |
--source include/search_pattern.inc |
| 34 |
--remove_file $MYSQL_LOG |
| 35 |
|
| 36 |
SET GLOBAL DEBUG='-d,vio_peer_addr_fake_hostname1'; |
| 37 |
|
| 38 |
--echo # Cleanup |
| 39 |
--source ../../sysschema/include/ps_setup_actors_cleanup.inc |
| 40 |
DROP USER some_user_name@host_1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890abcdefghij1234567890; |