← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/help.result
 
1
insert into mysql.help_category(help_category_id,name)values(10001,'impossible_category_1');
 
2
Warnings:
 
3
Warning 1364    Field 'url' doesn't have a default value
 
4
select @category1_id:= 10001;
 
5
@category1_id:= 10001
 
6
10001
 
7
insert into mysql.help_category(help_category_id,name)values(10002,'impossible_category_2');
 
8
Warnings:
 
9
Warning 1364    Field 'url' doesn't have a default value
 
10
select @category2_id:= 10002;
 
11
@category2_id:= 10002
 
12
10002
 
13
insert into mysql.help_category(help_category_id,name,parent_category_id)values(10003,'impossible_category_3',@category2_id);
 
14
Warnings:
 
15
Warning 1364    Field 'url' doesn't have a default value
 
16
select @category3_id:= 10003;
 
17
@category3_id:= 10003
 
18
10003
 
19
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10101,'impossible_function_1',@category1_id,'description of \n impossible_function1\n','example of \n impossible_function1');
 
20
Warnings:
 
21
Warning 1364    Field 'url' doesn't have a default value
 
22
select @topic1_id:= 10101;
 
23
@topic1_id:= 10101
 
24
10101
 
25
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10102,'impossible_function_2',@category1_id,'description of \n impossible_function2\n','example of \n impossible_function2');
 
26
Warnings:
 
27
Warning 1364    Field 'url' doesn't have a default value
 
28
select @topic2_id:= 10102;
 
29
@topic2_id:= 10102
 
30
10102
 
31
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10103,'impossible_function_3',@category2_id,'description of \n impossible_function3\n','example of \n impossible_function3');
 
32
Warnings:
 
33
Warning 1364    Field 'url' doesn't have a default value
 
34
select @topic3_id:= 10103;
 
35
@topic3_id:= 10103
 
36
10103
 
37
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10104,'impossible_function_4',@category2_id,'description of \n impossible_function4\n','example of \n impossible_function4');
 
38
Warnings:
 
39
Warning 1364    Field 'url' doesn't have a default value
 
40
select @topic4_id:= 10104;
 
41
@topic4_id:= 10104
 
42
10104
 
43
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(10105,'impossible_function_7',@category3_id,'description of \n impossible_function5\n','example of \n impossible_function7');
 
44
Warnings:
 
45
Warning 1364    Field 'url' doesn't have a default value
 
46
select @topic5_id:= 10105;
 
47
@topic5_id:= 10105
 
48
10105
 
49
insert into mysql.help_keyword(help_keyword_id,name)values(10201,'impossible_function_1');
 
50
select @keyword1_id:= 10201;
 
51
@keyword1_id:= 10201
 
52
10201
 
53
insert into mysql.help_keyword(help_keyword_id,name)values(10202,'impossible_function_5');
 
54
select @keyword2_id:= 10202;
 
55
@keyword2_id:= 10202
 
56
10202
 
57
insert into mysql.help_keyword(help_keyword_id,name)values(10203,'impossible_function_6');
 
58
select @keyword3_id:= 10203;
 
59
@keyword3_id:= 10203
 
60
10203
 
61
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword1_id,@topic2_id);
 
62
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword2_id,@topic1_id);
 
63
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword3_id,@topic3_id);
 
64
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword3_id,@topic4_id);
 
65
help 'function_of_my_dream';
 
66
name    is_it_category
 
67
help '%possible_f%';
 
68
name    is_it_category
 
69
impossible_function_1   N
 
70
impossible_function_2   N
 
71
impossible_function_3   N
 
72
impossible_function_4   N
 
73
impossible_function_7   N
 
74
help 'impossible_func%';
 
75
name    is_it_category
 
76
impossible_function_1   N
 
77
impossible_function_2   N
 
78
impossible_function_3   N
 
79
impossible_function_4   N
 
80
impossible_function_7   N
 
81
help 'impossible_category%';
 
82
name    is_it_category
 
83
impossible_category_1   Y
 
84
impossible_category_2   Y
 
85
impossible_category_3   Y
 
86
help 'impossible_%';
 
87
name    is_it_category
 
88
impossible_function_1   N
 
89
impossible_function_2   N
 
90
impossible_function_3   N
 
91
impossible_function_4   N
 
92
impossible_function_7   N
 
93
impossible_category_1   Y
 
94
impossible_category_2   Y
 
95
impossible_category_3   Y
 
96
help '%function_1';
 
97
name    description     example
 
98
impossible_function_1   description of 
 
99
 impossible_function1
 
100
        example of 
 
101
 impossible_function1
 
102
help '%function_2';
 
103
name    description     example
 
104
impossible_function_2   description of 
 
105
 impossible_function2
 
106
        example of 
 
107
 impossible_function2
 
108
help '%function_3';
 
109
name    description     example
 
110
impossible_function_3   description of 
 
111
 impossible_function3
 
112
        example of 
 
113
 impossible_function3
 
114
help '%function_4';
 
115
name    description     example
 
116
impossible_function_4   description of 
 
117
 impossible_function4
 
118
        example of 
 
119
 impossible_function4
 
120
help '%function_5';
 
121
name    description     example
 
122
impossible_function_1   description of 
 
123
 impossible_function1
 
124
        example of 
 
125
 impossible_function1
 
126
help '%function_6';
 
127
name    is_it_category
 
128
impossible_function_3   N
 
129
impossible_function_4   N
 
130
help '%function_7';
 
131
name    description     example
 
132
impossible_function_7   description of 
 
133
 impossible_function5
 
134
        example of 
 
135
 impossible_function7
 
136
help '%category_2';
 
137
source_category_name    name    is_it_category
 
