This is an automated email from the ASF dual-hosted git repository.
eldenmoon 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 20c4cadcbbe [Fix](Variant) fix outof range exception after calling
function element_at for variant type (#38318)
20c4cadcbbe is described below
commit 20c4cadcbbeb966c32423a01d0f8dda1e5176ac3
Author: lihangyu <[email protected]>
AuthorDate: Thu Jul 25 15:40:03 2024 +0800
[Fix](Variant) fix outof range exception after calling function element_at
for variant type (#38318)
…nt_at for variant type
src subcolumns empty but src row count may not be 0, so need to padding
rows to at least src.size() and finlize at last
```
[CANCELLED][E6] Parameter out of bound in IColumnStr<T>::insert_range_from
me !
```
---
be/src/vec/functions/function_variant_element.cpp | 10 +-
regression-test/data/variant_p0/rqg/rqg3.out | 130 ++++++++++++++++++++++
regression-test/suites/variant_p0/rqg/rqg3.sql | 43 +++++++
3 files changed, 182 insertions(+), 1 deletion(-)
diff --git a/be/src/vec/functions/function_variant_element.cpp
b/be/src/vec/functions/function_variant_element.cpp
index 84ddc3b8046..faa56ccb1e3 100644
--- a/be/src/vec/functions/function_variant_element.cpp
+++ b/be/src/vec/functions/function_variant_element.cpp
@@ -28,6 +28,7 @@
#include "common/status.h"
#include "exprs/json_functions.h"
#include "simdjson.h"
+#include "util/defer_op.h"
#include "vec/columns/column.h"
#include "vec/columns/column_nullable.h"
#include "vec/columns/column_object.h"
@@ -102,8 +103,11 @@ private:
static Status get_element_column(const ColumnObject& src, const ColumnPtr&
index_column,
ColumnPtr* result) {
std::string field_name = index_column->get_data_at(0).to_string();
+ Defer finalize([&]() { (*result)->assume_mutable()->finalize(); });
if (src.empty()) {
*result = ColumnObject::create(true);
+ // src subcolumns empty but src row count may not be 0
+ (*result)->assume_mutable()->insert_many_defaults(src.size());
return Status::OK();
}
if (src.is_scalar_variant() &&
@@ -135,8 +139,10 @@ private:
PathInData path(field_name);
ColumnObject::Subcolumns subcolumns =
mutable_ptr->get_subcolumns();
const auto* node = subcolumns.find_exact(path);
- auto result_col = ColumnObject::create(true, false /*should not
create root*/);
+ MutableColumnPtr result_col;
if (node != nullptr) {
+ // Create without root, since root will be added
+ result_col = ColumnObject::create(true, false /*should not
create root*/);
std::vector<decltype(node)> nodes;
PathsInData paths;
ColumnObject::Subcolumns::get_leaves_of_node(node, nodes,
paths);
@@ -162,6 +168,8 @@ private:
auto container =
ColumnObject::create(std::move(new_subcolumns), true);
result_col->insert_range_from(*container, 0,
container->size());
} else {
+ // Create with root, otherwise the root type maybe type Nothing
+ result_col = ColumnObject::create(true);
result_col->insert_many_defaults(src.size());
}
*result = result_col->get_ptr();
diff --git a/regression-test/data/variant_p0/rqg/rqg3.out
b/regression-test/data/variant_p0/rqg/rqg3.out
new file mode 100644
index 00000000000..d39b0e288dc
--- /dev/null
+++ b/regression-test/data/variant_p0/rqg/rqg3.out
@@ -0,0 +1,130 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !rqg3 --
+0
+
+-- !rqg3_2 --
+0
+
+-- !rqg3_3 --
+0
+
+-- !rqg3_4 --
+0
+
+-- !rqg3_5 --
+0
+
+-- !rqg3_6 --
+0
+
+-- !rqg3_7 --
+0
+
+-- !rqg3_8 --
+0
+
+-- !rqg3_9 --
+0
+
+-- !rqg3_10 --
+0
+
+-- !rqg3_11 --
+10
+
+-- !rqg3_12 --
+10
+
+-- !rqg3_13 --
+10
+
+-- !rqg3_14 --
+10
+
+-- !rqg3_15 --
+10
+
+-- !rqg3_16 --
+10
+
+-- !rqg3_17 --
+10
+
+-- !rqg3_18 --
+10
+
+-- !rqg3_19 --
+21
+
+-- !rqg3_20 --
+21
+
+-- !rqg3_21 --
+21
+
+-- !rqg3_22 --
+21
+
+-- !rqg3_23 --
+21
+
+-- !rqg3_24 --
+21
+
+-- !rqg3_25 --
+25
+
+-- !rqg3_26 --
+25
+
+-- !rqg3_27 --
+25
+
+-- !rqg3_28 --
+25
+
+-- !rqg3_29 --
+25
+
+-- !rqg3_30 --
+25
+
+-- !rqg3_31 --
+6
+
+-- !rqg3_32 --
+6
+
+-- !rqg3_33 --
+6
+
+-- !rqg3_34 --
+6
+
+-- !rqg3_35 --
+6
+
+-- !rqg3_36 --
+6
+
+-- !rqg3_37 --
+7
+
+-- !rqg3_38 --
+7
+
+-- !rqg3_39 --
+7
+
+-- !rqg3_40 --
+7
+
+-- !rqg3_41 --
+7
+
+-- !rqg3_42 --
+7
+
+-- !rqg3_43 --
+0 \N c \N \N \N
+
diff --git a/regression-test/suites/variant_p0/rqg/rqg3.sql
b/regression-test/suites/variant_p0/rqg/rqg3.sql
new file mode 100644
index 00000000000..d7fde8f1a1c
--- /dev/null
+++ b/regression-test/suites/variant_p0/rqg/rqg3.sql
@@ -0,0 +1,43 @@
+CREATE TABLE IF NOT EXISTS
table_10_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_10_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_21_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_21_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_25_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_6_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_6_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_7_undef_partitions2_keys3_properties4_distributed_by5 (
`col_int_undef_signed` int, `col_varchar_10__undef_signed` varchar(10),
`col_varchar_1024__undef_signed` varchar(1024), `pk` int, var VARIANT NULL )
engine=olap DUPLICATE KEY(`col_int_undef_signed`) distributed by
hash(`col_int_undef_signed`) buckets 10 properties("replication_num" = "1");
+CREATE TABLE IF NOT EXISTS
table_7_undef_partitions2_keys3_properties4_distributed_by5 ( pk int, var
VARIANT NULL ) engine=olap DUPLICATE KEY(pk) distributed by hash(pk) buckets 10
properties("replication_num" = "1");
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_bigint_undef_signed\": -94, \"col_varchar_10__undef_signed\":
\"had\", \"col_varchar_64__undef_signed\":
\"y\"}'),('1','{\"col_bigint_undef_signed\": 672609,
\"col_varchar_10__undef_signed\": \"k\", \"col_varchar_64__undef_signed\":
\"h\"}'),('2','{\"col_bigint_undef_signed\": -3766684,
\"col_varchar_10__undef_signed\": \"a\", \"col_varchar_64__undef_signed\":
\"p\"}'),('3','{\"col_bigint [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_bigint_undef_signed\": 111, \"col_varchar_10__undef_signed\":
\"from\", \"col_varchar_64__undef_signed\":
\"t\"}'),('1','{\"col_bigint_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"h\", \"col_varchar_64__undef_signed\":
\"out\"}'),('2','{\"col_bigint_undef_signed\": 3814,
\"col_varchar_10__undef_signed\": \"get\", \"col_varchar_64__undef_signed\":
\"q\"}'),('3','{\"col_bigint_ [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_int_undef_signed_not_null\": 9,
\"col_varchar_10__undef_signed\": \"\",
\"col_varchar_10__undef_signed_not_null\":
\"\"}'),('1','{\"col_int_undef_signed\": 8, \"col_int_undef_signed_not_null\":
6, \"col_varchar_10__undef_signed\": null,
\"col_varchar_10__undef_signed_not_null\":
\"k\"}'),('2','{\"col_int_undef_signed\": 1, \"col_int_undef_signed_not_null\":
6, [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null}'),('2','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"\"}'),('3','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"know\"}'),('4','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": null}' [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\": 8,
\"col_date_undef_signed\": \"2023-12-16\", \"col_date_undef_signed_not_null\":
\"2023-12-12\", \"col_varchar_10__undef_signed\": \"at\",
\"col_varchar_10__undef_signed_not_null\": \"one\",
\"col_varchar_1024__undef_signed\": \"r\",
\"col_varchar_1024__undef_signed_not_null\":
\"j\"}'),('1','{\"col_int_undef_signed\": 9, \"col_in [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"do\", \"col_varchar_1024__undef_signed\":
\"but\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"c\", \"col_varchar_1024__undef_signed\":
\"would\"}'),('2','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"x\"}'),('3','{\"col_int_undef_si [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"out\", \"col_varchar_1024__undef_signed\":
\"ok\"}'),('1','{\"col_int_undef_signed\": 5, \"col_varchar_10__undef_signed\":
\"see\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"b\", \"col_varchar_1024__undef_signed\":
\"s\"}'),('3','{\"col_int_undef_sign [...]
+INSERT INTO
table_10_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"q\",
\"col_varchar_1024__undef_signed\":
\"like\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"j\", \"col_varchar_1024__undef_signed\":
\"n\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"a\"}'),('3','{\"col_int_undef_sig [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\": \"it\",
\"col_varchar_1024__undef_signed\": \"oh\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"then\",
\"col_varchar_1024__undef_signed\": \"x\"}'),('2','{\"col_int_undef_signed\":
0, \"col_varchar_10__undef_signed\": \"didn\'t\",
\"col_varchar_1024__undef_signed\": \"her\"}'),('3','{\"col_int_undef [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\": \"why\",
\"col_varchar_1024__undef_signed\": \"t\"}'),('1','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"from\"}'),('2','{\"col_int_undef_signed\": 3,
\"col_varchar_10__undef_signed\": \"s\", \"col_varchar_1024__undef_signed\":
\"v\"}'),('3','{\"col_int_undef_signed\": [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 9, \"col_varchar_10__undef_signed\":
\"j\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"p\"}'),('2','{\"col_int_undef_signed\": 4,
\"col_varchar_10__undef_signed\": \"was\"}'),('3','{\"col_int_undef_signed\":
9, \"col_varchar_10__undef_signed\": \"a\"}'),('4','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"\"}'),(' [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 5,
\"col_date_undef_signed\": \"2023-12-19\", \"col_date_undef_signed_not_null\":
\"2023-12-16\", \"col_varchar_10__undef_signed\": \"okay\",
\"col_varchar_10__undef_signed_not_null\": \"know\",
\"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"y\"}'),('1','{\"col_int_undef_signed\": 5, \" [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 8,
\"col_varchar_10__undef_signed\": null,
\"col_varchar_10__undef_signed_not_null\":
\"mean\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_varchar_10__undef_signed\": \"is\",
\"col_varchar_10__undef_signed_not_null\":
\"l\"}'),('2','{\"col_int_undef_signed\": null, \"col_int_undef_signed [...]
+INSERT INTO
table_21_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"good\", \"col_varchar_1024__undef_signed\":
\"y\"}'),('1','{\"col_int_undef_signed\": 3, \"col_varchar_10__undef_signed\":
\"f\", \"col_varchar_1024__undef_signed\":
\"it\"}'),('2','{\"col_int_undef_signed\": 4, \"col_varchar_10__undef_signed\":
\"d\", \"col_varchar_1024__undef_signed\":
\"l\"}'),('3','{\"col_int_undef_signed\" [...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 2, \"col_int_undef_signed_not_null\": 4,
\"col_varchar_10__undef_signed\": \"I\'m\",
\"col_varchar_10__undef_signed_not_null\":
\"\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 8, \"col_varchar_10__undef_signed\": \"\",
\"col_varchar_10__undef_signed_not_null\":
\"w\"}'),('2','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_
[...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_int_undef_signed_not_null\": 5,
\"col_date_undef_signed\": \"2023-12-18\", \"col_date_undef_signed_not_null\":
\"2023-12-11\", \"col_varchar_10__undef_signed\": \"v\",
\"col_varchar_10__undef_signed_not_null\": \"r\",
\"col_varchar_1024__undef_signed\": \"want\",
\"col_varchar_1024__undef_signed_not_null\":
\"do\"}'),('1','{\"col_int_undef_signed\": null, \"co [...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\": \"k\",
\"col_varchar_1024__undef_signed\": \"v\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"okay\",
\"col_varchar_1024__undef_signed\": \"e\"}'),('2','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"and\",
\"col_varchar_1024__undef_signed\": \"g\"}'),('3','{\"col_int_undef_sign [...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_1024__undef_signed\": \"s\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"yes\",
\"col_varchar_1024__undef_signed\": \"can\"}'),('2','{\"col_int_undef_signed\":
2, \"col_varchar_10__undef_signed\": \"y\", \"col_varchar_1024__undef_signed\":
\"m\"}'),('3','{\"col_int_undef_signe [...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"for\", \"col_varchar_1024__undef_signed\":
\"can\'t\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"know\", \"col_varchar_1024__undef_signed\":
\"well\"}'),('2','{\"col_int_undef_signed\": 0,
\"col_varchar_10__undef_signed\": \"up\", \"col_varchar_1024__undef_signed\":
\"v\"}'),('3','{\"col_int_u [...]
+INSERT INTO
table_25_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"y\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"tell\"}'),('2','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"because\"}'),('3','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"\"}'),('4','{\"col_int_undef_signed\": 2,
\"col_varchar_10__undef_signed\" [...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"something\", \"col_varchar_1024__undef_signed\":
\"f\"}'),('1','{\"col_int_undef_signed\": 0, \"col_varchar_10__undef_signed\":
\"really\", \"col_varchar_1024__undef_signed\":
\"g\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"h\", \"col_varchar_1024__undef_signed\":
\"of\"}'),('3','{\"col_int_undef [...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 5, \"col_int_undef_signed_not_null\": 7,
\"col_varchar_10__undef_signed\": \"k\",
\"col_varchar_10__undef_signed_not_null\":
\"\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 7, \"col_varchar_10__undef_signed\":
\"how\", \"col_varchar_10__undef_signed_not_null\":
\"\"}'),('2','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_not_null\
[...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 0,
\"col_date_undef_signed\": \"2023-12-11\", \"col_date_undef_signed_not_null\":
\"2023-12-13\", \"col_varchar_10__undef_signed\": \"who\",
\"col_varchar_10__undef_signed_not_null\": \"back\",
\"col_varchar_1024__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed_not_null\":
\"j\"}'),('1','{\"col_int_undef_signed\": 9, \"co [...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"could\", \"col_varchar_1024__undef_signed\":
\"want\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"r\", \"col_varchar_1024__undef_signed\":
\"mean\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"will\", \"col_varchar_1024__undef_signed\":
\"your\"}'),('3','{\"col_i [...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"think\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"\"}'),('2','{\"col_int_undef_signed\": 2,
\"col_varchar_10__undef_signed\": \"\"}'),('3','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"r\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null} [...]
+INSERT INTO
table_6_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"this\", \"col_varchar_1024__undef_signed\":
\"think\"}'),('1','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"l\", \"col_varchar_1024__undef_signed\":
\"as\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"how\", \"col_varchar_1024__undef_signed\":
\"o\"}'),('3','{\"col_int_und [...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 1, \"col_int_undef_signed_not_null\": 1,
\"col_date_undef_signed\": \"2023-12-12\", \"col_date_undef_signed_not_null\":
\"2023-12-18\", \"col_varchar_10__undef_signed\": \"c\",
\"col_varchar_10__undef_signed_not_null\": \"d\",
\"col_varchar_1024__undef_signed\": \"d\",
\"col_varchar_1024__undef_signed_not_null\":
\"f\"}'),('1','{\"col_int_undef_signed\": null, \"col_int [...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\": \"y\",
\"col_varchar_1024__undef_signed\": \"g\"}'),('1','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\": \"t\",
\"col_varchar_1024__undef_signed\": \"can\"}'),('2','{\"col_int_undef_signed\":
8, \"col_varchar_10__undef_signed\": \"would\",
\"col_varchar_1024__undef_signed\": \"l\"}'),('3','{\"col_int_undef_signed\
[...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": 8, \"col_varchar_10__undef_signed\": \"w\",
\"col_varchar_1024__undef_signed\": \"a\"}'),('1','{\"col_int_undef_signed\":
8, \"col_varchar_10__undef_signed\": \"k\", \"col_varchar_1024__undef_signed\":
\"c\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"her\", \"col_varchar_1024__undef_signed\":
\"come\"}'),('3','{\"col_int_undef_signed\" [...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_int_undef_signed_not_null\": 0,
\"col_varchar_10__undef_signed\": \"didn\'t\",
\"col_varchar_10__undef_signed_not_null\":
\"d\"}'),('1','{\"col_int_undef_signed\": null,
\"col_int_undef_signed_not_null\": 1, \"col_varchar_10__undef_signed\": null,
\"col_varchar_10__undef_signed_not_null\":
\"\"}'),('2','{\"col_int_undef_signed\": 9, \"col_int_undef_signed_no [...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"q\"}'),('1','{\"col_int_undef_signed\": 7, \"col_varchar_10__undef_signed\":
\"k\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": null}'),('3','{\"col_int_undef_signed\":
null, \"col_varchar_10__undef_signed\":
\"\"}'),('4','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"\"}'),( [...]
+INSERT INTO
table_7_undef_partitions2_keys3_properties4_distributed_by5(pk,var) VALUES
('0','{\"col_int_undef_signed\": null, \"col_varchar_10__undef_signed\":
\"this\", \"col_varchar_1024__undef_signed\":
\"who\"}'),('1','{\"col_int_undef_signed\": 1,
\"col_varchar_10__undef_signed\": \"x\", \"col_varchar_1024__undef_signed\":
\"you\"}'),('2','{\"col_int_undef_signed\": null,
\"col_varchar_10__undef_signed\": \"didn\'t\",
\"col_varchar_1024__undef_signed\": \"this\"}'),('3','{\"col_int_ [...]
+SELECT t1.pk AS pk1, CAST(t1 . var['col_int_undef_signed'] AS int) AS col1,
CAST(t1 . var['col_varchar_10__undef_signed'] AS varchar(10)) AS col2, t2.pk
AS pk1, CAST(t2 . var['col_int_undef_signed'] AS int) AS col3, CAST(t2 .
var['col_varchar_10__undef_signed'] AS varchar(10)) AS col4 FROM
table_25_undef_partitions2_keys3_properties4_distributed_by5 AS t1 LEFT OUTER
JOIN table_21_undef_partitions2_keys3_properties4_distributed_by5 AS t2 ON t2 .
pk < 0 AND t2 . pk = 8 INNER JOIN [...]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
