Below is the list of changes that have just been committed into a local
5.1 repository of ndbdev. When ndbdev 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
1.2094 06/02/09 01:45:46 ngrishakin@stripped +2 -0
updated test cases ndb_dd_ddl
mysql-test/r/ndb_dd_ddl.result
1.4 06/02/09 01:45:03 ngrishakin@stripped +274 -0
Updated ndb_dd_ddl.result
mysql-test/t/ndb_dd_ddl.test
1.6 06/02/09 01:43:42 ngrishakin@stripped +400 -0
Updated ndb_dd_ddl.test
# 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: ngrishakin
# Host: ndb15.mysql.com
# Root: /home/ndbdev/ngrishakin/mysql-5.1-new
--- 1.3/mysql-test/r/ndb_dd_ddl.result 2006-01-31 20:10:19 +01:00
+++ 1.4/mysql-test/r/ndb_dd_ddl.result 2006-02-09 01:45:03 +01:00
@@ -188,3 +188,277 @@
DROP LOGFILE GROUP lg1
ENGINE NDB;
**** End = And No = ****
+Create LOGFILE GROUP lg1 where and specify UNDOFILE in none existent directory
+directory should be created by the engine
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/noneexisteddirectory/undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE ts1
+ADD DATAFILE './var/noneexisteddirectory/datafile.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 12M
+ENGINE NDB;
+ALTER TABLESPACE ts1
+DROP DATAFILE './var/noneexisteddirectory/datafile.dat'
+ENGINE NDB;
+DROP TABLESPACE ts1 ENGINE NDB;
+DROP LOGFILE GROUP lg1
+ENGINE=NDB;
+Create LOGFILE GROUP lg1 long path name for UNDOFILE
+Create CREATE TABLESPACE with long path name for datafile
+Create CREATE LOGFILE GROUP and CREATE TABLESPACE where name for datafile and --echo undofile files are up to 256 bytes long.
+Alter LOGFILE GROUP that does not exist bug 16767
+ALTER LOGFILE GROUP wnc1
+ADD UNDOFILE './tmp/undofile.dat'
+ENGINE=NDB;
+ERROR HY000: Failed to alter: CREATE UNDOFILE
+Alter ALTER TABLESPACE for non existent TABLESPACE
+ALTER TABLESPACE net
+DROP DATAFILE './tmp/datafile.dat'
+ENGINE=NDB;
+ERROR HY000: Failed to alter: NO SUCH FILE
+Drop TABLESPACE and LOGFILE GROUP that do not exist
+DROP TABLESPACE ts1 ENGINE NDB;
+ERROR HY000: Failed to drop TABLESPACE
+Test LG and TS names that contians (_, @, #, &, $,)
+CREATE LOGFILE GROUP _lg_#$&@1
+ADD UNDOFILE './var/undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE _ts_#$&@1
+ADD DATAFILE './var/tmp/datafile.dat'
+USE LOGFILE GROUP _lg_#$&@1
+INITIAL_SIZE 12M
+ENGINE=NDB;
+ALTER TABLESPACE _ts_#$&@1
+DROP DATAFILE './var/tmp/datafile.dat'
+ENGINE=NDB;
+DROP TABLESPACE _ts_#$&@1
+ENGINE=NDB;
+DROP LOGFILE GROUP _lg_#$&@1
+ENGINE=NDB;
+Test LG and TS and file names that start with number
+CREATE LOGFILE GROUP 1lg
+ADD UNDOFILE './var/1undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE 1ts
+ADD DATAFILE './var/tmp/1datafile.dat'
+USE LOGFILE GROUP 1lg
+INITIAL_SIZE 12M
+ENGINE=NDB;
+ALTER TABLESPACE 1ts
+DROP DATAFILE './var/tmp/1datafile.dat'
+ENGINE=NDB;
+DROP TABLESPACE 1ts
+ENGINE=NDB;
+DROP LOGFILE GROUP 1lg
+ENGINE=NDB;
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/undofile.dat'
+INITIAL_SIZE 1K
+UNDO_BUFFER_SIZE = 1k
+ENGINE=NDB;
+DROP LOGFILE GROUP lg1
+ENGINE=NDB;
+Testing limits for INITIAL_SIZE in TS
+2G
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE ts1
+ADD DATAFILE './var/datafile.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 500M
+ENGINE NDB;
+ALTER TABLESPACE ts1
+DROP DATAFILE './var/datafile.dat'
+ENGINE NDB;
+DROP TABLESPACE ts1 ENGINE NDB;
+DROP LOGFILE GROUP lg1
+ENGINE=NDB;
+Create TS and LG where permitions for user is denied
+DROP DATABASE IF EXISTS test1;
+CREATE DATABASE test1;
+CREATE TABLE IF NOT EXISTS test1.t1 (f1 BIGINT);
+DROP USER test_user1@localhost;
+CREATE USER test_user1@localhost identified by 'PWD';
+GRANT SELECT ON test1.t1 to test_user1@localhost;
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+ERROR 42000: Access denied for user 'test_user1'@'localhost' to database 'test1'
+CREATE TABLESPACE ts1
+ADD DATAFILE './var/datafile.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 12M
+ENGINE NDB;
+ERROR 42000: Access denied for user 'test_user1'@'localhost' to database 'test1'
+ALTER TABLESPACE ts1
+DROP DATAFILE './var/datafile.dat'
+ENGINE NDB;
+ERROR 42000: Access denied for user 'test_user1'@'localhost' to database 'test1'
+DROP TABLESPACE ts1 ENGINE NDB;
+ERROR 42000: Access denied for user 'test_user1'@'localhost' to database 'test1'
+DROP LOGFILE GROUP lg1
+ENGINE=NDB;
+ERROR 42000: Access denied for user 'test_user1'@'localhost' to database 'test1'
+DROP USER test_user1@localhost;
+DROP TABLE test1.t1;
+DROP DATABASE test1;
+Create loop through creating table spaces 5000. TS1 - TS5000
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/undofile.dat'
+INITIAL_SIZE 16M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS9
+ADD DATAFILE './var/datafile9.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS8
+ADD DATAFILE './var/datafile8.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS7
+ADD DATAFILE './var/datafile7.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS6
+ADD DATAFILE './var/datafile6.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS5
+ADD DATAFILE './var/datafile5.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS4
+ADD DATAFILE './var/datafile4.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS3
+ADD DATAFILE './var/datafile3.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS2
+ADD DATAFILE './var/datafile2.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS1
+ADD DATAFILE './var/datafile1.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+ALTER TABLESPACE TS9
+DROP DATAFILE './var/datafile9.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS8
+DROP DATAFILE './var/datafile8.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS7
+DROP DATAFILE './var/datafile7.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS6
+DROP DATAFILE './var/datafile6.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS5
+DROP DATAFILE './var/datafile5.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS4
+DROP DATAFILE './var/datafile4.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS3
+DROP DATAFILE './var/datafile3.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS2
+DROP DATAFILE './var/datafile2.dat'
+ENGINE=NDB;
+ALTER TABLESPACE TS1
+DROP DATAFILE './var/datafile1.dat'
+ENGINE=NDB;
+DROP TABLESPACE TS9
+ENGINE=NDB;
+DROP TABLESPACE TS8
+ENGINE=NDB;
+DROP TABLESPACE TS7
+ENGINE=NDB;
+DROP TABLESPACE TS6
+ENGINE=NDB;
+DROP TABLESPACE TS5
+ENGINE=NDB;
+DROP TABLESPACE TS4
+ENGINE=NDB;
+DROP TABLESPACE TS3
+ENGINE=NDB;
+DROP TABLESPACE TS2
+ENGINE=NDB;
+DROP TABLESPACE TS1
+ENGINE=NDB;
+DROP LOGFILE GROUP lg1 ENGINE=NDB;
+CREATE LOGFILE GROUP lg3
+ADD UNDOFILE './var/undofiled3.dat'
+INITIAL_SIZE 1M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS3
+ADD DATAFILE './var/datafiled3.dat'
+USE LOGFILE GROUP lg3
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE LOGFILE GROUP lg2
+ADD UNDOFILE './var/undofiled2.dat'
+INITIAL_SIZE 1M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS2
+ADD DATAFILE './var/datafiled2.dat'
+USE LOGFILE GROUP lg2
+INITIAL_SIZE 1M
+ENGINE=NDB;
+CREATE LOGFILE GROUP lg1
+ADD UNDOFILE './var/undofiled1.dat'
+INITIAL_SIZE 1M
+UNDO_BUFFER_SIZE = 1M
+ENGINE=NDB;
+CREATE TABLESPACE TS1
+ADD DATAFILE './var/datafiled1.dat'
+USE LOGFILE GROUP lg1
+INITIAL_SIZE 1M
+ENGINE=NDB;
+ALTER TABLESPACE TS3
+DROP DATAFILE './var/datafiled3.dat'
+ENGINE=NDB;
+DROP TABLESPACE TS3
+ENGINE=NDB;
+DROP LOGFILE GROUP lg3
+ENGINE=NDB;
+ALTER TABLESPACE TS2
+DROP DATAFILE './var/datafiled2.dat'
+ENGINE=NDB;
+DROP TABLESPACE TS2
+ENGINE=NDB;
+DROP LOGFILE GROUP lg2
+ENGINE=NDB;
+ALTER TABLESPACE TS1
+DROP DATAFILE './var/datafiled1.dat'
+ENGINE=NDB;
+DROP TABLESPACE TS1
+ENGINE=NDB;
+DROP LOGFILE GROUP lg1
+ENGINE=NDB;
--- 1.5/mysql-test/t/ndb_dd_ddl.test 2006-02-06 13:27:13 +01:00
+++ 1.6/mysql-test/t/ndb_dd_ddl.test 2006-02-09 01:43:42 +01:00
@@ -284,5 +284,405 @@
--echo **** End = And No = ****
############ End = And No = ##################
+#########################################
+# Author: ngrishakin
+# Date: 2006-01-19
+# Purpose: Test the NDB engine.
+############################################
+
+--echo Create LOGFILE GROUP lg1 where and specify UNDOFILE in none existent directory
+--echo directory should be created by the engine
+
+ CREATE LOGFILE GROUP lg1
+ ADD UNDOFILE './var/noneexisteddirectory/undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+ CREATE TABLESPACE ts1
+ ADD DATAFILE './var/noneexisteddirectory/datafile.dat'
+ USE LOGFILE GROUP lg1
+ INITIAL_SIZE 12M
+ ENGINE NDB;
+
+ ALTER TABLESPACE ts1
+ DROP DATAFILE './var/noneexisteddirectory/datafile.dat'
+ ENGINE NDB;
+
+ DROP TABLESPACE ts1 ENGINE NDB;
+
+ DROP LOGFILE GROUP lg1
+ ENGINE=NDB;
+
+--echo Create LOGFILE GROUP lg1 long path name for UNDOFILE
+# bug 16471 error returned:failed: 1506: Failed to create UNDOFILE
+
+# let $path1 = `SELECT CONCAT('./var/', repeat('a', 200), '/undofile.dat')`;
+# eval CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE '$path1'
+# INITIAL_SIZE 16M
+# UNDO_BUFFER_SIZE = 1M
+# ENGINE=NDB;
+
+# DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+--echo Create CREATE TABLESPACE with long path name for datafile
+#bug 16472
+
+# eval CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE './var/undofile.dat'
+# INITIAL_SIZE 16M
+# UNDO_BUFFER_SIZE = 1M
+# ENGINE=NDB;
+
+# let $path2 = `SELECT CONCAT('./var/', repeat('a', 160), '/datafile.dat')`;
+
+# eval CREATE TABLESPACE ts1
+# ADD DATAFILE '$path2'
+# USE LOGFILE GROUP lg1
+# INITIAL_SIZE 12M
+# ENGINE NDB;
+
+# eval ALTER TABLESPACE ts1
+# DROP DATAFILE '$path2'
+# ENGINE NDB;
+
+# eval DROP TABLESPACE ts1 ENGINE NDB;
+
+# eval DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+--echo Create CREATE LOGFILE GROUP and CREATE TABLESPACE where name for datafile and --echo undofile files are up to 256 bytes long.
+# bug 16545
+
+# let $fp1 = `SELECT CONCAT('./var/', repeat('u', 250), '.dat')`;
+# eval CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE '$fp1'
+# INITIAL_SIZE 16M
+# UNDO_BUFFER_SIZE = 1M
+# ENGINE=NDB;
+
+# let $fp2 = `SELECT CONCAT('./var/', repeat('d', 250), '.dat')`;
+
+# eval CREATE TABLESPACE ts1
+# ADD DATAFILE '$fp2'
+# USE LOGFILE GROUP lg1
+# INITIAL_SIZE 12M
+# ENGINE NDB;
+
+# eval ALTER TABLESPACE ts1
+# DROP DATAFILE '$fp2'
+# ENGINE NDB;
+
+# eval DROP TABLESPACE ts1 ENGINE NDB;
+# eval DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+
+--echo Alter LOGFILE GROUP that does not exist bug 16767
+--error ER_ALTER_FILEGROUP_FAILED
+ ALTER LOGFILE GROUP wnc1
+ ADD UNDOFILE './tmp/undofile.dat'
+ ENGINE=NDB;
+
+#bug 16658 "error 1064 altering LG that does not exist"
+# ALTER LOGFILE GROUP wnc1
+# ADD UNDOFILE './tmp/undofile.dat'
+# INITIAL_SIZE 16M
+# UNDO_BUFFER_SIZE = 1M
+# ENGINE=NDB;
+
+--echo Alter ALTER TABLESPACE for non existent TABLESPACE
+#BUG 17250
+--error ER_ALTER_FILEGROUP_FAILED
+ ALTER TABLESPACE net
+ DROP DATAFILE './tmp/datafile.dat'
+ ENGINE=NDB;
+
+--echo Drop TABLESPACE and LOGFILE GROUP that do not exist
+#BUG 17250
+--error ER_DROP_FILEGROUP_FAILED
+ DROP TABLESPACE ts1 ENGINE NDB;
+
+#Bug 16768 error returned: failed: 1507: Failed to drop LOGFILE GROUP
+#--error ER_DROP_TABLESPACE_FAILED
+# DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+
+# Test LG and TS names that contians (_, @, #, &, $,)
+# "@", "&", "#", cannot be used as first character in the name. It couses error
+# 1064: You have an error in your SQL syntax; check the manual that corresponds to # your MySQL server version for the right syntax to use near '@lg_#$&@1
+
+--echo Test LG and TS names that contians (_, @, #, &, $,)
+ CREATE LOGFILE GROUP _lg_#$&@1
+ ADD UNDOFILE './var/undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+ CREATE TABLESPACE _ts_#$&@1
+ ADD DATAFILE './var/tmp/datafile.dat'
+ USE LOGFILE GROUP _lg_#$&@1
+ INITIAL_SIZE 12M
+ ENGINE=NDB;
+
+ ALTER TABLESPACE _ts_#$&@1
+ DROP DATAFILE './var/tmp/datafile.dat'
+ ENGINE=NDB;
+
+ DROP TABLESPACE _ts_#$&@1
+ ENGINE=NDB;
+
+ DROP LOGFILE GROUP _lg_#$&@1
+ ENGINE=NDB;
+
+# Test LG and TS and file names that start with number
+
+--echo Test LG and TS and file names that start with number
+ CREATE LOGFILE GROUP 1lg
+ ADD UNDOFILE './var/1undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+ CREATE TABLESPACE 1ts
+ ADD DATAFILE './var/tmp/1datafile.dat'
+ USE LOGFILE GROUP 1lg
+ INITIAL_SIZE 12M
+ ENGINE=NDB;
+
+ ALTER TABLESPACE 1ts
+ DROP DATAFILE './var/tmp/1datafile.dat'
+ ENGINE=NDB;
+
+ DROP TABLESPACE 1ts
+ ENGINE=NDB;
+
+ DROP LOGFILE GROUP 1lg
+ ENGINE=NDB;
+
+#--echo Testing limits for INITIAL_SIZE and UNDO_BUFFER_SIZE LG
+
+# bug ?????
+# CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE './var/undofile.dat'
+# INITIAL_SIZE 0K
+# UNDO_BUFFER_SIZE = 0k
+# ENGINE=NDB;
+
+# DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+ CREATE LOGFILE GROUP lg1
+ ADD UNDOFILE './var/undofile.dat'
+ INITIAL_SIZE 1K
+ UNDO_BUFFER_SIZE = 1k
+ ENGINE=NDB;
+
+ DROP LOGFILE GROUP lg1
+ ENGINE=NDB;
+
+#--error ER_CREATE_TABLESPACE_FAILED
+# actual error: ERROR HY000: Failed to create UNDOFILE
+# bug 16787
+
+# CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE './var/undofile.dat'
+# INITIAL_SIZE 3G
+# UNDO_BUFFER_SIZE = 17M
+# ENGINE=NDB;
+
+# DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+#--echo Testing limits for INITIAL_SIZE in LG 2G
+# bug 16787 this test case takes 30 min to run
+ #CREATE LOGFILE GROUP lg1
+ #ADD UNDOFILE './var/undofile.dat'
+ #INITIAL_SIZE 2G
+ #UNDO_BUFFER_SIZE = 17M
+ #ENGINE=NDB;
+
+ #DROP LOGFILE GROUP lg1
+ #ENGINE=NDB;
+
+# bug 16657 error 1506 for UNDO_BUFFER_SIZE > 17M
+# CREATE LOGFILE GROUP lg1
+# ADD UNDOFILE './var/undofile.dat'
+# INITIAL_SIZE 2G
+# UNDO_BUFFER_SIZE = 25M
+# ENGINE=NDB;
+
+# DROP LOGFILE GROUP lg1
+# ENGINE=NDB;
+
+--echo Testing limits for INITIAL_SIZE in TS
+--echo 2G
+# test takes a long time with INITIAL_SIZE 2G : reduced to 500M
+
+ CREATE LOGFILE GROUP lg1
+ ADD UNDOFILE './var/undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+ CREATE TABLESPACE ts1
+ ADD DATAFILE './var/datafile.dat'
+ USE LOGFILE GROUP lg1
+ INITIAL_SIZE 500M
+ ENGINE NDB;
+
+ ALTER TABLESPACE ts1
+ DROP DATAFILE './var/datafile.dat'
+ ENGINE NDB;
+
+ DROP TABLESPACE ts1 ENGINE NDB;
+
+ DROP LOGFILE GROUP lg1
+ ENGINE=NDB;
+
+
+### Create TS and LG where permitions for user is denied ###
+--echo Create TS and LG where permitions for user is denied
+
+let $new_database= test1;
+--disable_warnings
+eval DROP DATABASE IF EXISTS $new_database;
+--enable_warnings
+eval CREATE DATABASE $new_database;
+eval CREATE TABLE IF NOT EXISTS $new_database.t1 (f1 BIGINT);
+
+let $new_user= test_user1;
+
+--error 0,ER_CANNOT_USER
+eval DROP USER $new_user@localhost;
+eval CREATE USER $new_user@localhost identified by 'PWD';
+eval GRANT SELECT ON $new_database.t1 to $new_user@localhost;
+
+--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
+connect (con1,localhost,test_user1,PWD,test1,$master_myport,master.sock);
+connection con1;
+
+#1044 Expected: Access denied for user 'test_user1'@'localhost' to database 'test1'
+--error ER_DBACCESS_DENIED_ERROR
+ CREATE LOGFILE GROUP lg1
+ ADD UNDOFILE './var/undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+--error ER_DBACCESS_DENIED_ERROR
+ CREATE TABLESPACE ts1
+ ADD DATAFILE './var/datafile.dat'
+ USE LOGFILE GROUP lg1
+ INITIAL_SIZE 12M
+ ENGINE NDB;
+
+--error ER_DBACCESS_DENIED_ERROR
+ ALTER TABLESPACE ts1
+ DROP DATAFILE './var/datafile.dat'
+ ENGINE NDB;
+
+--error ER_DBACCESS_DENIED_ERROR
+ DROP TABLESPACE ts1 ENGINE NDB;
+--error 1044
+ DROP LOGFILE GROUP lg1
+ ENGINE=NDB;
+
+connection default;
+disconnect con1;
+eval DROP USER $new_user@localhost;
+eval DROP TABLE $new_database.t1;
+eval DROP DATABASE $new_database;
+
+### end of access denied test #########
+
+--echo Create loop through creating table spaces 5000. TS1 - TS5000
+
+###### Every TS has the same LG ######
+# Limit 9 FG can be created at the same time. BUG 16913
+
+ CREATE LOGFILE GROUP lg1
+ ADD UNDOFILE './var/undofile.dat'
+ INITIAL_SIZE 16M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+#disable_query_log;
+let $cnt=9;
+while ($cnt)
+{
+ eval CREATE TABLESPACE TS$cnt
+ ADD DATAFILE './var/datafile$cnt.dat'
+ USE LOGFILE GROUP lg1
+ INITIAL_SIZE 1M
+ ENGINE=NDB;
+ dec $cnt;
+}
+#12M
+#enable_query_log;
+
+let $cnt=9;
+while ($cnt)
+{
+ eval ALTER TABLESPACE TS$cnt
+ DROP DATAFILE './var/datafile$cnt.dat'
+ ENGINE=NDB;
+ dec $cnt;
+}
+
+let $cnt=9;
+while ($cnt)
+{
+ eval DROP TABLESPACE TS$cnt
+ ENGINE=NDB;
+ dec $cnt;
+}
+DROP LOGFILE GROUP lg1 ENGINE=NDB;
+
+###### Every TS has its own LG ######
+### 16386
+
+#disable_query_log;
+
+let $cnt=3;
+while ($cnt)
+{
+ eval CREATE LOGFILE GROUP lg$cnt
+ ADD UNDOFILE './var/undofiled$cnt.dat'
+ INITIAL_SIZE 1M
+ UNDO_BUFFER_SIZE = 1M
+ ENGINE=NDB;
+
+ eval CREATE TABLESPACE TS$cnt
+ ADD DATAFILE './var/datafiled$cnt.dat'
+ USE LOGFILE GROUP lg$cnt
+ INITIAL_SIZE 1M
+ ENGINE=NDB;
+ dec $cnt;
+}
+
+let $cnt=3;
+while ($cnt)
+{
+ eval ALTER TABLESPACE TS$cnt
+ DROP DATAFILE './var/datafiled$cnt.dat'
+ ENGINE=NDB;
+
+ eval DROP TABLESPACE TS$cnt
+ ENGINE=NDB;
+
+ eval DROP LOGFILE GROUP lg$cnt
+ ENGINE=NDB;
+
+ dec $cnt;
+}
+
+#enable_query_log;
+
+
+
# End 5.1 test
| Thread |
|---|
| • bk commit into 5.1 tree (ngrishakin:1.2094) | Nikolay Grishakin | 9 Feb |
