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


# Keys should be detected for constants with
# no duplicates in a column.

query T multiline
EXPLAIN TYPED PLAN FOR (VALUES (1, 1), (1, 2))
----
%0 =
| Constant (1, 1) (1, 2)
| | types = (integer, integer)
| | keys = ((#1))

EOF

# A global primary key should be detected for constants with fewer than two rows.

query T multiline
EXPLAIN TYPED PLAN FOR (VALUES (1, 2, 3))
----
%0 =
| Constant (1, 2, 3)
| | types = (integer, integer, integer)
| | keys = (())

EOF

# Each detected-unique column belongs in a separate key.

query T multiline
EXPLAIN TYPED PLAN FOR (VALUES (1, 1, 1), (2, 2, 1), (3, 3, 1))
----
%0 =
| Constant (1, 1, 1) (2, 2, 1) (3, 3, 1)
| | types = (integer, integer, integer)
| | keys = ((#0), (#1))

EOF