Materialize/test/sqllogictest/max_result_size.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.

mode cockroach

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET max_result_size TO 1;
----
db error: ERROR: parameter "max_result_size" cannot have value "1B": only supports values in range ByteSize(1048576)..

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET max_result_size TO '1MB';
----
COMPLETE 0

simple conn=mz_system,user=mz_system
ALTER SYSTEM SET enable_compute_peek_response_stash TO 'false';
----
COMPLETE 0

statement ok
CREATE CLUSTER c1 SIZE 'mem-2';

query I
SELECT workers FROM mz_catalog.mz_cluster_replica_sizes JOIN mz_cluster_replicas USING (size) JOIN mz_clusters ON mz_cluster_replicas.cluster_id = mz_clusters.id WHERE mz_clusters.name != 'quickstart';
----
2
2
2
8

statement ok
CREATE TABLE t1 (a int, b text);

statement ok
INSERT INTO t1 SELECT * FROM generate_series(1, 10000), repeat('a', 100);

statement ok
SET cluster TO 'c1';

# Note: 'total' in the error message here is important because it indicates we failed when
# aggregating the result from multiple workers, as opposed to on any single worker.
query error db error: ERROR: total result exceeds max size of 1048.6 KB
SELECT * FROM t1;