Materialize/test/sqllogictest/postgres/pgcrypto/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/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 digest('', 'md5')::text
----
\xd41d8cd98f00b204e9800998ecf8427e

query T
SELECT digest(''::bytea, 'md5')::text
----
\xd41d8cd98f00b204e9800998ecf8427e

query T
SELECT digest('a', 'md5')::text
----
\x0cc175b9c0f1b6a831c399e269772661

query T
SELECT digest('abc', 'md5')::text
----
\x900150983cd24fb0d6963f7d28e17f72

query T
SELECT digest('message digest', 'md5')::text
----
\xf96b697d7cb7938d525a2f31aaf161d0

query T
SELECT digest('abcdefghijklmnopqrstuvwxyz', 'md5')::text
----
\xc3fcd3d76192e4007dfb496cca67e13b

query T
SELECT digest('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789', 'md5')::text
----
\xd174ab98d277d9f5a5611c2c9f419d9f

query T
SELECT digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'md5')::text
----
\x57edf4a22be3c955ac49da2e2107b67a