Materialize/test/sqllogictest/postgres/pgcrypto/hmac-sha1.slt

# Copyright 1994, Regents of the University of California.
# Copyright 1996-2020 PostgreSQL Global Development Group.
# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.
#
# This file is derived from the regression test suite in PostgreSQL.
# The original file was retrieved on December 14, 2020 from:
#
#     https://github.com/postgres/postgres/blob/9b584953e7bf91e342af87ef44606acd6206cd1c/contrib/pgcrypto/expected/hmac-sha1.out
#
# The original source code is subject to the terms of the PostgreSQL
# license, a copy of which can be found in the LICENSE file at the
# root of this repository

query T
SELECT hmac('Hi There', '\x0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b'::bytea, 'sha1')::text
----
\x675b0b3a1b4ddf4e124872da6c2f632bfed957e9

query T
SELECT hmac('Jefe', 'what do ya want for nothing?', 'sha1')::text
----
\x156d4c35468a0339f3fa57a067bf47f814eb7a57

query T
SELECT hmac(
  '\xdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd'::bytea,
  '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  'sha1'
)::text
----
\xd730594d167e35d5956fd8003d0db3d3f46dc7bb

query T
SELECT hmac(
  '\xcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd'::bytea,
  '\x0102030405060708090a0b0c0d0e0f10111213141516171819',
  'sha1'
)::text
----
\x4c9007f4026250c6bc8414f9bf50c86c2d7235da

query T
SELECT hmac(
  'Test With Truncation',
  '\x0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c'::bytea,
  'sha1'
)::text
----
\x37268b7e21e84da5720c53c4ba03ad1104039fa7

query T
SELECT hmac(
  'Test Using Larger Than Block-Size Key - Hash Key First',
  '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  'sha1'
)::text
----
\xaa4ae5e15272d00e95705637ce8a3b55ed402112

query T
SELECT hmac(
  'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
  '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  'sha1'
)::text
----
\xe8e99d0f45237d786d6bbaa7965c7808bbff1a91