Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
support aes_encrypt and aes_decrypt.
Insert work
|
|
create table t1 (id int, s varchar(50)) engine = columnstore; |
|
|
INSERT INTO t1 (id, s) VALUES (1, HEX(AES_ENCRYPT('text', SHA2('password', 512)))); |
select only with disabled select handler.
|
|
set session columnstore_select_handler=0; |
SELECT id, AES_DECRYPT(UNHEX(s), SHA2('password', 512)) FROM t1 |
;