From 48272222a7e4013073f51825f996b2c979f29b6a Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 30 Jun 2003 13:28:36 +0300 Subject: LAST_INSERT_ID() should not be set if we couldn't generate an auto_increment id. mysql-test/r/auto_increment.result: Update after auto_increment fix mysql-test/t/auto_increment.test: Another fix for LAST_INSERT_ID() sql/handler.cc: Another fix for LAST_INSERT_ID() sql/sql_class.h: Another fix for LAST_INSERT_ID() --- mysql-test/t/auto_increment.test | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/t/auto_increment.test') diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index 63fdfded6d0..189320a8dcb 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -80,6 +80,9 @@ insert into t1 set i = 254; insert into t1 set i = null; select last_insert_id(); --error 1062 +insert into t1 set i = 254; +select last_insert_id(); +--error 1062 insert into t1 set i = null; select last_insert_id(); drop table t1; @@ -100,5 +103,6 @@ select last_insert_id(); --error 1062 insert into t1 values (NULL, 10); select last_insert_id(); + drop table t1; -- cgit v1.2.1