diff options
| author | Bruce Momjian | 2006-03-08 03:51:52 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2006-03-08 03:51:52 +0000 |
| commit | daab4a101fc1198c20992c036157dd2a4b588a68 (patch) | |
| tree | 9ce111c82c2ce696dae473e92cc58b5c201157e4 /contrib/pgcrypto | |
| parent | 43ceb3d4493dc7bcd9a32302b04bd31f1f0edffc (diff) | |
Update /contrib regression tests for escape_string_warning.
Diffstat (limited to 'contrib/pgcrypto')
| -rw-r--r-- | contrib/pgcrypto/expected/pgp-encrypt.out | 6 | ||||
| -rw-r--r-- | contrib/pgcrypto/sql/pgp-encrypt.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/contrib/pgcrypto/expected/pgp-encrypt.out b/contrib/pgcrypto/expected/pgp-encrypt.out index ab33a04eec..637b473837 100644 --- a/contrib/pgcrypto/expected/pgp-encrypt.out +++ b/contrib/pgcrypto/expected/pgp-encrypt.out @@ -170,7 +170,7 @@ select pgp_sym_decrypt( -- crlf select encode(pgp_sym_decrypt_bytea( - pgp_sym_encrypt('1\n2\n3\r\n', 'key', 'convert-crlf=1'), + pgp_sym_encrypt(E'1\n2\n3\r\n', 'key', 'convert-crlf=1'), 'key'), 'hex'); encode ---------------------- @@ -179,9 +179,9 @@ select encode(pgp_sym_decrypt_bytea( -- conversion should be lossless select encode(digest(pgp_sym_decrypt( - pgp_sym_encrypt('\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'), + pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'), 'key', 'convert-crlf=1'), 'sha1'), 'hex') as result, - encode(digest('\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect; + encode(digest(E'\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect; result | expect ------------------------------------------+------------------------------------------ 47bde5d88d6ef8770572b9cbb4278b402aa69966 | 47bde5d88d6ef8770572b9cbb4278b402aa69966 diff --git a/contrib/pgcrypto/sql/pgp-encrypt.sql b/contrib/pgcrypto/sql/pgp-encrypt.sql index b663e051ae..03b34c8ad2 100644 --- a/contrib/pgcrypto/sql/pgp-encrypt.sql +++ b/contrib/pgcrypto/sql/pgp-encrypt.sql @@ -85,12 +85,12 @@ select pgp_sym_decrypt( -- crlf select encode(pgp_sym_decrypt_bytea( - pgp_sym_encrypt('1\n2\n3\r\n', 'key', 'convert-crlf=1'), + pgp_sym_encrypt(E'1\n2\n3\r\n', 'key', 'convert-crlf=1'), 'key'), 'hex'); -- conversion should be lossless select encode(digest(pgp_sym_decrypt( - pgp_sym_encrypt('\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'), + pgp_sym_encrypt(E'\r\n0\n1\r\r\n\n2\r', 'key', 'convert-crlf=1'), 'key', 'convert-crlf=1'), 'sha1'), 'hex') as result, - encode(digest('\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect; + encode(digest(E'\r\n0\n1\r\r\n\n2\r', 'sha1'), 'hex') as expect; |