~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/check-testcase.test

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

• reverse the comparison (51.3.6 to 511.2.1)
• stop comparing with revision 511.2.1

Show diffs side-by-side

added

removed

tests/include/check-testcase.test

1

 

#

2

 

# This test is executed twice for each test case if mysql-test-run is passed

3

 

# the flag --check-testcase.

4

 

# Before every testcase it's run with mysqltest in record mode and will

5

 

# thus produce an output file

6

 

# that can be compared to output from after the tescase.

7

 

# In that way it's possible to check that a testcase does not have

8

 

# any unwanted side affects.

9

 

#

10

 

 

11

 

#

12

 

# Dump all global variables

13

 

#

14

 

show global variables;

15

 

 

16

 

#

17

 

# Dump all databases

18

 

#

19

 

show databases;

20

 

 

21

 

#

22

 

# Dump the "test" database, all it's tables and their data

23

 

#

24

 

--exec $DRIZZLE_DUMP --skip-comments --skip-lock-tables test

25

 

 

26

 

#

27

 

# Dump the "mysql" database and it's tables

28

 

# Select data separately to add "order by"

29

 

#

30

 

--exec $DRIZZLE_DUMP --skip-comments --skip-lock-tables --no-data mysql

31

 

use mysql;

32

 

select * from columns_priv;

33

 

select * from db order by host, db, user;

34

 

select * from func;

35

 

select * from help_category;

36

 

select * from help_keyword;

37

 

select * from help_relation;

38

 

select * from help_relation;

39

 

select * from host;

40

 

select * from proc;

41

 

select * from procs_priv;

42

 

select * from tables_priv;

43

 

select * from time_zone;

44

 

select * from time_zone_leap_second;

45

 

select * from time_zone_name;

46

 

select * from time_zone_transition;

47

 

select * from time_zone_transition_type;

48

 

select * from user;

49

 

 

50

 

 

51

 

 

• Older »

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