Debian Codegraph @

mysql-test/suite/perfschema/t/hostname_length.test

raw
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;