diff options
| author | bar@mysql.com <> | 2006-06-22 19:40:59 +0500 |
|---|---|---|
| committer | bar@mysql.com <> | 2006-06-22 19:40:59 +0500 |
| commit | 75351dc0a5a55acba5fdcb6ec433f0028076c7d5 (patch) | |
| tree | 6195df0469a9d3c03b7c99c7c24e7251668ff347 /mysql-test/r/variables.result | |
| parent | 4bd163b6989bcf14a6402ed7974b630e82621a6c (diff) | |
| download | mariadb-git-75351dc0a5a55acba5fdcb6ec433f0028076c7d5.tar.gz | |
Additional test for Bugs#20392: INSERT_ID session variable has weird value
sys_var_insert_id returned LAST_INSERT_ID instead of INSERT_ID,
as Guilhem suggested.
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 1016cf27c18..4ddc7e2ab87 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -429,6 +429,16 @@ set session insert_id=20; select @@session.insert_id; @@session.insert_id 20 +set session last_insert_id=100; +select @@session.insert_id; +@@session.insert_id +20 +select @@session.last_insert_id; +@@session.last_insert_id +100 +select @@session.insert_id; +@@session.insert_id +20 set @@session.insert_id=@save_insert_id; select @@session.insert_id; @@session.insert_id |