From 42a1548cecf48d18233f56e3385cf9c89abcb9c2 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 3 Mar 2024 15:11:07 +0100 Subject: Merging upstream version 22.2.0. Signed-off-by: Daniel Baumann --- tests/fixtures/identity.sql | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) (limited to 'tests/fixtures/identity.sql') diff --git a/tests/fixtures/identity.sql b/tests/fixtures/identity.sql index d9efc57..6d3bb07 100644 --- a/tests/fixtures/identity.sql +++ b/tests/fixtures/identity.sql @@ -196,10 +196,10 @@ SET LOCAL variable = value @"x" COMMIT USE db -USE role x -USE warehouse x -USE database x -USE schema x.y +USE ROLE x +USE WAREHOUSE x +USE DATABASE x +USE SCHEMA x.y NOT 1 NOT NOT 1 SELECT * FROM test @@ -643,6 +643,7 @@ DROP MATERIALIZED VIEW x.y.z CACHE TABLE x CACHE LAZY TABLE x CACHE LAZY TABLE x OPTIONS('storageLevel' = 'value') +CACHE LAZY TABLE x OPTIONS(N'storageLevel' = 'value') CACHE LAZY TABLE x OPTIONS('storageLevel' = 'value') AS SELECT 1 CACHE LAZY TABLE x OPTIONS('storageLevel' = 'value') AS WITH a AS (SELECT 1) SELECT a.* FROM a CACHE LAZY TABLE x AS WITH a AS (SELECT 1) SELECT a.* FROM a @@ -708,6 +709,7 @@ COMMENT ON COLUMN my_schema.my_table.my_column IS 'Employee ID number' COMMENT ON DATABASE my_database IS 'Development Database' COMMENT ON PROCEDURE my_proc(integer, integer) IS 'Runs a report' COMMENT ON TABLE my_schema.my_table IS 'Employee Information' +COMMENT ON TABLE my_schema.my_table IS N'National String' WITH a AS (SELECT 1) INSERT INTO b SELECT * FROM a WITH a AS (SELECT * FROM b) UPDATE a SET col = 1 WITH a AS (SELECT * FROM b) CREATE TABLE b AS SELECT * FROM a @@ -785,6 +787,7 @@ ALTER TABLE baa ADD CONSTRAINT boo PRIMARY KEY (x, y) NOT ENFORCED DEFERRABLE IN ALTER TABLE baa ADD CONSTRAINT boo FOREIGN KEY (x, y) REFERENCES persons ON UPDATE NO ACTION ON DELETE NO ACTION MATCH FULL ALTER TABLE a ADD PRIMARY KEY (x, y) NOT ENFORCED ALTER TABLE a ADD FOREIGN KEY (x, y) REFERENCES bla +ALTER TABLE s_ut ADD CONSTRAINT s_ut_uq UNIQUE hajo SELECT partition FROM a SELECT end FROM a SELECT id FROM b.a AS a QUALIFY ROW_NUMBER() OVER (PARTITION BY br ORDER BY sadf DESC) = 1 @@ -850,3 +853,7 @@ CAST(foo AS BPCHAR) values SELECT values SELECT values AS values FROM t WHERE values + 1 > 3 +SELECT truncate +SELECT only +TRUNCATE(a, b) +SELECT enum -- cgit v1.2.3