summaryrefslogtreecommitdiffstats
path: root/tests/fixtures/pretty.sql
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2023-06-24 18:46:54 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2023-06-24 18:46:54 +0000
commit5cb547bdac6f807c3a1bc42faffaceaf726a3e3e (patch)
tree89287ecd0265188fc3119e9d711017634526a09e /tests/fixtures/pretty.sql
parentAdding upstream version 16.4.0. (diff)
downloadsqlglot-5cb547bdac6f807c3a1bc42faffaceaf726a3e3e.tar.xz
sqlglot-5cb547bdac6f807c3a1bc42faffaceaf726a3e3e.zip
Adding upstream version 16.4.2.upstream/16.4.2
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/fixtures/pretty.sql')
-rw-r--r--tests/fixtures/pretty.sql15
1 files changed, 14 insertions, 1 deletions
diff --git a/tests/fixtures/pretty.sql b/tests/fixtures/pretty.sql
index 8de9c85..46cd6d8 100644
--- a/tests/fixtures/pretty.sql
+++ b/tests/fixtures/pretty.sql
@@ -178,10 +178,23 @@ FROM (
) AS x;
INSERT OVERWRITE TABLE x VALUES (1, 2.0, '3.0'), (4, 5.0, '6.0');
-INSERT OVERWRITE TABLE x VALUES
+INSERT OVERWRITE TABLE x
+VALUES
(1, 2.0, '3.0'),
(4, 5.0, '6.0');
+INSERT INTO TABLE foo REPLACE WHERE cond SELECT * FROM bar;
+INSERT INTO foo
+REPLACE WHERE cond
+SELECT
+ *
+FROM bar;
+
+INSERT OVERWRITE TABLE zipcodes PARTITION(state = '0') VALUES (896, 'US', 'TAMPA', 33607);
+INSERT OVERWRITE TABLE zipcodes PARTITION(state = '0')
+VALUES
+ (896, 'US', 'TAMPA', 33607);
+
WITH regional_sales AS (
SELECT region, SUM(amount) AS total_sales
FROM orders