contrib/pgcrypto/expected/pgp-encrypt.out

   1 --
   2 -- PGP encrypt
   3 --
   4 select pgp_sym_decrypt(pgp_sym_encrypt('Secret.', 'key'), 'key');
   5  pgp_sym_decrypt
   6 -----------------
   7  Secret.
   8 (1 row)
   9
  10 -- check whether the defaults are ok
  11 select pgp_sym_decrypt(pgp_sym_encrypt('Secret.', 'key'),
  12         'key', 'expect-cipher-algo=aes128,
  13                 expect-disable-mdc=0,
  14                 expect-sess-key=0,
  15                 expect-s2k-mode=3,
  16                 expect-s2k-digest-algo=sha1,
  17                 expect-compress-algo=0
  18                 ');
  19  pgp_sym_decrypt
  20 -----------------
  21  Secret.
  22 (1 row)
  23
  24 -- maybe the expect- stuff simply does not work
  25 select pgp_sym_decrypt(pgp_sym_encrypt('Secret.', 'key'),
  26         'key', 'expect-cipher-algo=bf,
  27                 expect-disable-mdc=1,
  28                 expect-sess-key=1,
  29                 expect-s2k-mode=0,
  30                 expect-s2k-digest-algo=md5,
  31                 expect-compress-algo=1
  32                 ');
  33 NOTICE:  pgp_decrypt: unexpected cipher_algo: expected 4 got 7
  34 NOTICE:  pgp_decrypt: unexpected s2k_mode: expected 0 got 3
  35 NOTICE:  pgp_decrypt: unexpected s2k_digest_algo: expected 1 got 2
  36 NOTICE:  pgp_decrypt: unexpected use_sess_key: expected 1 got 0
  37 NOTICE:  pgp_decrypt: unexpected disable_mdc: expected 1 got 0
  38 NOTICE:  pgp_decrypt: unexpected compress_algo: expected 1 got 0
  39  pgp_sym_decrypt
  40 -----------------
  41  Secret.
  42 (1 row)
  43
  44 -- bytea as text
  45 select pgp_sym_decrypt(pgp_sym_encrypt_bytea('Binary', 'baz'), 'baz');
  46 ERROR:  Not text data
  47 -- text as bytea
  48 select encode(pgp_sym_decrypt_bytea(pgp_sym_encrypt('Text', 'baz'), 'baz'), 'escape');
  49  encode
  50 --------
  51  Text
  52 (1 row)
  53
  54 -- algorithm change
  55 select pgp_sym_decrypt(
  56         pgp_sym_encrypt('Secret.', 'key', 'cipher-algo=bf'),
  57         'key', 'expect-cipher-algo=bf');
  58  pgp_sym_decrypt
  59 -----------------
  60  Secret.
  61 (1 row)
  62
  63 select pgp_sym_decrypt(
  64         pgp_sym_encrypt('Secret.', 'key', 'cipher-algo=aes'),
  65         'key', 'expect-cipher-algo=aes128');
  66  pgp_sym_decrypt
  67 -----------------
  68  Secret.
  69 (1 row)
  70
  71 select pgp_sym_decrypt(
  72         pgp_sym_encrypt('Secret.', 'key', 'cipher-algo=aes192'),
  73         'key', 'expect-cipher-algo=aes192');
  74  pgp_sym_decrypt
  75 -----------------
  76  Secret.
  77 (1 row)
  78
  79 -- s2k change
  80 select pgp_sym_decrypt(
  81         pgp_sym_encrypt('Secret.', 'key', 's2k-mode=0'),
  82         'key', 'expect-s2k-mode=0');
  83  pgp_sym_decrypt
  84 -----------------
  85  Secret.
  86 (1 row)
  87
  88 select pgp_sym_decrypt(
  89         pgp_sym_encrypt('Secret.', 'key', 's2k-mode=1'),
  90         'key', 'expect-s2k-mode=1');
  91  pgp_sym_decrypt
  92 -----------------
  93  Secret.
  94 (1 row)
  95
  96 select pgp_sym_decrypt(
  97         pgp_sym_encrypt('Secret.', 'key', 's2k-mode=3'),
  98         'key', 'expect-s2k-mode=3');
  99  pgp_sym_decrypt
 100 -----------------
 101  Secret.
 102 (1 row)
 103
 104 -- s2k count change
 105 select pgp_sym_decrypt(
 106         pgp_sym_encrypt('Secret.', 'key', 's2k-count=1024'),
 107         'key', 'expect-s2k-count=1024');
 108  pgp_sym_decrypt
 109 -----------------
 110  Secret.
 111 (1 row)
 112
 113 -- s2k_count rounds up
 114 select pgp_sym_decrypt(
 115         pgp_sym_encrypt('Secret.', 'key', 's2k-count=65000000'),
 116         'key', 'expect-s2k-count=65000000');
 117 NOTICE:  pgp_decrypt: unexpected s2k_count: expected 65000000 got 65011712
 118  pgp_sym_decrypt
 119 -----------------
 120  Secret.
 121 (1 row)
 122
 123 -- s2k digest change
 124 select pgp_sym_decrypt(
 125                 pgp_sym_encrypt('Secret.', 'key', 's2k-digest-algo=sha1'),
 126         'key', 'expect-s2k-digest-algo=sha1');
 127  pgp_sym_decrypt
 128 -----------------
 129  Secret.
 130 (1 row)
 131
 132 -- sess key
 133 select pgp_sym_decrypt(
 134         pgp_sym_encrypt('Secret.', 'key', 'sess-key=0'),
 135         'key', 'expect-sess-key=0');
 136  pgp_sym_decrypt
 137 -----------------
 138  Secret.
 139 (1 row)
 140
 141 select pgp_sym_decrypt(
 142         pgp_sym_encrypt('Secret.', 'key', 'sess-key=1'),
 143         'key', 'expect-sess-key=1');
 144  pgp_sym_decrypt
 145 -----------------
 146  Secret.
 147 (1 row)
 148
 149 select pgp_sym_decrypt(
 150         pgp_sym_encrypt('Secret.', 'key', 'sess-key=1, cipher-algo=bf'),
 151         'key', 'expect-sess-key=1, expect-cipher-algo=bf');
 152  pgp_sym_decrypt
 153 -----------------
 154  Secret.
 155 (1 row)
 156
 157 select pgp_sym_decrypt(
 158         pgp_sym_encrypt('Secret.', 'key', 'sess-key=1, cipher-algo=aes192'),
 159         'key', 'expect-sess-key=1, expect-cipher-algo=aes192');
 160  pgp_sym_decrypt
 161 -----------------
 162  Secret.
 163 (1 row)
 164
 165 select pgp_sym_decrypt(
 166         pgp_sym_encrypt('Secret.', 'key', 'sess-key=1, cipher-algo=aes256'),
 167         'key', 'expect-sess-key=1, expect-cipher-algo=aes256');
 168  pgp_sym_decrypt
 169 -----------------
 170  Secret.
 171 (1 row)
 172
 173 -- no mdc
 174 select pgp_sym_decrypt(
 175                 pgp_sym_encrypt('Secret.', 'key', 'disable-mdc=1'),
 176         'key', 'expect-disable-mdc=1');
 177  pgp_sym_decrypt
 178 -----------------
 179  Secret.
 180 (1 row)
 181
 182 -- crlf
 183 select pgp_sym_decrypt_bytea(
 184         pgp_sym_encrypt(E'1\n2\n3\r\n', 'key', 'convert-crlf=1'),
 185         'key');
 186  pgp_sym_decrypt_bytea
 187 ------------------------
 188  \x310d0a320d0a330d0d0a
 189 (1 row)
 190
 191 -- conversion should be lossless
 192 select digest(pgp_sym_decrypt(
 193   pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'),
 194         'key', 'convert-crlf=1'), 'sha1') as result,
 195   digest(E'\r\n0\n1\r\r\n\n2\r', 'sha1') as expect;
 196                    result                   |                   expect
 197 --------------------------------------------+--------------------------------------------
 198  \x47bde5d88d6ef8770572b9cbb4278b402aa69966 | \x47bde5d88d6ef8770572b9cbb4278b402aa69966
 199 (1 row)
 200