#
# This test upgrades a database from 8.0.21 and attempts to add
# autoextend_size tablespace attribute to it's tables
# and tablespaces
#
# Stop the running server
###################################################################
# Unzip a 8.0.21 database and start the server using this directory
###################################################################
###################################################################
# Copy and unzip the datadir
###################################################################
# Restart the server using the new datadir
# restart: --datadir=BUGDATADIR --innodb_page_size=16k
# Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
SELECT lower(name), file_size, autoextend_size from
INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
lower(name)	file_size	autoextend_size
innodb_temporary	12582912	0
test/t5	114688	0
ts1	147456	0
# Update autoextend_size attribute both for the implicit as
# well as explicit tablespaces
ALTER TABLE t5 AUTOEXTEND_SIZE 4M;
ALTER TABLESPACE ts1 AUTOEXTEND_SIZE 4M;
# Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
SELECT lower(name), file_size, autoextend_size from
INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
lower(name)	file_size	autoextend_size
innodb_temporary	12582912	0
test/t5	114688	4194304
ts1	147456	4194304
# Cleanup
# Shutdown server
# Remove the copied files
# Restart the server
# restart