diff options
Diffstat (limited to 'tests/fixtures/identity.sql')
| -rw-r--r-- | tests/fixtures/identity.sql | 15 |
1 files changed, 11 insertions, 4 deletions
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 |