You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2022/11/26 02:06:24 UTC
[doris] branch master updated: [feature](jsonb type)refactor JSONB type using column and add testcase (#13778)
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 52c6ba051e [feature](jsonb type)refactor JSONB type using column and add testcase (#13778)
52c6ba051e is described below
commit 52c6ba051e13ec83b9b80b4687ccc5610b8fea8d
Author: Kang <kx...@gmail.com>
AuthorDate: Sat Nov 26 10:06:15 2022 +0800
[feature](jsonb type)refactor JSONB type using column and add testcase (#13778)
1. Refactor JSONB type using ColumnString instead making a copy.
2. Add regression testcase for JSONB load and functions.
---
be/src/olap/row_block2.cpp | 4 +-
be/src/runtime/primitive_type.h | 3 +-
be/src/vec/CMakeLists.txt | 1 -
be/src/vec/columns/column_jsonb.cpp | 424 ---
be/src/vec/columns/column_jsonb.h | 352 --
be/src/vec/data_types/data_type_jsonb.cpp | 138 +-
be/src/vec/data_types/data_type_jsonb.h | 9 +-
be/src/vec/exprs/vliteral.cpp | 2 +-
be/src/vec/functions/function_cast.h | 19 +-
be/src/vec/functions/function_jsonb.cpp | 25 +-
be/src/vec/olap/olap_data_convertor.cpp | 73 +-
be/src/vec/olap/olap_data_convertor.h | 16 -
be/src/vec/sink/vmysql_result_writer.cpp | 15 +-
be/src/vec/sink/vtablet_sink.cpp | 10 +-
be/test/vec/core/column_jsonb_test.cpp | 57 -
fe/fe-core/src/main/cup/sql_parser.cup | 6 +-
.../org/apache/doris/catalog/PrimitiveType.java | 2 +-
.../java/org/apache/doris/catalog/ScalarType.java | 4 +-
.../java/org/apache/doris/mysql/MysqlColType.java | 4 +-
fe/fe-core/src/main/jflex/sql_scanner.flex | 2 +-
regression-test/data/jsonb_p0/test_jsonb.csv | 25 +
.../data/jsonb_p0/test_jsonb_load_and_function.out | 3444 ++++++++++++++++++++
.../jsonb_p0/test_jsonb_load_and_function.groovy | 311 ++
23 files changed, 3849 insertions(+), 1097 deletions(-)
diff --git a/be/src/olap/row_block2.cpp b/be/src/olap/row_block2.cpp
index 6d68090a40..b27a67f65d 100644
--- a/be/src/olap/row_block2.cpp
+++ b/be/src/olap/row_block2.cpp
@@ -26,7 +26,6 @@
#include "util/bitmap.h"
#include "vec/columns/column_array.h"
#include "vec/columns/column_complex.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/columns/column_vector.h"
#include "vec/core/block.h"
#include "vec/core/types.h"
@@ -328,7 +327,7 @@ Status RowBlockV2::_copy_data_to_column(int cid,
break;
}
case OLAP_FIELD_TYPE_JSONB: {
- auto json_string = assert_cast<vectorized::ColumnJsonb*>(column);
+ auto json_string = assert_cast<vectorized::ColumnString*>(column);
size_t limit = config::jsonb_type_length_soft_limit_bytes;
for (uint16_t j = 0; j < _selected_size; ++j) {
if (!nullable_mark_array[j]) {
@@ -341,6 +340,7 @@ Status RowBlockV2::_copy_data_to_column(int cid,
fmt::format("Not support json len over than {} in vec engine.", limit));
}
} else {
+ // TODO
json_string->insert_default();
}
}
diff --git a/be/src/runtime/primitive_type.h b/be/src/runtime/primitive_type.h
index f785514696..4547333389 100644
--- a/be/src/runtime/primitive_type.h
+++ b/be/src/runtime/primitive_type.h
@@ -28,7 +28,6 @@ namespace doris {
namespace vectorized {
class ColumnString;
-class ColumnJsonb;
} // namespace vectorized
class DateTimeValue;
@@ -232,7 +231,7 @@ struct PrimitiveTypeTraits<TYPE_HLL> {
template <>
struct PrimitiveTypeTraits<TYPE_JSONB> {
using CppType = JsonBinaryValue;
- using ColumnType = vectorized::ColumnJsonb;
+ using ColumnType = vectorized::ColumnString;
};
// only for adapt get_predicate_column_ptr
diff --git a/be/src/vec/CMakeLists.txt b/be/src/vec/CMakeLists.txt
index 4155a974c9..0e83f98167 100644
--- a/be/src/vec/CMakeLists.txt
+++ b/be/src/vec/CMakeLists.txt
@@ -52,7 +52,6 @@ set(VEC_FILES
columns/column_decimal.cpp
columns/column_nullable.cpp
columns/column_string.cpp
- columns/column_jsonb.cpp
columns/column_vector.cpp
columns/columns_common.cpp
common/demangle.cpp
diff --git a/be/src/vec/columns/column_jsonb.cpp b/be/src/vec/columns/column_jsonb.cpp
deleted file mode 100644
index bc904dcb80..0000000000
--- a/be/src/vec/columns/column_jsonb.cpp
+++ /dev/null
@@ -1,424 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-#include "vec/columns/column_jsonb.h"
-
-#include "util/jsonb_parser.h"
-#include "vec/columns/column_string.h"
-#include "vec/columns/columns_common.h"
-#include "vec/common/arena.h"
-#include "vec/common/assert_cast.h"
-#include "vec/common/memcmp_small.h"
-#include "vec/common/string_buffer.hpp"
-#include "vec/common/unaligned.h"
-
-namespace doris::vectorized {
-
-MutableColumnPtr ColumnJsonb::clone_resized(size_t to_size) const {
- auto res = ColumnJsonb::create();
- if (to_size == 0) return res;
-
- size_t from_size = size();
-
- if (to_size <= from_size) {
- /// Just cut column.
-
- res->offsets.assign(offsets.begin(), offsets.begin() + to_size);
- res->chars.assign(chars.begin(), chars.begin() + offsets[to_size - 1]);
- } else {
- Offset offset = 0;
- if (from_size > 0) {
- res->offsets.assign(offsets.begin(), offsets.end());
- res->chars.assign(chars.begin(), chars.end());
- offset = offsets.back();
- }
-
- /// Empty strings are just zero terminating bytes.
-
- res->chars.resize_fill(res->chars.size() + to_size - from_size);
-
- res->offsets.resize(to_size);
- for (size_t i = from_size; i < to_size; ++i) {
- ++offset;
- res->offsets[i] = offset;
- }
- res->offsets.resize_fill(to_size, chars.size());
- }
-
- return res;
-}
-
-void ColumnJsonb::insert_range_from(const IColumn& src, size_t start, size_t length) {
- if (length == 0) return;
-
- const ColumnJsonb& src_concrete = reinterpret_cast<const ColumnJsonb&>(src);
-
- if (start + length > src_concrete.offsets.size()) {
- LOG(FATAL) << "Parameter out of bound in IColumnJsonb::insert_range_from method.";
- }
-
- size_t nested_offset = src_concrete.offset_at(start);
- size_t nested_length = src_concrete.offsets[start + length - 1] - nested_offset;
-
- size_t old_chars_size = chars.size();
- chars.resize(old_chars_size + nested_length);
- memcpy(&chars[old_chars_size], &src_concrete.chars[nested_offset], nested_length);
-
- if (start == 0 && offsets.empty()) {
- offsets.assign(src_concrete.offsets.begin(), src_concrete.offsets.begin() + length);
- } else {
- size_t old_size = offsets.size();
- size_t prev_max_offset = offsets.back(); /// -1th index is Ok, see PaddedPODArray
- offsets.resize(old_size + length);
-
- for (size_t i = 0; i < length; ++i)
- offsets[old_size + i] =
- src_concrete.offsets[start + i] - nested_offset + prev_max_offset;
- }
-}
-
-void ColumnJsonb::insert_indices_from(const IColumn& src, const int* indices_begin,
- const int* indices_end) {
- for (auto x = indices_begin; x != indices_end; ++x) {
- if (*x == -1) {
- ColumnJsonb::insert_default();
- } else {
- ColumnJsonb::insert_from(src, *x);
- }
- }
-}
-
-ColumnPtr ColumnJsonb::filter(const Filter& filt, ssize_t result_size_hint) const {
- if (offsets.size() == 0) return ColumnJsonb::create();
-
- auto res = ColumnJsonb::create();
-
- Chars& res_chars = res->chars;
- Offsets& res_offsets = res->offsets;
-
- filter_arrays_impl<UInt8>(chars, offsets, res_chars, res_offsets, filt, result_size_hint);
- return res;
-}
-
-ColumnPtr ColumnJsonb::permute(const Permutation& perm, size_t limit) const {
- size_t size = offsets.size();
-
- if (limit == 0)
- limit = size;
- else
- limit = std::min(size, limit);
-
- if (perm.size() < limit) {
- LOG(FATAL) << "Size of permutation is less than required.";
- }
-
- if (limit == 0) return ColumnJsonb::create();
-
- auto res = ColumnJsonb::create();
-
- Chars& res_chars = res->chars;
- Offsets& res_offsets = res->offsets;
-
- if (limit == size)
- res_chars.resize(chars.size());
- else {
- size_t new_chars_size = 0;
- for (size_t i = 0; i < limit; ++i) new_chars_size += size_at(perm[i]);
- res_chars.resize(new_chars_size);
- }
-
- res_offsets.resize(limit);
-
- Offset current_new_offset = 0;
-
- for (size_t i = 0; i < limit; ++i) {
- size_t j = perm[i];
- size_t json_offset = offsets[j - 1];
- size_t json_size = offsets[j] - json_offset;
-
- memcpy_small_allow_read_write_overflow15(&res_chars[current_new_offset],
- &chars[json_offset], json_size);
-
- current_new_offset += json_size;
- res_offsets[i] = current_new_offset;
- }
-
- return res;
-}
-
-StringRef ColumnJsonb::serialize_value_into_arena(size_t n, Arena& arena,
- char const*& begin) const {
- IColumn::Offset json_size = size_at(n);
- size_t offset = offset_at(n);
-
- StringRef res;
- res.size = sizeof(json_size) + json_size;
- char* pos = arena.alloc_continue(res.size, begin);
- memcpy(pos, &json_size, sizeof(json_size));
- memcpy(pos + sizeof(json_size), &chars[offset], json_size);
- res.data = pos;
-
- return res;
-}
-
-const char* ColumnJsonb::deserialize_and_insert_from_arena(const char* pos) {
- const IColumn::Offset json_size = unaligned_load<size_t>(pos);
- pos += sizeof(json_size);
-
- const size_t old_size = chars.size();
- const size_t new_size = old_size + json_size;
- chars.resize(new_size);
- memcpy(chars.data() + old_size, pos, json_size);
-
- offsets.push_back(new_size);
- return pos + json_size;
-}
-
-size_t ColumnJsonb::get_max_row_byte_size() const {
- size_t max_size = 0;
- size_t num_rows = offsets.size();
- for (size_t i = 0; i < num_rows; ++i) {
- max_size = std::max(max_size, size_at(i));
- }
-
- return max_size + sizeof(uint32_t);
-}
-
-void ColumnJsonb::serialize_vec(std::vector<StringRef>& keys, size_t num_rows,
- size_t max_row_byte_size) const {
- for (size_t i = 0; i < num_rows; ++i) {
- uint32_t offset(offset_at(i));
- uint32_t string_size(size_at(i));
-
- auto* ptr = const_cast<char*>(keys[i].data + keys[i].size);
- memcpy(ptr, &string_size, sizeof(string_size));
- memcpy(ptr + sizeof(string_size), &chars[offset], string_size);
- keys[i].size += sizeof(string_size) + string_size;
- }
-}
-
-void ColumnJsonb::serialize_vec_with_null_map(std::vector<StringRef>& keys, size_t num_rows,
- const uint8_t* null_map,
- size_t max_row_byte_size) const {
- for (size_t i = 0; i < num_rows; ++i) {
- if (null_map[i] == 0) {
- uint32_t offset(offset_at(i));
- uint32_t string_size(size_at(i));
-
- auto* ptr = const_cast<char*>(keys[i].data + keys[i].size);
- memcpy(ptr, &string_size, sizeof(string_size));
- memcpy(ptr + sizeof(string_size), &chars[offset], string_size);
- keys[i].size += sizeof(string_size) + string_size;
- }
- }
-}
-
-template <typename Type>
-ColumnPtr ColumnJsonb::index_impl(const PaddedPODArray<Type>& indexes, size_t limit) const {
- if (limit == 0) return ColumnJsonb::create();
-
- auto res = ColumnJsonb::create();
-
- Chars& res_chars = res->chars;
- Offsets& res_offsets = res->offsets;
-
- size_t new_chars_size = 0;
- for (size_t i = 0; i < limit; ++i) new_chars_size += size_at(indexes[i]);
- res_chars.resize(new_chars_size);
-
- res_offsets.resize(limit);
-
- Offset current_new_offset = 0;
-
- for (size_t i = 0; i < limit; ++i) {
- size_t j = indexes[i];
- size_t json_offset = offsets[j - 1];
- size_t json_size = offsets[j] - json_offset;
-
- memcpy_small_allow_read_write_overflow15(&res_chars[current_new_offset],
- &chars[json_offset], json_size);
-
- current_new_offset += json_size;
- res_offsets[i] = current_new_offset;
- }
-
- return res;
-}
-
-template <bool positive>
-struct ColumnJsonb::less {
- const ColumnJsonb& parent;
- explicit less(const ColumnJsonb& parent_) : parent(parent_) {}
- bool operator()(size_t lhs, size_t rhs) const {
- int res = memcmp_small_allow_overflow15(
- parent.chars.data() + parent.offset_at(lhs), parent.size_at(lhs) - 1,
- parent.chars.data() + parent.offset_at(rhs), parent.size_at(rhs) - 1);
-
- return positive ? (res < 0) : (res > 0);
- }
-};
-
-void ColumnJsonb::get_permutation(bool reverse, size_t limit, int /*nan_direction_hint*/,
- Permutation& res) const {
- size_t s = offsets.size();
- res.resize(s);
- for (size_t i = 0; i < s; ++i) res[i] = i;
-
- if (limit >= s) limit = 0;
-
- if (limit) {
- if (reverse)
- std::partial_sort(res.begin(), res.begin() + limit, res.end(), less<false>(*this));
- else
- std::partial_sort(res.begin(), res.begin() + limit, res.end(), less<true>(*this));
- } else {
- if (reverse)
- std::sort(res.begin(), res.end(), less<false>(*this));
- else
- std::sort(res.begin(), res.end(), less<true>(*this));
- }
-}
-
-ColumnPtr ColumnJsonb::replicate(const Offsets& replicate_offsets) const {
- size_t col_size = size();
- if (col_size != replicate_offsets.size()) {
- LOG(FATAL) << "Size of offsets doesn't match size of column.";
- }
-
- auto res = ColumnJsonb::create();
-
- if (0 == col_size) return res;
-
- Chars& res_chars = res->chars;
- Offsets& res_offsets = res->offsets;
- res_chars.reserve(chars.size() / col_size * replicate_offsets.back());
- res_offsets.reserve(replicate_offsets.back());
-
- Offset prev_replicate_offset = 0;
- Offset prev_json_offset = 0;
- Offset current_new_offset = 0;
-
- for (size_t i = 0; i < col_size; ++i) {
- size_t size_to_replicate = replicate_offsets[i] - prev_replicate_offset;
- size_t json_size = offsets[i] - prev_json_offset;
-
- for (size_t j = 0; j < size_to_replicate; ++j) {
- current_new_offset += json_size;
- res_offsets.push_back(current_new_offset);
-
- res_chars.resize(res_chars.size() + json_size);
- memcpy_small_allow_read_write_overflow15(&res_chars[res_chars.size() - json_size],
- &chars[prev_json_offset], json_size);
- }
-
- prev_replicate_offset = replicate_offsets[i];
- prev_json_offset = offsets[i];
- }
-
- return res;
-}
-
-void ColumnJsonb::replicate(const uint32_t* counts, size_t target_size, IColumn& column,
- size_t begin, int count_sz) const {
- size_t col_size = count_sz < 0 ? size() : count_sz;
- if (0 == col_size) return;
-
- auto& res = reinterpret_cast<ColumnJsonb&>(column);
-
- Chars& res_chars = res.chars;
- Offsets& res_offsets = res.offsets;
- res_chars.reserve(chars.size() / col_size * target_size);
- res_offsets.reserve(target_size);
-
- size_t base = begin > 0 ? offset_at(begin - 1) : 0;
- Offset prev_json_offset = 0 + base;
- Offset current_new_offset = 0;
-
- size_t end = begin + col_size;
- for (size_t i = begin; i < end; ++i) {
- size_t size_to_replicate = counts[i];
- size_t json_size = offsets[i] - prev_json_offset;
-
- for (size_t j = 0; j < size_to_replicate; ++j) {
- current_new_offset += json_size;
- res_offsets.push_back(current_new_offset);
-
- res_chars.resize(res_chars.size() + json_size);
- memcpy_small_allow_read_write_overflow15(&res_chars[res_chars.size() - json_size],
- &chars[prev_json_offset], json_size);
- }
-
- prev_json_offset = offsets[i];
- }
-}
-
-void ColumnJsonb::reserve(size_t n) {
- offsets.reserve(n);
- chars.reserve(n);
-}
-
-MutableColumnPtr ColumnJsonb::get_shrinked_column() {
- auto shrinked_column = ColumnJsonb::create();
- shrinked_column->get_offsets().reserve(offsets.size());
- shrinked_column->get_chars().reserve(chars.size());
- for (int i = 0; i < size(); i++) {
- StringRef str = get_data_at(i);
- reinterpret_cast<ColumnJsonb*>(shrinked_column.get())
- ->insert_data(str.data, strnlen(str.data, str.size));
- }
- return shrinked_column;
-}
-
-void ColumnJsonb::resize(size_t n) {
- auto origin_size = size();
- if (origin_size > n) {
- offsets.resize(n);
- } else if (origin_size < n) {
- insert_many_defaults(n - origin_size);
- }
-}
-
-void ColumnJsonb::get_extremes(Field& min, Field& max) const {
- min = String();
- max = String();
-
- size_t col_size = size();
-
- if (col_size == 0) return;
-
- size_t min_idx = 0;
- size_t max_idx = 0;
-
- less<true> less_op(*this);
-
- for (size_t i = 1; i < col_size; ++i) {
- if (less_op(i, min_idx))
- min_idx = i;
- else if (less_op(max_idx, i))
- max_idx = i;
- }
-
- get(min_idx, min);
- get(max_idx, max);
-}
-
-void ColumnJsonb::protect() {
- get_chars().protect();
- get_offsets().protect();
-}
-
-} // namespace doris::vectorized
diff --git a/be/src/vec/columns/column_jsonb.h b/be/src/vec/columns/column_jsonb.h
deleted file mode 100644
index 66e17d0e68..0000000000
--- a/be/src/vec/columns/column_jsonb.h
+++ /dev/null
@@ -1,352 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-#pragma once
-
-#include <cassert>
-#include <cstring>
-
-#include "runtime/jsonb_value.h"
-#include "vec/columns/column.h"
-#include "vec/columns/column_impl.h"
-#include "vec/columns/column_string.h"
-#include "vec/common/assert_cast.h"
-#include "vec/common/memcmp_small.h"
-#include "vec/common/memcpy_small.h"
-#include "vec/common/pod_array.h"
-#include "vec/common/sip_hash.h"
-#include "vec/core/field.h"
-
-namespace doris::vectorized {
-class ColumnJsonb final : public COWHelper<IColumn, ColumnJsonb> {
-public:
- using Char = UInt8;
- using Chars = PaddedPODArray<UInt8>;
-
-private:
- friend class COWHelper<IColumn, ColumnJsonb>;
-
- Offsets offsets;
-
- Chars chars;
-
- size_t ALWAYS_INLINE offset_at(ssize_t i) const { return offsets[i - 1]; }
-
- size_t ALWAYS_INLINE size_at(ssize_t i) const { return offsets[i] - offsets[i - 1]; }
-
- template <bool positive>
- struct less;
-
- template <bool positive>
- struct lessWithCollation;
-
- ColumnJsonb() = default;
-
- ColumnJsonb(const ColumnJsonb& src)
- : offsets(src.offsets.begin(), src.offsets.end()),
- chars(src.chars.begin(), src.chars.end()) {}
-
-public:
- const char* get_family_name() const override { return "JSONB"; }
-
- size_t size() const override { return offsets.size(); }
-
- size_t byte_size() const override { return chars.size() + offsets.size() * sizeof(offsets[0]); }
-
- size_t allocated_bytes() const override {
- return chars.allocated_bytes() + offsets.allocated_bytes();
- }
-
- void protect() override;
-
- MutableColumnPtr clone_resized(size_t to_size) const override;
-
- Field operator[](size_t n) const override {
- assert(n < size());
- return Field(&chars[offset_at(n)], size_at(n) - 1);
- }
-
- void get(size_t n, Field& res) const override {
- assert(n < size());
- res.assign_jsonb(&chars[offset_at(n)], size_at(n) - 1);
- }
-
- StringRef get_data_at(size_t n) const override {
- assert(n < size());
- return StringRef(&chars[offset_at(n)], size_at(n) - 1);
- }
-
-/// Suppress gcc 7.3.1 warning: '*((void*)&<anonymous> +8)' may be used uninitialized in this function
-#if !__clang__
-#pragma GCC diagnostic push
-#pragma GCC diagnostic ignored "-Wmaybe-uninitialized"
-#endif
-
- void insert(const Field& x) override {
- const JsonbField& s = doris::vectorized::get<const JsonbField&>(x);
-
- const size_t old_size = chars.size();
- const size_t size_to_append = s.get_size() + 1;
- const size_t new_size = old_size + size_to_append;
-
- chars.resize(new_size);
-
- memcpy(chars.data() + old_size, s.get_value(), size_to_append - 1);
- chars.data()[new_size - 1] = 0;
- offsets.push_back(new_size);
- }
-
-#if !__clang__
-#pragma GCC diagnostic pop
-#endif
-
- void insert_from(const IColumn& src_, size_t n) override {
- const ColumnJsonb& src = assert_cast<const ColumnJsonb&>(src_);
- const size_t size_to_append =
- src.offsets[n] - src.offsets[n - 1]; /// -1th index is Ok, see PaddedPODArray.
-
- if (size_to_append == 1) {
- /// shortcut for empty jsonb
- chars.push_back(0);
- offsets.push_back(chars.size());
- } else {
- const size_t old_size = chars.size();
- const size_t offset = src.offsets[n - 1];
- const size_t new_size = old_size + size_to_append;
-
- chars.resize(new_size);
- memcpy_small_allow_read_write_overflow15(chars.data() + old_size, &src.chars[offset],
- size_to_append);
- offsets.push_back(new_size);
- }
- }
-
- void insert_data(const char* pos, size_t length) override {
- const size_t old_size = chars.size();
- const size_t new_size = old_size + length + 1;
-
- chars.resize(new_size);
- if (length) memcpy(chars.data() + old_size, pos, length);
- chars[old_size + length] = 0;
- offsets.push_back(new_size);
- }
-
- void insert_many_continuous_binary_data(const char* data, const uint32_t* offsets_,
- const size_t num) override {
- if (UNLIKELY(num == 0)) {
- return;
- }
-
- size_t new_size = offsets_[num] - offsets_[0] + num * sizeof(char);
- const size_t old_size = chars.size();
- chars.resize(new_size + old_size);
-
- auto* data_ptr = chars.data();
- size_t offset = old_size;
-
- for (size_t i = 0; i != num; ++i) {
- uint32_t len = offsets_[i + 1] - offsets_[i];
- if (LIKELY(len)) {
- memcpy(data_ptr + offset, data + offsets_[i], len);
- offset += len;
- }
- data_ptr[offset] = 0;
- offset += 1;
- offsets.push_back(offset);
- }
- DCHECK(offset == chars.size());
- }
-
- void insert_many_binary_data(char* data_array, uint32_t* len_array,
- uint32_t* start_offset_array, size_t num) override {
- size_t new_size = 0;
- for (size_t i = 0; i < num; i++) {
- new_size += len_array[i] + 1;
- }
-
- const size_t old_size = chars.size();
- chars.resize(old_size + new_size);
-
- Char* data = chars.data();
- size_t offset = old_size;
- for (size_t i = 0; i < num; i++) {
- uint32_t len = len_array[i];
- uint32_t start_offset = start_offset_array[i];
- if (len) memcpy(data + offset, data_array + start_offset, len);
- data[offset + len] = 0;
- offset += len + 1;
- offsets.push_back(offset);
- }
- }
-
- void insert_many_dict_data(const int32_t* data_array, size_t start_index, const StringRef* dict,
- size_t num, uint32_t /*dict_num*/) override {
- for (size_t end_index = start_index + num; start_index < end_index; ++start_index) {
- int32_t codeword = data_array[start_index];
- insert_data(dict[codeword].data, dict[codeword].size);
- }
- }
-
- void pop_back(size_t n) override {
- size_t nested_n = offsets.back() - offset_at(offsets.size() - n);
- chars.resize(chars.size() - nested_n);
- offsets.resize_assume_reserved(offsets.size() - n);
- }
-
- StringRef serialize_value_into_arena(size_t n, Arena& arena, char const*& begin) const override;
-
- const char* deserialize_and_insert_from_arena(const char* pos) override;
-
- size_t get_max_row_byte_size() const override;
-
- void serialize_vec(std::vector<StringRef>& keys, size_t num_rows,
- size_t max_row_byte_size) const override;
-
- void serialize_vec_with_null_map(std::vector<StringRef>& keys, size_t num_rows,
- const uint8_t* null_map,
- size_t max_row_byte_size) const override;
-
- void update_hash_with_value(size_t n, SipHash& hash) const override {
- size_t string_size = size_at(n);
- size_t offset = offset_at(n);
-
- hash.update(reinterpret_cast<const char*>(&string_size), sizeof(string_size));
- hash.update(reinterpret_cast<const char*>(&chars[offset]), string_size);
- }
-
- void insert_range_from(const IColumn& src, size_t start, size_t length) override;
-
- void insert_indices_from(const IColumn& src, const int* indices_begin,
- const int* indices_end) override;
-
- ColumnPtr filter(const Filter& filt, ssize_t result_size_hint) const override;
-
- ColumnPtr permute(const Permutation& perm, size_t limit) const override;
-
- // ColumnPtr index(const IColumn & indexes, size_t limit) const override;
-
- template <typename Type>
- ColumnPtr index_impl(const PaddedPODArray<Type>& indexes, size_t limit) const;
-
- void insert_default() override {
- JsonBinaryValue empty_jsonb("{}");
- insert_data(empty_jsonb.value(), empty_jsonb.size());
- }
-
- void insert_many_defaults(size_t length) override {
- JsonBinaryValue empty_jsonb("{}");
- size_t new_size = 0;
- for (size_t i = 0; i < length; i++) {
- new_size += empty_jsonb.size() + 1;
- }
-
- const size_t old_size = chars.size();
- chars.resize(old_size + new_size);
-
- Char* data = chars.data();
- size_t offset = old_size;
- for (size_t i = 0; i < length; i++) {
- uint32_t len = empty_jsonb.size();
- if (len) memcpy(data + offset, empty_jsonb.value(), len);
- data[offset + len] = 0;
- offset += len + empty_jsonb.size();
- offsets.push_back(offset);
- }
- }
-
- int compare_at(size_t n, size_t m, const IColumn& rhs_,
- int /*nan_direction_hint*/) const override {
- LOG(FATAL) << "Not support compraing between JSONB value";
- }
-
- void get_permutation(bool reverse, size_t limit, int nan_direction_hint,
- Permutation& res) const override;
-
- ColumnPtr replicate(const Offsets& replicate_offsets) const override;
-
- void replicate(const uint32_t* counts, size_t target_size, IColumn& column, size_t begin = 0,
- int count_sz = -1) const override;
-
- MutableColumns scatter(ColumnIndex num_columns, const Selector& selector) const override {
- return scatter_impl<ColumnJsonb>(num_columns, selector);
- }
-
- void append_data_by_selector(MutableColumnPtr& res,
- const IColumn::Selector& selector) const override {
- append_data_by_selector_impl<ColumnString>(res, selector);
- }
- // void gather(ColumnGathererStream & gatherer_stream) override;
-
- void reserve(size_t n) override;
-
- void resize(size_t n) override;
-
- void get_extremes(Field& min, Field& max) const override;
-
- bool can_be_inside_nullable() const override { return true; }
-
- bool is_column_string() const override { return true; }
-
- bool structure_equals(const IColumn& rhs) const override {
- return typeid(rhs) == typeid(ColumnJsonb);
- }
-
- Chars& get_chars() { return chars; }
-
- const Chars& get_chars() const { return chars; }
-
- Offsets& get_offsets() { return offsets; }
-
- const Offsets& get_offsets() const { return offsets; }
-
- void clear() override {
- chars.clear();
- offsets.clear();
- }
-
- void replace_column_data(const IColumn& rhs, size_t row, size_t self_row = 0) override {
- DCHECK(size() > self_row);
- const auto& r = assert_cast<const ColumnJsonb&>(rhs);
- auto data = r.get_data_at(row);
-
- if (!self_row) {
- chars.clear();
- offsets[self_row] = data.size + 1;
- } else {
- offsets[self_row] = offsets[self_row - 1] + data.size + 1;
- }
-
- chars.insert(data.data, data.data + data.size + 1);
- }
-
- // should replace according to 0,1,2... ,size,0,1,2...
- void replace_column_data_default(size_t self_row = 0) override {
- DCHECK(size() > self_row);
-
- if (!self_row) {
- chars.clear();
- offsets[self_row] = 1;
- } else {
- offsets[self_row] = offsets[self_row - 1] + 1;
- }
-
- chars.emplace_back(0);
- }
-
- MutableColumnPtr get_shrinked_column() override;
-};
-}; // namespace doris::vectorized
\ No newline at end of file
diff --git a/be/src/vec/data_types/data_type_jsonb.cpp b/be/src/vec/data_types/data_type_jsonb.cpp
index c607ced9b3..40988550ad 100644
--- a/be/src/vec/data_types/data_type_jsonb.cpp
+++ b/be/src/vec/data_types/data_type_jsonb.cpp
@@ -19,7 +19,6 @@
#include "gen_cpp/data.pb.h"
#include "vec/columns/column_const.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/common/assert_cast.h"
#include "vec/core/field.h"
#include "vec/io/io_helper.h"
@@ -30,51 +29,37 @@
namespace doris::vectorized {
-template <typename Reader>
-static inline void read(IColumn& column, Reader&& reader) {
- ColumnJsonb& column_json = assert_cast<ColumnJsonb&>(column);
- ColumnJsonb::Chars& data = column_json.get_chars();
- ColumnJsonb::Offsets& offsets = column_json.get_offsets();
- size_t old_chars_size = data.size();
- size_t old_offsets_size = offsets.size();
- try {
- reader(data);
- data.push_back(0);
- offsets.push_back(data.size());
- } catch (...) {
- offsets.resize_assume_reserved(old_offsets_size);
- data.resize_assume_reserved(old_chars_size);
- throw;
- }
-}
-
std::string DataTypeJsonb::to_string(const IColumn& column, size_t row_num) const {
const StringRef& s =
- reinterpret_cast<const ColumnJsonb&>(*column.convert_to_full_column_if_const().get())
+ reinterpret_cast<const ColumnString&>(*column.convert_to_full_column_if_const().get())
.get_data_at(row_num);
- return JsonbToJson::jsonb_to_json_string(s.data, s.size);
+ // size == 0 is for NULL
+ return s.size > 0 ? JsonbToJson::jsonb_to_json_string(s.data, s.size) : "";
}
void DataTypeJsonb::to_string(const class doris::vectorized::IColumn& column, size_t row_num,
class doris::vectorized::BufferWritable& ostr) const {
- std::string json_string = to_string(column, row_num);
- ostr.write(json_string.c_str(), json_string.size());
+ const StringRef& s =
+ reinterpret_cast<const ColumnString&>(*column.convert_to_full_column_if_const().get())
+ .get_data_at(row_num);
+ if (s.size > 0) {
+ std::string str = JsonbToJson::jsonb_to_json_string(s.data, s.size);
+ ostr.write(str.c_str(), str.size());
+ }
}
Status DataTypeJsonb::from_string(ReadBuffer& rb, IColumn* column) const {
JsonBinaryValue value;
RETURN_IF_ERROR(value.from_json_string(rb.position(), rb.count()));
- Field field = JsonbField(value.value(), value.size());
-
- auto* column_jsonb = static_cast<ColumnJsonb*>(column);
- column_jsonb->insert(field);
+ auto* column_string = static_cast<ColumnString*>(column);
+ column_string->insert_data(value.value(), value.size());
return Status::OK();
}
MutableColumnPtr DataTypeJsonb::create_column() const {
- return ColumnJsonb::create();
+ return ColumnString::create();
}
bool DataTypeJsonb::equals(const IDataType& rhs) const {
@@ -83,106 +68,15 @@ bool DataTypeJsonb::equals(const IDataType& rhs) const {
int64_t DataTypeJsonb::get_uncompressed_serialized_bytes(const IColumn& column,
int data_version) const {
- auto ptr = column.convert_to_full_column_if_const();
- const auto& data_column = assert_cast<const ColumnJsonb&>(*ptr.get());
-
- if (data_version == -1) {
- return sizeof(IColumn::Offset) * (column.size() + 1) + sizeof(uint64_t) +
- data_column.get_chars().size() + column.size();
- }
-
- return sizeof(IColumn::Offset) * (column.size() + 1) + sizeof(uint64_t) +
- data_column.get_chars().size();
+ return data_type_string.get_uncompressed_serialized_bytes(column, data_version);
}
char* DataTypeJsonb::serialize(const IColumn& column, char* buf, int data_version) const {
- auto ptr = column.convert_to_full_column_if_const();
- const auto& data_column = assert_cast<const ColumnJsonb&>(*ptr.get());
-
- if (data_version == -1) {
- // row num
- *reinterpret_cast<IColumn::Offset*>(buf) = column.size();
- buf += sizeof(IColumn::Offset);
- // offsets
- for (int i = 0; i < column.size(); i++) {
- *reinterpret_cast<IColumn::Offset*>(buf) = data_column.get_offsets()[i] + i + 1;
- buf += sizeof(IColumn::Offset);
- }
- // total length
- *reinterpret_cast<uint64_t*>(buf) = data_column.get_chars().size() + column.size();
- buf += sizeof(uint64_t);
- // values
- for (int i = 0; i < column.size(); i++) {
- auto data = data_column.get_data_at(i);
- memcpy(buf, data.data, data.size);
- buf += data.size;
- *buf = '\0';
- buf++;
- }
- return buf;
- }
-
- // row num
- *reinterpret_cast<IColumn::Offset*>(buf) = column.size();
- buf += sizeof(IColumn::Offset);
- // offsets
- memcpy(buf, data_column.get_offsets().data(), column.size() * sizeof(IColumn::Offset));
- buf += column.size() * sizeof(IColumn::Offset);
- // total length
- uint64_t value_len = data_column.get_chars().size();
- *reinterpret_cast<uint64_t*>(buf) = value_len;
- buf += sizeof(uint64_t);
- // values
- memcpy(buf, data_column.get_chars().data(), value_len);
- buf += value_len;
-
- return buf;
+ return data_type_string.serialize(column, buf, data_version);
}
const char* DataTypeJsonb::deserialize(const char* buf, IColumn* column, int data_version) const {
- ColumnJsonb* column_string = assert_cast<ColumnJsonb*>(column);
- ColumnJsonb::Chars& data = column_string->get_chars();
- ColumnJsonb::Offsets& offsets = column_string->get_offsets();
-
- if (data_version == -1) {
- // row num
- IColumn::Offset row_num = *reinterpret_cast<const IColumn::Offset*>(buf);
- buf += sizeof(IColumn::Offset);
- // offsets
- offsets.resize(row_num);
- for (int i = 0; i < row_num; i++) {
- offsets[i] = *reinterpret_cast<const IColumn::Offset*>(buf) - i - 1;
- buf += sizeof(IColumn::Offset);
- }
- // total length
- uint64_t value_len = *reinterpret_cast<const uint64_t*>(buf);
- buf += sizeof(uint64_t);
- // values
- data.resize(value_len - row_num);
- for (int i = 0; i < row_num; i++) {
- memcpy(data.data() + offsets[i - 1], buf, offsets[i] - offsets[i - 1]);
- buf += offsets[i] - offsets[i - 1] + 1;
- }
-
- return buf;
- }
-
- // row num
- IColumn::Offset row_num = *reinterpret_cast<const IColumn::Offset*>(buf);
- buf += sizeof(IColumn::Offset);
- // offsets
- offsets.resize(row_num);
- memcpy(offsets.data(), buf, sizeof(IColumn::Offset) * row_num);
- buf += sizeof(IColumn::Offset) * row_num;
- // total length
- uint64_t value_len = *reinterpret_cast<const uint64_t*>(buf);
- buf += sizeof(uint64_t);
- // values
- data.resize(value_len);
- memcpy(data.data(), buf, value_len);
- buf += value_len;
-
- return buf;
+ return data_type_string.deserialize(buf, column, data_version);
}
} // namespace doris::vectorized
diff --git a/be/src/vec/data_types/data_type_jsonb.h b/be/src/vec/data_types/data_type_jsonb.h
index f437f40c3a..68274d6bff 100644
--- a/be/src/vec/data_types/data_type_jsonb.h
+++ b/be/src/vec/data_types/data_type_jsonb.h
@@ -19,13 +19,15 @@
#include <ostream>
-#include "vec/columns/column_jsonb.h"
+#include "runtime/jsonb_value.h"
+#include "vec/columns/column_string.h"
#include "vec/data_types/data_type.h"
+#include "vec/data_types/data_type_string.h"
namespace doris::vectorized {
class DataTypeJsonb final : public IDataType {
public:
- using ColumnType = ColumnJsonb;
+ using ColumnType = ColumnString;
using FieldType = JsonbField;
static constexpr bool is_parametric = false;
@@ -60,5 +62,8 @@ public:
std::string to_string(const IColumn& column, size_t row_num) const override;
void to_string(const IColumn& column, size_t row_num, BufferWritable& ostr) const override;
Status from_string(ReadBuffer& rb, IColumn* column) const override;
+
+private:
+ DataTypeString data_type_string;
};
} // namespace doris::vectorized
\ No newline at end of file
diff --git a/be/src/vec/exprs/vliteral.cpp b/be/src/vec/exprs/vliteral.cpp
index c6f3aa4224..0b9ca3a5d0 100644
--- a/be/src/vec/exprs/vliteral.cpp
+++ b/be/src/vec/exprs/vliteral.cpp
@@ -129,7 +129,7 @@ void VLiteral::init(const TExprNode& node) {
DCHECK_EQ(node.node_type, TExprNodeType::JSON_LITERAL);
DCHECK(node.__isset.json_literal);
JsonBinaryValue value(node.json_literal.value);
- field = JsonbField(value.value(), value.size());
+ field = String(value.value(), value.size());
break;
}
case TYPE_DECIMALV2: {
diff --git a/be/src/vec/functions/function_cast.h b/be/src/vec/functions/function_cast.h
index 0880a723f1..e15ef01e9f 100644
--- a/be/src/vec/functions/function_cast.h
+++ b/be/src/vec/functions/function_cast.h
@@ -24,7 +24,6 @@
#include "vec/columns/column_array.h"
#include "vec/columns/column_const.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/columns/column_nullable.h"
#include "vec/columns/column_string.h"
#include "vec/columns/columns_common.h"
@@ -366,7 +365,7 @@ struct ConvertImplNumberToJsonb {
const size_t result, size_t input_rows_count) {
const auto& col_with_type_and_name = block.get_by_position(arguments[0]);
- auto col_jsonb = ColumnJsonb::create();
+ auto column_string = ColumnString::create();
JsonbWriter writer;
const auto* col =
@@ -390,10 +389,11 @@ struct ConvertImplNumberToJsonb {
} else {
LOG(FATAL) << "unsupported type ";
}
- col_jsonb->insert_data(writer.getOutput()->getBuffer(), writer.getOutput()->getSize());
+ column_string->insert_data(writer.getOutput()->getBuffer(),
+ writer.getOutput()->getSize());
}
- block.replace_by_position(result, std::move(col_jsonb));
+ block.replace_by_position(result, std::move(column_string));
return Status::OK();
}
};
@@ -406,7 +406,7 @@ struct ConvertImplGenericToJsonb {
const IDataType& type = *col_with_type_and_name.type;
const IColumn& col_from = *col_with_type_and_name.column;
- auto col_jsonb = ColumnJsonb::create();
+ auto column_string = ColumnString::create();
JsonbWriter writer;
auto tmp_col = ColumnString::create();
@@ -422,10 +422,11 @@ struct ConvertImplGenericToJsonb {
auto str_ref = tmp_col->get_data_at(0);
writer.writeString(str_ref.data, str_ref.size);
writer.writeEndString();
- col_jsonb->insert_data(writer.getOutput()->getBuffer(), writer.getOutput()->getSize());
+ column_string->insert_data(writer.getOutput()->getBuffer(),
+ writer.getOutput()->getSize());
}
- block.replace_by_position(result, std::move(col_jsonb));
+ block.replace_by_position(result, std::move(column_string));
return Status::OK();
}
};
@@ -439,7 +440,7 @@ struct ConvertImplFromJsonb {
// result column must set type
DCHECK(block.get_by_position(result).type != nullptr);
auto data_type_to = block.get_by_position(result).type;
- if (const ColumnJsonb* col_jsonb = check_and_get_column<ColumnJsonb>(&col_from)) {
+ if (const ColumnString* column_string = check_and_get_column<ColumnString>(&col_from)) {
auto null_map_col = ColumnUInt8::create(input_rows_count, 0);
auto& null_map = null_map_col->get_data();
auto col_to = ColumnType::create();
@@ -451,7 +452,7 @@ struct ConvertImplFromJsonb {
res.resize(input_rows_count);
for (size_t i = 0; i < input_rows_count; ++i) {
- const auto& val = col_jsonb->get_data_at(i);
+ const auto& val = column_string->get_data_at(i);
// ReadBuffer read_buffer((char*)(val.data), val.size);
// RETURN_IF_ERROR(data_type_to->from_string(read_buffer, col_to));
diff --git a/be/src/vec/functions/function_jsonb.cpp b/be/src/vec/functions/function_jsonb.cpp
index a480735ca4..dd00e04166 100644
--- a/be/src/vec/functions/function_jsonb.cpp
+++ b/be/src/vec/functions/function_jsonb.cpp
@@ -21,7 +21,6 @@
#include "util/string_parser.hpp"
#include "util/string_util.h"
#include "vec/columns/column.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/columns/column_nullable.h"
#include "vec/columns/column_string.h"
#include "vec/columns/column_vector.h"
@@ -188,7 +187,7 @@ public:
col_from.get_name());
}
- auto col_to = ColumnJsonb::create();
+ auto col_to = ColumnString::create();
//IColumn & col_to = *res;
size_t size = col_from.size();
@@ -323,7 +322,7 @@ public:
auto res = Impl::ColumnType::create();
- auto jsonb_data_column = assert_cast<const ColumnJsonb*>(argument_columns[0].get());
+ auto jsonb_data_column = assert_cast<const ColumnString*>(argument_columns[0].get());
auto jsonb_path_column = assert_cast<const ColumnString*>(argument_columns[1].get());
auto& ldata = jsonb_data_column->get_chars();
@@ -370,7 +369,7 @@ struct JsonbExtractStringImpl {
}
for (size_t i = 0; i < input_rows_count; ++i) {
- int l_size = loffsets[i] - loffsets[i - 1] - 1;
+ int l_size = loffsets[i] - loffsets[i - 1];
const auto l_raw = reinterpret_cast<const char*>(&ldata[loffsets[i - 1]]);
int r_size = roffsets[i] - roffsets[i - 1];
@@ -405,13 +404,9 @@ struct JsonbExtractStringImpl {
if constexpr (std::is_same_v<DataTypeJsonb, ReturnType>) {
writer->reset();
writer->writeValue(value);
- // StringOP::push_value_string(
- // std::string_view(writer->getOutput()->getBuffer(), writer->getOutput()->getSize()),
- // i, res_data, res_offsets);
- res_data.insert(writer->getOutput()->getBuffer(),
- writer->getOutput()->getBuffer() + writer->getOutput()->getSize());
- res_data.push_back('\0');
- res_offsets[i] = res_data.size();
+ StringOP::push_value_string(std::string_view(writer->getOutput()->getBuffer(),
+ writer->getOutput()->getSize()),
+ i, res_data, res_offsets);
} else {
if (LIKELY(value->isString())) {
auto str_value = (JsonbStringVal*)value;
@@ -449,7 +444,7 @@ struct JsonbExtractImpl {
}
const char* l_raw_str = reinterpret_cast<const char*>(&ldata[loffsets[i - 1]]);
- int l_str_size = loffsets[i] - loffsets[i - 1] - 1;
+ int l_str_size = loffsets[i] - loffsets[i - 1];
const char* r_raw_str = reinterpret_cast<const char*>(&rdata[roffsets[i - 1]]);
int r_str_size = roffsets[i] - roffsets[i - 1];
@@ -470,7 +465,9 @@ struct JsonbExtractImpl {
// value is NOT necessary to be deleted since JsonbValue will not allocate memory
JsonbValue* value = doc->getValue()->findPath(r_raw_str, r_str_size, ".", nullptr);
if (UNLIKELY(!value)) {
- null_map[i] = 1;
+ if constexpr (!only_check_exists) {
+ null_map[i] = 1;
+ }
res[i] = 0;
continue;
}
@@ -580,7 +577,7 @@ struct JsonbTypeString {
struct JsonbTypeJson {
using T = std::string;
using ReturnType = DataTypeJsonb;
- using ColumnType = ColumnJsonb;
+ using ColumnType = ColumnString;
static const bool only_check_exists = false;
static const bool only_get_type = false;
};
diff --git a/be/src/vec/olap/olap_data_convertor.cpp b/be/src/vec/olap/olap_data_convertor.cpp
index 48fa0c6313..977fc3d1c7 100644
--- a/be/src/vec/olap/olap_data_convertor.cpp
+++ b/be/src/vec/olap/olap_data_convertor.cpp
@@ -79,7 +79,7 @@ OlapBlockDataConvertor::create_olap_column_data_convertor(const TabletColumn& co
return std::make_unique<OlapColumnDataConvertorDecimalV3<Decimal128I>>();
}
case FieldType::OLAP_FIELD_TYPE_JSONB: {
- return std::make_unique<OlapColumnDataConvertorJsonb>();
+ return std::make_unique<OlapColumnDataConvertorVarChar>(true);
}
case FieldType::OLAP_FIELD_TYPE_BOOL: {
return std::make_unique<OlapColumnDataConvertorSimple<vectorized::UInt8>>();
@@ -536,77 +536,6 @@ Status OlapBlockDataConvertor::OlapColumnDataConvertorDate::convert_to_olap() {
return Status::OK();
}
-// class OlapBlockDataConvertor::OlapColumnDataConvertorJsonb
-void OlapBlockDataConvertor::OlapColumnDataConvertorJsonb::set_source_column(
- const ColumnWithTypeAndName& typed_column, size_t row_pos, size_t num_rows) {
- OlapBlockDataConvertor::OlapColumnDataConvertorBase::set_source_column(typed_column, row_pos,
- num_rows);
- _slice.resize(num_rows);
-}
-
-const void* OlapBlockDataConvertor::OlapColumnDataConvertorJsonb::get_data() const {
- return _slice.data();
-}
-
-const void* OlapBlockDataConvertor::OlapColumnDataConvertorJsonb::get_data_at(size_t offset) const {
- assert(offset < _num_rows && _num_rows == _slice.size());
- UInt8 null_flag = 0;
- if (_nullmap) {
- null_flag = _nullmap[offset];
- }
- return null_flag ? nullptr : _slice.data() + offset;
-}
-
-Status OlapBlockDataConvertor::OlapColumnDataConvertorJsonb::convert_to_olap() {
- assert(_typed_column.column);
- const vectorized::ColumnJsonb* column_json = nullptr;
- if (_nullmap) {
- auto nullable_column =
- assert_cast<const vectorized::ColumnNullable*>(_typed_column.column.get());
- column_json = assert_cast<const vectorized::ColumnJsonb*>(
- nullable_column->get_nested_column_ptr().get());
- } else {
- column_json = assert_cast<const vectorized::ColumnJsonb*>(_typed_column.column.get());
- }
-
- assert(column_json);
-
- const char* char_data = (const char*)(column_json->get_chars().data());
- const ColumnJsonb::Offset* offset_cur = column_json->get_offsets().data() + _row_pos;
- const ColumnJsonb::Offset* offset_end = offset_cur + _num_rows;
-
- Slice* slice = _slice.data();
- size_t string_offset = *(offset_cur - 1);
- if (_nullmap) {
- const UInt8* nullmap_cur = _nullmap + _row_pos;
- while (offset_cur != offset_end) {
- if (!*nullmap_cur) {
- slice->data = const_cast<char*>(char_data + string_offset);
- slice->size = *offset_cur - string_offset - 1;
- } else {
- // TODO: this may not be necessary, check and remove later
- slice->data = nullptr;
- slice->size = 0;
- }
- string_offset = *offset_cur;
- ++nullmap_cur;
- ++slice;
- ++offset_cur;
- }
- assert(nullmap_cur == _nullmap + _row_pos + _num_rows && slice == _slice.get_end_ptr());
- } else {
- while (offset_cur != offset_end) {
- slice->data = const_cast<char*>(char_data + string_offset);
- slice->size = *offset_cur - string_offset - 1;
- string_offset = *offset_cur;
- ++slice;
- ++offset_cur;
- }
- assert(slice == _slice.get_end_ptr());
- }
- return Status::OK();
-}
-
void OlapBlockDataConvertor::OlapColumnDataConvertorDateTime::set_source_column(
const ColumnWithTypeAndName& typed_column, size_t row_pos, size_t num_rows) {
OlapBlockDataConvertor::OlapColumnDataConvertorPaddedPODArray<uint64_t>::set_source_column(
diff --git a/be/src/vec/olap/olap_data_convertor.h b/be/src/vec/olap/olap_data_convertor.h
index 9eb63c9154..577a60bc42 100644
--- a/be/src/vec/olap/olap_data_convertor.h
+++ b/be/src/vec/olap/olap_data_convertor.h
@@ -19,7 +19,6 @@
#include "olap/types.h"
#include "runtime/mem_pool.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/columns/column_nullable.h"
#include "vec/core/column_with_type_and_name.h"
#include "vec/core/types.h"
@@ -168,21 +167,6 @@ private:
PaddedPODArray<Slice> _slice;
};
- class OlapColumnDataConvertorJsonb : public OlapColumnDataConvertorBase {
- public:
- OlapColumnDataConvertorJsonb() = default;
- ~OlapColumnDataConvertorJsonb() override = default;
-
- void set_source_column(const ColumnWithTypeAndName& typed_column, size_t row_pos,
- size_t num_rows) override;
- const void* get_data() const override;
- const void* get_data_at(size_t offset) const override;
- Status convert_to_olap() override;
-
- private:
- PaddedPODArray<Slice> _slice;
- };
-
template <typename T>
class OlapColumnDataConvertorPaddedPODArray : public OlapColumnDataConvertorBase {
public:
diff --git a/be/src/vec/sink/vmysql_result_writer.cpp b/be/src/vec/sink/vmysql_result_writer.cpp
index b592206752..155e4c3f2e 100644
--- a/be/src/vec/sink/vmysql_result_writer.cpp
+++ b/be/src/vec/sink/vmysql_result_writer.cpp
@@ -109,18 +109,13 @@ Status VMysqlResultWriter::_add_one_column(const ColumnPtr& column_ptr,
}
}
if constexpr (type == TYPE_JSONB) {
- const auto json_val = column->get_data_at(i);
- if (json_val.data == nullptr) {
- if (json_val.size == 0) {
- // 0x01 is a magic num, not useful actually, just for present ""
- char* tmp_val = reinterpret_cast<char*>(0x01);
- buf_ret = _buffer.push_string(tmp_val, json_val.size);
- } else {
- buf_ret = _buffer.push_null();
- }
+ const auto jsonb_val = column->get_data_at(i);
+ // jsonb size == 0 is NULL
+ if (jsonb_val.data == nullptr || jsonb_val.size == 0) {
+ buf_ret = _buffer.push_null();
} else {
std::string json_str =
- JsonbToJson::jsonb_to_json_string(json_val.data, json_val.size);
+ JsonbToJson::jsonb_to_json_string(jsonb_val.data, jsonb_val.size);
buf_ret = _buffer.push_string(json_str.c_str(), json_str.size());
}
}
diff --git a/be/src/vec/sink/vtablet_sink.cpp b/be/src/vec/sink/vtablet_sink.cpp
index 3599abcbb3..7b5460a850 100644
--- a/be/src/vec/sink/vtablet_sink.cpp
+++ b/be/src/vec/sink/vtablet_sink.cpp
@@ -24,7 +24,6 @@
#include "util/proto_util.h"
#include "util/time.h"
#include "vec/columns/column_array.h"
-#include "vec/columns/column_jsonb.h"
#include "vec/core/block.h"
#include "vec/exprs/vexpr.h"
#include "vec/exprs/vexpr_context.h"
@@ -711,11 +710,14 @@ Status VOlapTableSink::_validate_column(RuntimeState* state, const TypeDescripto
break;
}
case TYPE_JSONB: {
- const auto column_jsonb =
- assert_cast<const vectorized::ColumnJsonb*>(real_column_ptr.get());
+ const auto column_string =
+ assert_cast<const vectorized::ColumnString*>(real_column_ptr.get());
for (size_t j = 0; j < column->size(); ++j) {
if (!filter_bitmap->Get(j)) {
- auto str_val = column_jsonb->get_data_at(j);
+ if (is_nullable && column_ptr && column_ptr->is_null_at(j)) {
+ continue;
+ }
+ auto str_val = column_string->get_data_at(j);
bool invalid = str_val.size == 0;
if (invalid) {
error_msg.clear();
diff --git a/be/test/vec/core/column_jsonb_test.cpp b/be/test/vec/core/column_jsonb_test.cpp
deleted file mode 100644
index ca9aeac809..0000000000
--- a/be/test/vec/core/column_jsonb_test.cpp
+++ /dev/null
@@ -1,57 +0,0 @@
-// Licensed to the Apache Software Foundation (ASF) under one
-// or more contributor license agreements. See the NOTICE file
-// distributed with this work for additional information
-// regarding copyright ownership. The ASF licenses this file
-// to you under the Apache License, Version 2.0 (the
-// "License"); you may not use this file except in compliance
-// with the License. You may obtain a copy of the License at
-//
-// http://www.apache.org/licenses/LICENSE-2.0
-//
-// Unless required by applicable law or agreed to in writing,
-// software distributed under the License is distributed on an
-// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-// KIND, either express or implied. See the License for the
-// specific language governing permissions and limitations
-// under the License.
-
-#include "vec/columns/column_jsonb.h"
-
-#include <gtest/gtest.h>
-
-#include <memory>
-#include <string>
-
-#include "vec/columns/column.h"
-#include "vec/columns/column_string.h"
-#include "vec/columns/column_vector.h"
-
-namespace doris::vectorized {
-
-JsonBinaryValue FromStdString(const std::string& str) {
- char* ptr = const_cast<char*>(str.c_str());
- int len = str.size();
- return JsonBinaryValue(ptr, len);
-}
-
-TEST(ColumnJsonbTest, SingleValueTest) {
- auto data_column = ColumnJsonb::create();
-
- std::vector<IColumn::Offset> offs = {0};
- std::vector<std::string> vals = {"[\"val1\", \"val2\"]", "[false]",
- "{\"key1\": \"js6\", \"key2\": [\"val1\", \"val2\"]}"};
- for (size_t i = 0; i < vals.size(); i++) {
- JsonBinaryValue v = FromStdString(vals[i]);
- if (i) {
- offs.push_back(offs[i - 1] + v.size());
- }
- data_column->insert_data(v.value(), v.size());
- }
-
- for (size_t i = 0; i < offs.size(); i++) {
- auto v = data_column->get_data_at(offs[i]);
- std::string json_str = JsonbToJson::jsonb_to_json_string(v.data, v.size);
- EXPECT_EQ(vals[i], json_str);
- }
-}
-} // namespace doris::vectorized
diff --git a/fe/fe-core/src/main/cup/sql_parser.cup b/fe/fe-core/src/main/cup/sql_parser.cup
index 62fab2aaaa..f2720f59ad 100644
--- a/fe/fe-core/src/main/cup/sql_parser.cup
+++ b/fe/fe-core/src/main/cup/sql_parser.cup
@@ -412,7 +412,7 @@ terminal String
KW_INVERTED,
KW_JOB,
KW_JOIN,
- KW_JSON,
+ KW_JSONB,
KW_KEY,
KW_KEYS,
KW_KILL,
@@ -5524,7 +5524,7 @@ type ::=
{: RESULT = Type.QUANTILE_STATE; :}
| KW_STRING
{: RESULT = ScalarType.createStringType(); :}
- | KW_JSON
+ | KW_JSONB
{: RESULT = ScalarType.createJsonbType(); :}
| KW_TEXT
{: RESULT = ScalarType.createStringType(); :}
@@ -6595,7 +6595,7 @@ keyword ::=
{: RESULT = id; :}
| KW_JOB:id
{: RESULT = id; :}
- | KW_JSON:id
+ | KW_JSONB:id
{: RESULT = id; :}
| KW_ENCRYPTKEY:id
{: RESULT = id; :}
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
index 8f03e8d8bc..273e658316 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/PrimitiveType.java
@@ -49,7 +49,7 @@ public enum PrimitiveType {
// 8-byte pointer and 4-byte length indicator (12 bytes total).
// Aligning to 8 bytes so 16 total.
VARCHAR("VARCHAR", 16, TPrimitiveType.VARCHAR),
- JSONB("JSON", 16, TPrimitiveType.JSONB),
+ JSONB("JSONB", 16, TPrimitiveType.JSONB),
DECIMALV2("DECIMALV2", 16, TPrimitiveType.DECIMALV2),
DECIMAL32("DECIMAL32", 4, TPrimitiveType.DECIMAL32),
diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/ScalarType.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/ScalarType.java
index d0dee96ca4..5243ba315a 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/catalog/ScalarType.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/ScalarType.java
@@ -529,7 +529,7 @@ public class ScalarType extends Type {
} else if (type == PrimitiveType.STRING) {
return "TEXT";
} else if (type == PrimitiveType.JSONB) {
- return "JSON";
+ return "JSONB";
}
return type.toString();
}
@@ -601,7 +601,7 @@ public class ScalarType extends Type {
stringBuilder.append("text");
break;
case JSONB:
- stringBuilder.append("json");
+ stringBuilder.append("jsonb");
break;
case ARRAY:
stringBuilder.append(type.toString().toLowerCase());
diff --git a/fe/fe-core/src/main/java/org/apache/doris/mysql/MysqlColType.java b/fe/fe-core/src/main/java/org/apache/doris/mysql/MysqlColType.java
index 580fcc9205..d451b5ee38 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/mysql/MysqlColType.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/mysql/MysqlColType.java
@@ -42,6 +42,7 @@ public enum MysqlColType {
MYSQL_TYPE_TIMESTAMP2(17, "TIMESTAMP2"),
MYSQL_TYPE_DATETIME2(18, "DATETIME2"),
MYSQL_TYPE_TIME2(19, "TIME2"),
+ MYSQL_TYPE_JSON(245, "JSON"),
MYSQL_TYPE_NEWDECIMAL(246, "NEW DECIMAL"),
MYSQL_TYPE_ENUM(247, "ENUM"),
MYSQL_TYPE_SET(248, "SET"),
@@ -51,8 +52,7 @@ public enum MysqlColType {
MYSQL_TYPE_BLOB(252, "BLOB"),
MYSQL_TYPE_VARSTRING(253, "VAR STRING"),
MYSQL_TYPE_STRING(254, "STRING"),
- MYSQL_TYPE_GEOMETRY(255, "GEOMETRY"),
- MYSQL_TYPE_JSON(256, "JSON");
+ MYSQL_TYPE_GEOMETRY(255, "GEOMETRY");
private MysqlColType(int code, String desc) {
this.code = code;
diff --git a/fe/fe-core/src/main/jflex/sql_scanner.flex b/fe/fe-core/src/main/jflex/sql_scanner.flex
index e57a011ace..1f50df0105 100644
--- a/fe/fe-core/src/main/jflex/sql_scanner.flex
+++ b/fe/fe-core/src/main/jflex/sql_scanner.flex
@@ -271,7 +271,7 @@ import org.apache.doris.qe.SqlModeHelper;
keywordMap.put("isolation", new Integer(SqlParserSymbols.KW_ISOLATION));
keywordMap.put("job", new Integer(SqlParserSymbols.KW_JOB));
keywordMap.put("join", new Integer(SqlParserSymbols.KW_JOIN));
- keywordMap.put("json", new Integer(SqlParserSymbols.KW_JSON));
+ keywordMap.put("jsonb", new Integer(SqlParserSymbols.KW_JSONB));
keywordMap.put("key", new Integer(SqlParserSymbols.KW_KEY));
keywordMap.put("keys", new Integer(SqlParserSymbols.KW_KEYS));
keywordMap.put("kill", new Integer(SqlParserSymbols.KW_KILL));
diff --git a/regression-test/data/jsonb_p0/test_jsonb.csv b/regression-test/data/jsonb_p0/test_jsonb.csv
new file mode 100644
index 0000000000..3a33f80e5b
--- /dev/null
+++ b/regression-test/data/jsonb_p0/test_jsonb.csv
@@ -0,0 +1,25 @@
+1 \N
+2 null
+3 true
+4 false
+5 100
+6 10000
+7 1000000000
+8 1152921504606846976
+9 6.18
+10 "abcd"
+11 {}
+12 {"k1":"v31", "k2": 300}
+13 []
+14 [123, 456]
+15 ["abc", "def"]
+16 [null, true, false, 100, 6.18, "abc"]
+17 [{"k1":"v41", "k2": 400}, 1, "a", 3.14]
+18 {"k1":"v31", "k2": 300, "a1": [{"k1":"v41", "k2": 400}, 1, "a", 3.14]}
+19 ''
+20 'abc'
+21 abc
+22 100x
+23 6.a8
+24 {x
+25 [123, abc]
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
new file mode 100644
index 0000000000..e50035ec83
--- /dev/null
+++ b/regression-test/data/jsonb_p0/test_jsonb_load_and_function.out
@@ -0,0 +1,3444 @@
+-- This file is automatically generated. You should know what you did if you want to edit this
+-- !select --
+1 \N
+2 null
+3 true
+4 false
+5 100
+6 10000
+7 1000000000
+8 1152921504606846976
+9 6.18
+10 "abcd"
+11 {}
+12 {"k1":"v31","k2":300}
+13 []
+14 [123,456]
+15 ["abc","def"]
+16 [null,true,false,100,6.18,"abc"]
+17 [{"k1":"v41","k2":400},1,"a",3.14]
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
+
+-- !select --
+1 \N
+2 null
+3 true
+4 false
+5 100
+6 10000
+7 1000000000
+8 1152921504606846976
+9 6.18
+10 "abcd"
+11 {}
+12 {"k1":"v31","k2":300}
+13 []
+14 [123,456]
+15 ["abc","def"]
+16 [null,true,false,100,6.18,"abc"]
+17 [{"k1":"v41","k2":400},1,"a",3.14]
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
+26 {"k1":"v1","k2":200}
+
+-- !select --
+1 \N \N
+2 null null
+3 true true
+4 false false
+5 100 100
+6 10000 10000
+7 1000000000 1000000000
+8 1152921504606846976 1152921504606846976
+9 6.18 6.18
+10 "abcd" "abcd"
+11 {} {}
+12 {"k1":"v31","k2":300} {"k1":"v31","k2":300}
+13 [] []
+14 [123,456] [123,456]
+15 ["abc","def"] ["abc","def"]
+16 [null,true,false,100,6.18,"abc"] [null,true,false,100,6.18,"abc"]
+17 [{"k1":"v41","k2":400},1,"a",3.14] [{"k1":"v41","k2":400},1,"a",3.14]
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]}
+26 {"k1":"v1","k2":200} {"k1":"v1","k2":200}
+
+-- !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} "v31"
+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]} "v31"
+26 {"k1":"v1","k2":200} "v1"
+
+-- !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} 300
+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]} 300
+26 {"k1":"v1","k2":200} 200
+
+-- !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] 123
+15 ["abc","def"] "abc"
+16 [null,true,false,100,6.18,"abc"] null
+17 [{"k1":"v41","k2":400},1,"a",3.14] {"k1":"v41","k2":400}
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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] 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]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] "a"
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] 100
+17 [{"k1":"v41","k2":400},1,"a",3.14] 3.14
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] 6.18
+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 {"k1":"v1","k2":200} \N
+
+-- !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"] "abc"
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} [{"k1":"v41","k2":400},1,"a",3.14]
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} {"k1":"v41","k2":400}
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} 1
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} "a"
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} 3.14
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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" abcd
+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 {"k1":"v1","k2":200} \N
+
+-- !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} v31
+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]} v31
+26 {"k1":"v1","k2":200} v1
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] abc
+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 {"k1":"v1","k2":200} \N
+
+-- !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"] def
+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 {"k1":"v1","k2":200} \N
+
+-- !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] a
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] abc
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} a
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null \N
+3 true \N
+4 false \N
+5 100 100
+6 10000 10000
+7 1000000000 1000000000
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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} 300
+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]} 300
+26 {"k1":"v1","k2":200} 200
+
+-- !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] 123
+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 {"k1":"v1","k2":200} \N
+
+-- !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] 456
+15 ["abc","def"] \N
+16 [null,true,false,100,6.18,"abc"] \N
+17 [{"k1":"v41","k2":400},1,"a",3.14] 1
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] 100
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} 1
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null \N
+3 true \N
+4 false \N
+5 100 100
+6 10000 10000
+7 1000000000 1000000000
+8 1152921504606846976 1152921504606846976
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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} 300
+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]} 300
+26 {"k1":"v1","k2":200} 200
+
+-- !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] 123
+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 {"k1":"v1","k2":200} \N
+
+-- !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] 456
+15 ["abc","def"] \N
+16 [null,true,false,100,6.18,"abc"] \N
+17 [{"k1":"v41","k2":400},1,"a",3.14] 1
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] 100
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} 1
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null \N
+3 true \N
+4 false \N
+5 100 100.0
+6 10000 10000.0
+7 1000000000 1.0E9
+8 1152921504606846976 1.15292150460684698E18
+9 6.18 6.18
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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} 300.0
+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]} 300.0
+26 {"k1":"v1","k2":200} 200.0
+
+-- !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] 123.0
+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 {"k1":"v1","k2":200} \N
+
+-- !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] 456.0
+15 ["abc","def"] \N
+16 [null,true,false,100,6.18,"abc"] \N
+17 [{"k1":"v41","k2":400},1,"a",3.14] 1.0
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] 100.0
+17 [{"k1":"v41","k2":400},1,"a",3.14] 3.14
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] 6.18
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} 1.0
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} 3.14
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null \N
+3 true true
+4 false false
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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"] true
+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 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null true
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !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} false
+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]} false
+26 {"k1":"v1","k2":200} false
+
+-- !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} false
+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]} false
+26 {"k1":"v1","k2":200} false
+
+-- !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] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+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 {"k1":"v1","k2":200} \N
+
+-- !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"] false
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} false
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} false
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} false
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} false
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} false
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !select --
+1 \N \N
+2 null true
+3 true true
+4 false true
+5 100 true
+6 10000 true
+7 1000000000 true
+8 1152921504606846976 true
+9 6.18 true
+10 "abcd" true
+11 {} true
+12 {"k1":"v31","k2":300} true
+13 [] true
+14 [123,456] true
+15 ["abc","def"] true
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] true
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} true
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} true
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} true
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} true
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} true
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] true
+15 ["abc","def"] true
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] true
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] true
+15 ["abc","def"] true
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] true
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] true
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] true
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] true
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} true
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null false
+3 true false
+4 false false
+5 100 false
+6 10000 false
+7 1000000000 false
+8 1152921504606846976 false
+9 6.18 false
+10 "abcd" false
+11 {} false
+12 {"k1":"v31","k2":300} false
+13 [] false
+14 [123,456] false
+15 ["abc","def"] false
+16 [null,true,false,100,6.18,"abc"] false
+17 [{"k1":"v41","k2":400},1,"a",3.14] false
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} false
+26 {"k1":"v1","k2":200} false
+
+-- !select --
+1 \N \N
+2 null null
+3 true bool
+4 false bool
+5 100 int
+6 10000 int
+7 1000000000 int
+8 1152921504606846976 bigint
+9 6.18 double
+10 "abcd" string
+11 {} object
+12 {"k1":"v31","k2":300} object
+13 [] array
+14 [123,456] array
+15 ["abc","def"] array
+16 [null,true,false,100,6.18,"abc"] array
+17 [{"k1":"v41","k2":400},1,"a",3.14] array
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} object
+26 {"k1":"v1","k2":200} object
+
+-- !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} string
+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]} string
+26 {"k1":"v1","k2":200} string
+
+-- !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} int
+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]} int
+26 {"k1":"v1","k2":200} int
+
+-- !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] int
+15 ["abc","def"] string
+16 [null,true,false,100,6.18,"abc"] null
+17 [{"k1":"v41","k2":400},1,"a",3.14] object
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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] int
+15 ["abc","def"] string
+16 [null,true,false,100,6.18,"abc"] bool
+17 [{"k1":"v41","k2":400},1,"a",3.14] int
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] bool
+17 [{"k1":"v41","k2":400},1,"a",3.14] string
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] int
+17 [{"k1":"v41","k2":400},1,"a",3.14] double
+18 {"k1":"v31","k2":300,"a1":[{"k1":"v41","k2":400},1,"a",3.14]} \N
+26 {"k1":"v1","k2":200} \N
+
+-- !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"] double
+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 {"k1":"v1","k2":200} \N
+
+-- !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"] string
+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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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]} array
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} object
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} int
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} string
+26 {"k1":"v1","k2":200} \N
+
+-- !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]} double
+26 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
+-- !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 {"k1":"v1","k2":200} \N
+
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
new file mode 100644
index 0000000000..871d1542dd
--- /dev/null
+++ b/regression-test/suites/jsonb_p0/test_jsonb_load_and_function.groovy
@@ -0,0 +1,311 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements. See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership. The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License. You may obtain a copy of the License at
+//
+// http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied. See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+suite("test_jsonb_load_and_function", "p0") {
+ // define a sql table
+ def testTable = "tbl_test_jsonb"
+ def dataFile = "test_jsonb.csv"
+
+ sql """ set enable_vectorized_engine = true """
+
+ sql "DROP TABLE IF EXISTS ${testTable}"
+
+ sql """
+ CREATE TABLE IF NOT EXISTS ${testTable} (
+ id INT,
+ j JSONB
+ )
+ DUPLICATE KEY(id)
+ DISTRIBUTED BY HASH(id) BUCKETS 10
+ PROPERTIES("replication_num" = "1");
+ """
+
+ // load the jsonb data from csv file
+ // fail by default for invalid data rows
+ streamLoad {
+ table testTable
+
+ file dataFile // import csv file
+ time 10000 // limit inflight 10s
+
+ // if declared a check callback, the default check condition will ignore.
+ // So you must check all condition
+ check { result, exception, startTime, endTime ->
+ if (exception != null) {
+ throw exception
+ }
+ log.info("Stream load result: ${result}".toString())
+ def json = parseJson(result)
+ assertEquals("fail", json.Status.toLowerCase())
+ assertEquals("too many filtered rows", json.Message)
+ assertEquals(25, json.NumberTotalRows)
+ assertEquals(18, json.NumberLoadedRows)
+ assertEquals(7, json.NumberFilteredRows)
+ assertTrue(json.LoadBytes > 0)
+ }
+ }
+
+ // load the jsonb data from csv file
+ // success with header 'max_filter_ratio: 0.3'
+ streamLoad {
+ table testTable
+
+ // set http request header params
+ set 'max_filter_ratio', '0.3'
+ file dataFile // import csv file
+ time 10000 // limit inflight 10s
+
+ // if declared a check callback, the default check condition will ignore.
+ // So you must check all condition
+ check { result, exception, startTime, endTime ->
+ if (exception != null) {
+ throw exception
+ }
+ log.info("Stream load result: ${result}".toString())
+ def json = parseJson(result)
+ assertEquals("success", json.Status.toLowerCase())
+ assertEquals(25, json.NumberTotalRows)
+ assertEquals(18, json.NumberLoadedRows)
+ assertEquals(7, json.NumberFilteredRows)
+ assertTrue(json.LoadBytes > 0)
+ }
+ }
+
+ // check result
+ qt_select "SELECT * FROM ${testTable} ORDER BY id"
+
+ // insert into 1 row and then check result
+ sql """INSERT INTO ${testTable} VALUES(26, '{"k1":"v1", "k2": 200}')"""
+ qt_select "SELECT * FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract
+ qt_select "SELECT id, j, jsonb_extract(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract_string
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_string(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract_int
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_int(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract_bigint
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bigint(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+
+ // jsonb_extract_double
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_double(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract_bool
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_bool(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_extract_isnull
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_extract_isnull(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_exists_path
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_exists_path(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+
+ // jsonb_type
+ qt_select "SELECT id, j, jsonb_type(j, '\$') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_type(j, '\$.k1') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.k2') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_type(j, '\$[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[5]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[6]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$[10]') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1') FROM ${testTable} ORDER BY id"
+
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[0]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[1]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[2]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[3]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[4]') FROM ${testTable} ORDER BY id"
+ qt_select "SELECT id, j, jsonb_type(j, '\$.a1[10]') FROM ${testTable} ORDER BY id"
+}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org