| 1234567891011121314151617181920212223242526 |
- # 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)
|
