← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to contrib/pgcrypto/expected/sha2.out

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/pgcrypto/expected/sha2.out
 
1
--
 
2
-- SHA2 family
 
3
--
 
4
-- SHA224
 
5
SELECT encode(digest('', 'sha224'), 'hex');
 
6
                          encode                          
 
7
----------------------------------------------------------
 
8
 d14a028c2a3a2bc9476102bb288234c415a2b01f828ea62ac5b3e42f
 
9
(1 row)
 
10
 
 
11
SELECT encode(digest('a', 'sha224'), 'hex');
 
12
                          encode                          
 
13
----------------------------------------------------------
 
14
 abd37534c7d9a2efb9465de931cd7055ffdb8879563ae98078d6d6d5
 
15
(1 row)
 
16
 
 
17
SELECT encode(digest('abc', 'sha224'), 'hex');
 
18
                          encode                          
 
19
----------------------------------------------------------
 
20
 23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7
 
21
(1 row)
 
22
 
 
23
SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha224'), 'hex');
 
24
                          encode                          
 
25
----------------------------------------------------------
 
26
 75388b16512776cc5dba5da1fd890150b0c6455cb4f58b1952522525
 
27
(1 row)
 
28
 
 
29
SELECT encode(digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'sha224'), 'hex');
 
30
                          encode                          
 
31
----------------------------------------------------------
 
32
 b50aecbe4e9bb0b57bc5f3ae760a8e01db24f203fb3cdcd13148046e
 
33
(1 row)
 
34
 
 
35
-- SHA256
 
36
SELECT encode(digest('', 'sha256'), 'hex');
 
37
                              encode                              
 
38
------------------------------------------------------------------
 
39
 e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
 
40
(1 row)
 
41
 
 
42
SELECT encode(digest('a', 'sha256'), 'hex');
 
43
                              encode                              
 
44
------------------------------------------------------------------
 
45
 ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb
 
46
(1 row)
 
47
 
 
48
SELECT encode(digest('abc', 'sha256'), 'hex');
 
49
                              encode                              
 
50
------------------------------------------------------------------
 
51
 ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad
 
52
(1 row)
 
53
 
 
54
SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha256'), 'hex');
 
55
                              encode                              
 
56
------------------------------------------------------------------
 
57
 248d6a61d20638b8e5c026930c3e6039a33ce45964ff2167f6ecedd419db06c1
 
58
(1 row)
 
59
 
 
60
SELECT encode(digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'sha256'), 'hex');
 
61
                              encode                              
 
62
------------------------------------------------------------------
 
63
 f371bc4a311f2b009eef952dd83ca80e2b60026c8e935592d0f9c308453c813e
 
64
(1 row)
 
65
 
 
66
-- SHA384
 
67
SELECT encode(digest('', 'sha384'), 'hex');
 
68
                                              encode                                              
 
69
--------------------------------------------------------------------------------------------------
 
70
 38b060a751ac96384cd9327eb1b1e36a21fdb71114be07434c0cc7bf63f6e1da274edebfe76f65fbd51ad2f14898b95b
 
71
(1 row)
 
72
 
 
73
SELECT encode(digest('a', 'sha384'), 'hex');
 
74
                                              encode                                              
 
75
--------------------------------------------------------------------------------------------------
 
76
 54a59b9f22b0b80880d8427e548b7c23abd873486e1f035dce9cd697e85175033caa88e6d57bc35efae0b5afd3145f31
 
77
(1 row)
 
78
 
 
79
SELECT encode(digest('abc', 'sha384'), 'hex');
 
80
                                              encode                                              
 
81
--------------------------------------------------------------------------------------------------
 
82
 cb00753f45a35e8bb5a03d699ac65007272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358baeca134c825a7
 
83
(1 row)
 
84
 
 
85
SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha384'), 'hex');
 
86
                                              encode                                              
 
87
--------------------------------------------------------------------------------------------------
 
88
 3391fdddfc8dc7393707a65b1b4709397cf8b1d162af05abfe8f450de5f36bc6b0455a8520bc4e6f5fe95b1fe3c8452b
 
89
(1 row)
 
90
 
 
91
SELECT encode(digest('abcdefghbcdefghicdefghijdefghijkefghijklfghijklmghijklmnhijklmnoijklmnopjklmnopqklmnopqrlmnopqrsmnopqrstnopqrstu', 'sha384'), 'hex');
 
92
                                              encode                                              
 
93
--------------------------------------------------------------------------------------------------
 
94
 09330c33f71147e83d192fc782cd1b4753111b173b3b05d22fa08086e3b0f712fcc7c71a557e2db966c3e9fa91746039
 
95
(1 row)
 
96
 
 
97
SELECT encode(digest('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz', 'sha384'), 'hex');
 
98
                                              encode                                              
 
99
--------------------------------------------------------------------------------------------------
 
100
 3d208973ab3508dbbd7e2c2862ba290ad3010e4978c198dc4d8fd014e582823a89e16f9b2a7bbc1ac938e2d199e8bea4
 
101
(1 row)
 
102
 
 
103
-- SHA512
 
104
SELECT encode(digest('', 'sha512'), 'hex');
 
105
                                                              encode                                                              
 
106
----------------------------------------------------------------------------------------------------------------------------------
 
107
 cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e
 
108
(1 row)
 
109
 
 
110
SELECT encode(digest('a', 'sha512'), 'hex');
 
111
                                                              encode                                                              
 
112
----------------------------------------------------------------------------------------------------------------------------------
 
113
 1f40fc92da241694750979ee6cf582f2d5d7d28e18335de05abc54d0560e0f5302860c652bf08d560252aa5e74210546f369fbbbce8c12cfc7957b2652fe9a75
 
114
(1 row)
 
115
 
 
116
SELECT encode(digest('abc', 'sha512'), 'hex');
 
117
                                                              encode                                                              
 
118
----------------------------------------------------------------------------------------------------------------------------------
 
119
 ddaf35a193617abacc417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a2192992a274fc1a836ba3c23a3feebbd454d4423643ce80e2a9ac94fa54ca49f
 
120
(1 row)
 
121
 
 
122
SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha512'), 'hex');
 
123
                                                              encode                                                              
 
124
----------------------------------------------------------------------------------------------------------------------------------
 
125
 204a8fc6dda82f0a0ced7beb8e08a41657c16ef468b228a8279be331a703c33596fd15c13b1b07f9aa1d3bea57789ca031ad85c7a71dd70354ec631238ca3445
 
126
(1 row)
 
127
 
 
128
SELECT encode(digest('abcdefghbcdefghicdefghijdefghijkefghijklfghijklmghijklmnhijklmnoijklmnopjklmnopqklmnopqrlmnopqrsmnopqrstnopqrstu', 'sha512'), 'hex');
 
129
                                                              encode                                                              
 
130
----------------------------------------------------------------------------------------------------------------------------------
 
131
 8e959b75dae313da8cf4f72814fc143f8f7779c6eb9f7fa17299aeadb6889018501d289e4900f7e4331b99dec4b5433ac7d329eeb6dd26545e96e55b874be909
 
132
(1 row)
 
133
 
 
134
SELECT encode(digest('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz', 'sha512'), 'hex');
 
135
                                                              encode                                                              
 
136
----------------------------------------------------------------------------------------------------------------------------------
 
137
 930d0cefcb30ff1133b6898121f1cf3d27578afcafe8677c5257cf069911f75d8f5831b56ebfda67b278e66dff8b84fe2b2870f742a580d8edb41987232850c9
 
138
(1 row)
 
139