EVOLUTION-MANAGER

Edit File: row_format_alter.test

--source include/have_tokudb.inc
#
# Attempt to change row format with and without
# other ALTER TABLE statements.
#
SET DEFAULT_STORAGE_ENGINE='tokudb';
set tokudb_hide_default_row_format=false;

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

CREATE TABLE foo (c1 int not null primary key) engine=TokuDB;

# Sanity check for default values.
SELECT CREATE_OPTIONS 
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=tokudb_lzma, add column c2 int not null;

# Check to see that the row format was changed.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=TOKUDB_QUICKLZ, add column c3 int not null;

# Check to see that QuickLZ was selected.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=TOKUDB_UNCOMPRESSED, add column c4 int not null;

# Check to see that it is now uncompressed.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=TOKUDB_ZLIB, add column c5 int not null;

# Check to see that we are using zlib.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=TOKUDB_FAST, add column c6 int not null;

# Check for 'fast' compression mode.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

ALTER TABLE foo compression=TOKUDB_SMALL, add column c7 int not null;

# Check for small compression type.
SELECT CREATE_OPTIONS
FROM INFORMATION_SCHEMA.TABLES  WHERE (table_name LIKE 'foo');
SHOW CREATE TABLE foo;

DROP TABLE foo;