diff options
| author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
|---|---|---|
| committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
| commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
| tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/suite/sys_vars/r/last_insert_id_func.result | |
| parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
| download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz | |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
Diffstat (limited to 'mysql-test/suite/sys_vars/r/last_insert_id_func.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/last_insert_id_func.result | 93 |
1 files changed, 93 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/last_insert_id_func.result b/mysql-test/suite/sys_vars/r/last_insert_id_func.result new file mode 100644 index 00000000000..2f07aeeec05 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/last_insert_id_func.result @@ -0,0 +1,93 @@ +drop table if exists t1; +## Creating new table ## +CREATE TABLE t1 +( +id INT NOT NULL auto_increment, +PRIMARY KEY (id), +name VARCHAR(30) +) ENGINE = INNODB; +'#--------------------FN_DYNVARS_059_01-------------------------#' +## Verifying initial value of ## +SELECT @@session.last_insert_id; +@@session.last_insert_id +0 +## Inserting records in table t1 ## +INSERT into t1(name) values('Record_1'); +INSERT into t1(name) values('Record_2'); +SELECT * from t1; +id name +1 Record_1 +2 Record_2 +## Verifying value of variable after inserting some rows ## +SELECT @@session.last_insert_id = 2; +@@session.last_insert_id = 2 +1 +'#--------------------FN_DYNVARS_059_02-------------------------#' +## Creating & connecting to new connection test_con1 ## +SET @@autocommit = 0; +## Verifying initial value of variable in new connection ## +SELECT @@session.last_insert_id; +@@session.last_insert_id +0 +## Inserting rows in table t1 ## +START TRANSACTION; +INSERT into t1(name) values('Record_3'); +INSERT into t1(name) values('Record_4'); +INSERT into t1(name) values('Record_5'); +## Verifying value of variable without committing rows ## +SELECT @@session.last_insert_id; +@@session.last_insert_id +5 +'#--------------------FN_DYNVARS_059_03-------------------------#' +## Creating & connecting to new connection test_con2 ## +## Inserting values through new connection ## +INSERT into t1(name) values('Record_6'); +INSERT into t1(name) values('Record_7'); +SELECT * from t1; +id name +1 Record_1 +2 Record_2 +6 Record_6 +7 Record_7 +## Verifying value of variable in second connection ## +SELECT @@last_insert_id; +@@last_insert_id +7 +'#--------------------FN_DYNVARS_059_04-------------------------#' +## Switching to test_con1 ## +## Verifying all records in table & value of variable ## +SELECT * from t1; +id name +1 Record_1 +2 Record_2 +3 Record_3 +4 Record_4 +5 Record_5 +6 Record_6 +7 Record_7 +SELECT @@session.last_insert_id; +@@session.last_insert_id +5 +## Commiting records in table ## +COMMIT; +SELECT @@session.last_insert_id; +@@session.last_insert_id +5 +## Switching to test_con2 & verifying value of variable in it ## +SELECT @@session.last_insert_id; +@@session.last_insert_id +7 +'#--------------------FN_DYNVARS_059_05-------------------------#' +## Setting value of variable ## +SET @@session.last_insert_id = 100; +SELECT @@session.last_insert_id; +@@session.last_insert_id +100 +## Inserting new record and verifying variable's effect on it ## +INSERT into t1(name) values('Record_8'); +SELECT @@session.last_insert_id; +@@session.last_insert_id +8 +## Dropping table t1 ## +drop table t1; +## Disconnecting both the connections ## |