# 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

statement ok
CREATE TABLE t (a int, b string, c int)

statement ok
INSERT INTO t (a, b, c) VALUES (1, 'test', 1)

statement ok
INSERT INTO t (a, b, c) VALUES (0, 'test', 1)

statement ok
INSERT INTO t (a, b, c) VALUES (3, 'test', 1)

# Regression test for database-issues#1555
statement error Evaluation error: division by zero
SELECT recip - 1 FROM (SELECT b, 1/a as recip, max(c) from t GROUP BY b, 1/a)