Adding upstream version 23.7.0.upstream/23.7.0

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 9 insertions, 1 deletions

diff --git a/tests/fixtures/identity.sql b/tests/fixtures/identity.sql
index 6d3bb07..5453a78 100644
--- a/tests/fixtures/identity.sql
+++ b/tests/fixtures/identity.sql
@@ -141,6 +141,7 @@ x ILIKE '%y%' ESCAPE '\'
 INTERVAL '1' DAY
 INTERVAL '1' MONTH
 INTERVAL '1' YEAR
+INTERVAL '1' HOUR TO SECOND
 INTERVAL '-1' CURRENT_DATE
 INTERVAL '-31' CAST(GETDATE() AS DATE)
 INTERVAL (1 + 3) DAYS
@@ -149,6 +150,7 @@ INTERVAL '1' DAY * 5
 CASE WHEN TRUE THEN INTERVAL '15' DAYS END
 CASE WHEN TRUE THEN 1 ELSE interval END
 CASE WHEN TRUE THEN 1 ELSE "INTERVAL" END
+SELECT asof FROM x
 SELECT * WHERE interval IS NULL
 SELECT * WHERE NOT interval IS NULL
 SELECT * WHERE INTERVAL "is" > 1
@@ -176,6 +178,7 @@ COUNT(DISTINCT CASE WHEN DATE_TRUNC('ISOWEEK', DATE(time_field)) = DATE_TRUNC('I
 COUNT(a, b)
 x[y - 1]
 CASE WHEN SUM(x) > 3 THEN 1 END OVER (PARTITION BY x)
+ANY(x) OVER (PARTITION BY x)
 SUM(ROW() OVER (PARTITION BY x))
 SUM(ROW() OVER (PARTITION BY x + 1))
 SUM(ROW() OVER (PARTITION BY x AND y))
@@ -361,7 +364,6 @@ SELECT GREATEST(a, b, c) FROM test
 SELECT LAST_VALUE(a) FROM test
 SELECT LAST_VALUE(a) IGNORE NULLS OVER () + 1
 SELECT LN(a) FROM test
-SELECT LOG10(a) FROM test
 SELECT MAX(a) FROM test
 SELECT MIN(a) FROM test
 SELECT POWER(a, 2) FROM test
@@ -476,6 +478,7 @@ SELECT 1 UNION (SELECT 2) ORDER BY x
 SELECT * FROM (((SELECT 1) UNION SELECT 2) ORDER BY x LIMIT 1 OFFSET 1)
 SELECT * FROM ((SELECT 1 AS x) CROSS JOIN (SELECT 2 AS y)) AS z
 ((SELECT 1) EXCEPT (SELECT 2))
+((SELECT 1)) LIMIT 1
 VALUES (1) UNION SELECT * FROM x
 WITH a AS (SELECT 1) SELECT a.* FROM a
 WITH a AS (SELECT 1), b AS (SELECT 2) SELECT a.*, b.* FROM a CROSS JOIN b
@@ -637,6 +640,8 @@ CREATE DATABASE IF NOT EXISTS y
 CREATE PROCEDURE IF NOT EXISTS a.b.c() AS 'DECLARE BEGIN; END'
 CREATE TABLE T3 AS (SELECT DISTINCT A FROM T1 EXCEPT (SELECT A FROM T2) LIMIT 1)
 DESCRIBE x
+DESCRIBE EXTENDED a.b
+DESCRIBE FORMATTED a.b
 DROP INDEX a.b.c
 DROP FUNCTION a.b.c (INT)
 DROP MATERIALIZED VIEW x.y.z
@@ -831,6 +836,7 @@ SELECT * FROM schema.case
 SELECT * FROM current_date
 SELECT * FROM schema.current_date
 SELECT /*+ SOME_HINT(foo) */ 1
+SELECT /*+ REBALANCE */ * FROM foo
 SELECT * FROM (tbl1 CROSS JOIN (SELECT * FROM tbl2) AS t1)
 /* comment1 */ INSERT INTO x /* comment2 */ VALUES (1, 2, 3)
 /* comment1 */ UPDATE tbl /* comment2 */ SET x = 2 WHERE x < 2
@@ -857,3 +863,5 @@ SELECT truncate
 SELECT only
 TRUNCATE(a, b)
 SELECT enum
+SELECT unlogged
+SELECT name