diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-24 18:46:54 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-24 18:46:54 +0000 |
commit | 5cb547bdac6f807c3a1bc42faffaceaf726a3e3e (patch) | |
tree | 89287ecd0265188fc3119e9d711017634526a09e /tests/fixtures/pretty.sql | |
parent | Adding upstream version 16.4.0. (diff) | |
download | sqlglot-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.sql | 15 |
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 |