diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-01-30 15:44:49 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-01-30 15:44:49 +0200 |
| commit | 87eb2cb938382b545158987a1cc6bc170588db3a (patch) | |
| tree | a6a00e2376ec5327aa29d5a5b2441a06f8d146d4 /mysql-test/suite/sys_vars/r/insert_id_func.result | |
| parent | 093a6dd90e12ca41e7e415f57f5a91181bf1959e (diff) | |
| parent | f7a24d72dc7a86341da4634f6d1a71f1ea77000b (diff) | |
| download | mariadb-git-87eb2cb938382b545158987a1cc6bc170588db3a.tar.gz | |
merged 5.1-main -> 5.1-bugteam
Diffstat (limited to 'mysql-test/suite/sys_vars/r/insert_id_func.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/insert_id_func.result | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/insert_id_func.result b/mysql-test/suite/sys_vars/r/insert_id_func.result new file mode 100644 index 00000000000..f03b3ea4851 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/insert_id_func.result @@ -0,0 +1,68 @@ +drop table if exists t1; +## Creating new table t1 ## +CREATE TABLE t1 +( +id INT NOT NULL auto_increment, +PRIMARY KEY (id), +name VARCHAR(30) +); +'#--------------------FN_DYNVARS_051_01-------------------------#' +## Setting value of variable to 100 ## +SET @@session.insert_id = 100; +SELECT @@session.insert_id; +@@session.insert_id +100 +## Inserting some rows in table ## +INSERT into t1(name) values('Record_1'); +INSERT into t1(name) values('Record_2'); +## Verifying rows in table ## +SELECT * from t1; +id name +100 Record_1 +101 Record_2 +SELECT @@session.insert_id; +@@session.insert_id +0 +INSERT into t1(name) values('Record_3'); +'#--------------------FN_DYNVARS_051_02-------------------------#' +## Creating & Connecting new connection test_con1 ## +## Setting value of insert_id to 50 ## +SET @@session.insert_id = 50; +SELECT @@session.insert_id; +@@session.insert_id +50 +## 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; +id name +100 Record_1 +101 Record_2 +102 Record_3 +50 Record_4 +103 Record_5 +104 Record_6 +'Bug#35376 Value of insert_id automatically resets to 0 after inserting +' 1st row' +'#--------------------FN_DYNVARS_051_03-------------------------#' +## Creating and switching to new connection test_con2 ## +## Setting session value of variable to 25 ## +SET @@session.insert_id = 25; +## Inserting some rows in table ## +INSERT into t1(name) values('Record_7'); +INSERT into t1(name) values('Record_8'); +## Verifying data in table t1 ## +SELECT * from t1; +id name +100 Record_1 +101 Record_2 +102 Record_3 +50 Record_4 +103 Record_5 +104 Record_6 +25 Record_7 +105 Record_8 +## Dropping table t1 ## +drop table t1; +## Disconnecting connections ## |