rijndael.sql 1.2 KB
Newer Older
B
Bruce Momjian 已提交
1 2 3 4 5
--
-- AES / Rijndael-128 cipher
--

-- some standard Rijndael testvalues
6
SELECT encode(encrypt(
B
Bruce Momjian 已提交
7 8 9 10
decode('00112233445566778899aabbccddeeff', 'hex'),
decode('000102030405060708090a0b0c0d0e0f', 'hex'),
'aes-ecb/pad:none'), 'hex');

11
SELECT encode(encrypt(
B
Bruce Momjian 已提交
12 13 14 15
decode('00112233445566778899aabbccddeeff', 'hex'),
decode('000102030405060708090a0b0c0d0e0f1011121314151617', 'hex'),
'aes-ecb/pad:none'), 'hex');

16
SELECT encode(encrypt(
B
Bruce Momjian 已提交
17 18 19 20 21
decode('00112233445566778899aabbccddeeff', 'hex'),
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'hex'),
'aes-ecb/pad:none'), 'hex');

-- cbc
22
SELECT encode(encrypt(
B
Bruce Momjian 已提交
23 24 25 26 27 28
decode('00112233445566778899aabbccddeeff', 'hex'),
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'hex'),
'aes-cbc/pad:none'), 'hex');

-- key padding

29
SELECT encode(encrypt(
B
Bruce Momjian 已提交
30 31 32 33
decode('0011223344', 'hex'),
decode('000102030405', 'hex'),
'aes-cbc'), 'hex');

34
SELECT encode(encrypt(
B
Bruce Momjian 已提交
35 36 37 38
decode('0011223344', 'hex'),
decode('000102030405060708090a0b0c0d0e0f10111213', 'hex'),
'aes-cbc'), 'hex');

39
SELECT encode(encrypt(
B
Bruce Momjian 已提交
40 41 42 43
decode('0011223344', 'hex'),
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b', 'hex'),
'aes-cbc'), 'hex');