diff options
| author | unknown <ramil@mysql.com> | 2006-06-07 14:01:10 +0500 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2006-06-07 14:01:10 +0500 |
| commit | febe7eb64a7472823294ae7295194af2be1b3497 (patch) | |
| tree | d8d09c3be3884fca5eaa05199a9a076fb7b2ca13 /mysql-test/t/rpl_log.test | |
| parent | b29e052dbfe5021fefb5d312860a4980c851c24b (diff) | |
| download | mariadb-git-febe7eb64a7472823294ae7295194af2be1b3497.tar.gz | |
Fix for bug #6880: LAST_INSERT_ID() within a statement
mysql-test/r/auto_increment.result:
Fix for bug #6880: LAST_INSERT_ID() within a statement
- test result
mysql-test/r/rpl_log.result:
Fix for bug #6880: LAST_INSERT_ID() within a statement
- test result
mysql-test/t/auto_increment.test:
Fix for bug #6880: LAST_INSERT_ID() within a statement
- test case
mysql-test/t/rpl_log.test:
Fix for bug #6880: LAST_INSERT_ID() within a statement
- test case
sql/item_func.cc:
Fix for bug #6880: LAST_INSERT_ID() within a statement
- return the first thd->last_insert_id set (within a query)
Diffstat (limited to 'mysql-test/t/rpl_log.test')
| -rw-r--r-- | mysql-test/t/rpl_log.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_log.test b/mysql-test/t/rpl_log.test index 7a67ab2311a..08aa3b28850 100644 --- a/mysql-test/t/rpl_log.test +++ b/mysql-test/t/rpl_log.test @@ -108,4 +108,18 @@ show slave status; --error 1220 show binlog events in 'slave-bin.000005' from 4; +# +# Bug #6880: LAST_INSERT_ID() within a statement +# + +create table t1(a int auto_increment primary key, b int); +insert into t1 values (NULL, 1); +reset master; +set insert_id=5; +insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id()); +--replace_result $VERSION VERSION +show binlog events; +select * from t1; +drop table t1; + # End of 4.1 tests |