~stewart/drizzle/embedded-innodb-rnd-read

« back to all changes in this revision

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

  • Committer: Stewart Smith
  • Date: 2010-04-06 07:37:28 UTC
  • mfrom: (1310.1.44)
  • Revision ID: stewart@flamingspork.com-20100406073728-ml0gfkm3n3yq3lj3
Merged embedded-innodb-write-row into embedded-innodb-rnd-read.

Show diffs side-by-side

added added

removed removed

Lines of Context:
11
11
#
12
12
# Dump all global variables
13
13
#
14
 
show global variables;
 
14
select * from data_dictionary.GLOBAL_VARIABLES where VARIABLE_NAME != 'timestamp';
15
15
 
16
16
#
17
17
# Dump all databases
21
21
#
22
22
# Dump the "test" database, all it's tables and their data
23
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
 
 
 
24
--exec $DRIZZLE_DUMP --skip-comments test
50
25
 
51
26