Materialize/test/sqllogictest/cockroach/exec_merge_join.slt

# Copyright 2015 - 2019 The Cockroach Authors. All rights reserved.
# 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.
#
# This file is derived from the logic test suite in CockroachDB. The
# original file was retrieved on June 10, 2019 from:
#
#     https://github.com/cockroachdb/cockroach/blob/d2f7fbf5dd1fc1a099bbad790a2e1f7c60a66cc3/pkg/sql/logictest/testdata/logic_test/exec_merge_join
#
# The original source code is subject to the terms of the Apache
# 2.0 license, a copy of which can be found in the LICENSE file at the
# root of this repository.

mode cockroach

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

# Basic tables, no nulls

statement ok
CREATE TABLE t1 (k INT PRIMARY KEY, v INT)

statement ok
INSERT INTO t1 VALUES (-1, -1), (0, 4), (2, 1), (3, 4), (5, 4)

statement ok
CREATE TABLE t2 (x INT, y INT, INDEX x (x))

statement ok
INSERT INTO t2 VALUES (0, 5), (1, 3), (1, 4), (3, 2), (3, 3), (4, 6)

query IIII
SELECT k, v, x, y FROM t1 INNER MERGE JOIN t2 ON k = x
----
0 4 0 5
3 4 3 2
3 4 3 3

statement ok
DROP TABLE t1

statement ok
DROP TABLE t2

# Basic tables with nulls

statement ok
CREATE TABLE t1 (k INT, INDEX k(k))

statement ok
INSERT INTO t1 VALUES (0), (null)

statement ok
CREATE TABLE t2 (x INT, INDEX x (x))

statement ok
INSERT INTO t2 VALUES (0), (null)

query II
SELECT k, x FROM t1 INNER MERGE JOIN t2 ON k = x
----
0 0