encryption.innodb_encryption_filekeys 'cbc,innodb' w2 [ fail ]

        Test ended at 2018-03-09 16:56:34

CURRENT_TEST: encryption.innodb_encryption_filekeys

mysqltest: At line 85: query 'SELECT NAME,ENCRYPTION_SHCEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION' failed: 1054: Unknown column 'ENCRYPTION_SHCEME' in 'field list'

The result from queries just before the failure was:

< snip >

CREATE TABLE t3 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=NO;

CREATE TABLE t4 (pk INT PRIMARY KEY AUTO_INCREMENT, c VARCHAR(256)) ENGINE=INNODB ENCRYPTED=YES ENCRYPTION_KEY_ID=4;

SET GLOBAL innodb_encrypt_tables = on;

# Wait max 10 min for key encryption threads to encrypt required all spaces

# Success!

SELECT COUNT(1) FROM t1;

COUNT(1)

10

SELECT COUNT(1) FROM t2;

COUNT(1)

10

SELECT COUNT(1) FROM t3;

COUNT(1)

10

SELECT COUNT(1) FROM t4;

COUNT(1)

10

SET GLOBAL innodb_encrypt_tables = off;

# Wait max 10 min for key encryption threads to decrypt all required spaces

SELECT NAME,ENCRYPTION_SHCEME,MIN_KEY_VERSION, ROTATING_OR_FLUSHING FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION;