~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/perfschema/t/digest_null_literal.test

• browse files at revision 1.2.5
• compare with another revision
• download diff
• download tarball
• view history from revision 1.2.5

Show diffs side-by-side

added

removed

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

 

1

# ----------------------------------------------------

 

2

# Tests for the performance schema statement Digests.

 

3

# ----------------------------------------------------

 

4

 

 

5

# Test case to show behavior of statements digest when

 

6

# parsing a NULL literal

 

7

 

 

8

--source include/not_embedded.inc

 

9

--source include/have_perfschema.inc

 

10

--source ../include/no_protocol.inc

 

11

 

 

12

TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;

 

13

 

 

14

--disable_query_log

 

15

 

 

16

select NULL;

 

17

select NULL FROM DUAL;

 

18

select NULL, NULL;

 

19

select NULL, NULL, NULL, 1, 2, 3, NULL, NULL;

 

20

 

 

21

select 1 IS NULL;

 

22

select 2 IS NOT NULL;

 

23

select 1 IS NULL, 2 IS NULL, 3 IS NOT NULL, 4 IS NOT NULL;

 

24

 

 

25

create table foo (a int DEFAULT NULL, b int NOT NULL DEFAULT 1, c int NOT NULL);

 

26

drop table foo;

 

27

 

 

28

--enable_query_log

 

29

 

 

30

SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR

 

31

  FROM performance_schema.events_statements_summary_by_digest;

 

32

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1