contrib/pgcrypto/sql/hmac-md5.sql

   1 --
   2 -- HMAC-MD5
   3 --
   4
   5 SELECT hmac(
   6 'Hi There',
   7 '\x0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b'::bytea,
   8 'md5');
   9
  10 -- 2
  11 SELECT hmac(
  12 'Jefe',
  13 'what do ya want for nothing?',
  14 'md5');
  15
  16 -- 3
  17 SELECT hmac(
  18 '\xdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd'::bytea,
  19 '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  20 'md5');
  21
  22 -- 4
  23 SELECT hmac(
  24 '\xcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd'::bytea,
  25 '\x0102030405060708090a0b0c0d0e0f10111213141516171819'::bytea,
  26 'md5');
  27
  28 -- 5
  29 SELECT hmac(
  30 'Test With Truncation',
  31 '\x0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c'::bytea,
  32 'md5');
  33
  34 -- 6
  35 SELECT hmac(
  36 'Test Using Larger Than Block-Size Key - Hash Key First',
  37 '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  38 'md5');
  39
  40 -- 7
  41 SELECT hmac(
  42 'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
  43 '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  44 'md5');