bzr commit into mysql-5.1-telco-6.2 branch (Martin.Skold:3017) Bug#47865

[Martin Skold]

#At file:///home/marty/MySQL/mysql-5.1-telco-6.2/

 3017 Martin Skold	2009-10-08
      Bug#47865 SHOW CREATE TABLE does not show the current auto_increment number for ndb tables: added test case
      modified:
        mysql-test/suite/ndb/r/ndb_auto_increment.result
        mysql-test/suite/ndb/t/ndb_auto_increment.test

=== modified file 'mysql-test/suite/ndb/r/ndb_auto_increment.result'
--- a/mysql-test/suite/ndb/r/ndb_auto_increment.result	2009-09-03 07:49:50 +0000
+++ b/mysql-test/suite/ndb/r/ndb_auto_increment.result	2009-10-08 09:58:57 +0000
@@ -499,3 +499,13 @@ evend_id	server_id
 drop trigger tr1;
 drop table t1, t2;
 drop trigger if exists tr1;
+create table t1 (a int primary key auto_increment, b int) engine=ndb;
+insert into t1 values (null,1),(null,2),(null,3);
+show create table t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` int(11) NOT NULL AUTO_INCREMENT,
+  `b` int(11) DEFAULT NULL,
+  PRIMARY KEY (`a`)
+) ENGINE=ndbcluster AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
+drop table t1;

=== modified file 'mysql-test/suite/ndb/t/ndb_auto_increment.test'
--- a/mysql-test/suite/ndb/t/ndb_auto_increment.test	2009-09-03 07:49:50 +0000
+++ b/mysql-test/suite/ndb/t/ndb_auto_increment.test	2009-10-08 09:58:57 +0000
@@ -378,3 +378,15 @@ connection server2;
 --disable_warnings
 drop trigger if exists tr1;
 --enable_warnings
+
+#
+# Bug #47865  	SHOW CREATE TABLE does not show the current auto_increment number for ndb tables
+#
+
+create table t1 (a int primary key auto_increment, b int) engine=ndb;
+
+insert into t1 values (null,1),(null,2),(null,3);
+
+show create table t1;
+
+drop table t1;
\ No newline at end of file