138
impossible_category_2   impossible_function_3   N
 
139
impossible_category_2   impossible_function_4   N
 
140
impossible_category_2   impossible_category_3   Y
 
141
help 'impossible_function_1';
 
142
name    description     example
 
143
impossible_function_1   description of 
 
144
 impossible_function1
 
145
        example of 
 
146
 impossible_function1
 
147
help 'impossible_category_1';
 
148
source_category_name    name    is_it_category
 
149
impossible_category_1   impossible_function_1   N
 
150
impossible_category_1   impossible_function_2   N
 
151
alter table mysql.help_relation engine=innodb;
 
152
alter table mysql.help_keyword engine=innodb;
 
153
alter table mysql.help_topic engine=innodb;
 
154
alter table mysql.help_category engine=innodb;
 
155
help 'function_of_my_dream';
 
156
name    is_it_category
 
157
help '%possible_f%';
 
158
name    is_it_category
 
159
impossible_function_1   N
 
160
impossible_function_2   N
 
161
impossible_function_3   N
 
162
impossible_function_4   N
 
163
impossible_function_7   N
 
164
help 'impossible_func%';
 
165
name    is_it_category
 
166
impossible_function_1   N
 
167
impossible_function_2   N
 
168
impossible_function_3   N
 
169
impossible_function_4   N
 
170
impossible_function_7   N
 
171
help 'impossible_category%';
 
172
name    is_it_category
 
173
impossible_category_1   Y
 
174
impossible_category_2   Y
 
175
impossible_category_3   Y
 
176
help 'impossible_%';
 
177
name    is_it_category
 
178
impossible_function_1   N
 
179
impossible_function_2   N
 
180
impossible_function_3   N
 
181
impossible_function_4   N
 
182
impossible_function_7   N
 
183
impossible_category_1   Y
 
184
impossible_category_2   Y
 
185
impossible_category_3   Y
 
186
help '%function_1';
 
187
name    description     example
 
188
impossible_function_1   description of 
 
189
 impossible_function1
 
190
        example of 
 
191
 impossible_function1
 
192
help '%function_2';
 
193
name    description     example
 
194
impossible_function_2   description of 
 
195
 impossible_function2
 
196
        example of 
 
197
 impossible_function2
 
198
help '%function_3';
 
199
name    description     example
 
200
impossible_function_3   description of 
 
201
 impossible_function3
 
202
        example of 
 
203
 impossible_function3
 
204
help '%function_4';
 
205
name    description     example
 
206
impossible_function_4   description of 
 
207
 impossible_function4
 
208
        example of 
 
209
 impossible_function4
 
210
help '%function_5';
 
211
name    description     example
 
212
impossible_function_1   description of 
 
213
 impossible_function1
 
214
        example of 
 
215
 impossible_function1
 
216
help '%function_6';
 
217
name    is_it_category
 
218
impossible_function_3   N
 
219
impossible_function_4   N
 
220
help '%function_7';
 
221
name    description     example
 
222
impossible_function_7   description of 
 
223
 impossible_function5
 
224
        example of 
 
225
 impossible_function7
 
226
help '%category_2';
 
227
source_category_name    name    is_it_category
 
228
impossible_category_2   impossible_function_3   N
 
229
impossible_category_2   impossible_function_4   N
 
230
impossible_category_2   impossible_category_3   Y
 
231
help 'impossible_function_1';
 
232
name    description     example
 
233
impossible_function_1   description of 
 
234
 impossible_function1
 
235
        example of 
 
236
 impossible_function1
 
237
help 'impossible_category_1';
 
238
source_category_name    name    is_it_category
 
239
impossible_category_1   impossible_function_1   N
 
240
impossible_category_1   impossible_function_2   N
 
241
alter table mysql.help_relation engine=myisam;
 
242
alter table mysql.help_keyword engine=myisam;
 
243
alter table mysql.help_topic engine=myisam;
 
244
alter table mysql.help_category engine=myisam;
 
245
delete from mysql.help_topic where help_topic_id=@topic1_id;
 
246
delete from mysql.help_topic where help_topic_id=@topic2_id;
 
247
delete from mysql.help_topic where help_topic_id=@topic3_id;
 
248
delete from mysql.help_topic where help_topic_id=@topic4_id;
 
249
delete from mysql.help_topic where help_topic_id=@topic5_id;
 
250
delete from mysql.help_category where help_category_id=@category3_id;
 
251
delete from mysql.help_category where help_category_id=@category2_id;
 
252
delete from mysql.help_category where help_category_id=@category1_id;
 
253
delete from mysql.help_keyword where help_keyword_id=@keyword1_id;
 
254
delete from mysql.help_keyword where help_keyword_id=@keyword2_id;
 
255
delete from mysql.help_keyword where help_keyword_id=@keyword3_id;
 
256
delete from mysql.help_relation where help_keyword_id=@keyword1_id and help_topic_id=@topic2_id;
 
257
delete from mysql.help_relation where help_keyword_id=@keyword2_id and help_topic_id=@topic1_id;
 
258
delete from mysql.help_relation where help_keyword_id=@keyword3_id and help_topic_id=@topic3_id;
 
259
delete from mysql.help_relation where help_keyword_id=@keyword3_id and help_topic_id=@topic4_id;
 
260
End of 4.1 tests.
 
261
DROP TABLE IF EXISTS t1;
 
262
CREATE TABLE t1 (i INT);
 
263
LOCK TABLES t1 WRITE;
 
264
HELP no_such_topic;
 
265
name    is_it_category
 
266
UNLOCK TABLES;
 
267
DROP TABLE t1;
 
268
End of 5.1 tests.