This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 e48b94883aa [fix](case) fix jsonb-load output (#38661)
e48b94883aa is described below
commit e48b94883aabc1df9e0233a84f3b621fd049e96c
Author: amory <[email protected]>
AuthorDate: Thu Aug 1 18:48:52 2024 +0800
[fix](case) fix jsonb-load output (#38661)
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
---
.../jsonb_p0/test_jsonb_load_and_function.out | 36 +++++++++++-----------
1 file changed, 18 insertions(+), 18 deletions(-)
diff --git
a/regression-test/data/nereids_p0/jsonb_p0/test_jsonb_load_and_function.out
b/regression-test/data/nereids_p0/jsonb_p0/test_jsonb_load_and_function.out
index e8a32a41421..51c904364cb 100644
--- a/regression-test/data/nereids_p0/jsonb_p0/test_jsonb_load_and_function.out
+++ b/regression-test/data/nereids_p0/jsonb_p0/test_jsonb_load_and_function.out
@@ -8315,16 +8315,8 @@ false
33 {"":1,"":"v1"} [null,null,null]
34 {"":1,"ab":"v1","":"v1","":2} [null,null,null]
--- !order_select_explode_json_object --
+-- !select_explode_json_object --
1 \N \N \N
-2 null \N \N
-3 true \N \N
-4 false \N \N
-5 100 \N \N
-6 10000 \N \N
-7 1000000000 \N \N
-8 1152921504606846976 \N \N
-9 6.18 \N \N
10 "abcd" \N \N
11 {} \N \N
12 {"k1":"v31","k2":300} k1 "v31"
@@ -8337,32 +8329,32 @@ false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} a1
[{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} k1
"v31"
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} k2
300
+2 null \N \N
26 \N \N \N
27 {"k1":"v1","k2":200} k1 "v1"
27 {"k1":"v1","k2":200} k2 200
28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} a "niu"
28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} a.b.c
{"k1.a1":"v31","k2":300}
29 12524337771678448270 \N \N
+3 true \N \N
30 -9223372036854775808 \N \N
31 18446744073709551615 \N \N
32 {"":"v1"} "v1"
-33 {"":1,"":"v1"} 1
33 {"":1,"":"v1"} "v1"
-34 {"":1,"ab":"v1","":"v1","":2} 1
+33 {"":1,"":"v1"} 1
34 {"":1,"ab":"v1","":"v1","":2} "v1"
+34 {"":1,"ab":"v1","":"v1","":2} 1
34 {"":1,"ab":"v1","":"v1","":2} 2
34 {"":1,"ab":"v1","":"v1","":2} ab "v1"
-
--- !order_select_explode_json_object_out --
-1 \N \N \N
-2 null \N \N
-3 true \N \N
4 false \N \N
5 100 \N \N
6 10000 \N \N
7 1000000000 \N \N
8 1152921504606846976 \N \N
9 6.18 \N \N
+
+-- !select_explode_json_object_out --
+1 \N \N \N
10 "abcd" \N \N
11 {} \N \N
12 {"k1":"v31","k2":300} k1 "v31"
@@ -8375,21 +8367,29 @@ false
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} a1
[{"k1":"v41","k2":400},1,"a",3.14]
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} k1
"v31"
18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} k2
300
+2 null \N \N
26 \N \N \N
27 {"k1":"v1","k2":200} k1 "v1"
27 {"k1":"v1","k2":200} k2 200
28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} a "niu"
28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} a.b.c
{"k1.a1":"v31","k2":300}
29 12524337771678448270 \N \N
+3 true \N \N
30 -9223372036854775808 \N \N
31 18446744073709551615 \N \N
32 {"":"v1"} "v1"
-33 {"":1,"":"v1"} 1
33 {"":1,"":"v1"} "v1"
-34 {"":1,"ab":"v1","":"v1","":2} 1
+33 {"":1,"":"v1"} 1
34 {"":1,"ab":"v1","":"v1","":2} "v1"
+34 {"":1,"ab":"v1","":"v1","":2} 1
34 {"":1,"ab":"v1","":"v1","":2} 2
34 {"":1,"ab":"v1","":"v1","":2} ab "v1"
+4 false \N \N
+5 100 \N \N
+6 10000 \N \N
+7 1000000000 \N \N
+8 1152921504606846976 \N \N
+9 6.18 \N \N
-- !sql_json_parse --
{"":"v1"}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
