← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/t/help.test

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/t/help.test
13
13
#      impossible_category_3
14
14
#                            impossible_function_7 
15
15
 
16
 
insert into mysql.help_category(help_category_id,name)values(1,'impossible_category_1');
17
 
select @category1_id:= 1;
18
 
insert into mysql.help_category(help_category_id,name)values(2,'impossible_category_2');
19
 
select @category2_id:= 2;
20
 
insert into mysql.help_category(help_category_id,name,parent_category_id)values(3,'impossible_category_3',@category2_id);
21
 
select @category3_id:= 3;
22
 
 
23
 
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(1,'impossible_function_1',@category1_id,'description of \n impossible_function1\n','example of \n impossible_function1');
24
 
select @topic1_id:= 1;
25
 
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(2,'impossible_function_2',@category1_id,'description of \n impossible_function2\n','example of \n impossible_function2');
26
 
select @topic2_id:= 2;
27
 
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(3,'impossible_function_3',@category2_id,'description of \n impossible_function3\n','example of \n impossible_function3');
28
 
select @topic3_id:= 3;
29
 
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(4,'impossible_function_4',@category2_id,'description of \n impossible_function4\n','example of \n impossible_function4');
30
 
select @topic4_id:= 4;
31
 
insert into mysql.help_topic(help_topic_id,name,help_category_id,description,example)values(5,'impossible_function_7',@category3_id,'description of \n impossible_function5\n','example of \n impossible_function7');
32
 
select @topic5_id:= 5;
33
 
 
34
 
insert into mysql.help_keyword(help_keyword_id,name)values(1,'impossible_function_1');
35
 
select @keyword1_id:= 1;
36
 
insert into mysql.help_keyword(help_keyword_id,name)values(2,'impossible_function_5');
37
 
select @keyword2_id:= 2;
38
 
insert into mysql.help_keyword(help_keyword_id,name)values(3,'impossible_function_6');
39
 
select @keyword3_id:= 3;
 
16
insert into mysql.help_category(help_category_id,name)values(10001,'impossible_category_1');
 
17
select @category1_id:= 10001;
 
18
insert into mysql.help_category(help_category_id,name)values(10002,'impossible_category_2');
 
19
select @category2_id:= 10002;
 
20
insert into mysql.help_category(help_category_id,name,parent_category_id)values(10003,'impossible_category_3',@category2_id);
 
21
select @category3_id:= 10003;
 
22
 
 
23
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');
 
24
select @topic1_id:= 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
select @topic2_id:= 10102;
 
27
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');
 
28
select @topic3_id:= 10103;
 
29
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');
 
30
select @topic4_id:= 10104;
 
31
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');
 
32
select @topic5_id:= 10105;
 
33
 
 
34
insert into mysql.help_keyword(help_keyword_id,name)values(10201,'impossible_function_1');
 
35
select @keyword1_id:= 10201;
 
36
insert into mysql.help_keyword(help_keyword_id,name)values(10202,'impossible_function_5');
 
37
select @keyword2_id:= 10202;
 
38
insert into mysql.help_keyword(help_keyword_id,name)values(10203,'impossible_function_6');
 
39
select @keyword3_id:= 10203;
40
40
 
41
41
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword1_id,@topic2_id);
42
42
insert into mysql.help_relation(help_keyword_id,help_topic_id)values(@keyword2_id,@topic1_id);
114
114
delete from mysql.help_relation where help_keyword_id=@keyword3_id and help_topic_id=@topic3_id;
115
115
delete from mysql.help_relation where help_keyword_id=@keyword3_id and help_topic_id=@topic4_id;
116
116
 
117
 
# End of 4.1 tests
 
117
--echo End of 4.1 tests.
 
118
 
 
119
#
 
120
# Test that we can use HELP even under LOCK TABLES.  See bug#9953:
 
121
# CONVERT_TZ requires mysql.time_zone_name to be locked.
 
122
#
 
123
--disable_warnings
 
124
DROP TABLE IF EXISTS t1;
 
125
--enable_warnings
 
126
 
 
127
CREATE TABLE t1 (i INT);
 
128
 
 
129
LOCK TABLES t1 WRITE;
 
130
 
 
131
HELP no_such_topic;
 
132
 
 
133
UNLOCK TABLES;
 
134
 
 
135
DROP TABLE t1;
 
136
 
 
137
 
 
138
--echo End of 5.1 tests.