diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-11 12:13:38 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-11 12:13:38 +0000 |
| commit | e894f65cf8a2e3c88439e1b06d8542b969e2bc3f (patch) | |
| tree | db0e8e728b297f06d7ad5a6034e8110bae97297e /tests/fixtures/optimizer | |
| parent | Releasing debian version 25.18.0-1. (diff) | |
| download | sqlglot-e894f65cf8a2e3c88439e1b06d8542b969e2bc3f.tar.xz sqlglot-e894f65cf8a2e3c88439e1b06d8542b969e2bc3f.zip | |
Merging upstream version 25.20.1.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/fixtures/optimizer')
| -rw-r--r-- | tests/fixtures/optimizer/annotate_types.sql | 14 | ||||
| -rw-r--r-- | tests/fixtures/optimizer/optimizer.sql | 2 |
2 files changed, 14 insertions, 2 deletions
diff --git a/tests/fixtures/optimizer/annotate_types.sql b/tests/fixtures/optimizer/annotate_types.sql index 0a5fc22..f608851 100644 --- a/tests/fixtures/optimizer/annotate_types.sql +++ b/tests/fixtures/optimizer/annotate_types.sql @@ -1,13 +1,25 @@ 5; INT; +-5; +INT; + +~5; +INT; + +(5); +INT; + 5.3; DOUBLE; 'bla'; VARCHAR; -True; +true; +bool; + +not true; bool; false; diff --git a/tests/fixtures/optimizer/optimizer.sql b/tests/fixtures/optimizer/optimizer.sql index c5f8a4f..76fc16d 100644 --- a/tests/fixtures/optimizer/optimizer.sql +++ b/tests/fixtures/optimizer/optimizer.sql @@ -838,7 +838,7 @@ SELECT FROM `bigquery-public-data.GooGle_tReNDs.TOp_TeRmS` AS `TOp_TeRmS` WHERE `TOp_TeRmS`.`rank` = 1 - AND `TOp_TeRmS`.`refresh_date` >= DATE_SUB(CURRENT_DATE, INTERVAL 2 WEEK) + AND `TOp_TeRmS`.`refresh_date` >= DATE_SUB(CURRENT_DATE, INTERVAL '2' WEEK) GROUP BY `day`, `top_term`, |