encryption.innodb_encryption_discard_import 'innodb' w1 [ fail ]

        Test ended at 2017-10-11 09:02:47

CURRENT_TEST: encryption.innodb_encryption_discard_import

mysqltest: At line 113: query 'SELECT COUNT(1) FROM t3' failed: 1296: Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB

The result from queries just before the failure was:

< snip >

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

ALTER TABLE t3 ENGINE InnoDB;

SHOW CREATE TABLE t3;

Table	Create Table

t3	CREATE TABLE `t3` (

  `id` int(11) NOT NULL,

  `a` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED `encrypted`=yes

# Restarting server

# Done restarting server

# Verify that tables are still usable

SELECT COUNT(1) FROM t1;

COUNT(1)

10000

SELECT COUNT(1) FROM t2;

COUNT(1)

10000

SELECT COUNT(1) FROM t3;