31 lines
995 B
Plaintext
31 lines
995 B
Plaintext
CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undo1.dat' ENGINE=NDB;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
ENGINE=NDB ENCRYPTION='n';
|
|
ALTER TABLESPACE ts1 DROP DATAFILE 'ts1_datafile.dat';
|
|
DROP TABLESPACE ts1;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
ENGINE=NDB ENCRYPTION='N';
|
|
ALTER TABLESPACE ts1 DROP DATAFILE 'ts1_datafile.dat';
|
|
DROP TABLESPACE ts1;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
ENGINE=NDB ENCRYPTION='';
|
|
ALTER TABLESPACE ts1 DROP DATAFILE 'ts1_datafile.dat';
|
|
DROP TABLESPACE ts1;
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
ENGINE=NDB ENCRYPTION='Y';
|
|
ERROR 42000: The storage engine for the table doesn't support ENCRYPTION
|
|
CREATE TABLESPACE ts1
|
|
ADD DATAFILE 'ts1_datafile.dat'
|
|
USE LOGFILE GROUP lg1
|
|
ENGINE=NDB ENCRYPTION='R';
|
|
ERROR 42000: The storage engine for the table doesn't support ENCRYPTION
|
|
DROP LOGFILE GROUP lg1 ENGINE=NDB;
|