diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-05-10 06:44:54 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-05-10 06:44:54 +0000 |
| commit | d2e9401b18925b5702c5c758af7d4f5b61deb493 (patch) | |
| tree | 58dbf490c0457c2908751b3e4b63af13287381ee /tests/fixtures/identity.sql | |
| parent | Adding upstream version 11.7.1. (diff) | |
| download | sqlglot-d2e9401b18925b5702c5c758af7d4f5b61deb493.tar.xz sqlglot-d2e9401b18925b5702c5c758af7d4f5b61deb493.zip | |
Adding upstream version 12.2.0.upstream/12.2.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/fixtures/identity.sql')
| -rw-r--r-- | tests/fixtures/identity.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/tests/fixtures/identity.sql b/tests/fixtures/identity.sql index a08a7a8..ea695c9 100644 --- a/tests/fixtures/identity.sql +++ b/tests/fixtures/identity.sql @@ -85,6 +85,7 @@ x IS TRUE x IS FALSE x IS TRUE IS TRUE x LIKE y IS TRUE +TRIM('a' || 'b') MAP() GREATEST(x) LEAST(y) @@ -104,6 +105,7 @@ ARRAY(time, foo) ARRAY(foo, time) ARRAY(LENGTH(waiter_name) > 0) ARRAY_CONTAINS(x, 1) +x.EXTRACT(1) EXTRACT(x FROM y) EXTRACT(DATE FROM y) EXTRACT(WEEK(monday) FROM created_at) @@ -215,6 +217,7 @@ SELECT COUNT(DISTINCT a, b) SELECT COUNT(DISTINCT a, b + 1) SELECT SUM(DISTINCT x) SELECT SUM(x IGNORE NULLS) AS x +SELECT COUNT(x RESPECT NULLS) SELECT TRUNCATE(a, b) SELECT ARRAY_AGG(DISTINCT x IGNORE NULLS ORDER BY a, b DESC LIMIT 10) AS x SELECT ARRAY_AGG(STRUCT(x, x AS y) ORDER BY z DESC) AS x @@ -820,3 +823,6 @@ JSON_OBJECT('x': 1 RETURNING VARBINARY FORMAT JSON ENCODING UTF8) SELECT if.x SELECT NEXT VALUE FOR db.schema.sequence_name SELECT NEXT VALUE FOR db.schema.sequence_name OVER (ORDER BY foo), col +SELECT PERCENTILE_CONT(x, 0.5) OVER () +SELECT PERCENTILE_CONT(x, 0.5 RESPECT NULLS) OVER () +SELECT PERCENTILE_CONT(x, 0.5 IGNORE NULLS) OVER () |