/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/pgcrypto/sql/hmac-sha1.sql
44 строки
1 KB
Peter Eisentraut
pgcrypto: Remove explicit hex encoding/decoding from tests
08 дек 2021, 08:06
08 дек 2021, 08:06
814e1d9
Код
Авторство
О чём код?
-- -- HMAC-SHA1 -- SELECT hmac( 'Hi There', '\x0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b'::bytea, 'sha1'); -- 2 SELECT hmac( 'Jefe', 'what do ya want for nothing?', 'sha1'); -- 3 SELECT hmac( '\xdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd'::bytea, '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea, 'sha1'); -- 4 SELECT hmac( '\xcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd'::bytea, '\x0102030405060708090a0b0c0d0e0f10111213141516171819'::bytea, 'sha1'); -- 5 SELECT hmac( 'Test With Truncation', '\x0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c'::bytea, 'sha1'); -- 6 SELECT hmac( 'Test Using Larger Than Block-Size Key - Hash Key First', '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea, 'sha1'); -- 7 SELECT hmac( 'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data', '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea, 'sha1');