contrib/pgcrypto/expected/hmac-sha1.out

   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