# Test that changes to column properties
# are backward compatible

-- source include/have_ndb.inc
-- source include/have_case_sensitive_file_system.inc
-- source suite/ndb/include/backup_restore_setup.inc

CREATE DATABASE BANK default charset=latin1 default collate=latin1_bin;
--exec $NDB_RESTORE -b 1 -n 1 -p 1 -m -r $NDB_SAVED_BACKUPS/51 >> $NDB_TOOLS_OUTPUT
--exec $NDB_RESTORE -e -b 1 -n 2 -p 1 -r $NDB_SAVED_BACKUPS/51 >> $NDB_TOOLS_OUTPUT
USE BANK;

# Check for warnings of implicit conversion of COLUMN_FORMAT
# after default has changed to DYNAMIC

ALTER TABLE ACCOUNT MODIFY`OWNER` int(11) unsigned NOT NULL COLUMN_FORMAT FIXED;
--echo Now there should be two warnings of implicit COLUMN_FORMAT conversion
SHOW WARNINGS;
ALTER TABLE BANK.ACCOUNT RENAME test.t1;
source show_attributes.inc;
DROP TABLE test.t1;
--error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
ALTER TABLE ACCOUNT_TYPE algorithm=inplace, MODIFY `DESCRIPTION` char(65);
ALTER TABLE ACCOUNT_TYPE DROP `DESCRIPTION`;
--echo Now there should be no warning
SHOW WARNINGS;
ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(21);
--echo Now there should be one warning of implicit COLUMN_FORMAT conversion
SHOW WARNINGS;
ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(22);
--echo Now there should be no warning
SHOW WARNINGS;
ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(23);
set @old_acat = @@session.ndb_allow_copying_alter_table;
set @@session.ndb_allow_copying_alter_table = off;
# Changing bigint display width can be done without copying
ALTER TABLE SYSTEM_VALUES MODIFY `VALUE` bigint(24);
--echo Now there should be no warning
SHOW WARNINGS;
set @@session.ndb_allow_copying_alter_table = @old_acat;
set @old_ndcf = @@global.ndb_default_column_format;

set @@global.ndb_default_column_format = FIXED;
ALTER TABLE TRANSACTION MODIFY `ACCOUNT_TYPE` int(11) unsigned NOT NULL;
--echo Now there should be no warning
SHOW WARNINGS;
ALTER TABLE BANK.TRANSACTION RENAME test.t1;
source show_attributes.inc;
DROP TABLE test.t1;
set @@global.ndb_default_column_format = @old_ndcf;
DROP DATABASE BANK;

--remove_file $NDB_TOOLS_OUTPUT