search

ClickHouse / clickhouse-docs

Official documentation for ClickHouse
https://clickhouse.com/docs
Other
108 stars 256 forks source link

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

Open alsugiliazova opened 4 months ago

alsugiliazova commented 4 months ago

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 commented 4 months ago

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