~vcs-imports/mammoth-replicator/trunk

« back to all changes in this revision

Viewing changes to contrib/pgcrypto/expected/hmac-sha1.out

  • Committer: alvherre
  • Date: 2005-12-16 21:24:52 UTC
  • Revision ID: svn-v4:db760fc0-0f08-0410-9d63-cc6633f64896:trunk:1
Initial import of the REL8_0_3 sources from the Pgsql CVS repository.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
--
 
2
-- HMAC-MD5
 
3
--
 
4
SELECT encode(hmac(
 
5
'Hi There',
 
6
decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
 
7
'sha1'), 'hex');
 
8
                  encode                  
 
9
------------------------------------------
 
10
 675b0b3a1b4ddf4e124872da6c2f632bfed957e9
 
11
(1 row)
 
12
 
 
13
-- 2
 
14
SELECT encode(hmac(
 
15
'Jefe',
 
16
'what do ya want for nothing?',
 
17
'sha1'), 'hex');
 
18
                  encode                  
 
19
------------------------------------------
 
20
 156d4c35468a0339f3fa57a067bf47f814eb7a57
 
21
(1 row)
 
22
 
 
23
-- 3
 
24
SELECT encode(hmac(
 
25
decode('dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'hex'),
 
26
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
 
27
'sha1'), 'hex');
 
28
                  encode                  
 
29
------------------------------------------
 
30
 d730594d167e35d5956fd8003d0db3d3f46dc7bb
 
31
(1 row)
 
32
 
 
33
-- 4
 
34
SELECT encode(hmac(
 
35
decode('cdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd', 'hex'),
 
36
decode('0102030405060708090a0b0c0d0e0f10111213141516171819', 'hex'),
 
37
'sha1'), 'hex');
 
38
                  encode                  
 
39
------------------------------------------
 
40
 4c9007f4026250c6bc8414f9bf50c86c2d7235da
 
41
(1 row)
 
42
 
 
43
-- 5
 
44
SELECT encode(hmac(
 
45
'Test With Truncation',
 
46
decode('0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c', 'hex'),
 
47
'sha1'), 'hex');
 
48
                  encode                  
 
49
------------------------------------------
 
50
 37268b7e21e84da5720c53c4ba03ad1104039fa7
 
51
(1 row)
 
52
 
 
53
-- 6
 
54
SELECT encode(hmac(
 
55
'Test Using Larger Than Block-Size Key - Hash Key First',
 
56
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
 
57
'sha1'), 'hex');
 
58
                  encode                  
 
59
------------------------------------------
 
60
 aa4ae5e15272d00e95705637ce8a3b55ed402112
 
61
(1 row)
 
62
 
 
63
-- 7
 
64
SELECT encode(hmac(
 
65
'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
 
66
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
 
67
'sha1'), 'hex');
 
68
                  encode                  
 
69
------------------------------------------
 
70
 e8e99d0f45237d786d6bbaa7965c7808bbff1a91
 
71
(1 row)
 
72