129 lines
3.1 KiB
Plaintext
129 lines
3.1 KiB
Plaintext
CREATE LOGFILE GROUP lg1
|
|
ADD UNDOFILE 'lg1_undofile.dat'
|
|
INITIAL_SIZE 1M
|
|
UNDO_BUFFER_SIZE = 1M
|
|
ENGINE NDB;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
INITIAL_SIZE 2M
|
|
ENGINE NDB;
|
|
USE ndb_ddl_test;
|
|
CREATE TABLE t10 (
|
|
a INT PRIMARY KEY,
|
|
b VARCHAR(255)
|
|
) ENGINE NDB
|
|
TABLESPACE ts1
|
|
STORAGE DISK;
|
|
INSERT INTO t10 VALUES(1, 'Poirot');
|
|
CREATE DATABASE ndb_ddl_test3;
|
|
USE ndb_ddl_test3;
|
|
CREATE TABLE t1 (
|
|
a INT,
|
|
b INT,
|
|
PRIMARY KEY(a,b)
|
|
) ENGINE NDB;
|
|
CREATE TABLE t2(
|
|
a INT PRIMARY KEY,
|
|
b VARCHAR(255)
|
|
) ENGINE NDB;
|
|
CREATE DATABASE ndb_ddl_test4;
|
|
USE ndb_ddl_test4;
|
|
CREATE TABLE t1 (
|
|
a INT,
|
|
b INT,
|
|
PRIMARY KEY(a,b)
|
|
) ENGINE NDB;
|
|
CREATE TABLE t2(
|
|
a INT PRIMARY KEY,
|
|
b VARCHAR(255)
|
|
) ENGINE NDB;
|
|
CREATE DATABASE ndb_ddl_test5;
|
|
USE ndb_ddl_test5;
|
|
CREATE TABLE t1 (
|
|
a INT,
|
|
b INT,
|
|
PRIMARY KEY(a,b)
|
|
) ENGINE NDB;
|
|
USE ndb_ddl_test;
|
|
DROP TABLE t6;
|
|
DROP TABLE t7;
|
|
DROP TABLE t8;
|
|
DROP TABLE t9;
|
|
DROP TABLE t10;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
DROP TABLESPACE ts1;
|
|
DROP LOGFILE GROUP lg1
|
|
ENGINE NDB;
|
|
USE ndb_ddl_test3;
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
|
|
SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
|
|
SET SESSION ndb_metadata_check = 1;
|
|
ERROR HY000: Variable 'ndb_metadata_check' is a GLOBAL variable and should be set with SET GLOBAL
|
|
SET SESSION ndb_metadata_check_interval = 5;
|
|
ERROR HY000: Variable 'ndb_metadata_check_interval' is a GLOBAL variable and should be set with SET GLOBAL
|
|
SET GLOBAL ndb_metadata_check_interval = 0;
|
|
SET GLOBAL ndb_metadata_check = 1;
|
|
SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
|
|
SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
|
|
SELECT * FROM ndb_ddl_test.t6;
|
|
a
|
|
value1
|
|
value2
|
|
value3
|
|
value4
|
|
value5
|
|
SELECT * FROM ndb_ddl_test.t8;
|
|
a b c d e
|
|
1 1-t8 2017-10-20 09:13:01 NULL 1
|
|
2 2-t8 2017-10-20 09:13:02 NULL 2
|
|
3 3-t8 2017-10-20 09:13:03 NULL 3
|
|
4 4-t8 2017-10-20 09:13:04 NULL 4
|
|
5 5-t8 2017-10-20 09:13:05 NULL 5
|
|
SELECT * FROM ndb_ddl_test.t10;
|
|
a b
|
|
1 Poirot
|
|
ALTER TABLE ndb_ddl_test3.t1
|
|
ADD COLUMN c VARCHAR(255);
|
|
Warnings:
|
|
Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
|
|
INSERT INTO ndb_ddl_test3.t1 VALUES(1, 1, 'Use your little grey cells mon ami');
|
|
SELECT * FROM ndb_ddl_test3.t1;
|
|
a b c
|
|
1 1 Use your little grey cells mon ami
|
|
SHOW CREATE TABLE ndb_ddl_test4.t1;
|
|
ERROR 42S02: Table 'ndb_ddl_test4.t1' doesn't exist
|
|
SHOW CREATE TABLE ndb_ddl_test5.t1;
|
|
ERROR 42S02: Table 'ndb_ddl_test5.t1' doesn't exist
|
|
CREATE TABLESPACE ts2
|
|
ADD DATAFILE 'ts2_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
INITIAL_SIZE 2M
|
|
ENGINE NDB;
|
|
ALTER TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile2.dat';
|
|
CREATE TABLE ndb_ddl_test4.t1 (
|
|
a INT PRIMARY KEY,
|
|
b INT
|
|
) ENGINE NDB;
|
|
INSERT INTO ndb_ddl_test4.t1 VALUES(1,1);
|
|
SELECT * FROM ndb_ddl_test4.t1;
|
|
a b
|
|
1 1
|
|
DROP DATABASE ndb_ddl_test3;
|
|
DROP DATABASE ndb_ddl_test4;
|
|
DROP DATABASE ndb_ddl_test5;
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile.dat';
|
|
ALTER TABLESPACE ts1
|
|
DROP DATAFILE 'ts1_datafile2.dat';
|
|
DROP TABLESPACE ts1;
|
|
ALTER TABLESPACE ts2
|
|
DROP DATAFILE 'ts2_datafile.dat';
|
|
DROP TABLESPACE ts2;
|
|
DROP LOGFILE GROUP lg1
|
|
ENGINE NDB;
|