Materialize/test/sqllogictest/special/memory.slt

# 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.

# Generates a massive cross-join so that Materialize's memory footprint can
# be measured.

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET unsafe_enable_table_keys = true
----
COMPLETE 0

statement ok
CREATE TABLE t1 (
  a1 integer PRIMARY KEY,
  b1 integer,
  x1 varchar(40)
)

statement ok
INSERT INTO t1 VALUES (1, 1, 'table t1 row 1')

statement ok
INSERT INTO t1 VALUES (2, 9, 'table t1 row 2')

statement ok
INSERT INTO t1 VALUES (3, 8, 'table t1 row 3')

statement ok
INSERT INTO t1 VALUES (4, 4, 'table t1 row 4')

statement ok
INSERT INTO t1 VALUES (5, 2, 'table t1 row 5')

statement ok
INSERT INTO t1 VALUES (6, 3, 'table t1 row 6')

statement ok
INSERT INTO t1 VALUES (7, 6, 'table t1 row 7')

statement ok
INSERT INTO t1 VALUES (8, 7, 'table t1 row 8')

statement ok
INSERT INTO t1 VALUES (9, 10, 'table t1 row 9')

statement ok
INSERT INTO t1 VALUES (10, 5, 'table t1 row 10')

statement ok
CREATE TABLE t2 (
  a2 integer PRIMARY KEY,
  b2 integer,
  x2 varchar(40)
)

statement ok
INSERT INTO t2 VALUES (1, 7, 'table t2 row 1')

statement ok
INSERT INTO t2 VALUES (2, 5, 'table t2 row 2')

statement ok
INSERT INTO t2 VALUES (3, 9, 'table t2 row 3')

statement ok
INSERT INTO t2 VALUES (4, 3, 'table t2 row 4')

statement ok
INSERT INTO t2 VALUES (5, 2, 'table t2 row 5')

statement ok
INSERT INTO t2 VALUES (6, 10, 'table t2 row 6')

statement ok
INSERT INTO t2 VALUES (7, 8, 'table t2 row 7')

statement ok
INSERT INTO t2 VALUES (8, 6, 'table t2 row 8')

statement ok
INSERT INTO t2 VALUES (9, 4, 'table t2 row 9')

statement ok
INSERT INTO t2 VALUES (10, 1, 'table t2 row 10')

statement ok
CREATE TABLE t3 (
  a3 integer PRIMARY KEY,
  b3 integer,
  x3 varchar(40)
)

statement ok
INSERT INTO t3 VALUES (1, 6, 'table t3 row 1')

statement ok
INSERT INTO t3 VALUES (2, 8, 'table t3 row 2')

statement ok
INSERT INTO t3 VALUES (3, 3, 'table t3 row 3')

statement ok
INSERT INTO t3 VALUES (4, 2, 'table t3 row 4')

statement ok
INSERT INTO t3 VALUES (5, 4, 'table t3 row 5')

statement ok
INSERT INTO t3 VALUES (6, 5, 'table t3 row 6')

statement ok
INSERT INTO t3 VALUES (7, 9, 'table t3 row 7')

statement ok
INSERT INTO t3 VALUES (8, 10, 'table t3 row 8')

statement ok
INSERT INTO t3 VALUES (9, 1, 'table t3 row 9')

statement ok
INSERT INTO t3 VALUES (10, 7, 'table t3 row 10')

statement ok
CREATE TABLE t4 (
  a4 integer PRIMARY KEY,
  b4 integer,
  x4 varchar(40)
)

statement ok
INSERT INTO t4 VALUES (1, 2, 'table t4 row 1')

statement ok
INSERT INTO t4 VALUES (2, 6, 'table t4 row 2')

statement ok
INSERT INTO t4 VALUES (3, 10, 'table t4 row 3')

statement ok
INSERT INTO t4 VALUES (4, 4, 'table t4 row 4')

statement ok
INSERT INTO t4 VALUES (5, 1, 'table t4 row 5')

statement ok
INSERT INTO t4 VALUES (6, 8, 'table t4 row 6')

statement ok
INSERT INTO t4 VALUES (7, 7, 'table t4 row 7')

statement ok
INSERT INTO t4 VALUES (8, 5, 'table t4 row 8')

statement ok
INSERT INTO t4 VALUES (9, 3, 'table t4 row 9')

statement ok
INSERT INTO t4 VALUES (10, 9, 'table t4 row 10')

statement ok
CREATE TABLE t5 (
  a5 integer PRIMARY KEY,
  b5 integer,
  x5 varchar(40)
)

statement ok
INSERT INTO t5 VALUES (1, 9, 'table t5 row 1')

statement ok
INSERT INTO t5 VALUES (2, 5, 'table t5 row 2')

statement ok
INSERT INTO t5 VALUES (3, 10, 'table t5 row 3')

statement ok
INSERT INTO t5 VALUES (4, 7, 'table t5 row 4')

statement ok
INSERT INTO t5 VALUES (5, 4, 'table t5 row 5')

statement ok
INSERT INTO t5 VALUES (6, 2, 'table t5 row 6')

statement ok
INSERT INTO t5 VALUES (7, 1, 'table t5 row 7')

statement ok
INSERT INTO t5 VALUES (8, 8, 'table t5 row 8')

statement ok
INSERT INTO t5 VALUES (9, 3, 'table t5 row 9')

statement ok
INSERT INTO t5 VALUES (10, 6, 'table t5 row 10')

