Done
Details
Details
Assignee
mohit.joshi
mohit.joshiReporter
mohit.joshi
mohit.joshi[Release Manager]
Hrvoje Matijakovic
Hrvoje Matijakovic[QA Director]
Peter Schwaller
Peter Schwaller(Deactivated)Time tracking
1d 1h logged
Priority
MediumCreated July 4, 2019 at 12:54 PM
Updated March 6, 2024 at 12:02 PM
Resolved December 31, 2019 at 5:43 AM
Functional Requirements for 5.7
Case 1 - When --innodb_temp_tablespace_encrypt=OFF:
a) If I have --innodb-encrypt-tables=OFF:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='N" and MUST PASS.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as it is and MUST FAIL since innodb_temporary is un-encrypted and SHALL NOT allow encrypted data.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be executed as it is and MUST PASS
b) If I have --innodb-encrypt-tables=ON:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y" and MUST FAIL since innodb_temporary is un-encrypted and SHALL NOT allow encrypted data.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as is and MUST FAIL since innodb_temporary is un-encrypted and SHALL NOT allow encrypted data.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be executed as is and MUST PASS
c) If I have --innodb-encrypt-tables=FORCE:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y" and MUST FAIL since innodb_temporary is un-encrypted and SHALL NOT allow encrypted data.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as is and MUST FAIL since innodb_temporary is un-encrypted and SHALL NOT allow encrypted data.
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be forbidden.
Case 2 - When --innodb_temp_tablespace_encrypt=ON:
a) If I have --innodb-encrypt-tables=OFF:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='N" and MUST FAIL since innodb_temporary is encrypted
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as it is and MUST PASS
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be executed as it is and MUST FAIL
b) If I have --innodb-encrypt-tables=ON:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y" and MUST PASS
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as is and MUST PASS
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be executed as is and MUST FAIL
c) If I have --innodb-encrypt-tables=FORCE:
"CREATE [TEMPORARY] TABLE t()" should be silently translated into "CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y" and MUST PASS
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='Y'" should be executed as is and MUST PASS
"CREATE [TEMPORARY] TABLE t() ENCRYPTION='N'" should be forbidden.