diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-24 18:46:57 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-24 18:46:57 +0000 |
| commit | caf48491ccffa709546a473d36df6a4444164ad1 (patch) | |
| tree | e803e4a815a9a39695e6161ec4feb55f295f4942 /tests/fixtures/pretty.sql | |
| parent | Releasing debian version 16.4.0-1. (diff) | |
| download | sqlglot-caf48491ccffa709546a473d36df6a4444164ad1.tar.xz sqlglot-caf48491ccffa709546a473d36df6a4444164ad1.zip | |
Merging upstream version 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 |