ERROR 1478 (HY000) at line 1: InnoDB: Tablespace innodb_temporary can contain only an ENCRYPTED tables.

[ShahriyarR]

For --test_mode the PS 5.7 by default started as:

--innodb_encrypt_tables=ON --innodb_encrypt_online_alter_logs=ON --innodb_temp_tablespace_encrypt=ON

But in temp_table_test.sh:

#!/usr/bin/env bash

BASEDIR=$1
MYSQL_SOCK=$2
MYSQL_USER=root
#CONN_STR=${BASEDIR}/bin/mysql --user=${MYSQL_USER} --socket=${MYSQL_SOCK}


${BASEDIR}/bin/mysql --user=${MYSQL_USER} --socket=${MYSQL_SOCK} -e "CREATE TEMPORARY TABLE sysbench_test_db.t04 (a TEXT) ENGINE=InnoDB encryption='N';INSERT INTO sysbench_test_db.t04 VALUES ('Praesent tristique eros a tempus fringilla');"
${BASEDIR}/bin/mysql --user=${MYSQL_USER} --socket=${MYSQL_SOCK} -e "CREATE TEMPORARY TABLE sysbench_test_db.t03 (a TEXT) ENGINE=InnoDB ROW_FORMAT=COMPRESSED encryption='N';INSERT INTO sysbench_test_db.t03 VALUES ('Praesent tristique eros a tempus fringilla');"

It can be changed to create encrypted temp tables.