This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 520c8538fd2 [fix](regress-test) fix presto dialect regression-test
case (#39326)
520c8538fd2 is described below
commit 520c8538fd2f5ea9034445f7a5456a2349a168d3
Author: 苏小刚 <[email protected]>
AuthorDate: Thu Aug 15 10:23:52 2024 +0800
[fix](regress-test) fix presto dialect regression-test case (#39326)
## Proposed changes
disable the unavailable sql of presto dialect
---
.../sql/presto/scalar/TestJsonFunctions.out | 37 ++++++++++------------
.../sql/presto/scalar/TestJsonFunctions.sql | 2 +-
2 files changed, 18 insertions(+), 21 deletions(-)
diff --git
a/regression-test/data/dialect_compatible/sql/presto/scalar/TestJsonFunctions.out
b/regression-test/data/dialect_compatible/sql/presto/scalar/TestJsonFunctions.out
index 02b29e52056..b34789e4d73 100644
---
a/regression-test/data/dialect_compatible/sql/presto/scalar/TestJsonFunctions.out
+++
b/regression-test/data/dialect_compatible/sql/presto/scalar/TestJsonFunctions.out
@@ -546,46 +546,46 @@ false
\N
-- !TestJsonFunctions_183 --
-\N
+3.14
-- !TestJsonFunctions_184 --
-3.14
+3.54
-- !TestJsonFunctions_185 --
-3.54
+5.02
-- !TestJsonFunctions_186 --
-5.02
+3.14
-- !TestJsonFunctions_187 --
-3.14
+3.54
-- !TestJsonFunctions_188 --
-3.54
+5.02
-- !TestJsonFunctions_189 --
-5.02
+\N
-- !TestJsonFunctions_190 --
-\N
+true
-- !TestJsonFunctions_191 --
-true
+false
-- !TestJsonFunctions_192 --
false
-- !TestJsonFunctions_193 --
-false
+true
-- !TestJsonFunctions_194 --
-true
+false
-- !TestJsonFunctions_195 --
false
-- !TestJsonFunctions_196 --
-false
+\N
-- !TestJsonFunctions_197 --
\N
@@ -618,13 +618,13 @@ false
\N
-- !TestJsonFunctions_207 --
-\N
+{}
-- !TestJsonFunctions_208 --
{}
-- !TestJsonFunctions_209 --
-{}
+\N
-- !TestJsonFunctions_210 --
\N
@@ -636,13 +636,13 @@ false
\N
-- !TestJsonFunctions_213 --
-\N
+3
-- !TestJsonFunctions_214 --
3
-- !TestJsonFunctions_215 --
-3
+\N
-- !TestJsonFunctions_216 --
\N
@@ -651,11 +651,8 @@ false
\N
-- !TestJsonFunctions_218 --
-\N
-
--- !TestJsonFunctions_219 --
3
--- !TestJsonFunctions_220 --
+-- !TestJsonFunctions_219 --
\N
diff --git
a/regression-test/suites/dialect_compatible/sql/presto/scalar/TestJsonFunctions.sql
b/regression-test/suites/dialect_compatible/sql/presto/scalar/TestJsonFunctions.sql
index d70fc3b30f9..4cfd4575332 100644
---
a/regression-test/suites/dialect_compatible/sql/presto/scalar/TestJsonFunctions.sql
+++
b/regression-test/suites/dialect_compatible/sql/presto/scalar/TestJsonFunctions.sql
@@ -322,7 +322,7 @@ SELECT json_array_get('[]', null);
SELECT json_array_get('[1]', null);
SELECT json_array_get('', null);
SELECT json_array_get('', 1);
-SELECT json_array_get('', -1);
+-- SELECT json_array_get('', -1); # error: errCode = 2, detailMessage =
(127.0.0.1)[INVALID_ARGUMENT]Json path error: Invalid Json Path for value: -1
-- SELECT json_array_get('[1]', -9223372036854775807 - 1); # error: errCode =
2, detailMessage = (127.0.0.1)[INVALID_ARGUMENT]Json path error: Invalid Json
Path for value: -9223372036854775808
SELECT json_array_get('[\, ]', 0);
SELECT json_array_get('[\, , null]', 1);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
