PS-3821, it is noticed that if we change the value of innodb-temp-tablespace encryption to OFF during runtime , the subsequent file-per-table temporary tables are not un-encrypted.
To verify following testcase was executed:
- Start the server with innodb-temp-tablespace-encrypt=ON
- Turn off encryption
- create temporary table t1(a int) row_format=compressed; /It fails/