aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pg/str_lookup_pg.sql
blob: 750cd6281fb2e9e572ddae97fe85d236750def6c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
pragma warning("disable", "4510");

select StartsWith('test1'u, 'tes'p),
       EndsWith('test1'u, 't1'p),
       YQL::StringContains('test1'u, 'est'p);

select StartsWith('test1'u, 'tes'pb),
       EndsWith('test1'u, 't1'pb),
       YQL::StringContains('test1'u, 'est'pb);

select StartsWith('test1', 'tes'p),
       EndsWith('test1', 't1'p),
       YQL::StringContains('test1', 'est'p);

select StartsWith('test1', 'tes'pv),
       EndsWith('test1', 't1'pv),
       YQL::StringContains('test1', 'est'pv);

select StartsWith('test1'u, 'x'pv),
       EndsWith(Nothing(Utf8?), 'x'pv),
       YQL::StringContains('test1'u, PgCast(null, PgVarChar));