← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Monty Taylor
  • Date: 2008-09-16 00:00:48 UTC
  • mto: This revision was merged to the branch mainline in revision 391.
  • Revision ID: monty@inaugust.com-20080916000048-3rvrv3gv9l0ad3gs
Fixed copyright headers in drizzled/

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/check-testcase.test
11
11
#
12
12
# Dump all global variables
13
13
#
14
 
select * from data_dictionary.GLOBAL_VARIABLES where VARIABLE_NAME != 'timestamp';
 
14
show global variables;
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 test
 
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
 
25
50
 
26
51