From f73e9af131151f1e058446361c35b05c4c90bf10 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Thu, 7 Sep 2023 13:39:48 +0200
Subject: Merging upstream version 18.2.0.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 tests/fixtures/identity.sql | 15 +++++++++------
 1 file changed, 9 insertions(+), 6 deletions(-)

(limited to 'tests/fixtures/identity.sql')

diff --git a/tests/fixtures/identity.sql b/tests/fixtures/identity.sql
index b21d65d..0953fee 100644
--- a/tests/fixtures/identity.sql
+++ b/tests/fixtures/identity.sql
@@ -139,6 +139,7 @@ x ILIKE '%y%' ESCAPE '\'
 1 AS escape
 INTERVAL '1' day
 INTERVAL '1' MONTH
+INTERVAL '1' YEAR
 INTERVAL '-1' CURRENT_DATE
 INTERVAL '-31' CAST(GETDATE() AS DATE)
 INTERVAL (1 + 3) DAYS
@@ -620,13 +621,13 @@ CREATE FUNCTION a() LANGUAGE sql
 CREATE FUNCTION a() LANGUAGE sql RETURNS INT
 CREATE FUNCTION a.b(x INT) RETURNS INT AS RETURN x + 1
 CREATE FUNCTION a.b.c()
-CREATE INDEX abc ON t (a)
-CREATE INDEX "abc" ON t (a)
-CREATE INDEX abc ON t (a, b, b)
-CREATE INDEX abc ON t (a NULLS LAST)
+CREATE INDEX abc ON t(a)
+CREATE INDEX "abc" ON t(a)
+CREATE INDEX abc ON t(a, b, b)
+CREATE INDEX abc ON t(a NULLS LAST)
 CREATE INDEX pointloc ON points USING GIST(BOX(location, location))
-CREATE UNIQUE INDEX abc ON t (a, b, b)
-CREATE UNIQUE INDEX IF NOT EXISTS my_idx ON tbl (a, b)
+CREATE UNIQUE INDEX abc ON t(a, b, b)
+CREATE UNIQUE INDEX IF NOT EXISTS my_idx ON tbl(a, b)
 CREATE SCHEMA x
 CREATE SCHEMA IF NOT EXISTS y
 CREATE DATABASE x
@@ -836,6 +837,7 @@ JSON_OBJECT('x': NULL, 'y': 1 WITH UNIQUE KEYS)
 JSON_OBJECT('x': NULL, 'y': 1 ABSENT ON NULL WITH UNIQUE KEYS)
 JSON_OBJECT('x': 1 RETURNING VARCHAR(100))
 JSON_OBJECT('x': 1 RETURNING VARBINARY FORMAT JSON ENCODING UTF8)
+PRIOR AS x
 SELECT if.x
 SELECT NEXT VALUE FOR db.schema.sequence_name
 SELECT NEXT VALUE FOR db.schema.sequence_name OVER (ORDER BY foo), col
@@ -855,3 +857,4 @@ SELECT * FROM (tbl1 CROSS JOIN (SELECT * FROM tbl2) AS t1)
 /* comment1 */ DELETE FROM x /* comment2 */ WHERE y > 1
 /* comment */ CREATE TABLE foo AS SELECT 1
 SELECT next, transform, if
+SELECT "any", "case", "if", "next"
-- 
cgit v1.2.3

