diff options
Diffstat (limited to 'mysql-test/t/insert_id_func.test')
| -rw-r--r-- | mysql-test/t/insert_id_func.test | 113 |
1 files changed, 0 insertions, 113 deletions
diff --git a/mysql-test/t/insert_id_func.test b/mysql-test/t/insert_id_func.test deleted file mode 100644 index d7103f806bd..00000000000 --- a/mysql-test/t/insert_id_func.test +++ /dev/null @@ -1,113 +0,0 @@ -################### mysql-test\t\insert_id_func.test ########################## -# # -# Variable Name: insert_id # -# Scope: SESSION # -# Access Type: Dynamic # -# Data Type: numeric # -# Default Value:- # -# Range: - # -# # -# # -# Creation Date: 2008-03-07 # -# Author: Salman Rawala # -# # -# Description: Test Cases of Dynamic System Variable insert_id # -# that checks the functionality of this variable # -# # -# Reference: http://dev.mysql.com/doc/refman/5.1/en/ # -# server-system-variables.html # -# # -############################################################################### - - ---disable_warnings -drop table if exists t1; ---enable_warnings - -######################### -# Creating new table # -######################### - ---echo ## Creating new table t1 ## -CREATE TABLE t1 -( -id INT NOT NULL auto_increment, -PRIMARY KEY (id), -name VARCHAR(30) -); - ---echo '#--------------------FN_DYNVARS_051_01-------------------------#' -####################################################################### -# Setting initial value of insert_id and verifying its behavior # -####################################################################### - ---echo ## Setting value of variable to 100 ## -SET @@session.insert_id = 100; -SELECT @@session.insert_id; - ---echo ## Inserting some rows in table ## -INSERT into t1(name) values('Record_1'); -INSERT into t1(name) values('Record_2'); - ---echo ## Verifying rows in table ## -SELECT * from t1; -SELECT @@session.insert_id; - -INSERT into t1(name) values('Record_3'); - - - ---echo '#--------------------FN_DYNVARS_051_02-------------------------#' -########################################################## -# Verifying value of insert_id with new connection # -########################################################## - ---echo ## Creating & Connecting new connection test_con1 ## -connect (test_con1, localhost, root,,); -connection test_con1; - ---echo ## Setting value of insert_id to 50 ## -SET @@session.insert_id = 50; -SELECT @@session.insert_id; - ---echo ## Inserting rows in table t1 ## -INSERT into t1(name) values('Record_4'); -INSERT into t1(name) values('Record_5'); -INSERT into t1(name) values('Record_6'); - -SELECT * from t1; - ---echo 'Bug#35376 Value of insert_id automatically resets to 0 after inserting ---echo ' 1st row' - ---echo '#--------------------FN_DYNVARS_051_03-------------------------#' -############################################################################# -# Now verifying some new value of insert_id with second new connection # -############################################################################# - ---echo ## Creating and switching to new connection test_con2 ## -connect (test_con2, localhost, root,,); -connection test_con2; - ---echo ## Setting session value of variable to 25 ## -SET @@session.insert_id = 25; - ---echo ## Inserting some rows in table ## -INSERT into t1(name) values('Record_7'); -INSERT into t1(name) values('Record_8'); - ---echo ## Verifying data in table t1 ## -SELECT * from t1; - - ---echo ## Dropping table t1 ## -drop table t1; - ---echo ## Disconnecting connections ## -disconnect test_con1; -disconnect test_con2; - - - - - |