diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-23 07:22:23 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-23 07:22:23 +0000 |
commit | 0d1477fdf20125df42fe49355b757625417c8f8c (patch) | |
tree | 0ace7a95d185b2b1ae36e25e341bf92cd9021cb0 /tests/dialects/test_doris.py | |
parent | Releasing debian version 23.16.0-1. (diff) | |
download | sqlglot-0d1477fdf20125df42fe49355b757625417c8f8c.tar.xz sqlglot-0d1477fdf20125df42fe49355b757625417c8f8c.zip |
Merging upstream version 24.0.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_doris.py')
-rw-r--r-- | tests/dialects/test_doris.py | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/tests/dialects/test_doris.py b/tests/dialects/test_doris.py index 035289b..f7fce02 100644 --- a/tests/dialects/test_doris.py +++ b/tests/dialects/test_doris.py @@ -14,7 +14,9 @@ class TestDoris(Validator): ) self.validate_all( "SELECT MAX_BY(a, b), MIN_BY(c, d)", - read={"clickhouse": "SELECT argMax(a, b), argMin(c, d)"}, + read={ + "clickhouse": "SELECT argMax(a, b), argMin(c, d)", + }, ) self.validate_all( "SELECT ARRAY_SUM(x -> x * x, ARRAY(2, 3))", @@ -36,6 +38,16 @@ class TestDoris(Validator): "oracle": "ADD_MONTHS(d, n)", }, ) + self.validate_all( + """SELECT JSON_EXTRACT(CAST('{"key": 1}' AS JSONB), '$.key')""", + read={ + "postgres": """SELECT '{"key": 1}'::jsonb ->> 'key'""", + }, + write={ + "doris": """SELECT JSON_EXTRACT(CAST('{"key": 1}' AS JSONB), '$.key')""", + "postgres": """SELECT JSON_EXTRACT_PATH(CAST('{"key": 1}' AS JSONB), 'key')""", + }, + ) def test_identity(self): self.validate_identity("COALECSE(a, b, c, d)") |