statement ok
CREATE TABLE t6 (
  a6 integer PRIMARY KEY,
  b6 integer,
  x6 varchar(40)
)

statement ok
INSERT INTO t6 VALUES (1, 2, 'table t6 row 1')

statement ok
INSERT INTO t6 VALUES (2, 5, 'table t6 row 2')

statement ok
INSERT INTO t6 VALUES (3, 9, 'table t6 row 3')

statement ok
INSERT INTO t6 VALUES (4, 3, 'table t6 row 4')

statement ok
INSERT INTO t6 VALUES (5, 1, 'table t6 row 5')

statement ok
INSERT INTO t6 VALUES (6, 8, 'table t6 row 6')

statement ok
INSERT INTO t6 VALUES (7, 10, 'table t6 row 7')

statement ok
INSERT INTO t6 VALUES (8, 6, 'table t6 row 8')

statement ok
INSERT INTO t6 VALUES (9, 4, 'table t6 row 9')

statement ok
INSERT INTO t6 VALUES (10, 7, 'table t6 row 10')

statement ok
CREATE TABLE t7 (
  a7 integer PRIMARY KEY,
  b7 integer,
  x7 varchar(40)
)

statement ok
INSERT INTO t7 VALUES (1, 1, 'table t7 row 1')

statement ok
INSERT INTO t7 VALUES (2, 5, 'table t7 row 2')

statement ok
INSERT INTO t7 VALUES (3, 3, 'table t7 row 3')

statement ok
INSERT INTO t7 VALUES (4, 9, 'table t7 row 4')

statement ok
INSERT INTO t7 VALUES (5, 8, 'table t7 row 5')

statement ok
INSERT INTO t7 VALUES (6, 4, 'table t7 row 6')

statement ok
INSERT INTO t7 VALUES (7, 2, 'table t7 row 7')

statement ok
INSERT INTO t7 VALUES (8, 10, 'table t7 row 8')

statement ok
INSERT INTO t7 VALUES (9, 6, 'table t7 row 9')

statement ok
INSERT INTO t7 VALUES (10, 7, 'table t7 row 10')

statement ok
CREATE TABLE t8 (
  a8 integer PRIMARY KEY,
  b8 integer,
  x8 varchar(40)
)

statement ok
INSERT INTO t8 VALUES (1, 3, 'table t8 row 1')

statement ok
INSERT INTO t8 VALUES (2, 10, 'table t8 row 2')

statement ok
INSERT INTO t8 VALUES (3, 8, 'table t8 row 3')

statement ok
INSERT INTO t8 VALUES (4, 6, 'table t8 row 4')

statement ok
INSERT INTO t8 VALUES (5, 7, 'table t8 row 5')

statement ok
INSERT INTO t8 VALUES (6, 4, 'table t8 row 6')

statement ok
INSERT INTO t8 VALUES (7, 2, 'table t8 row 7')

statement ok
INSERT INTO t8 VALUES (8, 9, 'table t8 row 8')

statement ok
INSERT INTO t8 VALUES (9, 5, 'table t8 row 9')

statement ok
INSERT INTO t8 VALUES (10, 1, 'table t8 row 10')

statement ok
CREATE TABLE t9 (
  a9 integer PRIMARY KEY,
  b9 integer,
  x9 varchar(40)
)

statement ok
INSERT INTO t9 VALUES (1, 3, 'table t9 row 1')

statement ok
INSERT INTO t9 VALUES (2, 4, 'table t9 row 2')

statement ok
INSERT INTO t9 VALUES (3, 6, 'table t9 row 3')

statement ok
INSERT INTO t9 VALUES (4, 5, 'table t9 row 4')

statement ok
INSERT INTO t9 VALUES (5, 9, 'table t9 row 5')

statement ok
INSERT INTO t9 VALUES (6, 7, 'table t9 row 6')

statement ok
INSERT INTO t9 VALUES (7, 2, 'table t9 row 7')

statement ok
INSERT INTO t9 VALUES (8, 1, 'table t9 row 8')

statement ok
INSERT INTO t9 VALUES (9, 10, 'table t9 row 9')

statement ok
INSERT INTO t9 VALUES (10, 8, 'table t9 row 10')

statement ok
CREATE TABLE t10 (
  a10 integer PRIMARY KEY,
  b10 integer,
  x10 varchar(40)
)

statement ok
INSERT INTO t10 VALUES (1, 8, 'table t10 row 1')

statement ok
INSERT INTO t10 VALUES (2, 10, 'table t10 row 2')

statement ok
INSERT INTO t10 VALUES (3, 7, 'table t10 row 3')

statement ok
INSERT INTO t10 VALUES (4, 1, 'table t10 row 4')

statement ok
INSERT INTO t10 VALUES (5, 5, 'table t10 row 5')

statement ok
INSERT INTO t10 VALUES (6, 4, 'table t10 row 6')

statement ok
INSERT INTO t10 VALUES (7, 3, 'table t10 row 7')

statement ok
INSERT INTO t10 VALUES (8, 9, 'table t10 row 8')

statement ok
INSERT INTO t10 VALUES (9, 6, 'table t10 row 9')

statement ok
INSERT INTO t10 VALUES (10, 2, 'table t10 row 10')

query IITIITIITIITIITIIT nosort
SELECT *
  FROM t1, t2, t3, t4, t5, t6
  ORDER BY a1, a2, a3, a4, a5, a6
  LIMIT 1
----
18 values hashing to 2de53412d2ea9c3a2645ae7e81af8160