clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Encryption mode `aes-128-cfb1` is supported from 24.4 but no information in docs

Open alsugiliazova opened this issue 1 year ago • 1 comments

https://fiddle.clickhouse.com/03ddaf67-5164-4e48-b45c-ee7ddaf971b5

SELECT hex(encrypt('aes-128-cfb1', 'hello there', '0123456789123456')) FORMAT TabSeparated;

SELECT decrypt('aes-128-cfb1', unhex('AA1826B5F66A903C888D5DCDA9FB63D1D9CCA10EC55F59D6C00D37'), '0123456789123456') FORMAT TabSeparated;
58A90C0FCAABB5C64BA4FC
�\t8�a��p�s�%��gT�@\\(s�\t�

https://clickhouse.com/docs/en/sql-reference/functions/encryption-functions#aes_encrypt_mysql

alsugiliazova avatar May 10 '24 10:05 alsugiliazova

Same with aes-128-cfb8 https://fiddle.clickhouse.com/7b840943-cca5-41ed-a8a3-a0b9639eedc1

alsugiliazova avatar May 10 '24 10:05 alsugiliazova

https://github.com/ClickHouse/ClickHouse/pull/73098

thanks @alsugiliazova

gingerwizard avatar Dec 11 '24 10:12 gingerwizard