← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/drizzlecheck.result

  • Committer: Mark Atwood
  • Date: 2008-12-29 22:12:25 UTC
  • mfrom: (752 testable)
  • mto: (754.1.4 devel)
  • mto: This revision was merged to the branch mainline in revision 755.
  • Revision ID: me@mark.atwood.name-20081229221225-u2hiic4ztb2mryfn
merge from main

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/drizzlecheck.result
1
1
DROP TABLE IF EXISTS t1, `t``1`, `t 1`;
2
 
drop view if exists v1;
3
2
drop database if exists client_test_db;
4
 
mysql.columns_priv                                 OK
5
 
mysql.db                                           OK
6
 
mysql.event                                        OK
7
 
mysql.func                                         OK
8
 
mysql.general_log
9
 
note     : The storage engine for the table doesn't support optimize
10
 
mysql.help_category                                OK
11
 
mysql.help_keyword                                 OK
12
 
mysql.help_relation                                OK
13
 
mysql.help_topic                                   OK
14
 
mysql.host                                         OK
15
 
mysql.ndb_binlog_index                             OK
16
 
mysql.online_backup                                OK
17
 
mysql.online_backup_progress                       OK
18
 
mysql.plugin                                       OK
19
 
mysql.proc                                         OK
20
 
mysql.procs_priv                                   OK
21
 
mysql.servers                                      OK
22
 
mysql.slow_log
23
 
note     : The storage engine for the table doesn't support optimize
24
 
mysql.tables_priv                                  OK
25
 
mysql.time_zone                                    OK
26
 
mysql.time_zone_leap_second                        OK
27
 
mysql.time_zone_name                               OK
28
 
mysql.time_zone_transition                         OK
29
 
mysql.time_zone_transition_type                    OK
30
 
mysql.user                                         OK
31
 
mysql.columns_priv                                 OK
32
 
mysql.db                                           OK
33
 
mysql.event                                        OK
34
 
mysql.func                                         OK
35
 
mysql.general_log
36
 
note     : The storage engine for the table doesn't support optimize
37
 
mysql.help_category                                OK
38
 
mysql.help_keyword                                 OK
39
 
mysql.help_relation                                OK
40
 
mysql.help_topic                                   OK
41
 
mysql.host                                         OK
42
 
mysql.ndb_binlog_index                             OK
43
 
mysql.online_backup                                OK
44
 
mysql.online_backup_progress                       OK
45
 
mysql.plugin                                       OK
46
 
mysql.proc                                         OK
47
 
mysql.procs_priv                                   OK
48
 
mysql.servers                                      OK
49
 
mysql.slow_log
50
 
note     : The storage engine for the table doesn't support optimize
51
 
mysql.tables_priv                                  OK
52
 
mysql.time_zone                                    OK
53
 
mysql.time_zone_leap_second                        OK
54
 
mysql.time_zone_name                               OK
55
 
mysql.time_zone_transition                         OK
56
 
mysql.time_zone_transition_type                    OK
57
 
mysql.user                                         OK
58
 
create table t1 (a int);
59
 
create view v1 as select * from t1;
60
 
test.t1                                            OK
61
 
test.t1                                            OK
62
 
drop view v1;
63
 
drop table t1;
64
3
create table `t``1`(a int);
65
4
create table `t 1`(a int);
66
5
test.t 1                                           OK
68
7
drop table `t``1`, `t 1`;
69
8
create database d_bug25347;
70
9
use d_bug25347;
71
 
create table t_bug25347 (a int);
72
 
create view v_bug25347 as select * from t_bug25347;
 
10
create table t_bug25347 (a int) engine=MyISAM;
73
11
insert into t_bug25347 values (1),(2),(3);
74
12
flush tables;
75
13
removing and creating
76
14
d_bug25347.t_bug25347
77
15
Error    : Incorrect file format 't_bug25347'
78
 
error    : Corrupt
 
16
status   : OK
79
17
insert into t_bug25347 values (4),(5),(6);
80
18
ERROR HY000: Incorrect file format 't_bug25347'
81
19
d_bug25347.t_bug25347
90
28
7
91
29
8
92
30
9
93
 
select * from v_bug25347;
94
 
a
95
 
1
96
 
2
97
 
3
98
 
7
99
 
8
100
 
9
101
 
drop view v_bug25347;
102
31
drop table t_bug25347;
103
32
drop database d_bug25347;
104
33
use test;
105
34
End of 5.0 tests
106
 
create table t1(a int);
107
 
create view v1 as select * from t1;
108
 
show tables;
109
 
Tables_in_test
110
 
t1
111
 
v1
112
 
show tables;
113
 
Tables_in_test
114
 
t1
115
 
#mysql50#v-1
116
 
v1
117
 
show tables;
118
 
Tables_in_test
119
 
t1
120
 
v1
121
 
v-1
122
 
drop view v1, `v-1`;
123
 
drop table t1;