diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/start_server_no_digests.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/start_server_no_digests.result | 92 |
1 files changed, 92 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/start_server_no_digests.result b/mysql-test/suite/perfschema/r/start_server_no_digests.result new file mode 100644 index 00000000000..38d6d2750f6 --- /dev/null +++ b/mysql-test/suite/perfschema/r/start_server_no_digests.result @@ -0,0 +1,92 @@ +#################################### +# SETUP +#################################### +CREATE DATABASE statements_digest; +USE statements_digest; +CREATE TABLE t1(a int); +CREATE TABLE t2(a int); +CREATE TABLE t3(a int, b int); +CREATE TABLE t4(a int, b int); +CREATE TABLE t5(a int, b int, c int); +TRUNCATE TABLE performance_schema.events_statements_summary_by_digest; +#################################### +# EXECUTION +#################################### +SELECT 1 FROM t1; +1 +SELECT 1 FROM `t1`; +1 +SELECT 1,2 FROM t1; +1 2 +SELECT 1, 2, 3, 4 FROM t1; +1 2 3 4 +SELECT 1 FROM t2; +1 +SELECT 1,2 FROM t2; +1 2 +SELECT 1, 2, 3, 4 FROM t2; +1 2 3 4 +INSERT INTO t1 VALUES (1); +INSERT INTO t2 VALUES (1); +INSERT INTO t3 VALUES (1, 2); +INSERT INTO t4 VALUES (1, 2); +INSERT INTO t5 VALUES (1, 2, 3); +INSERT INTO t1 VALUES (1), (2), (3); +INSERT INTO t1 VALUES (1), (2), (3), (4); +INSERT INTO t3 VALUES (1, 2), (3, 4), (5, 6); +INSERT INTO t5 VALUES (1, 2, 3), (4, 5, 6), (7, 8, 9); +SELECT 1 + 1; +1 + 1 +2 +SELECT 1; +1 +1 +SELECT 1 /* This is an inline comment */ + 1; +1 /* This is an inline comment */ + 1 +2 +SELECT 1+ +/* +this is a +multiple-line comment +*/ +1; +1+ +/* +this is a +multiple-line comment +*/ +1 +2 +CREATE SCHEMA statements_digest_temp; +DROP SCHEMA statements_digest_temp; +CREATE DATABASE statements_digest_temp; +DROP DATABASE statements_digest_temp; +SELECT 1 from t11; +ERROR 42S02: Table 'statements_digest.t11' doesn't exist +create table t11 (c char(4)); +create table t11 (c char(4)); +ERROR 42S01: Table 't11' already exists +insert into t11 values("MySQL"); +Warnings: +Warning 1265 Data truncated for column 'c' at row 1 +#################################### +# QUERYING PS STATEMENT DIGEST +#################################### +SELECT DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS, +SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest; +DIGEST DIGEST_TEXT COUNT_STAR SUM_ROWS_AFFECTED SUM_WARNINGS SUM_ERRORS +SHOW VARIABLES LIKE "performance_schema_digests_size"; +Variable_name Value +performance_schema_digests_size 0 +SELECT COUNT(*) FROM performance_schema.events_statements_summary_by_digest; +COUNT(*) +0 +#################################### +# CLEANUP +#################################### +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +DROP TABLE IF EXISTS t3; +DROP TABLE IF EXISTS t4; +DROP TABLE IF EXISTS t5; +DROP DATABASE IF EXISTS statements_digest; |