diff options
| author | unknown <bar@mysql.com> | 2006-06-22 19:40:59 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-06-22 19:40:59 +0500 |
| commit | 9040e4a9ce866c58ed77738cb13fdcf8fdf4233a (patch) | |
| tree | 6195df0469a9d3c03b7c99c7c24e7251668ff347 /mysql-test/t/variables.test | |
| parent | 4af5e597ef8c22fdf8c4b88ba7d12d113e56e81f (diff) | |
| download | mariadb-git-9040e4a9ce866c58ed77738cb13fdcf8fdf4233a.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.
mysql-test/r/variables.result:
Additional test
mysql-test/t/variables.test:
Additional test
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index d0def5af8d0..68efcafd1e0 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -308,6 +308,12 @@ select @@session.insert_id; set @save_insert_id=@@session.insert_id; set session insert_id=20; select @@session.insert_id; + +set session last_insert_id=100; +select @@session.insert_id; +select @@session.last_insert_id; +select @@session.insert_id; + set @@session.insert_id=@save_insert_id; select @@session.insert_id; |