Materialize/test/sqllogictest/cockroach/custom_escape_character.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/custom_escape_character
#
# 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.

# not supported yet
halt

mode cockroach

query B
SELECT '%' LIKE 't%' ESCAPE CASE WHEN (SELECT '-A' SIMILAR TO '--A' ESCAPE '-') THEN 't' ELSE 'f' END
----
true

query B
SELECT '%' LIKE 't%' ESCAPE CASE WHEN (SELECT 'A' SIMILAR TO '-A' ESCAPE '') THEN 't' ELSE 'f' END
----
false

query B
SELECT '%bC' ILIKE 't%Bc' ESCAPE CASE WHEN (SELECT 'A' ILIKE '-a' ESCAPE '-') THEN 't' ELSE 'f' END
----
true

query B
SELECT 'A' LIKE '\A' ESCAPE '\'
----
true

query B
SELECT 'A' LIKE '\A' ESCAPE ''
----
false

query B
SELECT '%A' LIKE '_A' ESCAPE '%'
----
true

query B
SELECT '%A' LIKE '%A' ESCAPE '%'
----
false

query B
SELECT '%A' LIKE '%%A' ESCAPE '%'
----
true

query B
SELECT '春A' LIKE '春春_' ESCAPE '春'
----
true

query error invalid escape string
SELECT 'A' LIKE 'AA' ESCAPE 'AA'

query error invalid escape string
SELECT '春A' LIKE '春春_' ESCAPE '春春'

query B
SELECT 'A' SIMILAR TO '\A' ESCAPE '\'
----
false

query B
SELECT '\A' SIMILAR TO '\A' ESCAPE ''
----
true

query B
SELECT '%A' SIMILAR TO '_A' ESCAPE '%'
----
true

query B
SELECT '%A' SIMILAR TO '%A' ESCAPE '%'
----
false

query B
SELECT '123A_' SIMILAR TO '%A_' ESCAPE '_'
----
false

query B
SELECT '123A_' SIMILAR TO '%A__' ESCAPE '_'
----
true

query B
SELECT '春A' SIMILAR TO '春春_' ESCAPE '春'
----
true

query B
SELECT '春A_春春' SIMILAR TO '%_春_%' ESCAPE '春'
----
true

query error invalid escape string
SELECT 'A' SIMILAR TO 'AA' ESCAPE 'AA'

query error invalid escape string
SELECT '春A' SIMILAR TO '春春_' ESCAPE '春春'