This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 c7fc347a151 [fix](cases) fix test_json_cast case out file (#38266)
c7fc347a151 is described below
commit c7fc347a1511b901d6d734d0ca907070446423d7
Author: amory <[email protected]>
AuthorDate: Wed Jul 24 21:26:51 2024 +0800
[fix](cases) fix test_json_cast case out file (#38266)
---
regression-test/data/jsonb_p0/test_jsonb_cast.out | 18 +++++++++---------
.../jsonb_p0/test_jsonb_load_and_function.groovy | 4 ++--
2 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/regression-test/data/jsonb_p0/test_jsonb_cast.out
b/regression-test/data/jsonb_p0/test_jsonb_cast.out
index 3495d4af00d..bb47b7249a5 100644
--- a/regression-test/data/jsonb_p0/test_jsonb_cast.out
+++ b/regression-test/data/jsonb_p0/test_jsonb_cast.out
@@ -1,15 +1,15 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !select_1 --
1 \N
-2 ["{\\'x\\':\\'{"y":1}\\', \\'t\\':\\'{"y":2}\\'}", "{"x":1}"]
-3 ["foo\\'bar', 'foo"bar', 'foo\\\\'bar', 'foo\\'\\'bar"]
-4 ["\\/some\\/cool\\/url", "/some/cool/url",
"a\\\\_\\\\c\\\\l\\\\i\\\\c\\\\k\\\\h\\\\o\\\\u\\\\s\\\\e"]
+2 ["{'x':'{"y":1}', 't':'{"y":2}'}", "{"x":1}"]
+3 ["foo'bar', 'foo"bar', 'foo\\'bar', 'foo''bar"]
+4 ["/some/cool/url", "/some/cool/url",
"a\\_\\c\\l\\i\\c\\k\\h\\o\\u\\s\\e"]
-- !select_2 --
1 \N
-2 ["{\\'x\\':\\'{"y":1}\\', \\'t\\':\\'{"y":2}\\'}", "{"x":1}"]
-3 ["foo\\'bar', 'foo"bar', 'foo\\\\'bar', 'foo\\'\\'bar"]
-4 ["\\/some\\/cool\\/url", "/some/cool/url",
"a\\\\_\\\\c\\\\l\\\\i\\\\c\\\\k\\\\h\\\\o\\\\u\\\\s\\\\e"]
+2 ["{'x':'{"y":1}', 't':'{"y":2}'}", "{"x":1}"]
+3 ["foo'bar', 'foo"bar', 'foo\\'bar', 'foo''bar"]
+4 ["/some/cool/url", "/some/cool/url",
"a\\_\\c\\l\\i\\c\\k\\h\\o\\u\\s\\e"]
27 ["{"k1":"v1", "k2":200}"]
28 ["{"a.b.c":{"k1.a1":"v31", "k2":300},"a":"niu"}"]
29 [" \n\r", " \n\r"]
@@ -17,9 +17,9 @@
-- !select_json --
1 \N
-2 ["{\\\\'x\\\\':\\\\'{\\"y\\":1}\\\\',
\\\\'t\\\\':\\\\'{\\"y\\":2}\\\\'}","{\\"x\\":1}"]
-3 ["foo\\\\'bar', 'foo\\"bar', 'foo\\\\\\\\'bar', 'foo\\\\'\\\\'bar"]
-4
["\\\\/some\\\\/cool\\\\/url","/some/cool/url","a\\\\\\\\_\\\\\\\\c\\\\\\\\l\\\\\\\\i\\\\\\\\c\\\\\\\\k\\\\\\\\h\\\\\\\\o\\\\\\\\u\\\\\\\\s\\\\\\\\e"]
+2 ["{'x':'{\\"y\\":1}', 't':'{\\"y\\":2}'}","{\\"x\\":1}"]
+3 ["foo'bar', 'foo\\"bar', 'foo\\\\'bar', 'foo''bar"]
+4
["/some/cool/url","/some/cool/url","a\\\\_\\\\c\\\\l\\\\i\\\\c\\\\k\\\\h\\\\o\\\\u\\\\s\\\\e"]
27 ["{\\"k1\\":\\"v1\\", \\"k2\\":200}"]
28 ["{\\"a.b.c\\":{\\"k1.a1\\":\\"v31\\",
\\"k2\\":300},\\"a\\":\\"niu\\"}"]
29 ["\\f\\n\\r","\\f\\n\\r"]
diff --git
a/regression-test/suites/nereids_p0/jsonb_p0/test_jsonb_load_and_function.groovy
b/regression-test/suites/nereids_p0/jsonb_p0/test_jsonb_load_and_function.groovy
index 0701072ca50..5f61dff8def 100644
---
a/regression-test/suites/nereids_p0/jsonb_p0/test_jsonb_load_and_function.groovy
+++
b/regression-test/suites/nereids_p0/jsonb_p0/test_jsonb_load_and_function.groovy
@@ -544,8 +544,8 @@ suite("test_jsonb_load_and_function", "p0") {
qt_select """SELECT id, j, JSON_EXTRACT(j, '\$.a1[0].k1', '\$.a1[0].k2',
'\$.a1[2]') FROM ${testTable} ORDER BY id"""
// explode_json_object function
- qt_order_select_explode_json_object "select id, j, k,v from ${testTable}
lateral view explode_json_object_outer(j) tmp as k,v order by id, k;"
- qt_order_select_explode_json_object_out "select id, j, k,v from
${testTable} lateral view explode_json_object_outer(j) tmp as k,v order by id,
k;"
+ order_qt_select_explode_json_object "select id, j, k,v from ${testTable}
lateral view explode_json_object_outer(j) tmp as k,v order by id, k;"
+ order_qt_select_explode_json_object_out "select id, j, k,v from
${testTable} lateral view explode_json_object_outer(j) tmp as k,v order by id,
k;"
// json_parse
qt_sql_json_parse """SELECT/*+SET_VAR(enable_fold_constant_by_be=false)*/
json_parse('{"":"v1"}')"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
