← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/mysqlcheck.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/mysqlcheck.result
 
1
DROP TABLE IF EXISTS t1, `t``1`, `t 1`;
 
2
drop view if exists v1;
 
3
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
create table `t``1`(a int);
 
65
create table `t 1`(a int);
 
66
test.t 1                                           OK
 
67
test.t`1                                           OK
 
68
drop table `t``1`, `t 1`;
 
69
create database d_bug25347;
 
70
use d_bug25347;
 
71
create table t_bug25347 (a int);
 
72
create view v_bug25347 as select * from t_bug25347;
 
73
insert into t_bug25347 values (1),(2),(3);
 
74
flush tables;
 
75
removing and creating
 
76
d_bug25347.t_bug25347
 
77
Error    : Incorrect file format 't_bug25347'
 
78
error    : Corrupt
 
79
insert into t_bug25347 values (4),(5),(6);
 
80
ERROR HY000: Incorrect file format 't_bug25347'
 
81
d_bug25347.t_bug25347
 
82
warning  : Number of rows changed from 0 to 3
 
83
status   : OK
 
84
insert into t_bug25347 values (7),(8),(9);
 
85
select * from t_bug25347;
 
86
a
 
87
1
 
88
2
 
89
3
 
90
7
 
91
8
 
92
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
drop table t_bug25347;
 
103
drop database d_bug25347;
 
104
use test;
 
105
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;