This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 3da7ab5412d [fix](testcase) fix jsonb arrow op testcase (#25037)
3da7ab5412d is described below
commit 3da7ab5412dc80ea8e0689d00514ac2bc383571a
Author: Kang <[email protected]>
AuthorDate: Thu Oct 5 22:16:23 2023 +0800
[fix](testcase) fix jsonb arrow op testcase (#25037)
---
.../data/jsonb_p0/test_jsonb_load_and_function.out | 129 ---------------------
.../jsonb_p0/test_jsonb_load_and_function.groovy | 6 -
2 files changed, 135 deletions(-)
diff --git a/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
b/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
index 0e0fabb039b..124b95eeea6 100644
--- a/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
+++ b/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
@@ -7461,135 +7461,6 @@ false
30 -9223372036854775808 [null,null,null]
31 18446744073709551615 [null,null,null]
--- !select --
-1 \N \N
-2 null null
-3 true null
-4 false null
-5 100 null
-6 10000 null
-7 1000000000 null
-8 1152921504606846976 null
-9 6.18 null
-10 "abcd" null
-11 {} null
-12 {"k1":"v31","k2":300} "v31"
-13 [] null
-14 [123,456] null
-15 ["abc","def"] null
-16 [null,true,false,100,6.18,"abc"] null
-17 [{"k1":"v41","k2":400},1,"a",3.14] ["v41"]
-18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} "v31"
-26 \N \N
-27 {"k1":"v1","k2":200} "v1"
-28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} null
-29 12524337771678448270 null
-30 -9223372036854775808 null
-31 18446744073709551615 null
-
--- !select --
-1 \N \N
-2 null null
-3 true null
-4 false null
-5 100 null
-6 10000 null
-7 1000000000 null
-8 1152921504606846976 null
-9 6.18 null
-10 "abcd" null
-11 {} null
-12 {"k1":"v31","k2":300} null
-13 [] null
-14 [123,456] 456
-15 ["abc","def"] "def"
-16 [null,true,false,100,6.18,"abc"] true
-17 [{"k1":"v41","k2":400},1,"a",3.14] 1
-18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} null
-26 \N \N
-27 {"k1":"v1","k2":200} null
-28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} null
-29 12524337771678448270 null
-30 -9223372036854775808 null
-31 18446744073709551615 null
-
--- !select --
-1 \N \N
-2 null \N
-3 true \N
-4 false \N
-5 100 \N
-6 10000 \N
-7 1000000000 \N
-8 1152921504606846976 \N
-9 6.18 \N
-10 "abcd" \N
-11 {} \N
-12 {"k1":"v31","k2":300} \N
-13 [] \N
-14 [123,456] \N
-15 ["abc","def"] \N
-16 [null,true,false,100,6.18,"abc"] \N
-17 [{"k1":"v41","k2":400},1,"a",3.14] \N
-18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
-26 \N \N
-27 {"k1":"v1","k2":200} \N
-28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} \N
-29 12524337771678448270 \N
-30 -9223372036854775808 \N
-31 18446744073709551615 \N
-
--- !select --
-1 \N \N
-2 null null
-3 true null
-4 false null
-5 100 null
-6 10000 null
-7 1000000000 null
-8 1152921504606846976 null
-9 6.18 null
-10 "abcd" null
-11 {} null
-12 {"k1":"v31","k2":300} null
-13 [] null
-14 [123,456] null
-15 ["abc","def"] null
-16 [null,true,false,100,6.18,"abc"] null
-17 [{"k1":"v41","k2":400},1,"a",3.14] null
-18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} 400
-26 \N \N
-27 {"k1":"v1","k2":200} null
-28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} null
-29 12524337771678448270 null
-30 -9223372036854775808 null
-31 18446744073709551615 null
-
--- !select --
-1 \N \N
-2 null null
-3 true null
-4 false null
-5 100 null
-6 10000 null
-7 1000000000 null
-8 1152921504606846976 null
-9 6.18 null
-10 "abcd" null
-11 {} null
-12 {"k1":"v31","k2":300} null
-13 [] null
-14 [123,456] null
-15 ["abc","def"] null
-16 [null,true,false,100,6.18,"abc"] null
-17 [{"k1":"v41","k2":400},1,"a",3.14] null
-18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} "v41"
-26 \N \N
-27 {"k1":"v1","k2":200} null
-28 {"a.b.c":{"k1.a1":"v31","k2":300},"a":"niu"} null
-29 12524337771678448270 null
-30 -9223372036854775808 null
-31 18446744073709551615 null
-- !sql_json_length --
1
diff --git
a/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
b/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
index 7dbfc653905..55ecf001ebe 100644
--- a/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
+++ b/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
@@ -534,12 +534,6 @@ suite("test_jsonb_load_and_function", "p0") {
qt_select """SELECT id, j, JSON_EXTRACT(j, '\$.k2', null) FROM
${testTable} ORDER BY id"""
qt_select """SELECT id, j, JSON_EXTRACT(j, '\$.a1[0].k1', '\$.a1[0].k2',
'\$.a1[2]') FROM ${testTable} ORDER BY id"""
- qt_select """SELECT id, j, j->'\$.k1' FROM ${testTable} ORDER BY id"""
- qt_select """SELECT id, j, j->'\$.[1]' FROM ${testTable} ORDER BY id"""
- qt_select """SELECT id, j, j->null FROM ${testTable} ORDER BY id"""
- qt_select """SELECT id, j, j->'\$.a1[0].k2' FROM ${testTable} ORDER BY
id"""
- qt_select """SELECT id, j, j->'\$.a1[0]'->'\$.k1' FROM ${testTable} ORDER
BY id"""
-
//json_length
qt_sql_json_length """SELECT json_length('1')"""
qt_sql_json_length """SELECT json_length('true')"""
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
