bk commit into 5.1 tree (skozlov:1.2374)

[Serge Kozlov]

Below is the list of changes that have just been committed into a local
5.1 repository of ksm. When ksm does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2006-11-27 14:11:16+03:00, skozlov@stripped +1 -0
  WL#2811. Testcase for testing ndb_dd bugs 24521, 24560, 24578

  mysql-test/t/ndb_dd_basic2.test@stripped, 2006-11-27 14:11:13+03:00, skozlov@stripped +80 -0
    WL#2811. Testcase for testing ndb_dd bugs 24521, 24560, 24578

  mysql-test/t/ndb_dd_basic2.test@stripped, 2006-11-27 14:11:13+03:00, skozlov@stripped +0 -0

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	skozlov
# Host:	virtop.localdomain
# Root:	/space/skozlov/5.1
--- New file ---
+++ mysql-test/t/ndb_dd_basic2.test	06/11/27 14:11:13
#####################################################################
# Author: Serge Kozlov
# Date: 2006-11-21
# Purpose: To test some ndb_dd bugs
#####################################################################

-- source include/have_ndb.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

#####################################################################
#
# Bug#24521
#
#####################################################################

#CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 20M UNDO_BUFFER_SIZE 1M
ENGINE=NDB;
#CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 10M
ENGINE=NDB;

#let $1= 30;
#while ($1)
#{
# --error 0,1520
# eval ALTER TABLESPACE ts1 ADD DATAFILE 'datafile$1.dat' INITIAL_SIZE = 1M ENGINE=NDB;
# dec $1;
#}

#let $1= 30;
#while ($1)
#{
# --error 0,1520
# eval ALTER TABLESPACE ts1 DROP DATAFILE 'datafile$1.dat' ENGINE=NDB;
# dec $1;
#}

#ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB;
#DROP TABLESPACE ts1 ENGINE = NDB;
#DROP LOGFILE GROUP lg1 ENGINE =NDB;


#####################################################################
#
# Bug#24560
#
#####################################################################

#CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 20M UNDO_BUFFER_SIZE 1
ENGINE=NDB;
#CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 10M
ENGINE=NDB;
#CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(500)) TABLESPACE ts1 STORAGE DISK
ENGINE=NDB;

#ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB;
#DROP TABLESPACE ts1 ENGINE = NDB;
#DROP LOGFILE GROUP lg1 ENGINE =NDB;


#####################################################################
#
# Bug#24578
#
#####################################################################

#CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 20M UNDO_BUFFER_SIZE 1M
ENGINE=NDB;
#CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 1K
ENGINE=NDB;

#CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(500)) TABLESPACE ts1 STORAGE DISK
ENGINE=NDB;
#INSERT INTO t1 VALUES(1, 'a');
#INSERT INTO t1 VALUES(2, 'b');
#--error 1114
#INSERT INTO t1 VALUES(3, 'c');
#DROP TABLE t1;
#CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(500)) TABLESPACE ts1 STORAGE DISK
ENGINE=NDB;
#INSERT INTO t1 VALUES(1, 'a');

#ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB;
#DROP TABLESPACE ts1 ENGINE = NDB;
#DROP LOGFILE GROUP lg1 ENGINE =NDB;

#End 5.1 test case