2
-- AES / Rijndael-128 cipher
4
-- ensure consistent test output regardless of the default bytea format
5
SET bytea_output TO escape;
6
-- some standard Rijndael testvalues
8
decode('00112233445566778899aabbccddeeff', 'hex'),
9
decode('000102030405060708090a0b0c0d0e0f', 'hex'),
10
'aes-ecb/pad:none'), 'hex');
12
----------------------------------
13
69c4e0d86a7b0430d8cdb78070b4c55a
16
SELECT encode(encrypt(
17
decode('00112233445566778899aabbccddeeff', 'hex'),
18
decode('000102030405060708090a0b0c0d0e0f1011121314151617', 'hex'),
19
'aes-ecb/pad:none'), 'hex');
21
----------------------------------
22
dda97ca4864cdfe06eaf70a0ec0d7191
25
SELECT encode(encrypt(
26
decode('00112233445566778899aabbccddeeff', 'hex'),
27
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'hex'),
28
'aes-ecb/pad:none'), 'hex');
30
----------------------------------
31
8ea2b7ca516745bfeafc49904b496089
35
SELECT encode(encrypt(
36
decode('00112233445566778899aabbccddeeff', 'hex'),
37
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b1c1d1e1f', 'hex'),
38
'aes-cbc/pad:none'), 'hex');
40
----------------------------------
41
8ea2b7ca516745bfeafc49904b496089
45
SELECT encode(encrypt(
46
decode('0011223344', 'hex'),
47
decode('000102030405', 'hex'),
50
----------------------------------
51
189a28932213f017b246678dbc28655f
54
SELECT encode(encrypt(
55
decode('0011223344', 'hex'),
56
decode('000102030405060708090a0b0c0d0e0f10111213', 'hex'),
59
----------------------------------
60
3b02279162d15580e069d3a71407a556
63
SELECT encode(encrypt(
64
decode('0011223344', 'hex'),
65
decode('000102030405060708090a0b0c0d0e0f101112131415161718191a1b', 'hex'),
68
----------------------------------
69
4facb6a041d53e0a5a73289170901fe7
73
select encode(encrypt('', 'foo', 'aes'), 'hex');
75
----------------------------------
76
b48cc3338a2eb293b6007ef72c360d48
80
select encode(encrypt('foo', '0123456789', 'aes'), 'hex');
82
----------------------------------
83
f397f03d2819b7172b68d0706fda4693
87
select encode(encrypt('foo', '0123456789012345678901', 'aes'), 'hex');
89
----------------------------------
90
5c9db77af02b4678117bcd8a71ae7f53
94
select decrypt(encrypt('foo', '0123456', 'aes'), '0123456', 'aes');
101
select encode(encrypt_iv('foo', '0123456', 'abcd', 'aes'), 'hex');
103
----------------------------------
104
2c24cb7da91d6d5699801268b0f5adad
107
select decrypt_iv(decode('2c24cb7da91d6d5699801268b0f5adad', 'hex'),
108
'0123456', 'abcd', 'aes');
115
select encode(encrypt('Lets try a longer message.', '0123456789', 'aes'), 'hex');
117
------------------------------------------------------------------
118
d9beb785dd5403ed02f66b755bb191b93ed93ca54930153f2c3b9ec7785056ad
121
select decrypt(encrypt('Lets try a longer message.', '0123456789', 'aes'), '0123456789', 'aes');
123
----------------------------
124
Lets try a longer message.