diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-16 16:50:34 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-09-16 16:50:34 +0000 |
| commit | 7b2d028262d3e100dfc42b94bb705a09a5c7e93d (patch) | |
| tree | a957a3e8fac83475e3652d4bae8cab896e6b22a6 /tests/dialects/test_oracle.py | |
| parent | Releasing debian version 25.20.1-1. (diff) | |
| download | sqlglot-7b2d028262d3e100dfc42b94bb705a09a5c7e93d.tar.xz sqlglot-7b2d028262d3e100dfc42b94bb705a09a5c7e93d.zip | |
Merging upstream version 25.21.3.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_oracle.py')
| -rw-r--r-- | tests/dialects/test_oracle.py | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/tests/dialects/test_oracle.py b/tests/dialects/test_oracle.py index 8bdc4af..28a8da9 100644 --- a/tests/dialects/test_oracle.py +++ b/tests/dialects/test_oracle.py @@ -70,6 +70,10 @@ class TestOracle(Validator): "SELECT MIN(column_name) KEEP (DENSE_RANK FIRST ORDER BY column_name DESC) FROM table_name" ) self.validate_identity( + "SELECT TRUNC(SYSDATE)", + "SELECT TRUNC(SYSDATE, 'DD')", + ) + self.validate_identity( """SELECT JSON_OBJECT(KEY 'key1' IS emp.column1, KEY 'key2' IS emp.column1) "emp_key" FROM emp""", """SELECT JSON_OBJECT('key1': emp.column1, 'key2': emp.column1) AS "emp_key" FROM emp""", ) |