Materialize/test/sqllogictest/pg_size_pretty.slt

# Copyright 1994, Regents of the University of California.
# Copyright 1996-2024 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 Jul 15, 2024 from:
#
#     https://github.com/postgres/postgres/blob/74e12db19cbc78258a92da8be637a3fb0106b126/src/test/regress/expected/dbsize.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.

mode cockroach

query TTT rowsort
SELECT size, pg_size_pretty(size), pg_size_pretty(-1 * size) FROM
   (VALUES (10::bigint), (1000::bigint), (1000000::bigint),
           (1000000000::bigint), (1000000000000::bigint),
           (1000000000000000::bigint)) x(size);
----
10	10␠bytes	-10␠bytes
1000	1000␠bytes	-1000␠bytes
1000000	977␠kB	-977␠kB
1000000000	954␠MB	-954␠MB
1000000000000	931␠GB	-931␠GB
1000000000000000	909␠TB	-909␠TB

query TTT rowsort
SELECT size, pg_size_pretty(size), pg_size_pretty(-1 * size) FROM
   (VALUES (10::numeric), (1000::numeric), (1000000::numeric),
           (1000000000::numeric), (1000000000000::numeric),
           (1000000000000000::numeric),
           (10.5::numeric), (1000.5::numeric), (1000000.5::numeric),
           (1000000000.5::numeric), (1000000000000.5::numeric),
           (1000000000000000.5::numeric)) x(size);
----
10	10␠bytes	-10␠bytes
1000	1000␠bytes	-1000␠bytes
1000000	977␠kB	-977␠kB
1000000000	954␠MB	-954␠MB
1000000000000	931␠GB	-931␠GB
1000000000000000	909␠TB	-909␠TB
10.5	10.5␠bytes	-10.5␠bytes
1000.5	1000.5␠bytes	-1000.5␠bytes
1000000.5	977␠kB	-977␠kB
1000000000.5	954␠MB	-954␠MB
1000000000000.5	931␠GB	-931␠GB
1000000000000000.5	909␠TB	-909␠TB

query TTT rowsort
SELECT size, pg_size_pretty(size), pg_size_pretty(-1 * size) FROM
   (VALUES (10239::bigint), (10240::bigint),
           (10485247::bigint), (10485248::bigint),
           (10736893951::bigint), (10736893952::bigint),
           (10994579406847::bigint), (10994579406848::bigint),
           (11258449312612351::bigint), (11258449312612352::bigint)) x(size);
----
10239	10239␠bytes	-10239␠bytes
10240	10␠kB	-10␠kB
10485247	10239␠kB	-10239␠kB
10485248	10␠MB	-10␠MB
10736893951	10239␠MB	-10239␠MB
10736893952	10␠GB	-10␠GB
10994579406847	10239␠GB	-10239␠GB
10994579406848	10␠TB	-10␠TB
11258449312612351	10239␠TB	-10239␠TB
11258449312612352	10␠PB	-10␠PB

query TTT rowsort
SELECT size, pg_size_pretty(size), pg_size_pretty(-1 * size) FROM
   (VALUES (10239::numeric), (10240::numeric),
           (10485247::numeric), (10485248::numeric),
           (10736893951::numeric), (10736893952::numeric),
           (10994579406847::numeric), (10994579406848::numeric),
           (11258449312612351::numeric), (11258449312612352::numeric),
           (11528652096115048447::numeric), (11528652096115048448::numeric)) x(size);
----
10239	10239␠bytes	-10239␠bytes
10240	10␠kB	-10␠kB
10485247	10239␠kB	-10239␠kB
10485248	10␠MB	-10␠MB
10736893951	10239␠MB	-10239␠MB
10736893952	10␠GB	-10␠GB
10994579406847	10239␠GB	-10239␠GB
10994579406848	10␠TB	-10␠TB
11258449312612351	10239␠TB	-10239␠TB
11258449312612352	10␠PB	-10␠PB
11528652096115048447	10239␠PB	-10239␠PB
11528652096115048448	10240␠PB	-10240␠PB