Materialize/test/sqllogictest/postgres/pgcrypto/hmac-md5.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-md5.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, 'md5')::text
----
\x9294727a3638bb1c13f48ef8158bfc9d

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

query T
SELECT hmac(
  '\xdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd'::bytea,
  '\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'::bytea,
  'md5'
)::text
----
\x56be34521d144c88dbb8c733f0e8b3f6

query T
SELECT hmac(
  '\xcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd'::bytea,
  '\x0102030405060708090a0b0c0d0e0f10111213141516171819',
  'md5'
)::text
----
\x697eaf0aca3a3aea3a75164746ffaa79

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

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

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