aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/in/in_ansi_variant.sql
blob: 86b2a2dbfafe33ee9bbd507b82a24b00af8c1137 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
/* postgres can not */
/* syntax version 1 */
PRAGMA AnsiInForEmptyOrNullableItemsCollections;
Select Enum("foo",Enum<"foo","bar">) in (
            AsEnum("foo")
        ),
        Enum("foo",Enum<"foo","bar">) in (
            AsEnum("bar")
        ),
        Enum("foo",Enum<"foo","bar">) in (
            AsEnum("foo"),
            AsEnum("bar")
        ),
        Enum("foo",Enum<"foo","bar">) in (
            AsEnum("bar"),
            AsEnum("baz")
        ),
        Enum("foo",Enum<"foo","bar">) in [
            AsEnum("foo"),
            AsEnum("bar")
        ],
        Enum("foo",Enum<"foo","bar">) in {
            AsEnum("bar"),
            AsEnum("baz")
        };