| 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 t1(f1 int, f2 int)
- statement ok
- CREATE TABLE t2(f1 int, f2 int)
- query T multiline
- EXPLAIN OPTIMIZED PLAN WITH(humanized expressions, arity, join implementations) AS VERBOSE TEXT FOR SELECT FROM t1 LEFT JOIN t2 ON TRUE WHERE t1.f1 = t1.f2 + 4 AND t1.f1 IS NULL AND NOT t1.f2 = t1.f1
- ----
- Explained Query (fast path):
- Constant <empty>
- Target cluster: quickstart
- EOF
|
