diff options
| author | unknown <patg@govinda.patg.net> | 2006-01-27 15:43:44 -0800 |
|---|---|---|
| committer | unknown <patg@govinda.patg.net> | 2006-01-27 15:43:44 -0800 |
| commit | e13a840ad7618b583085e40459faf9a8f1dc6ff3 (patch) | |
| tree | eaca100f1a55995832aa43fdfe315f6434a06da4 /mysql-test/t/federated.test | |
| parent | ae951e0f72bb3474eaaa282342f17b645d64ac87 (diff) | |
| download | mariadb-git-e13a840ad7618b583085e40459faf9a8f1dc6ff3.tar.gz | |
BUG# 14768
Added fixes to make last_insert_id() to work.
mysql-test/r/federated.result:
BUG #14768
New test results for last_insert_id()
mysql-test/t/federated.test:
BUG #14768
Tests for last_insert_id()
sql/ha_federated.cc:
BUG# 14768
* Added code to set last_insert_id()
* Added code to free share->scheme
sql/ha_federated.h:
BUG #14768
New method for setting last_insert_id()
Diffstat (limited to 'mysql-test/t/federated.test')
| -rw-r--r-- | mysql-test/t/federated.test | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/mysql-test/t/federated.test b/mysql-test/t/federated.test index b6b3b90c083..e550c5d3ac0 100644 --- a/mysql-test/t/federated.test +++ b/mysql-test/t/federated.test @@ -1224,4 +1224,34 @@ drop table federated.t1; connection slave; drop table federated.t1; +# +# BUG# 14768 test auto_increment last_insert_id() +# +connection slave; +DROP TABLE IF EXISTS federated.t1; +CREATE TABLE federated.t1 ( + `id` int(20) NOT NULL auto_increment, + PRIMARY KEY (`id`)); + +connection master; +DROP TABLE IF EXISTS federated.t1; +eval CREATE TABLE federated.t1 ( + `id` int(20) NOT NULL auto_increment, + PRIMARY KEY (`id`) + ) + ENGINE="FEDERATED" DEFAULT CHARSET=latin1 + CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/federated/t1'; + +INSERT INTO federated.t1 VALUES (); +SELECT LAST_INSERT_ID(); +INSERT INTO federated.t1 VALUES (); +SELECT LAST_INSERT_ID(); +INSERT INTO federated.t1 VALUES (); +SELECT LAST_INSERT_ID(); +INSERT INTO federated.t1 VALUES (); +SELECT LAST_INSERT_ID(); +INSERT INTO federated.t1 VALUES (); +SELECT LAST_INSERT_ID(); +SELECT * FROM federated.t1; + source include/federated_cleanup.inc; |