Modify to check for boundaries for encryption_key_id

Description

create table t2(a int) encryption='keyring';
mysql> alter table t2 encryption_key_id=9999999999;
Query OK, 0 rows affected (0.83 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> select current_key_id from information_schema.innodb_tablespaces_encryption where name = 'test/t2';
----------------

current_key_id

----------------

1410065407

----------------
1 row in set (0.00 sec)

It simply prints garbage value.

Environment

None

Smart Checklist

Activity

Show:
Done

Details

Assignee

Reporter

Time tracking

1d 4h 40m logged

Fix versions

Affects versions

Priority

Smart Checklist

Created September 3, 2020 at 10:48 AM
Updated March 6, 2024 at 10:57 AM
Resolved October 8, 2020 at 12:05 PM