diff options
| author | unknown <bar@mysql.com> | 2006-06-22 19:10:11 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2006-06-22 19:10:11 +0500 |
| commit | 4af5e597ef8c22fdf8c4b88ba7d12d113e56e81f (patch) | |
| tree | c3f6d852e20a5295c0717546027c3bef5459e476 /mysql-test/t/variables.test | |
| parent | 95d042771491313346286ff31bd7128cbe3629db (diff) | |
| download | mariadb-git-4af5e597ef8c22fdf8c4b88ba7d12d113e56e81f.tar.gz | |
Bugs#20392: INSERT_ID session variable has weird value
sys_var_insert_id returned LAST_INSERT_ID instead of INSERT_ID.
mysql-test/r/variables.result:
Adding test case
mysql-test/t/variables.test:
Adding test case
sql/set_var.cc:
Fixed that sys_var_insert_id returned last_indert_id instead of insert_id.
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index be1731e7493..d0def5af8d0 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -302,6 +302,16 @@ set wait_timeout=100; set log_warnings=1; # +# Bugs: #20392: INSERT_ID session variable has weird value +# +select @@session.insert_id; +set @save_insert_id=@@session.insert_id; +set session insert_id=20; +select @@session.insert_id; +set @@session.insert_id=@save_insert_id; +select @@session.insert_id; + +# # key buffer # |