From 2aa3ff8eb90b8fcbee4b690aa21e9fc8791b0538 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 25 May 2006 12:13:47 +0200 Subject: ndb - bug#14509 v5.1 part 2/2 : handler level mysql-test/r/ndb_basic.result: put auto-incr range under NDB_SHARE until otherwise decided.. makes auto-incr process-global per table. each use requires mutex mysql-test/t/ndb_alter_table.test: put auto-incr range under NDB_SHARE until otherwise decided.. makes auto-incr process-global per table. each use requires mutex sql/ha_ndbcluster.cc: put auto-incr range under NDB_SHARE until otherwise decided.. makes auto-incr process-global per table. each use requires mutex sql/ha_ndbcluster.h: put auto-incr range under NDB_SHARE until otherwise decided.. makes auto-incr process-global per table. each use requires mutex --- mysql-test/t/ndb_alter_table.test | 30 +++++++++++++++--------------- 1 file changed, 15 insertions(+), 15 deletions(-) (limited to 'mysql-test/t/ndb_alter_table.test') diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index cd5c4819c51..8e3b4a6ca89 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -325,21 +325,6 @@ on t1 (c010, c011, c012, c013); drop table t1; -# simple test that auto incr is not lost at rename or alter -create table t1 (a int primary key auto_increment, b int) engine=ndb; -insert into t1 (b) values (101),(102),(103); -select * from t1 where a = 3; -alter table t1 rename t2; -insert into t2 (b) values (201),(202),(203); -select * from t2 where a = 6; -alter table t2 add c int; -insert into t2 (b) values (301),(302),(303); -select * from t2 where a = 9; -alter table t2 rename t1; -insert into t1 (b) values (401),(402),(403); -select * from t1 where a = 12; -drop table t1; - # End of 4.1 tests # On-line alter table @@ -398,3 +383,18 @@ LOAD DATA INFILE 'tmp.dat' INTO TABLE ndb_show_tables; select 'no_copy' from ndb_show_tables where id = @t1_id and name like '%t1%'; DROP TABLE t1, ndb_show_tables; + +# simple test that auto incr is not lost at rename or alter +create table t1 (a int primary key auto_increment, b int) engine=ndb; +insert into t1 (b) values (101),(102),(103); +select * from t1 where a = 3; +alter table t1 rename t2; +insert into t2 (b) values (201),(202),(203); +select * from t2 where a = 6; +alter table t2 add c int; +insert into t2 (b) values (301),(302),(303); +select * from t2 where a = 9; +alter table t2 rename t1; +insert into t1 (b) values (401),(402),(403); +select * from t1 where a = 12; +drop table t1; -- cgit v1.2.1