This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new c81adb0cce5 branch-4.0: [fix](array-union) Update ArrayUnion for
behavior #56443 (#56613)
c81adb0cce5 is described below
commit c81adb0cce58b2c21d07398737d7f2835ea0b32c
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Sep 29 11:16:23 2025 +0800
branch-4.0: [fix](array-union) Update ArrayUnion for behavior #56443
(#56613)
Cherry-picked from #56443
Co-authored-by: amory <[email protected]>
---
be/src/vec/functions/array/function_array_nary.h | 2 +-
.../sql_functions/array_functions/sql/q04.out | 115 ++++++++++++++++++
.../sql_functions/array_functions/sql/q04.sql | 128 +++++++++++++++++++++
3 files changed, 244 insertions(+), 1 deletion(-)
diff --git a/be/src/vec/functions/array/function_array_nary.h
b/be/src/vec/functions/array/function_array_nary.h
index 042e87eabb6..71ad1e1a87c 100644
--- a/be/src/vec/functions/array/function_array_nary.h
+++ b/be/src/vec/functions/array/function_array_nary.h
@@ -51,7 +51,7 @@ public:
assert_cast<const
DataTypeArray&>(*(remove_nullable(arguments[i])))
.get_nested_type());
// do check array nested data type, now we just support same
nested data type
- CHECK(nested_type->equals(*right_nested_type))
+ CHECK(nested_type->equals_ignore_precision(*right_nested_type))
<< "data type " << arguments[i]->get_name() << " not equal
with "
<< arguments[0]->get_name();
}
diff --git
a/regression-test/data/nereids_p0/sql_functions/array_functions/sql/q04.out
b/regression-test/data/nereids_p0/sql_functions/array_functions/sql/q04.out
new file mode 100644
index 00000000000..bb227803c74
--- /dev/null
+++ b/regression-test/data/nereids_p0/sql_functions/array_functions/sql/q04.out
@@ -0,0 +1,115 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !q04 --
+0
+
+-- !q04_2 --
+46
+
+-- !q04_3 --
+46
+
+-- !q04_4 --
+8
+
+-- !q04_5 --
+[{"col1":0, "col2":"2005-10-27 08:50:36.000000", "col3":40.123},
{"col1":7781130171397164183, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":-2503439427251591834, "col2":"2023-01-15
08:32:59.000000", "col3":300.343}, {"col1":-2124648, "col2":"2016-08-26
00:00:00.000000", "col3":40.123}, {"col1":32679, "col2":"2014-06-05
21:33:55.000000", "col3":47.73442}, {"col1":0, "col2":"2016-01-19
23:06:47.000000", "col3":25.52237}, {"col1":-8175610, "col2":"2013-09-19
21:51:02.000000", [...]
+[{"col1":-1595604180, "col2":"2024-08-03 13:08:30.000000", "col3":67.35693},
{"col1":-9223372036854775808, "col2":"2002-10-25 05:35:24.000000",
"col3":100.02}, {"col1":9223372036854775807, "col2":"2011-07-11
07:13:22.000000", "col3":40.123}, {"col1":6615424, "col2":"2024-06-30
12:01:02.000000", "col3":300.343}, {"col1":2038567011, "col2":"9999-12-31
00:00:00.000000", "col3":40.123}, {"col1":7213331012602341619,
"col2":"2024-06-30 12:01:02.000000", "col3":85.81667}, {"col1":147483648, "co
[...]
+[{"col1":7834816776402847276, "col2":"2016-01-15 00:00:00.000000",
"col3":100.02}, {"col1":-9223372036854775808, "col2":"9999-12-31
00:00:00.000000", "col3":300.343}, {"col1":9223372036854775807,
"col2":"2009-09-15 00:00:00.000000", "col3":76.0097},
{"col1":4288426160485546636, "col2":"2008-09-15 00:00:00.000000",
"col3":40.123}, {"col1":909490161141143825, "col2":"2014-11-24
13:21:14.000000", "col3":40.123}, {"col1":1, "col2":"2023-01-15
08:32:59.000000", "col3":76.48198}, {"col1":1, "c [...]
+[{"col1":-1660557639, "col2":"2013-10-04 07:58:49.000000", "col3":53.25555},
{"col1":-6551050258462995373, "col2":"2024-06-30 12:01:02.000000",
"col3":100.02}, {"col1":3918860117122531357, "col2":"2023-01-15
08:32:59.000000", "col3":75.97913}, {"col1":6379084380923195541,
"col2":"2007-06-06 16:42:54.000000", "col3":54.40132}, {"col1":-5168354,
"col2":"2024-06-30 12:01:02.000000", "col3":100.02},
{"col1":9223372036854775807, "col2":"2009-02-07 00:00:00.000000",
"col3":41.53735}, {"col1":- [...]
+[{"col1":9223372036854775807, "col2":"9999-12-31 00:00:00.000000",
"col3":70.86533}, {"col1":245, "col2":"9999-12-31 23:59:59.000000",
"col3":300.343}, {"col1":1, "col2":"2015-03-10 00:00:00.000000",
"col3":72.49912}, {"col1":-9223372036854775808, "col2":"2008-03-20
00:00:00.000000", "col3":68.41246}, {"col1":245, "col2":"2024-08-03
13:08:30.000000", "col3":8.116032}, {"col1":-7027296746212339778,
"col2":"2015-08-14 21:03:13.000000", "col3":55.1092}, {"col1":1,
"col2":"9999-12-31 00:00:0 [...]
+[{"col1":-291582690122224237, "col2":"2024-07-01 00:00:00.000000",
"col3":40.123}, {"col1":-7794788469030242368, "col2":"2024-07-01
00:00:00.000000", "col3":25.35414}, {"col1":147483648, "col2":"2009-12-14
00:00:00.000000", "col3":90.19814}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":1,
"col2":"2009-06-04 00:00:00.000000", "col3":100.02},
{"col1":5100121954013998443, "col2":"2014-08-12 00:00:00.000000",
"col3":94.3192}, {"col1":-86622452176 [...]
+[{"col1":-9223372036854775808, "col2":"2014-08-12 00:00:00.000000",
"col3":300.343}, {"col1":-1719844, "col2":"2024-07-01 00:00:00.000000",
"col3":100.02}, {"col1":32679, "col2":"2014-08-12 00:00:00.000000",
"col3":300.343}, {"col1":0, "col2":"2014-08-23 00:00:00.000000",
"col3":40.123}, {"col1":147483648, "col2":"2023-01-15 08:32:59.000000",
"col3":93.65681}, {"col1":-9223372036854775808, "col2":"2004-10-16
04:52:22.000000", "col3":43.15916}, {"col1":-9223372036854775808,
"col2":"2024-0 [...]
+[{"col1":1685956128896459469, "col2":"2024-08-03 13:08:30.000000",
"col3":52.53688}, {"col1":7793081368349639613, "col2":"2023-01-15
08:32:59.000000", "col3":100.02}, {"col1":3531667257661460206,
"col2":"2024-06-30 12:01:02.000000", "col3":40.07779},
{"col1":7874414725760916357, "col2":"2024-08-03 13:08:30.000000",
"col3":0.6340275}, {"col1":-5551761, "col2":"9999-12-31 00:00:00.000000",
"col3":300.343}, {"col1":5124640477435937389, "col2":"2010-12-07
03:35:52.000000", "col3":40.123}, {" [...]
+[{"col1":8476298356050368528, "col2":"2003-04-19 23:36:38.000000",
"col3":29.26468}, {"col1":245, "col2":"2023-01-15 08:32:59.000000",
"col3":300.343}, {"col1":-7872528218172459183, "col2":"2014-08-12
00:00:00.000000", "col3":100.02}, {"col1":245, "col2":"2024-08-03
13:08:30.000000", "col3":60.52922}, {"col1":147483648, "col2":"2003-11-18
00:00:00.000000", "col3":17.01382}, {"col1":-7395576895594436115,
"col2":"2024-07-01 00:00:00.000000", "col3":45.61228}, {"col1":-1798503762,
"col2":"2 [...]
+[{"col1":-6879743115985662081, "col2":"2014-08-12 00:00:00.000000",
"col3":100.02}, {"col1":245, "col2":"9999-12-31 00:00:00.000000",
"col3":300.343}, {"col1":32679, "col2":"2024-08-03 13:08:30.000000",
"col3":2.07401}, {"col1":32679, "col2":"2023-01-15 08:32:59.000000",
"col3":33.07206}, {"col1":245, "col2":"2004-12-18 16:01:22.000000",
"col3":300.343}, {"col1":1802241, "col2":"2024-08-03 13:08:30.000000",
"col3":93.4528}, {"col1":147483648, "col2":"2016-02-01 00:00:00.000000",
"col3":4 [...]
+[{"col1":-4349336, "col2":"9999-12-31 23:59:59.000000", "col3":300.343},
{"col1":32679, "col2":"2015-04-04 00:00:00.000000", "col3":88.32224},
{"col1":245, "col2":"2004-08-04 00:00:00.000000", "col3":89.99874},
{"col1":147483648, "col2":"2014-08-12 00:00:00.000000", "col3":88.34442},
{"col1":147483648, "col2":"2015-12-07 12:07:54.000000", "col3":100.7104},
{"col1":9223372036854775807, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":32679, "col2":"2024-08-03 13:08:30.000000", [...]
+[{"col1":-6627460165664162739, "col2":"9999-12-31 00:00:00.000000",
"col3":300.343}, {"col1":8073612, "col2":"2014-08-12 00:00:00.000000",
"col3":300.343}, {"col1":-2402372999039318912, "col2":"2001-02-27
00:00:00.000000", "col3":76.67532}, {"col1":5484417194401458139,
"col2":"2024-06-30 12:01:02.000000", "col3":40.19484},
{"col1":9223372036854775807, "col2":"2017-10-26 00:00:00.000000",
"col3":300.343}, {"col1":-9223372036854775808, "col2":"2024-08-03
13:08:30.000000", "col3":50.86631}, [...]
+[{"col1":1276346546, "col2":"2014-08-12 00:00:00.000000", "col3":300.343},
{"col1":-1706709, "col2":"9999-12-31 00:00:00.000000", "col3":86.13071},
{"col1":5892347, "col2":"2023-01-15 08:32:59.000000", "col3":100.02},
{"col1":-5056783290518716323, "col2":"2011-09-14 00:00:00.000000",
"col3":100.02}, {"col1":0, "col2":"2003-05-08 00:00:00.000000",
"col3":56.52518}, {"col1":123708688, "col2":"2024-08-03 13:08:30.000000",
"col3":23.85541}, {"col1":245, "col2":"2005-10-14 00:00:00.000000", " [...]
+[{"col1":-4660939327461715459, "col2":"2024-07-01 00:00:00.000000",
"col3":20.81306}, {"col1":32679, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":-9223372036854775808, "col2":"2024-07-01
00:00:00.000000", "col3":37.6587}, {"col1":0, "col2":"2024-08-03
13:08:30.000000", "col3":100.02}, {"col1":9223372036854775807,
"col2":"2004-04-16 00:00:00.000000", "col3":29.23627}, {"col1":245,
"col2":"2012-07-01 00:00:00.000000", "col3":40.123}, {"col1":-1956607765,
"col2":"9999-12-31 [...]
+[{"col1":-9223372036854775808, "col2":"9999-12-31 00:00:00.000000",
"col3":100.02}, {"col1":-9223372036854775808, "col2":"2001-01-07
09:16:37.000000", "col3":71.56235}, {"col1":3322776632403075217,
"col2":"2009-06-13 00:00:00.000000", "col3":9.742453}, {"col1":92854860,
"col2":"2024-07-01 00:00:00.000000", "col3":40.123}, {"col1":-921439,
"col2":"2004-04-23 04:03:54.000000", "col3":7.286445},
{"col1":-9223372036854775808, "col2":"2023-01-15 08:32:59.000000",
"col3":300.343}, {"col1":-503 [...]
+[{"col1":0, "col2":"9999-12-31 23:59:59.000000", "col3":52.98089},
{"col1":32679, "col2":"2018-08-17 10:15:20.000000", "col3":50.76899},
{"col1":-933904, "col2":"2012-06-22 15:10:34.000000", "col3":2.254311},
{"col1":-9223372036854775808, "col2":"2024-08-03 13:08:30.000000",
"col3":14.66545}, {"col1":1, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":-3856819516830271692, "col2":"2015-10-24
00:00:00.000000", "col3":40.123}, {"col1":1, "col2":"2014-08-12
00:00:00.000000", "co [...]
+[{"col1":-7002826391329678, "col2":"2024-06-30 12:01:02.000000",
"col3":78.28637}, {"col1":245, "col2":"2014-08-12 00:00:00.000000",
"col3":100.02}, {"col1":8771934701859972163, "col2":"2023-01-15
08:32:59.000000", "col3":300.343}, {"col1":-4802980236776923373,
"col2":"2014-08-12 00:00:00.000000", "col3":6.217669},
{"col1":5334571509830514127, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":0, "col2":"2024-07-01 00:00:00.000000",
"col3":300.343}, {"col1":2305826, "col2":"202 [...]
+[{"col1":2311869, "col2":"9999-12-31 23:59:59.000000", "col3":300.343},
{"col1":0, "col2":"2017-07-05 00:00:00.000000", "col3":300.343},
{"col1":-1261081179, "col2":"9999-12-31 23:59:59.000000", "col3":9.442795},
{"col1":-9223372036854775808, "col2":"2019-10-27 00:00:00.000000",
"col3":58.98088}, {"col1":-9223372036854775808, "col2":"2024-07-01
00:00:00.000000", "col3":59.45621}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59.000000", "col3":300.343}, {"col1":92233720368547758
[...]
+[{"col1":32679, "col2":"2023-01-15 08:32:59.000000", "col3":0.1658373},
{"col1":-1405916958, "col2":"2024-08-03 13:08:30.000000", "col3":53.25177},
{"col1":-6907313394582335259, "col2":"2023-01-15 08:32:59.000000",
"col3":100.02}, {"col1":147483648, "col2":"9999-12-31 00:00:00.000000",
"col3":87.63569}, {"col1":1078144224162071745, "col2":"2012-10-15
00:00:00.000000", "col3":300.343}, {"col1":147483648, "col2":"9999-12-31
00:00:00.000000", "col3":11.40319}, {"col1":689239, "col2":"2024-0 [...]
+[{"col1":9223372036854775807, "col2":"9999-12-31 00:00:00.000000",
"col3":3.614839}, {"col1":9223372036854775807, "col2":"2014-08-12
00:00:00.000000", "col3":100.02}, {"col1":9223372036854775807,
"col2":"2006-10-21 00:00:00.000000", "col3":56.98264}, {"col1":32679,
"col2":"2014-08-12 00:00:00.000000", "col3":300.343}, {"col1":1,
"col2":"9999-12-31 00:00:00.000000", "col3":100.02},
{"col1":-7228684911800236895, "col2":"2012-08-24 00:00:00.000000",
"col3":80.63489}, {"col1":-92233720368547 [...]
+[{"col1":-9223372036854775808, "col2":"2009-08-19 00:00:00.000000",
"col3":40.123}, {"col1":-7069904862691878360, "col2":"2003-06-11
06:27:48.000000", "col3":300.343}, {"col1":1952685100, "col2":"2024-08-03
13:08:30.000000", "col3":40.123}, {"col1":245, "col2":"2023-01-15
08:32:59.000000", "col3":100.02}, {"col1":-9223372036854775808,
"col2":"2024-06-30 12:01:02.000000", "col3":41.22036},
{"col1":-6849393376322923901, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":1, "col2" [...]
+[{"col1":0, "col2":"2024-08-03 13:08:30.000000", "col3":86.25024},
{"col1":245, "col2":"9999-12-31 00:00:00.000000", "col3":88.46123},
{"col1":6672239643354961251, "col2":"2024-08-03 13:08:30.000000",
"col3":88.91956}, {"col1":245, "col2":"2024-07-01 00:00:00.000000",
"col3":89.56328}, {"col1":6568799233875883066, "col2":"2014-08-12
00:00:00.000000", "col3":100.02}, {"col1":-6651366764729044439,
"col2":"2012-06-06 05:43:49.000000", "col3":40.123}, {"col1":0,
"col2":"2018-04-17 00:00:00.0 [...]
+[{"col1":1, "col2":"2007-12-16 21:58:03.000000", "col3":52.82284}, {"col1":0,
"col2":"2024-07-01 00:00:00.000000", "col3":100.02}, {"col1":147483648,
"col2":"2024-07-01 00:00:00.000000", "col3":82.08601}, {"col1":0,
"col2":"9999-12-31 00:00:00.000000", "col3":40.123}, {"col1":147483648,
"col2":"2014-08-12 00:00:00.000000", "col3":97.58604}, {"col1":147483648,
"col2":"2024-06-30 12:01:02.000000", "col3":50.5893}, {"col1":1455484367,
"col2":"9999-12-31 00:00:00.000000", "col3":300.343}, {" [...]
+[{"col1":-9223372036854775808, "col2":"2023-01-15 08:32:59.000000",
"col3":300.343}, {"col1":147483648, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":-326512117, "col2":"2001-09-24 11:02:50.000000",
"col3":300.343}, {"col1":1, "col2":"2024-07-01 00:00:00.000000",
"col3":62.86046}, {"col1":147483648, "col2":"9999-12-31 00:00:00.000000",
"col3":35.5274}, {"col1":7096961603049650339, "col2":"9999-12-31
23:59:59.000000", "col3":40.123}, {"col1":32679, "col2":"2017-01-05 00:00: [...]
+[{"col1":-1625551448, "col2":"2023-01-15 08:32:59.000000", "col3":300.343},
{"col1":3995145186957833925, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":-9223372036854775808, "col2":"2024-06-30
12:01:02.000000", "col3":16.55132}, {"col1":-1366680, "col2":"2013-09-03
12:56:04.000000", "col3":4.545856}, {"col1":3585652657506436443,
"col2":"2024-06-30 12:01:02.000000", "col3":100.02}, {"col1":0,
"col2":"9999-12-31 00:00:00.000000", "col3":40.123}, {"col1":0,
"col2":"9999-12-31 [...]
+[{"col1":245, "col2":"9999-12-31 00:00:00.000000", "col3":78.74184},
{"col1":147483648, "col2":"9999-12-31 23:59:59.000000", "col3":40.123},
{"col1":7831150821511923024, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":32679, "col2":"2017-06-14 00:00:17.000000",
"col3":61.85044}, {"col1":-528010017, "col2":"9999-12-31 23:59:59.000000",
"col3":79.08855}, {"col1":0, "col2":"2024-06-30 12:01:02.000000",
"col3":67.61272}, {"col1":9223372036854775807, "col2":"9999-12-31 00:00:00.0
[...]
+[{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":56.95077},
{"col1":-9223372036854775808, "col2":"2000-01-04 00:00:00.000000",
"col3":100.02}, {"col1":2515704734744050779, "col2":"2007-11-21
00:00:00.000000", "col3":300.343}, {"col1":-3185985422970303920,
"col2":"2024-06-30 12:01:02.000000", "col3":100.02}, {"col1":32679,
"col2":"9999-12-31 23:59:59.000000", "col3":59.36998},
{"col1":9223372036854775807, "col2":"2018-08-24 11:32:59.000000",
"col3":63.51496}, {"col1":1, "col2": [...]
+[{"col1":32679, "col2":"2006-03-01 10:48:58.000000", "col3":300.343},
{"col1":4791272, "col2":"2024-08-03 13:08:30.000000", "col3":40.123},
{"col1":-9223372036854775808, "col2":"2005-07-05 14:21:01.000000",
"col3":300.343}, {"col1":2960098, "col2":"2014-08-12 00:00:00.000000",
"col3":35.60499}, {"col1":32679, "col2":"2023-01-15 08:32:59.000000",
"col3":96.66632}, {"col1":6329582, "col2":"2007-08-04 16:34:28.000000",
"col3":100.02}, {"col1":245, "col2":"2014-08-12 00:00:00.000000", "col3" [...]
+[{"col1":-9223372036854775808, "col2":"2006-05-21 00:00:00.000000",
"col3":300.343}, {"col1":1489929271268213888, "col2":"2024-07-01
00:00:00.000000", "col3":36.34687}, {"col1":9223372036854775807,
"col2":"2014-08-12 00:00:00.000000", "col3":24.50964}, {"col1":-86551474,
"col2":"9999-12-31 00:00:00.000000", "col3":15.05111}, {"col1":-7367725,
"col2":"9999-12-31 23:59:59.000000", "col3":40.123}, {"col1":1,
"col2":"2024-07-01 00:00:00.000000", "col3":40.123}, {"col1":-893630281,
"col2":"20 [...]
+[{"col1":4739871129515100802, "col2":"2011-07-05 04:36:38.000000",
"col3":64.84802}, {"col1":245, "col2":"9999-12-31 00:00:00.000000",
"col3":92.79067}, {"col1":-9223372036854775808, "col2":"2024-07-01
00:00:00.000000", "col3":83.07674}, {"col1":-9223372036854775808,
"col2":"9999-12-31 23:59:59.000000", "col3":85.16518},
{"col1":439292925106633527, "col2":"2014-08-12 00:00:00.000000",
"col3":18.52916}, {"col1":245, "col2":"2010-05-17 00:00:00.000000",
"col3":68.7772}, {"col1":32679, "col [...]
+[{"col1":1, "col2":"2023-01-15 08:32:59.000000", "col3":300.343},
{"col1":5949451654247653378, "col2":"2018-11-14 14:16:09.000000",
"col3":27.96915}, {"col1":32679, "col2":"2024-06-30 12:01:02.000000",
"col3":300.343}, {"col1":-6748411, "col2":"2011-07-20 00:00:00.000000",
"col3":85.72122}, {"col1":-1163289, "col2":"2014-06-06 00:00:00.000000",
"col3":40.123}, {"col1":2450473, "col2":"2024-07-01 00:00:00.000000",
"col3":10.16615}, {"col1":8999219121030028466, "col2":"2011-01-22 00:00:00.
[...]
+[{"col1":1, "col2":"2019-07-18 00:00:00.000000", "col3":8.75857},
{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":2.23899},
{"col1":32679, "col2":"9999-12-31 23:59:59.000000", "col3":99.60713},
{"col1":147483648, "col2":"2024-08-03 13:08:30.000000", "col3":59.99109},
{"col1":1, "col2":"2012-12-11 02:39:26.000000", "col3":5.735258},
{"col1":-7902030258626272081, "col2":"2011-12-03 00:00:00.000000",
"col3":72.65997}, {"col1":720513665, "col2":"2023-01-15 08:32:59.000000",
"col3" [...]
+[{"col1":9223372036854775807, "col2":"2014-08-12 00:00:00.000000",
"col3":88.9054}, {"col1":-276412109254103572, "col2":"2024-06-30
12:01:02.000000", "col3":40.123}, {"col1":-9223372036854775808,
"col2":"2003-12-22 00:00:00.000000", "col3":37.15853},
{"col1":-3569676148310583986, "col2":"2024-07-01 00:00:00.000000",
"col3":23.78745}, {"col1":1, "col2":"2009-07-14 09:52:32.000000",
"col3":5.473039}, {"col1":-1307447387280451809, "col2":"2013-06-14
00:00:00.000000", "col3":16.53926}, {"col [...]
+[{"col1":147483648, "col2":"2009-08-22 13:01:24.000000", "col3":7.624625},
{"col1":32679, "col2":"2024-06-30 12:01:02.000000", "col3":100.02},
{"col1":-4382547536625816359, "col2":"2023-01-15 08:32:59.000000",
"col3":40.123}, {"col1":-1793835076, "col2":"2000-04-07 00:00:00.000000",
"col3":25.98565}, {"col1":-9223372036854775808, "col2":"2014-08-12
00:00:00.000000", "col3":40.123}, {"col1":-3598724, "col2":"2018-06-09
00:00:00.000000", "col3":97.70689}, {"col1":32679, "col2":"2010-05-17 [...]
+[{"col1":0, "col2":"2023-01-15 08:32:59.000000", "col3":100.02}, {"col1":245,
"col2":"2023-01-15 08:32:59.000000", "col3":16.53879}, {"col1":1,
"col2":"2014-08-12 00:00:00.000000", "col3":76.20891}, {"col1":245,
"col2":"2008-03-12 21:31:37.000000", "col3":40.123}, {"col1":1,
"col2":"2024-07-01 00:00:00.000000", "col3":27.10388}, {"col1":32679,
"col2":"9999-12-31 23:59:59.000000", "col3":40.123}, {"col1":245,
"col2":"2014-08-12 00:00:00.000000", "col3":300.343}, {"col1":1,
"col2":"9999-12 [...]
+[{"col1":147483648, "col2":"2023-01-15 08:32:59.000000", "col3":40.123},
{"col1":0, "col2":"9999-12-31 23:59:59.000000", "col3":69.63186},
{"col1":32679, "col2":"2011-06-16 19:38:44.000000", "col3":29.60791},
{"col1":-39450663, "col2":"2005-11-18 00:00:00.000000", "col3":40.123},
{"col1":4294702821621128611, "col2":"2012-04-02 02:07:56.000000",
"col3":40.123}, {"col1":147483648, "col2":"2011-11-17 00:00:00.000000",
"col3":19.60731}, {"col1":0, "col2":"9999-12-31 23:59:59.000000", "col3": [...]
+[{"col1":-2125857012597099957, "col2":"2003-10-23 13:58:30.000000",
"col3":24.79307}, {"col1":241492481, "col2":"9999-12-31 23:59:59.000000",
"col3":93.02438}, {"col1":-3187122414054569422, "col2":"2023-01-15
08:32:59.000000", "col3":48.57945}, {"col1":1, "col2":"2003-01-12
00:00:00.000000", "col3":100.02}, {"col1":9223372036854775807,
"col2":"2019-07-14 05:15:18.000000", "col3":72.80141},
{"col1":5158557407380401474, "col2":"2014-08-12 00:00:00.000000",
"col3":40.123}, {"col1":1, "col2" [...]
+[{"col1":1, "col2":"2002-01-07 00:00:00.000000", "col3":100.02},
{"col1":-3701766, "col2":"9999-12-31 00:00:00.000000", "col3":40.123},
{"col1":1, "col2":"2001-07-10 00:05:21.000000", "col3":86.28424}, {"col1":1,
"col2":"2024-08-03 13:08:30.000000", "col3":300.343},
{"col1":-766627413716089346, "col2":"2011-05-09 04:19:11.000000",
"col3":37.05988}, {"col1":-1561930774, "col2":"9999-12-31 23:59:59.000000",
"col3":26.64327}, {"col1":-3579384282182607492, "col2":"2010-06-01
09:26:49.000000" [...]
+[{"col1":245, "col2":"2004-11-08 00:00:00.000000", "col3":27.89622},
{"col1":0, "col2":"2000-01-06 08:46:04.000000", "col3":6.72724},
{"col1":-627548234020206471, "col2":"2007-02-06 00:00:00.000000",
"col3":50.5831}, {"col1":7259547921178257690, "col2":"9999-12-31
23:59:59.000000", "col3":60.72728}, {"col1":6787292694663255513,
"col2":"2024-06-30 12:01:02.000000", "col3":100.02},
{"col1":-9223372036854775808, "col2":"2023-01-15 08:32:59.000000",
"col3":41.28314}, {"col1":32679, "col2":"2 [...]
+[{"col1":-288211638, "col2":"9999-12-31 23:59:59.000000", "col3":100.02},
{"col1":-4849223988904645465, "col2":"2024-08-03 13:08:30.000000",
"col3":300.343}, {"col1":-5534154, "col2":"9999-12-31 00:00:00.000000",
"col3":95.51274}, {"col1":245, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":-2177806753693996546, "col2":"2010-07-02
00:00:00.000000", "col3":100.02}, {"col1":-9223372036854775808,
"col2":"2014-08-12 00:00:00.000000", "col3":100.02}, {"col1":-278363826,
"col2":"9 [...]
+[{"col1":-4153835, "col2":"9999-12-31 23:59:59.000000", "col3":76.28134},
{"col1":-3093899, "col2":"2023-01-15 08:32:59.000000", "col3":27.17271},
{"col1":32679, "col2":"2008-04-05 00:00:00.000000", "col3":40.123},
{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":20.07249},
{"col1":-9223372036854775808, "col2":"2000-05-18 06:22:41.000000",
"col3":100.02}, {"col1":7870407, "col2":"2006-10-20 00:00:00.000000",
"col3":42.33057}, {"col1":3830484649655767711, "col2":"2023-01-15 08:3 [...]
+[{"col1":1, "col2":"2024-06-30 12:01:02.000000", "col3":4.801603},
{"col1":758021812, "col2":"2014-08-12 00:00:00.000000", "col3":300.343},
{"col1":1, "col2":"2014-08-12 00:00:00.000000", "col3":97.35194},
{"col1":2626264014159775980, "col2":"2023-01-15 08:32:59.000000",
"col3":40.123}, {"col1":1, "col2":"2011-11-06 00:00:00.000000",
"col3":36.59717}, {"col1":32679, "col2":"2024-07-01 00:00:00.000000",
"col3":22.40163}, {"col1":147483648, "col2":"2010-04-11 09:15:41.000000",
"col3":3.572 [...]
+[{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":48.53108},
{"col1":147483648, "col2":"2024-06-30 12:01:02.000000", "col3":38.26062},
{"col1":-9223372036854775808, "col2":"9999-12-31 00:00:00.000000",
"col3":47.67053}, {"col1":-6103619, "col2":"2013-12-13 17:51:40.000000",
"col3":9.019568}, {"col1":-4489192220759694894, "col2":"2004-07-21
18:34:56.000000", "col3":3.641654}, {"col1":245, "col2":"9999-12-31
00:00:00.000000", "col3":300.343}, {"col1":6798182042418766374, "col2":" [...]
+[{"col1":147483648, "col2":"2024-06-30 12:01:02.000000", "col3":300.343},
{"col1":4557293094697365881, "col2":"2024-07-01 00:00:00.000000",
"col3":97.03959}, {"col1":9223372036854775807, "col2":"2009-01-04
23:24:03.000000", "col3":300.343}, {"col1":0, "col2":"9999-12-31
23:59:59.000000", "col3":84.10744}, {"col1":1, "col2":"2024-08-03
13:08:30.000000", "col3":10.91973}, {"col1":3291955317360852307,
"col2":"2024-08-03 13:08:30.000000", "col3":100.02},
{"col1":1723274695432582386, "col2":" [...]
+[{"col1":0, "col2":"2014-08-12 00:00:00.000000", "col3":14.37908},
{"col1":32679, "col2":"2024-06-30 12:01:02.000000", "col3":300.343},
{"col1":9223372036854775807, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":1, "col2":"2024-08-03 13:08:30.000000", "col3":40.123},
{"col1":9223372036854775807, "col2":"2012-12-04 17:14:15.000000",
"col3":14.33862}, {"col1":1220847, "col2":"9999-12-31 23:59:59.000000",
"col3":52.73846}, {"col1":-7773408573193823932, "col2":"2002-01-28 00:03 [...]
+[{"col1":1364038999, "col2":"2023-01-15 08:32:59.000000", "col3":97.06125},
{"col1":245, "col2":"2014-08-12 00:00:00.000000", "col3":15.23926},
{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":52.96986},
{"col1":6305854028232551826, "col2":"2001-10-01 00:00:00.000000",
"col3":95.61839}, {"col1":4869076082015718217, "col2":"2016-09-02
00:00:00.000000", "col3":67.33}, {"col1":-1851574555, "col2":"2023-01-15
08:32:59.000000", "col3":40.123}, {"col1":-9223372036854775808, "col2":"9 [...]
+[{"col1":245, "col2":"2024-08-03 13:08:30.000000", "col3":40.75657},
{"col1":-950755023, "col2":"2014-08-12 00:00:00.000000", "col3":64.67323},
{"col1":848999334, "col2":"9999-12-31 00:00:00.000000", "col3":15.5588},
{"col1":4615944230483613231, "col2":"2024-08-03 13:08:30.000000",
"col3":300.343}, {"col1":147483648, "col2":"2006-03-25 00:00:00.000000",
"col3":300.343}, {"col1":147483648, "col2":"2023-01-15 08:32:59.000000",
"col3":300.343}, {"col1":9223372036854775807, "col2":"2024-08-0 [...]
+[{"col1":0, "col2":"2006-01-13 19:40:35.000000", "col3":78.75011},
{"col1":753595847274675312, "col2":"2024-07-01 00:00:00.000000",
"col3":4.847248}, {"col1":9223372036854775807, "col2":"2014-08-12
00:00:00.000000", "col3":100.02}, {"col1":-1655375982, "col2":"2024-06-30
12:01:02.000000", "col3":22.22225}, {"col1":245, "col2":"2014-08-12
00:00:00.000000", "col3":15.22864}, {"col1":32679, "col2":"2024-08-03
13:08:30.000000", "col3":100.02}, {"col1":1, "col2":"9999-12-31
23:59:59.000000", [...]
+[{"col1":9223372036854775807, "col2":"2023-01-15 08:32:59.000000",
"col3":300.343}, {"col1":0, "col2":"2024-08-03 13:08:30.000000",
"col3":32.86915}, {"col1":245, "col2":"9999-12-31 23:59:59.000000",
"col3":80.14172}, {"col1":-3108134354750700534, "col2":"2017-09-05
21:37:31.000000", "col3":300.343}, {"col1":-9061207846183197774,
"col2":"2023-01-15 08:32:59.000000", "col3":4.152825}, {"col1":32679,
"col2":"2024-07-01 00:00:00.000000", "col3":78.59793}, {"col1":32679,
"col2":"2011-12-08 2 [...]
+[{"col1":-9223372036854775808, "col2":"2024-06-30 12:01:02.000000",
"col3":79.32755}, {"col1":3769159482883898487, "col2":"2023-01-15
08:32:59.000000", "col3":300.343}, {"col1":9223372036854775807,
"col2":"9999-12-31 23:59:59.000000", "col3":28.50526},
{"col1":-9223372036854775808, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":-2059265078, "col2":"2014-08-12 00:00:00.000000",
"col3":29.00503}, {"col1":-5198159706372226015, "col2":"9999-12-31
23:59:59.000000", "col3":300.34 [...]
+[{"col1":245, "col2":"2024-06-30 12:01:02.000000", "col3":40.123},
{"col1":-7866046249451216238, "col2":"2006-06-19 01:21:15.000000",
"col3":300.343}, {"col1":1, "col2":"2023-01-15 08:32:59.000000",
"col3":100.02}, {"col1":9223372036854775807, "col2":"2024-07-01
00:00:00.000000", "col3":94.10663}, {"col1":9223372036854775807,
"col2":"2001-03-16 00:00:00.000000", "col3":40.123},
{"col1":-1007020981511060171, "col2":"2014-08-12 00:00:00.000000",
"col3":94.19551}, {"col1":-36904730451009213 [...]
+[{"col1":-9223372036854775808, "col2":"2013-08-08 00:00:00.000000",
"col3":29.78231}, {"col1":9223372036854775807, "col2":"2024-07-01
00:00:00.000000", "col3":31.40171}, {"col1":9223372036854775807,
"col2":"2024-08-03 13:08:30.000000", "col3":300.343}, {"col1":-7263097,
"col2":"2019-07-23 02:46:20.000000", "col3":100.02}, {"col1":147483648,
"col2":"2015-10-16 00:00:00.000000", "col3":9.052414}, {"col1":5408244,
"col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":7155834768751946
[...]
+[{"col1":-9223372036854775808, "col2":"2012-07-19 03:07:43.000000",
"col3":100.02}, {"col1":147483648, "col2":"2001-12-19 06:34:47.000000",
"col3":300.343}, {"col1":1376141470, "col2":"2024-07-01 00:00:00.000000",
"col3":73.16489}, {"col1":1, "col2":"9999-12-31 23:59:59.000000",
"col3":300.343}, {"col1":245, "col2":"2024-06-30 12:01:02.000000",
"col3":65.73045}, {"col1":-596481, "col2":"2024-08-03 13:08:30.000000",
"col3":100.02}, {"col1":32679, "col2":"2018-06-05 05:49:18.000000", "col3 [...]
+[{"col1":-7971256102124046564, "col2":"2023-01-15 08:32:59.000000",
"col3":77.09658}, {"col1":5573869614375025345, "col2":"2011-02-02
23:18:44.000000", "col3":40.123}, {"col1":9223372036854775807,
"col2":"9999-12-31 23:59:59.000000", "col3":52.53096}, {"col1":2032476212,
"col2":"9999-12-31 00:00:00.000000", "col3":300.343},
{"col1":9223372036854775807, "col2":"9999-12-31 23:59:59.000000",
"col3":65.2136}, {"col1":245, "col2":"2024-08-03 13:08:30.000000",
"col3":300.343}, {"col1":26159061 [...]
+[{"col1":0, "col2":"2001-08-07 00:00:00.000000", "col3":300.343}, {"col1":0,
"col2":"2023-01-15 08:32:59.000000", "col3":31.17017}, {"col1":147483648,
"col2":"2016-08-08 14:53:36.000000", "col3":76.28036}, {"col1":245,
"col2":"2006-05-10 04:29:41.000000", "col3":40.123}, {"col1":32679,
"col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":147483648,
"col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":-711748,
"col2":"2024-06-30 12:01:02.000000", "col3":54.92981}, {"col1": [...]
+[{"col1":1, "col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":245,
"col2":"2024-06-30 12:01:02.000000", "col3":300.343}, {"col1":1,
"col2":"9999-12-31 23:59:59.000000", "col3":100.02},
{"col1":9223372036854775807, "col2":"9999-12-31 00:00:00.000000",
"col3":300.343}, {"col1":0, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":-9223372036854775808, "col2":"2005-10-07
00:00:00.000000", "col3":100.02}, {"col1":9223372036854775807,
"col2":"2024-08-03 13:08:30.000000", [...]
+[{"col1":2088483620320579704, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":2787982921469004760, "col2":"2000-09-12
00:00:00.000000", "col3":100.02}, {"col1":-3155415, "col2":"2024-07-01
00:00:00.000000", "col3":32.80022}, {"col1":-1017475, "col2":"2010-02-16
00:00:00.000000", "col3":87.10366}, {"col1":82224, "col2":"2024-07-01
00:00:00.000000", "col3":88.41032}, {"col1":9223372036854775807,
"col2":"9999-12-31 00:00:00.000000", "col3":14.31471}, {"col1":147483648,
"col2":" [...]
+[{"col1":147483648, "col2":"2014-08-12 00:00:00.000000", "col3":82.05509},
{"col1":1, "col2":"2023-01-15 08:32:59.000000", "col3":300.343}, {"col1":245,
"col2":"9999-12-31 00:00:00.000000", "col3":25.62183},
{"col1":-7068182211518283061, "col2":"2004-08-27 04:05:52.000000",
"col3":300.343}, {"col1":245, "col2":"2024-06-30 12:01:02.000000",
"col3":53.26661}, {"col1":1220800802, "col2":"9999-12-31 23:59:59.000000",
"col3":40.123}, {"col1":1, "col2":"2024-07-01 00:00:00.000000", "col3":67.7
[...]
+[{"col1":5217165237782065776, "col2":"2024-06-30 12:01:02.000000",
"col3":100.02}, {"col1":-572474246049303393, "col2":"2014-05-01
02:04:12.000000", "col3":300.343}, {"col1":-3437515, "col2":"2014-08-12
00:00:00.000000", "col3":59.36162}, {"col1":1, "col2":"9999-12-31
23:59:59.000000", "col3":59.374}, {"col1":2423528400791611570,
"col2":"2008-10-02 00:00:00.000000", "col3":300.343},
{"col1":9223372036854775807, "col2":"2014-08-12 00:00:00.000000",
"col3":97.85905}, {"col1":-3303681111344 [...]
+[{"col1":-9223372036854775808, "col2":"2024-06-30 12:01:02.000000",
"col3":56.07276}, {"col1":1, "col2":"2024-08-03 13:08:30.000000",
"col3":63.66675}, {"col1":1, "col2":"2024-07-01 00:00:00.000000",
"col3":12.33396}, {"col1":-6825383, "col2":"2010-05-02 00:00:00.000000",
"col3":300.343}, {"col1":32679, "col2":"2023-01-15 08:32:59.000000",
"col3":66.03566}, {"col1":32679, "col2":"2014-08-12 00:00:00.000000",
"col3":12.78865}, {"col1":32679, "col2":"2024-08-03 13:08:30.000000",
"col3":100 [...]
+[{"col1":-9223372036854775808, "col2":"2014-09-19 07:43:33.000000",
"col3":300.343}, {"col1":8092737313590629566, "col2":"2014-08-12
00:00:00.000000", "col3":79.69758}, {"col1":-6283623775956464432,
"col2":"2014-08-12 00:00:00.000000", "col3":41.90858}, {"col1":1213360841,
"col2":"2017-12-03 00:00:00.000000", "col3":40.123}, {"col1":217849651,
"col2":"2009-05-24 00:00:00.000000", "col3":300.343}, {"col1":245,
"col2":"2003-04-25 15:13:47.000000", "col3":40.123}, {"col1":-5831766, "col2":"
[...]
+[{"col1":32679, "col2":"9999-12-31 23:59:59.000000", "col3":10.00709},
{"col1":0, "col2":"2008-07-22 00:00:00.000000", "col3":100.02},
{"col1":-1389307501, "col2":"2023-01-15 08:32:59.000000", "col3":58.13106},
{"col1":-5124269602647716684, "col2":"9999-12-31 23:59:59.000000",
"col3":29.03741}, {"col1":0, "col2":"2014-07-26 00:00:00.000000",
"col3":100.02}, {"col1":147483648, "col2":"2014-07-08 00:00:00.000000",
"col3":75.28541}, {"col1":-4192116, "col2":"2009-03-27 02:44:32.000000", "co
[...]
+[{"col1":-3785879174777200073, "col2":"2014-08-12 00:00:00.000000",
"col3":40.123}, {"col1":0, "col2":"2007-05-17 10:50:22.000000", "col3":40.123},
{"col1":1, "col2":"2024-08-03 13:08:30.000000", "col3":62.03609},
{"col1":32679, "col2":"2024-06-30 12:01:02.000000", "col3":79.00111},
{"col1":1, "col2":"2000-03-12 00:00:00.000000", "col3":300.343},
{"col1":9223372036854775807, "col2":"9999-12-31 23:59:59.000000",
"col3":100.02}, {"col1":-5114553003654784160, "col2":"2023-01-15 08:32:59.000
[...]
+[{"col1":9223372036854775807, "col2":"2024-08-03 13:08:30.000000",
"col3":57.50349}, {"col1":147483648, "col2":"2004-01-28 00:00:00.000000",
"col3":41.19076}, {"col1":1924758911169280029, "col2":"2003-07-08
06:50:56.000000", "col3":61.91198}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59.000000", "col3":40.123}, {"col1":147483648,
"col2":"2024-06-30 12:01:02.000000", "col3":100.02}, {"col1":147483648,
"col2":"2002-06-27 00:00:00.000000", "col3":300.343}, {"col1":9223372036854
[...]
+[{"col1":2912883, "col2":"2005-06-18 00:00:00.000000", "col3":62.97731},
{"col1":9223372036854775807, "col2":"2010-10-01 02:51:00.000000",
"col3":33.99363}, {"col1":147483648, "col2":"2005-10-14 03:41:51.000000",
"col3":49.09568}, {"col1":344376428379760980, "col2":"2002-02-01
00:00:00.000000", "col3":10.94106}, {"col1":2299376473407530620,
"col2":"9999-12-31 00:00:00.000000", "col3":37.15903}, {"col1":32679,
"col2":"2024-08-03 13:08:30.000000", "col3":40.123}, {"col1":0, "col2":"2023-01
[...]
+[{"col1":0, "col2":"9999-12-31 00:00:00.000000", "col3":43.53165},
{"col1":-1697507163, "col2":"9999-12-31 23:59:59.000000", "col3":300.343},
{"col1":1, "col2":"2009-02-01 00:00:00.000000", "col3":300.343},
{"col1":147483648, "col2":"2024-06-30 12:01:02.000000", "col3":60.8661},
{"col1":-9223372036854775808, "col2":"2024-06-30 12:01:02.000000",
"col3":10.28465}, {"col1":1, "col2":"9999-12-31 23:59:59.000000",
"col3":26.04799}, {"col1":-4567597561503124619, "col2":"2013-01-21 00:15:53.000
[...]
+[{"col1":-226454437, "col2":"9999-12-31 00:00:00.000000", "col3":60.97051},
{"col1":8074058, "col2":"2011-11-11 00:00:00.000000", "col3":300.343},
{"col1":9223372036854775807, "col2":"2024-07-01 00:00:00.000000",
"col3":100.02}, {"col1":1, "col2":"2004-07-14 00:00:00.000000",
"col3":55.85773}, {"col1":-2153927, "col2":"2009-12-14 10:33:47.000000",
"col3":12.44972}, {"col1":32679, "col2":"9999-12-31 00:00:00.000000",
"col3":60.80994}, {"col1":-9223372036854775808, "col2":"2024-08-03 13:08 [...]
+[{"col1":32679, "col2":"2018-12-08 00:00:00.000000", "col3":100.02},
{"col1":-5905390, "col2":"9999-12-31 23:59:59.000000", "col3":95.10726},
{"col1":1, "col2":"2007-01-08 16:44:57.000000", "col3":31.76705}, {"col1":245,
"col2":"2000-02-14 06:54:29.000000", "col3":37.05043},
{"col1":9223372036854775807, "col2":"2011-01-18 00:00:00.000000",
"col3":37.70451}, {"col1":-9223372036854775808, "col2":"2016-02-19
19:43:13.000000", "col3":300.343}, {"col1":147483648, "col2":"2024-08-03
13:08:30.0 [...]
+[{"col1":9223372036854775807, "col2":"2015-03-01 00:00:00.000000",
"col3":68.75548}, {"col1":7001443, "col2":"2023-01-15 08:32:59.000000",
"col3":100.02}, {"col1":0, "col2":"2009-02-07 00:00:00.000000", "col3":40.123},
{"col1":8241633905882129849, "col2":"2024-06-30 12:01:02.000000",
"col3":91.63402}, {"col1":2749264234670051152, "col2":"2024-07-01
00:00:00.000000", "col3":2.815725}, {"col1":0, "col2":"2024-07-01
00:00:00.000000", "col3":300.343}, {"col1":-7354223545065148094, "col2":"20
[...]
+[{"col1":5929625, "col2":"2024-07-01 00:00:00.000000", "col3":35.63008},
{"col1":32679, "col2":"2019-05-06 00:00:00.000000", "col3":76.65412},
{"col1":1, "col2":"2024-07-01 00:00:00.000000", "col3":74.59498},
{"col1":147483648, "col2":"9999-12-31 23:59:59.000000", "col3":40.123},
{"col1":-1777374, "col2":"9999-12-31 00:00:00.000000", "col3":41.03664},
{"col1":7908799197764845907, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":-4369133, "col2":"2024-07-01 00:00:00.000000", " [...]
+[{"col1":9223372036854775807, "col2":"2014-08-12 00:00:00.000000",
"col3":40.123}, {"col1":-1341415562, "col2":"9999-12-31 00:00:00.000000",
"col3":16.20586}, {"col1":8318673, "col2":"2004-07-19 11:43:49.000000",
"col3":300.343}, {"col1":-9223372036854775808, "col2":"2000-08-13
08:47:31.000000", "col3":76.08282}, {"col1":1, "col2":"2002-12-26
00:00:00.000000", "col3":40.123}, {"col1":32679, "col2":"2024-07-01
00:00:00.000000", "col3":300.343}, {"col1":32679, "col2":"2023-01-15 08:32:59.0
[...]
+[{"col1":245, "col2":"2024-08-03 13:08:30.000000", "col3":40.123},
{"col1":32679, "col2":"2009-03-28 17:05:31.000000", "col3":42.87412},
{"col1":1128136767488233223, "col2":"9999-12-31 23:59:59.000000",
"col3":45.98336}, {"col1":-9223372036854775808, "col2":"2024-06-30
12:01:02.000000", "col3":80.26015}, {"col1":32679, "col2":"2024-06-30
12:01:02.000000", "col3":43.30775}, {"col1":1416996981, "col2":"2002-03-08
08:53:38.000000", "col3":40.123}, {"col1":245, "col2":"2024-07-01 00:00:00.00
[...]
+[{"col1":-9223372036854775808, "col2":"2002-12-17 00:00:00.000000",
"col3":40.123}, {"col1":-9223372036854775808, "col2":"2023-01-15
08:32:59.000000", "col3":67.72457}, {"col1":-9223372036854775808,
"col2":"9999-12-31 00:00:00.000000", "col3":89.65717},
{"col1":3559475027024857976, "col2":"2024-08-03 13:08:30.000000",
"col3":50.73302}, {"col1":2808091657423479754, "col2":"2016-02-27
00:00:00.000000", "col3":40.123}, {"col1":9223372036854775807,
"col2":"2014-09-12 05:23:46.000000", "col3" [...]
+[{"col1":32679, "col2":"2015-03-11 18:18:56.000000", "col3":300.343},
{"col1":0, "col2":"2011-01-20 00:00:00.000000", "col3":100.02},
{"col1":-2636495134244375617, "col2":"2005-11-14 00:00:00.000000",
"col3":100.02}, {"col1":1926091962, "col2":"2024-07-01 00:00:00.000000",
"col3":100.02}, {"col1":0, "col2":"2013-07-17 00:00:00.000000",
"col3":93.90285}, {"col1":1881535678360023831, "col2":"2014-08-12
00:00:00.000000", "col3":300.343}, {"col1":8221380577298974307,
"col2":"2006-04-24 00:00 [...]
+[{"col1":-9223372036854775808, "col2":"2014-06-27 17:24:45.000000",
"col3":44.90651}, {"col1":-764296545, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":0, "col2":"2003-12-27 14:48:57.000000",
"col3":57.22913}, {"col1":-1824562447, "col2":"9999-12-31 23:59:59.000000",
"col3":40.123}, {"col1":-6180298867321737446, "col2":"2023-01-15
08:32:59.000000", "col3":93.94769}, {"col1":9223372036854775807,
"col2":"2019-02-14 09:47:34.000000", "col3":50.89013}, {"col1":1, "col2":"2023-
[...]
+[{"col1":0, "col2":"2024-06-30 12:01:02.000000", "col3":40.123}, {"col1":1,
"col2":"2024-08-03 13:08:30.000000", "col3":14.01944}, {"col1":5784302,
"col2":"2007-03-19 17:17:36.000000", "col3":28.70374},
{"col1":-90921797250303742, "col2":"2024-07-01 00:00:00.000000",
"col3":40.123}, {"col1":3715051786809223743, "col2":"2016-11-28
00:00:00.000000", "col3":40.123}, {"col1":245, "col2":"9999-12-31
00:00:00.000000", "col3":11.25309}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59. [...]
+[{"col1":4564281, "col2":"2007-03-14 00:00:00.000000", "col3":23.92071},
{"col1":2107186773, "col2":"2014-08-12 00:00:00.000000", "col3":51.66171},
{"col1":7553660, "col2":"2024-06-30 12:01:02.000000", "col3":40.123},
{"col1":147483648, "col2":"2014-08-12 00:00:00.000000", "col3":80.12557},
{"col1":-7080463257811943206, "col2":"2009-11-15 00:00:00.000000",
"col3":69.84637}, {"col1":1, "col2":"2023-01-15 08:32:59.000000",
"col3":96.03031}, {"col1":-996618676, "col2":"2024-07-01 00:00:00.0 [...]
+[{"col1":3978324359222908728, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":8358001467589099345, "col2":"2023-01-15
08:32:59.000000", "col3":300.343}, {"col1":32679, "col2":"2024-07-01
00:00:00.000000", "col3":100.02}, {"col1":5190098, "col2":"2011-04-25
00:00:00.000000", "col3":100.02}, {"col1":9223372036854775807,
"col2":"2014-01-07 00:00:00.000000", "col3":48.14768}, {"col1":32679,
"col2":"9999-12-31 00:00:00.000000", "col3":43.0671}, {"col1":32679,
"col2":"2010-07-23 0 [...]
+[{"col1":-1614086684125855151, "col2":"9999-12-31 00:00:00.000000",
"col3":40.123}, {"col1":8883549370176774713, "col2":"9999-12-31
23:59:59.000000", "col3":60.82939}, {"col1":1, "col2":"9999-12-31
23:59:59.000000", "col3":100.02}, {"col1":6163523345656684731,
"col2":"2024-07-01 00:00:00.000000", "col3":86.45116}, {"col1":0,
"col2":"2005-10-21 00:00:00.000000", "col3":100.02}, {"col1":245,
"col2":"2019-05-08 01:24:14.000000", "col3":92.75134}, {"col1":-2113159025,
"col2":"2000-11-06 13:2 [...]
+[{"col1":1124939, "col2":"9999-12-31 00:00:00.000000", "col3":40.123},
{"col1":2030052733, "col2":"2024-07-01 00:00:00.000000", "col3":83.44152},
{"col1":-5021647788081575978, "col2":"2024-08-03 13:08:30.000000",
"col3":52.37899}, {"col1":-9223372036854775808, "col2":"2012-12-12
15:36:00.000000", "col3":62.69048}, {"col1":-1359908423, "col2":"2024-08-03
13:08:30.000000", "col3":10.39856}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59.000000", "col3":6.100019}, {"col1":-187544 [...]
+[{"col1":0, "col2":"2003-10-22 00:00:00.000000", "col3":29.46242},
{"col1":711431, "col2":"2024-08-03 13:08:30.000000", "col3":99.46093},
{"col1":1, "col2":"2006-06-18 15:01:39.000000", "col3":300.343},
{"col1":-2162183, "col2":"2001-10-15 23:23:05.000000", "col3":40.123},
{"col1":948318933, "col2":"9999-12-31 00:00:00.000000", "col3":300.343},
{"col1":5015377, "col2":"2023-01-15 08:32:59.000000", "col3":60.47369},
{"col1":-1933955555, "col2":"2009-09-13 00:00:00.000000", "col3":66.30293 [...]
+[{"col1":-4195937535396017009, "col2":"2016-10-17 03:16:42.000000",
"col3":300.343}, {"col1":1778311398, "col2":"2024-07-01 00:00:00.000000",
"col3":40.123}, {"col1":4957783190359928216, "col2":"2024-07-01
00:00:00.000000", "col3":59.67171}, {"col1":-1595989968, "col2":"2024-08-03
13:08:30.000000", "col3":100.02}, {"col1":0, "col2":"2024-06-30
12:01:02.000000", "col3":34.81098}, {"col1":9223372036854775807,
"col2":"2023-01-15 08:32:59.000000", "col3":89.3142}, {"col1":32679,
"col2":"9999 [...]
+[{"col1":0, "col2":"2019-09-13 18:15:06.000000", "col3":90.28475}, {"col1":0,
"col2":"9999-12-31 00:00:00.000000", "col3":300.343},
{"col1":1188125204052821847, "col2":"2003-05-22 00:47:54.000000",
"col3":51.83068}, {"col1":32679, "col2":"2024-06-30 12:01:02.000000",
"col3":63.20104}, {"col1":0, "col2":"9999-12-31 23:59:59.000000",
"col3":22.93358}, {"col1":245, "col2":"2024-08-03 13:08:30.000000",
"col3":7.369187}, {"col1":1, "col2":"2024-06-30 12:01:02.000000",
"col3":100.02}, {"col1": [...]
+[{"col1":-9223372036854775808, "col2":"2000-03-04 00:00:00.000000",
"col3":300.343}, {"col1":-5250311514973888583, "col2":"2024-07-01
00:00:00.000000", "col3":100.02}, {"col1":147483648, "col2":"2024-08-03
13:08:30.000000", "col3":0.01981326}, {"col1":147483648, "col2":"2007-12-14
15:40:39.000000", "col3":54.77441}, {"col1":6405003944954063436,
"col2":"2023-01-15 08:32:59.000000", "col3":52.76279},
{"col1":-9223372036854775808, "col2":"2024-08-03 13:08:30.000000",
"col3":1.556406}, {"col [...]
+[{"col1":3605708503345865412, "col2":"9999-12-31 00:00:00.000000",
"col3":12.54703}, {"col1":1, "col2":"2004-12-27 11:52:56.000000",
"col3":3.708239}, {"col1":-4177972530898104282, "col2":"9999-12-31
00:00:00.000000", "col3":300.343}, {"col1":471305779, "col2":"2018-09-04
00:00:00.000000", "col3":81.54317}, {"col1":-3362395891844830164,
"col2":"9999-12-31 00:00:00.000000", "col3":40.123},
{"col1":-3370141034322630992, "col2":"2009-07-06 06:10:44.000000",
"col3":26.2692}, {"col1":0, "col2 [...]
+[{"col1":8502245137192996061, "col2":"2024-07-01 00:00:00.000000",
"col3":28.63033}, {"col1":2609737715342257596, "col2":"2010-09-04
00:00:00.000000", "col3":100.02}, {"col1":7210055270257435707,
"col2":"2005-11-03 08:01:13.000000", "col3":1.265358}, {"col1":147483648,
"col2":"2004-10-05 12:47:25.000000", "col3":100.02},
{"col1":9223372036854775807, "col2":"2014-08-12 00:00:00.000000",
"col3":28.95525}, {"col1":9223372036854775807, "col2":"2024-08-03
13:08:30.000000", "col3":13.40952}, { [...]
+[{"col1":-7113536318748323416, "col2":"2012-11-17 00:00:00.000000",
"col3":40.123}, {"col1":9223372036854775807, "col2":"9999-12-31
00:00:00.000000", "col3":100.02}, {"col1":4248886768550810980,
"col2":"2023-01-15 08:32:59.000000", "col3":300.343},
{"col1":-9223372036854775808, "col2":"2014-05-10 00:00:00.000000",
"col3":8.298746}, {"col1":147483648, "col2":"2014-08-12 00:00:00.000000",
"col3":23.57331}, {"col1":245, "col2":"2008-05-05 02:09:04.000000",
"col3":83.92262}, {"col1":245, "co [...]
+[{"col1":1, "col2":"2007-01-15 00:00:00.000000", "col3":1.711898},
{"col1":-9223372036854775808, "col2":"2024-06-30 12:01:02.000000",
"col3":13.35497}, {"col1":32679, "col2":"2024-06-30 12:01:02.000000",
"col3":40.123}, {"col1":0, "col2":"2024-06-30 12:01:02.000000",
"col3":88.29248}, {"col1":1883141947937624365, "col2":"2024-08-03
13:08:30.000000", "col3":16.31094}, {"col1":-9223372036854775808,
"col2":"2005-08-12 06:48:16.000000", "col3":40.123},
{"col1":9223372036854775807, "col2":"99 [...]
+[{"col1":32679, "col2":"9999-12-31 00:00:00.000000", "col3":95.50592},
{"col1":1383932100, "col2":"9999-12-31 00:00:00.000000", "col3":100.02},
{"col1":32679, "col2":"2010-09-27 21:39:42.000000", "col3":40.123}, {"col1":0,
"col2":"2024-08-03 13:08:30.000000", "col3":100.02}, {"col1":245,
"col2":"2014-04-22 00:00:00.000000", "col3":11.44433}, {"col1":0,
"col2":"2014-08-12 00:00:00.000000", "col3":40.123}, {"col1":335666,
"col2":"2024-08-03 13:08:30.000000", "col3":13.6872}, {"col1":660493 [...]
+[{"col1":-9223372036854775808, "col2":"2023-01-15 08:32:59.000000",
"col3":6.470507}, {"col1":147483648, "col2":"2008-02-25 00:00:00.000000",
"col3":100.02}, {"col1":32679, "col2":"2014-08-12 00:00:00.000000",
"col3":100.02}, {"col1":-4550882424274407632, "col2":"2001-05-10
11:52:18.000000", "col3":43.5405}, {"col1":32679, "col2":"2001-11-07
11:05:22.000000", "col3":15.39053}, {"col1":32679, "col2":"9999-12-31
00:00:00.000000", "col3":82.6918}, {"col1":321726, "col2":"2012-11-25 00:00:00
[...]
+[{"col1":9223372036854775807, "col2":"2007-02-12 19:01:03.000000",
"col3":99.65969}, {"col1":-9223372036854775808, "col2":"2003-08-02
00:00:00.000000", "col3":40.123}, {"col1":245, "col2":"2001-05-14
11:04:27.000000", "col3":100.02}, {"col1":4787917, "col2":"2007-10-19
12:03:33.000000", "col3":100.02}, {"col1":7402042610115475717,
"col2":"2000-02-22 00:00:00.000000", "col3":76.72903}, {"col1":147483648,
"col2":"9999-12-31 23:59:59.000000", "col3":40.123}, {"col1":0,
"col2":"2000-09-23 00 [...]
+[{"col1":245, "col2":"2003-07-16 00:00:00.000000", "col3":29.97996},
{"col1":32679, "col2":"2024-08-03 13:08:30.000000", "col3":27.23573},
{"col1":-7365767, "col2":"2003-08-15 00:00:00.000000", "col3":100.02},
{"col1":147483648, "col2":"9999-12-31 23:59:59.000000", "col3":38.11153},
{"col1":6800816, "col2":"2010-06-12 00:00:00.000000", "col3":100.02},
{"col1":147483648, "col2":"2018-03-13 19:11:51.000000", "col3":300.343},
{"col1":32679, "col2":"2004-08-01 00:00:00.000000", "col3":57.185 [...]
+[{"col1":9223372036854775807, "col2":"2024-06-30 12:01:02.000000",
"col3":100.02}, {"col1":32679, "col2":"2014-11-28 07:46:53.000000",
"col3":100.02}, {"col1":147483648, "col2":"2024-08-03 13:08:30.000000",
"col3":98.61409}, {"col1":-9223372036854775808, "col2":"2016-08-01
00:00:00.000000", "col3":40.123}, {"col1":245, "col2":"9999-12-31
00:00:00.000000", "col3":300.343}, {"col1":1, "col2":"2024-07-01
00:00:00.000000", "col3":27.00343}, {"col1":-470717, "col2":"2014-08-12
00:00:00.000000 [...]
+[{"col1":2117045820, "col2":"2018-02-10 16:32:46.000000", "col3":300.343},
{"col1":-8149054128257850589, "col2":"2024-08-03 13:08:30.000000",
"col3":40.123}, {"col1":1, "col2":"2005-09-15 17:33:35.000000",
"col3":5.52531}, {"col1":1723726881, "col2":"2024-06-30 12:01:02.000000",
"col3":59.97636}, {"col1":2223347671603532107, "col2":"2018-03-12
00:00:00.000000", "col3":49.05131}, {"col1":1870375793, "col2":"2007-12-07
04:02:40.000000", "col3":40.123}, {"col1":-9223372036854775808, "col2": [...]
+[{"col1":147483648, "col2":"2024-08-03 13:08:30.000000", "col3":100.02},
{"col1":0, "col2":"9999-12-31 23:59:59.000000", "col3":100.02}, {"col1":1,
"col2":"2024-08-03 13:08:30.000000", "col3":300.343},
{"col1":-9223372036854775808, "col2":"9999-12-31 23:59:59.000000",
"col3":65.26621}, {"col1":-9223372036854775808, "col2":"2024-06-30
12:01:02.000000", "col3":40.123}, {"col1":32679, "col2":"2012-02-07
00:00:00.000000", "col3":35.37392}, {"col1":1, "col2":"2024-07-01
00:00:00.000000", "col [...]
+[{"col1":0, "col2":"2004-10-22 00:00:00.000000", "col3":300.343},
{"col1":-9223372036854775808, "col2":"2008-08-14 01:57:52.000000",
"col3":56.32014}, {"col1":5231525250049839844, "col2":"9999-12-31
23:59:59.000000", "col3":97.18168}, {"col1":32679, "col2":"2024-06-30
12:01:02.000000", "col3":100.02}, {"col1":4567050841824726776,
"col2":"2024-07-01 00:00:00.000000", "col3":95.26378},
{"col1":-4819809037249876495, "col2":"2000-12-22 09:04:59.000000",
"col3":19.7707}, {"col1":-199137910899 [...]
+[{"col1":-630385728, "col2":"2006-06-13 17:36:54.000000", "col3":40.123},
{"col1":326165155, "col2":"2024-07-01 00:00:00.000000", "col3":100.02},
{"col1":-4756938, "col2":"2014-08-12 00:00:00.000000", "col3":100.02},
{"col1":-4032514327818733053, "col2":"2016-10-06 01:31:46.000000",
"col3":96.03272}, {"col1":0, "col2":"9999-12-31 00:00:00.000000",
"col3":9.64976}, {"col1":865363052495596491, "col2":"2011-05-11
00:00:00.000000", "col3":43.93465}, {"col1":-5917378717822508597, "col2":"2014
[...]
+[{"col1":-1486609614448364003, "col2":"9999-12-31 23:59:59.000000",
"col3":98.63902}, {"col1":1, "col2":"2003-11-11 00:00:00.000000",
"col3":41.05365}, {"col1":8047493113532754772, "col2":"2004-03-04
18:20:32.000000", "col3":92.61216}, {"col1":5032492, "col2":"9999-12-31
23:59:59.000000", "col3":9.955972}, {"col1":0, "col2":"2023-01-15
08:32:59.000000", "col3":55.36078}, {"col1":-774827352, "col2":"2024-07-01
00:00:00.000000", "col3":300.343}, {"col1":9223372036854775807, "col2":"2024-08
[...]
+[{"col1":147483648, "col2":"2024-07-01 00:00:00.000000", "col3":100.02},
{"col1":9223372036854775807, "col2":"2014-08-12 00:00:00.000000",
"col3":300.343}, {"col1":245, "col2":"2024-07-01 00:00:00.000000",
"col3":40.123}, {"col1":-5426898939321443754, "col2":"2016-11-26
11:13:38.000000", "col3":300.343}, {"col1":1, "col2":"2017-11-01
00:00:00.000000", "col3":300.343}, {"col1":-9223372036854775808,
"col2":"2023-01-15 08:32:59.000000", "col3":91.00703}, {"col1":245,
"col2":"2019-07-18 00:0 [...]
+[{"col1":147483648, "col2":"2012-12-24 00:00:00.000000", "col3":100.02},
{"col1":-9223372036854775808, "col2":"2024-07-01 00:00:00.000000",
"col3":100.02}, {"col1":0, "col2":"2024-06-30 12:01:02.000000",
"col3":58.47456}, {"col1":1, "col2":"2024-08-03 13:08:30.000000",
"col3":28.11074}, {"col1":685924, "col2":"2024-07-01 00:00:00.000000",
"col3":68.85097}, {"col1":-7079273816820442907, "col2":"2002-01-10
09:09:02.000000", "col3":11.22855}, {"col1":147483648, "col2":"2017-08-17
08:47:25.0 [...]
+
diff --git
a/regression-test/suites/nereids_p0/sql_functions/array_functions/sql/q04.sql
b/regression-test/suites/nereids_p0/sql_functions/array_functions/sql/q04.sql
new file mode 100644
index 00000000000..aa0d1f96e5c
--- /dev/null
+++
b/regression-test/suites/nereids_p0/sql_functions/array_functions/sql/q04.sql
@@ -0,0 +1,128 @@
+CREATE TABLE `table_100_undef_partitions2_keys3_properties4_distributed_by52` (
+ `pk` int NULL,
+ `col_array_boolean__undef_signed` array<boolean> NULL,
+ `col_array_boolean__undef_signed_index_inverted` array<boolean> NULL,
+ `col_array_boolean__undef_signed_not_null` array<boolean> NOT NULL,
+ `col_array_boolean__undef_signed_not_null_index_inverted` array<boolean> NOT
NULL,
+ `col_array_tinyint__undef_signed` array<tinyint> NULL,
+ `col_array_tinyint__undef_signed_index_inverted` array<tinyint> NULL,
+ `col_array_tinyint__undef_signed_not_null` array<tinyint> NOT NULL,
+ `col_array_tinyint__undef_signed_not_null_index_inverted` array<tinyint> NOT
NULL,
+ `col_array_smallint__undef_signed` array<smallint> NULL,
+ `col_array_smallint__undef_signed_index_inverted` array<smallint> NULL,
+ `col_array_smallint__undef_signed_not_null` array<smallint> NOT NULL,
+ `col_array_smallint__undef_signed_not_null_index_inverted` array<smallint>
NOT NULL,
+ `col_array_int__undef_signed` array<int> NULL,
+ `col_array_int__undef_signed_index_inverted` array<int> NULL,
+ `col_array_int__undef_signed_not_null` array<int> NOT NULL,
+ `col_array_int__undef_signed_not_null_index_inverted` array<int> NOT NULL,
+ `col_array_bigint__undef_signed` array<bigint> NULL,
+ `col_array_bigint__undef_signed_index_inverted` array<bigint> NULL,
+ `col_array_bigint__undef_signed_not_null` array<bigint> NOT NULL,
+ `col_array_bigint__undef_signed_not_null_index_inverted` array<bigint> NOT
NULL,
+ `col_array_largeint__undef_signed` array<largeint> NULL,
+ `col_array_largeint__undef_signed_index_inverted` array<largeint> NULL,
+ `col_array_largeint__undef_signed_not_null` array<largeint> NOT NULL,
+ `col_array_largeint__undef_signed_not_null_index_inverted` array<largeint>
NOT NULL,
+ `col_array_float__undef_signed` array<float> NULL,
+ `col_array_float__undef_signed_not_null` array<float> NOT NULL,
+ `col_array_double__undef_signed` array<double> NULL,
+ `col_array_double__undef_signed_not_null` array<double> NOT NULL,
+ `col_array_decimal_16_10___undef_signed` array<decimal(16,10)> NULL,
+ `col_array_decimal_16_10___undef_signed_index_inverted`
array<decimal(16,10)> NULL,
+ `col_array_decimal_16_10___undef_signed_not_null` array<decimal(16,10)> NOT
NULL,
+ `col_array_decimal_16_10___undef_signed_not_null_index_inverted`
array<decimal(16,10)> NOT NULL,
+ `col_array_decimal_10_0___undef_signed` array<decimal(10,0)> NULL,
+ `col_array_decimal_10_0___undef_signed_index_inverted` array<decimal(10,0)>
NULL,
+ `col_array_decimal_10_0___undef_signed_not_null` array<decimal(10,0)> NOT
NULL,
+ `col_array_decimal_10_0___undef_signed_not_null_index_inverted`
array<decimal(10,0)> NOT NULL,
+ `col_array_decimal_37__12___undef_signed` array<decimal(37,12)> NULL,
+ `col_array_decimal_37__12___undef_signed_index_inverted`
array<decimal(37,12)> NULL,
+ `col_array_decimal_37__12___undef_signed_not_null` array<decimal(37,12)> NOT
NULL,
+ `col_array_decimal_37__12___undef_signed_not_null_index_inverted`
array<decimal(37,12)> NOT NULL,
+ `col_array_decimal_17_0___undef_signed` array<decimal(17,0)> NULL,
+ `col_array_decimal_17_0___undef_signed_index_inverted` array<decimal(17,0)>
NULL,
+ `col_array_decimal_17_0___undef_signed_not_null` array<decimal(17,0)> NOT
NULL,
+ `col_array_decimal_17_0___undef_signed_not_null_index_inverted`
array<decimal(17,0)> NOT NULL,
+ `col_array_decimal_8_4___undef_signed` array<decimal(8,4)> NULL,
+ `col_array_decimal_8_4___undef_signed_index_inverted` array<decimal(8,4)>
NULL,
+ `col_array_decimal_8_4___undef_signed_not_null` array<decimal(8,4)> NOT NULL,
+ `col_array_decimal_8_4___undef_signed_not_null_index_inverted`
array<decimal(8,4)> NOT NULL,
+ `col_array_decimal_9_0___undef_signed` array<decimal(9,0)> NULL,
+ `col_array_decimal_9_0___undef_signed_index_inverted` array<decimal(9,0)>
NULL,
+ `col_array_decimal_9_0___undef_signed_not_null` array<decimal(9,0)> NOT NULL,
+ `col_array_decimal_9_0___undef_signed_not_null_index_inverted`
array<decimal(9,0)> NOT NULL,
+ `col_array_char_255___undef_signed` array<character(255)> NULL,
+ `col_array_char_255___undef_signed_index_inverted` array<character(255)>
NULL,
+ `col_array_char_255___undef_signed_not_null` array<character(255)> NOT NULL,
+ `col_array_char_255___undef_signed_not_null_index_inverted`
array<character(255)> NOT NULL,
+ `col_array_varchar_65533___undef_signed` array<varchar(65533)> NULL,
+ `col_array_varchar_65533___undef_signed_index_inverted`
array<varchar(65533)> NULL,
+ `col_array_varchar_65533___undef_signed_not_null` array<varchar(65533)> NOT
NULL,
+ `col_array_varchar_65533___undef_signed_not_null_index_inverted`
array<varchar(65533)> NOT NULL,
+ `col_array_string__undef_signed` array<text> NULL,
+ `col_array_string__undef_signed_index_inverted` array<text> NULL,
+ `col_array_string__undef_signed_not_null` array<text> NOT NULL,
+ `col_array_string__undef_signed_not_null_index_inverted` array<text> NOT
NULL,
+ `col_array_date__undef_signed` array<date> NULL,
+ `col_array_date__undef_signed_index_inverted` array<date> NULL,
+ `col_array_date__undef_signed_not_null` array<date> NOT NULL,
+ `col_array_date__undef_signed_not_null_index_inverted` array<date> NOT NULL,
+ `col_array_datetime__undef_signed` array<datetime> NULL,
+ `col_array_datetime__undef_signed_index_inverted` array<datetime> NULL,
+ `col_array_datetime__undef_signed_not_null` array<datetime> NOT NULL,
+ `col_array_datetime__undef_signed_not_null_index_inverted` array<datetime>
NOT NULL,
+ `col_array_datetime_6___undef_signed` array<datetime(6)> NULL,
+ `col_array_datetime_6___undef_signed_index_inverted` array<datetime(6)> NULL,
+ `col_array_datetime_6___undef_signed_not_null` array<datetime(6)> NOT NULL,
+ `col_array_datetime_6___undef_signed_not_null_index_inverted`
array<datetime(6)> NOT NULL,
+ INDEX col_array_boolean__undef_signed_index_inverted_idx
(`col_array_boolean__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_boolean__undef_signed_not_null_index_inverted_idx
(`col_array_boolean__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_tinyint__undef_signed_index_inverted_idx
(`col_array_tinyint__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_tinyint__undef_signed_not_null_index_inverted_idx
(`col_array_tinyint__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_smallint__undef_signed_index_inverted_idx
(`col_array_smallint__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_smallint__undef_signed_not_null_index_inverted_idx
(`col_array_smallint__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_int__undef_signed_index_inverted_idx
(`col_array_int__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_int__undef_signed_not_null_index_inverted_idx
(`col_array_int__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_bigint__undef_signed_index_inverted_idx
(`col_array_bigint__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_bigint__undef_signed_not_null_index_inverted_idx
(`col_array_bigint__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_largeint__undef_signed_index_inverted_idx
(`col_array_largeint__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_largeint__undef_signed_not_null_index_inverted_idx
(`col_array_largeint__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_16_10___undef_signed_index_inverted_idx
(`col_array_decimal_16_10___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_16_10___undef_signed_n_0_idx
(`col_array_decimal_16_10___undef_signed_not_null_index_inverted`) USING
INVERTED,
+ INDEX col_array_decimal_10_0___undef_signed_index_inverted_idx
(`col_array_decimal_10_0___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_10_0___undef_signed_no_1_idx
(`col_array_decimal_10_0___undef_signed_not_null_index_inverted`) USING
INVERTED,
+ INDEX col_array_decimal_37__12___undef_signed_index_inverted_idx
(`col_array_decimal_37__12___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_37__12___undef_signed__2_idx
(`col_array_decimal_37__12___undef_signed_not_null_index_inverted`) USING
INVERTED,
+ INDEX col_array_decimal_17_0___undef_signed_index_inverted_idx
(`col_array_decimal_17_0___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_17_0___undef_signed_no_3_idx
(`col_array_decimal_17_0___undef_signed_not_null_index_inverted`) USING
INVERTED,
+ INDEX col_array_decimal_8_4___undef_signed_index_inverted_idx
(`col_array_decimal_8_4___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_8_4___undef_signed_not_4_idx
(`col_array_decimal_8_4___undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_9_0___undef_signed_index_inverted_idx
(`col_array_decimal_9_0___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_decimal_9_0___undef_signed_not_5_idx
(`col_array_decimal_9_0___undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_char_255___undef_signed_index_inverted_idx
(`col_array_char_255___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_char_255___undef_signed_not_null_index_inverted_idx
(`col_array_char_255___undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_varchar_65533___undef_signed_index_inverted_idx
(`col_array_varchar_65533___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_varchar_65533___undef_signed_n_6_idx
(`col_array_varchar_65533___undef_signed_not_null_index_inverted`) USING
INVERTED,
+ INDEX col_array_string__undef_signed_index_inverted_idx
(`col_array_string__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_string__undef_signed_not_null_index_inverted_idx
(`col_array_string__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_date__undef_signed_index_inverted_idx
(`col_array_date__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_date__undef_signed_not_null_index_inverted_idx
(`col_array_date__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_datetime__undef_signed_index_inverted_idx
(`col_array_datetime__undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_datetime__undef_signed_not_null_index_inverted_idx
(`col_array_datetime__undef_signed_not_null_index_inverted`) USING INVERTED,
+ INDEX col_array_datetime_6___undef_signed_index_inverted_idx
(`col_array_datetime_6___undef_signed_index_inverted`) USING INVERTED,
+ INDEX col_array_datetime_6___undef_signed_not_null_index_inverted_idx
(`col_array_datetime_6___undef_signed_not_null_index_inverted`) USING INVERTED
+) ENGINE=OLAP
+DUPLICATE KEY(`pk`)
+DISTRIBUTED BY HASH(`pk`) BUCKETS 10
+PROPERTIES (
+"replication_num" = "1"
+);
+
+
+INSERT INTO `table_100_undef_partitions2_keys3_properties4_distributed_by52`
VALUES (11,'[null, null, 1, null, 0, 0, 0, null, 1, 0, null, null, 0, 0, 1,
null, null, 0, 1, 0, 0, null, 0, 1, null]','[null, 1, null, 1, null, 1, 0, 0,
1, 1, null, 0, null, null, 0, null, 0, null, 1, null, 0, null, 0, 0, 1]','[0,
null, null, null, 0, null, 1, 0, 0, 1, 0, null, null, 0, null, 0, 1, 0, 0,
null, null, 1, 0, 0, null]','[null, 1, 0, 0, 0, null, 0, 0, null, null, 1, 0,
0, 1, null, 0, 1, null, 1, 0, [...]
+INSERT INTO `table_100_undef_partitions2_keys3_properties4_distributed_by52`
VALUES (98,'[0, null, null, 0, 0, 0, 0, 0, 0, 1, null, 0, 0, null, 0, 0, 0, 0,
0, 0, 0, null, 0, 0, 0]','[1, null, 0, 1, 1, null, 0, null, 1, 1, null, 0,
null, null, null, null, 0, 1, 1, 1, 0, 0, null, 0, 1]','[1, null, 1, null,
null, 1, 0, 1, null, 0, 1, 1, null, 0, 1, 0, null, null, 1, null, null, 0, 1,
null, 0]','[0, 0, 0, null, null, 0, 1, null, 1, 1, 0, 0, null, 1, 0, 1, 1,
null, 0, 0, 1, 1, 1, 0, 1]','[6, [...]
+INSERT INTO `table_100_undef_partitions2_keys3_properties4_distributed_by52`
VALUES (62,'[null, null, 0, null, null, 0, 0, null, 1, null, 1, 1, 1, 1, 0, 0,
null, null, null, 0, null, 0, null, null, 0]','[1, null, 1, 1, null, null,
null, 0, 1, 1, 0, 1, 0, null, 1, 1, 1, 1, 1, 1, 0, 1, null, null, 1]','[1, 0,
1, 0, 1, 1, null, null, 0, 0, 0, 1, null, null, 0, 0, 0, 0, 0, 0, 0, null, 0,
null, 1]','[1, 0, null, null, null, null, 0, 0, 1, null, 1, 1, 1, null, 1, 0,
1, 1, 1, null, 0, 1, 0, nul [...]
+
+
+select array_zip(col_array_largeint__undef_signed_not_null,
col_array_datetime_6___undef_signed, col_array_float__undef_signed_not_null),
array_range(1, 10), array_popback(col_array_date__undef_signed_not_null),
array_union(col_array_datetime__undef_signed_index_inverted,
col_array_decimal_16_10___undef_signed_not_null),
array_zip(col_array_decimal_37__12___undef_signed_not_null,
col_array_decimal_37__12___undef_signed),
array_popback(col_array_date__undef_signed_index_inverted), array_w [...]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
