1
############## mysql-test\t\completion_type_func.test #########################
3
# Variable Name: completion_type #
4
# Scope: GLOBAL & SESSION #
5
# Access Type: Dynamic #
8
# Valid Values: 0,1 & 2 #
11
# Creation Date: 2008-03-07 #
12
# Author: Salman Rawala #
14
# Description: Test Cases of Dynamic System Variable "completion_type" #
15
# that checks functinality of this variable #
17
# Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
18
# server-system-variables.html#option_mysqld_completion_type #
20
################################################################################
22
--source include/have_innodb.inc
25
drop table if exists t1;
28
#########################
29
# Creating new table #
30
#########################
32
--echo ## Creating new table ##
35
id INT NOT NULL auto_increment,
40
--echo '#--------------------FN_DYNVARS_017_01-------------------------#'
41
#########################################################
42
# Setting initial value of completion_type to zero #
43
#########################################################
45
--echo ## Creating new connection ##
46
connect (test_con1,localhost,root,,);
49
INSERT into t1(name) values('Record_1');
53
--echo ## Setting value of variable to 0 ##
54
SET @@session.completion_type = 0;
56
--echo ## Here commit & rollback should work normally ##
59
INSERT into t1(name) values('Record_2');
60
INSERT into t1(name) values('Record_3');
62
DELETE FROM t1 where id = 2;
68
INSERT into t1(name) values('Record_4');
69
INSERT into t1(name) values('Record_5');
73
--echo '#--------------------FN_DYNVARS_017_02-------------------------#'
74
#########################################################
75
# Setting initial value of completion_type to 2 #
76
#########################################################
78
SET @@session.completion_type = 2;
80
--echo ## Here commit should work as COMMIT RELEASE ##
83
INSERT into t1(name) values('Record_6');
84
INSERT into t1(name) values('Record_7');
87
--echo ## Inserting rows should give error here because connection should ##
88
--echo ## disconnect after using COMMIT ##
89
--Error 2006,2013,1053
90
INSERT into t1(name) values('Record_4');
92
--echo ## Creating new connection test_con2 ##
93
connect (test_con2,localhost,root,,);
95
SET @@session.completion_type = 2;
97
--echo ## Inserting rows and using Rollback which should Rollback & release ##
100
INSERT into t1(name) values('Record_8');
101
INSERT into t1(name) values('Record_9');
104
--Error 2006,2013,1053
105
INSERT into t1(name) values('Record_4');