This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-4.1 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 803367f276207c0aa5b9df1a81273462b2e57e40 Author: Jerry Hu <[email protected]> AuthorDate: Sun Mar 15 21:45:30 2026 +0800 [chore](test) Make results of array_union sorted by array_sort in test cases (#61333) (#61344) pick #61333 The result of `array_union` does not guarantee element order, so the outputs of its related test cases are also unstable. Use `array_sort` to make the results deterministic. Related PR: #xxx Problem Summary: None - Test <!-- At least one of them must be included. --> - [ ] Regression test - [ ] Unit Test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test or manual test. Explain why: - [ ] This is a refactor/code format and no logic has been changed. - [ ] Previous test can cover this change. - [ ] No code files have been changed. - [ ] Other reason <!-- Add your reason? --> - Behavior changed: - [ ] No. - [ ] Yes. <!-- Explain the behavior change --> - Does this need documentation? - [ ] No. - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 --> - [ ] Confirm the release note - [ ] Confirm test cases - [ ] Confirm document - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into --> ### What problem does this PR solve? Issue Number: close #xxx Related PR: #xxx Problem Summary: ### Release note None ### Check List (For Author) - Test <!-- At least one of them must be included. --> - [ ] Regression test - [ ] Unit Test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test or manual test. Explain why: - [ ] This is a refactor/code format and no logic has been changed. - [ ] Previous test can cover this change. - [ ] No code files have been changed. - [ ] Other reason <!-- Add your reason? --> - Behavior changed: - [ ] No. - [ ] Yes. <!-- Explain the behavior change --> - Does this need documentation? - [ ] No. - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 --> ### Check List (For Reviewer who merge this PR) - [ ] Confirm the release note - [ ] Confirm test cases - [ ] Confirm document - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into --> --- .../sql-function/test_array_function.out | 40 ++-- .../sql_functions/array_functions/sql/q04.out | 204 ++++++++++----------- .../test_array_functions_by_literal.out | 66 +++---- .../sql-function/test_array_function.groovy | 54 +++--- .../sql_functions/array_functions/sql/q04.sql | 3 +- .../test_array_functions_by_literal.groovy | 84 ++++----- 6 files changed, 226 insertions(+), 225 deletions(-) diff --git a/regression-test/data/doc/sql-manual/sql-function/test_array_function.out b/regression-test/data/doc/sql-manual/sql-function/test_array_function.out index ee85529dd24..a8b38ff8c67 100644 --- a/regression-test/data/doc/sql-manual/sql-function/test_array_function.out +++ b/regression-test/data/doc/sql-manual/sql-function/test_array_function.out @@ -295,58 +295,58 @@ false [0, 1] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- -[1.1, 3.3, 2.2] +[1.1, 2.2, 3.3] -- !sql -- -[3.3, 1.1, 2.2] +[1.1, 2.2, 3.3] -- !sql -- [1.10, 2.20, 3.30] -- !sql -- -[2.200, 1.100, 3.300] +[1.100, 2.200, 3.300] -- !sql -- [1.10000, 2.20000, 3.30000] -- !sql -- -[3.3000000, 2.2000000, 1.1000000] +[1.1000000, 2.2000000, 3.3000000] -- !sql -- -["world", "hello world", "hello"] +["hello", "hello world", "world"] -- !sql -- -["world", "hello world", "hello"] +["hello", "hello world", "world"] -- !sql -- -["world", "hello world", "hello"] +["hello", "hello world", "world"] -- !sql -- -["2021-01-01", "2021-01-03", "2021-01-02"] +["2021-01-01", "2021-01-02", "2021-01-03"] -- !sql -- -["2021-01-01 00:00:00", "2021-01-03 00:00:00", "2021-01-02 00:00:00"] +["2021-01-01 00:00:00", "2021-01-02 00:00:00", "2021-01-03 00:00:00"] -- !sql -- -["192.168.1.2", "192.168.1.1", "192.168.1.3"] +["192.168.1.1", "192.168.1.2", "192.168.1.3"] -- !sql -- -["::2", "::1", "::3"] +["::1", "::2", "::3"] -- !sql -- \N @@ -358,19 +358,19 @@ false \N -- !sql -- -[1, 5, 2, 6, 3] +[1, 2, 3, 5, 6] -- !sql -- -["world", "hello"] +["hello", "world"] -- !sql -- \N -- !sql -- -[null, "world", "hello"] +[null, "hello", "world"] -- !sql -- -[null, "world", "hello"] +[null, "hello", "world"] -- !sql -- 6 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 index f520e446c81..63f2b17b53c 100644 --- 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 @@ -3,113 +3,113 @@ 0 -- !q04_2 -- -46 +0 -- !q04_3 -- 46 -- !q04_4 -- -8 +46 -- !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 [...] +[{"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/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out index 6584aaabaf3..6da3414e648 100644 --- a/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out +++ b/regression-test/data/query_p0/sql_functions/array_functions/test_array_functions_by_literal.out @@ -465,7 +465,7 @@ false true -- !sql -- -[4, 1, 2, 3] +[1, 2, 3, 4] -- !sql -- [1] @@ -474,7 +474,7 @@ true [2, 3] -- !sql -- -[null, 4, 1, 2, 3] +[null, 1, 2, 3, 4] -- !sql -- [1] @@ -501,7 +501,7 @@ true [] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- [] @@ -510,7 +510,7 @@ true [] -- !sql -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [null] @@ -528,7 +528,7 @@ true [] -- !sql -- -["2023-02-06 22:07:34.999", "2023-02-04 23:07:34.999", "2023-02-07 22:07:34.999"] +["2023-02-04 23:07:34.999", "2023-02-06 22:07:34.999", "2023-02-07 22:07:34.999"] -- !sql -- ["2023-02-06 22:07:34.999"] @@ -537,7 +537,7 @@ true ["2023-02-04 23:07:34.999"] -- !sql -- -["2023-02-06", "2023-02-05", "2023-02-07"] +["2023-02-05", "2023-02-06", "2023-02-07"] -- !sql -- ["2023-02-06"] @@ -546,7 +546,7 @@ true ["2023-02-05"] -- !sql -- -[333.333, 222.222, 111.111] +[111.111, 222.222, 333.333] -- !sql -- [111.111] @@ -603,16 +603,16 @@ true [] -- !sql_union_1 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_2 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_3 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_4 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [2, 3, 4, 5, 6] @@ -1449,7 +1449,7 @@ false true -- !sql -- -[4, 1, 2, 3] +[1, 2, 3, 4] -- !sql -- [1] @@ -1458,7 +1458,7 @@ true [2, 3] -- !sql -- -[null, 4, 1, 2, 3] +[null, 1, 2, 3, 4] -- !sql -- [1] @@ -1485,7 +1485,7 @@ true [] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- [] @@ -1494,7 +1494,7 @@ true [] -- !sql -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [null] @@ -1512,7 +1512,7 @@ true [] -- !sql -- -["2023-02-06 22:07:34.999", "2023-02-04 23:07:34.999", "2023-02-07 22:07:34.999"] +["2023-02-04 23:07:34.999", "2023-02-06 22:07:34.999", "2023-02-07 22:07:34.999"] -- !sql -- ["2023-02-06 22:07:34.999"] @@ -1521,7 +1521,7 @@ true ["2023-02-04 23:07:34.999"] -- !sql -- -["2023-02-06", "2023-02-05", "2023-02-07"] +["2023-02-05", "2023-02-06", "2023-02-07"] -- !sql -- ["2023-02-06"] @@ -1530,7 +1530,7 @@ true ["2023-02-05"] -- !sql -- -[333.333, 222.222, 111.111] +[111.111, 222.222, 333.333] -- !sql -- [111.111] @@ -1587,16 +1587,16 @@ true [] -- !sql_union_1 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_2 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_3 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_4 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [2, 3, 4, 5, 6] @@ -2433,7 +2433,7 @@ false true -- !sql -- -[4, 1, 2, 3] +[1, 2, 3, 4] -- !sql -- [1] @@ -2442,7 +2442,7 @@ true [2, 3] -- !sql -- -[null, 4, 1, 2, 3] +[null, 1, 2, 3, 4] -- !sql -- [1] @@ -2469,7 +2469,7 @@ true [] -- !sql -- -[2, 1, 3] +[1, 2, 3] -- !sql -- [] @@ -2478,7 +2478,7 @@ true [] -- !sql -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [null] @@ -2496,7 +2496,7 @@ true [] -- !sql -- -["2023-02-06 22:07:34.999", "2023-02-04 23:07:34.999", "2023-02-07 22:07:34.999"] +["2023-02-04 23:07:34.999", "2023-02-06 22:07:34.999", "2023-02-07 22:07:34.999"] -- !sql -- ["2023-02-06 22:07:34.999"] @@ -2505,7 +2505,7 @@ true ["2023-02-04 23:07:34.999"] -- !sql -- -["2023-02-06", "2023-02-05", "2023-02-07"] +["2023-02-05", "2023-02-06", "2023-02-07"] -- !sql -- ["2023-02-06"] @@ -2514,7 +2514,7 @@ true ["2023-02-05"] -- !sql -- -[333.333, 222.222, 111.111] +[111.111, 222.222, 333.333] -- !sql -- [111.111] @@ -2571,16 +2571,16 @@ true [] -- !sql_union_1 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_2 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_3 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql_union_4 -- -[null, 2, 1, 3] +[null, 1, 2, 3] -- !sql -- [2, 3, 4, 5, 6] diff --git a/regression-test/suites/doc/sql-manual/sql-function/test_array_function.groovy b/regression-test/suites/doc/sql-manual/sql-function/test_array_function.groovy index 648c021322b..6f9f1f7b0e0 100644 --- a/regression-test/suites/doc/sql-manual/sql-function/test_array_function.groovy +++ b/regression-test/suites/doc/sql-manual/sql-function/test_array_function.groovy @@ -360,43 +360,43 @@ suite("test_array_function_doc", "p0") { qt_sql """ SELECT ARRAY_REPEAT(NULL, 'hello'); """ - qt_sql """ SELECT ARRAY_UNION(array_boolean, array_boolean) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_boolean, array_boolean)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_tinyint, array_tinyint) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_tinyint, array_tinyint)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_smallint, array_smallint) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_smallint, array_smallint)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_int, array_int) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_int, array_int)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_bigint, array_bigint) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_bigint, array_bigint)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_largeint, array_largeint) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_largeint, array_largeint)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_float, array_float) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_float, array_float)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_double, array_double) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_double, array_double)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_decimal32, array_decimal32) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_decimal32, array_decimal32)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_decimal64, array_decimal64) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_decimal64, array_decimal64)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_decimal128, array_decimal128) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_decimal128, array_decimal128)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_decimal256, array_decimal256) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_decimal256, array_decimal256)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_string, array_string) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_string, array_string)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_varchar, array_varchar) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_varchar, array_varchar)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_char, array_char) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_char, array_char)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_date, array_date) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_date, array_date)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_datetime, array_datetime) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_datetime, array_datetime)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_ipv4, array_ipv4) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_ipv4, array_ipv4)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_ipv6, array_ipv6) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_ipv6, array_ipv6)) from ${tableName}; """ test { sql """ SELECT ARRAY_UNION(array_struct, array_struct) from ${tableName}; """ @@ -413,21 +413,21 @@ suite("test_array_function_doc", "p0") { exception "array_union does not support types: ARRAY<MAP<TEXT,INT>>" } - qt_sql """ SELECT ARRAY_UNION(NULL, array_boolean) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(NULL, array_boolean)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(array_boolean, NULL) from ${tableName}; """ + qt_sql """ SELECT array_sort(ARRAY_UNION(array_boolean, NULL)) from ${tableName}; """ - qt_sql """ SELECT ARRAY_UNION(NULL, NULL); """ + qt_sql """ SELECT array_sort(ARRAY_UNION(NULL, NULL)); """ - qt_sql """ SELECT ARRAY_UNION(ARRAY(1, 2, 3), ARRAY(3, 5, 6)); """ + qt_sql """ SELECT array_sort(ARRAY_UNION(ARRAY(1, 2, 3), ARRAY(3, 5, 6))); """ - qt_sql """ SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', 'world')); """ + qt_sql """ SELECT array_sort(ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', 'world'))); """ - qt_sql """ SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', 'world'), NULL); """ + qt_sql """ SELECT array_sort(ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', 'world'), NULL)); """ - qt_sql """ SELECT ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL)); """ + qt_sql """ SELECT array_sort(ARRAY_UNION(ARRAY('hello', 'world'), ARRAY('hello', NULL))); """ - qt_sql """SELECT ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL)); """ + qt_sql """SELECT array_sort(ARRAY_UNION(ARRAY(NULL, 'world'), ARRAY('hello', NULL))); """ qt_sql """ SELECT ARRAY_SUM(array_tinyint) from ${tableName}; """ 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 index aa0d1f96e5c..e837f589bc0 100644 --- 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 @@ -1,3 +1,4 @@ +DROP TABLE IF EXISTS `table_100_undef_partitions2_keys3_properties4_distributed_by52`; CREATE TABLE `table_100_undef_partitions2_keys3_properties4_distributed_by52` ( `pk` int NULL, `col_array_boolean__undef_signed` array<boolean> NULL, @@ -125,4 +126,4 @@ INSERT INTO `table_100_undef_partitions2_keys3_properties4_distributed_by52` VAL 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 [...] +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_sort(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_invert [...] diff --git a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy index 4e885e0ce5e..b51a0b6bd6b 100644 --- a/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy +++ b/regression-test/suites/query_p0/sql_functions/array_functions/test_array_functions_by_literal.groovy @@ -199,34 +199,34 @@ suite("test_array_functions_by_literal") { qt_sql "select arrays_overlap(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" // array_binary function - qt_sql "select array_union([1,2,3], [2,3,4])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4]))" qt_sql "select array_except([1,2,3], [2,3,4])" qt_sql "select array_intersect([1,2,3], [2,3,4])" - qt_sql "select array_union([1,2,3], [2,3,4,null])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4,null]))" qt_sql "select array_except([1,2,3], [2,3,4,null])" qt_sql "select array_intersect([1,2,3], [2,3,4,null])" - qt_sql "select array_union([true], [false])" + qt_sql "select array_sort(array_union([true], [false]))" qt_sql "select array_except([true, false], [true])" qt_sql "select array_intersect([false, true], [false])" - qt_sql "select array_union([], [])" + qt_sql "select array_sort(array_union([], []))" qt_sql "select array_except([], [])" qt_sql "select array_intersect([], [])" - qt_sql "select array_union([], [1,2,3])" + qt_sql "select array_sort(array_union([], [1,2,3]))" qt_sql "select array_except([], [1,2,3])" qt_sql "select array_intersect([], [1,2,3])" - qt_sql "select array_union([null], [1,2,3])" + qt_sql "select array_sort(array_union([null], [1,2,3]))" qt_sql "select array_except([null], [1,2,3])" qt_sql "select array_intersect([null], [1,2,3])" - qt_sql "select array_union([1], [100000000])" + qt_sql "select array_sort(array_union([1], [100000000]))" qt_sql "select array_except([1], [100000000])" qt_sql "select array_intersect([1], [100000000])" - qt_sql "select array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3)))))" qt_sql "select array_except(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" qt_sql "select array_intersect(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" - qt_sql "select array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2))))" qt_sql "select array_except(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" qt_sql "select array_intersect(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" - qt_sql "select array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" + qt_sql "select array_sort(array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3)))))" qt_sql "select array_except(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" qt_sql "select array_intersect(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" @@ -251,10 +251,10 @@ suite("test_array_functions_by_literal") { qt_sql_intersect_4 "select array_intersect([1,2,3], [1,2,3], [null], [])" // array_union-with-multiple-arguments - qt_sql_union_1 "select array_union([1,2,3], [1,2,3], [null])" - qt_sql_union_2 "select array_union([1, 2, null], [1, 3, null], [1,2,3,null])" - qt_sql_union_3 "select array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null])" - qt_sql_union_4 "select array_union([1,2,3], [1,2,3], [null], [])" + qt_sql_union_1 "select array_sort(array_union([1,2,3], [1,2,3], [null]))" + qt_sql_union_2 "select array_sort(array_union([1, 2, null], [1, 3, null], [1,2,3,null]))" + qt_sql_union_3 "select array_sort(array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null]))" + qt_sql_union_4 "select array_sort(array_union([1,2,3], [1,2,3], [null], []))" // array_popfront function qt_sql "select array_popfront([1,2,3,4,5,6])" @@ -628,34 +628,34 @@ suite("test_array_functions_by_literal") { qt_sql "select arrays_overlap(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" // array_binary function - qt_sql "select array_union([1,2,3], [2,3,4])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4]))" qt_sql "select array_except([1,2,3], [2,3,4])" qt_sql "select array_intersect([1,2,3], [2,3,4])" - qt_sql "select array_union([1,2,3], [2,3,4,null])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4,null]))" qt_sql "select array_except([1,2,3], [2,3,4,null])" qt_sql "select array_intersect([1,2,3], [2,3,4,null])" - qt_sql "select array_union([true], [false])" + qt_sql "select array_sort(array_union([true], [false]))" qt_sql "select array_except([true, false], [true])" qt_sql "select array_intersect([false, true], [false])" - qt_sql "select array_union([], [])" + qt_sql "select array_sort(array_union([], []))" qt_sql "select array_except([], [])" qt_sql "select array_intersect([], [])" - qt_sql "select array_union([], [1,2,3])" + qt_sql "select array_sort(array_union([], [1,2,3]))" qt_sql "select array_except([], [1,2,3])" qt_sql "select array_intersect([], [1,2,3])" - qt_sql "select array_union([null], [1,2,3])" + qt_sql "select array_sort(array_union([null], [1,2,3]))" qt_sql "select array_except([null], [1,2,3])" qt_sql "select array_intersect([null], [1,2,3])" - qt_sql "select array_union([1], [100000000])" + qt_sql "select array_sort(array_union([1], [100000000]))" qt_sql "select array_except([1], [100000000])" qt_sql "select array_intersect([1], [100000000])" - qt_sql "select array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3)))))" qt_sql "select array_except(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" qt_sql "select array_intersect(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" - qt_sql "select array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2))))" qt_sql "select array_except(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" qt_sql "select array_intersect(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" - qt_sql "select array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" + qt_sql "select array_sort(array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3)))))" qt_sql "select array_except(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" qt_sql "select array_intersect(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" @@ -680,10 +680,10 @@ suite("test_array_functions_by_literal") { qt_sql_intersect_4 "select array_intersect([1,2,3], [1,2,3], [null], [])" // array_union-with-multiple-arguments - qt_sql_union_1 "select array_union([1,2,3], [1,2,3], [null])" - qt_sql_union_2 "select array_union([1, 2, null], [1, 3, null], [1,2,3,null])" - qt_sql_union_3 "select array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null])" - qt_sql_union_4 "select array_union([1,2,3], [1,2,3], [null], [])" + qt_sql_union_1 "select array_sort(array_union([1,2,3], [1,2,3], [null]))" + qt_sql_union_2 "select array_sort(array_union([1, 2, null], [1, 3, null], [1,2,3,null]))" + qt_sql_union_3 "select array_sort(array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null]))" + qt_sql_union_4 "select array_sort(array_union([1,2,3], [1,2,3], [null], []))" // array_popfront function qt_sql "select array_popfront([1,2,3,4,5,6])" @@ -1055,34 +1055,34 @@ suite("test_array_functions_by_literal") { qt_sql "select arrays_overlap(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" // array_binary function - qt_sql "select array_union([1,2,3], [2,3,4])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4]))" qt_sql "select array_except([1,2,3], [2,3,4])" qt_sql "select array_intersect([1,2,3], [2,3,4])" - qt_sql "select array_union([1,2,3], [2,3,4,null])" + qt_sql "select array_sort(array_union([1,2,3], [2,3,4,null]))" qt_sql "select array_except([1,2,3], [2,3,4,null])" qt_sql "select array_intersect([1,2,3], [2,3,4,null])" - qt_sql "select array_union([true], [false])" + qt_sql "select array_sort(array_union([true], [false]))" qt_sql "select array_except([true, false], [true])" qt_sql "select array_intersect([false, true], [false])" - qt_sql "select array_union([], [])" + qt_sql "select array_sort(array_union([], []))" qt_sql "select array_except([], [])" qt_sql "select array_intersect([], [])" - qt_sql "select array_union([], [1,2,3])" + qt_sql "select array_sort(array_union([], [1,2,3]))" qt_sql "select array_except([], [1,2,3])" qt_sql "select array_intersect([], [1,2,3])" - qt_sql "select array_union([null], [1,2,3])" + qt_sql "select array_sort(array_union([null], [1,2,3]))" qt_sql "select array_except([null], [1,2,3])" qt_sql "select array_intersect([null], [1,2,3])" - qt_sql "select array_union([1], [100000000])" + qt_sql "select array_sort(array_union([1], [100000000]))" qt_sql "select array_except([1], [100000000])" qt_sql "select array_intersect([1], [100000000])" - qt_sql "select array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3)))))" qt_sql "select array_except(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" qt_sql "select array_intersect(array(cast ('2023-02-06 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))),array(cast ('2023-02-07 22:07:34.999' as datetimev2(3)),cast ('2023-02-04 23:07:34.999' as datetimev2(3))))" - qt_sql "select array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" + qt_sql "select array_sort(array_union(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2))))" qt_sql "select array_except(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" qt_sql "select array_intersect(array(cast ('2023-02-06' as datev2), cast ('2023-02-05' as datev2)), array(cast ('2023-02-07' as datev2), cast ('2023-02-05' as datev2)))" - qt_sql "select array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" + qt_sql "select array_sort(array_union(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3)))))" qt_sql "select array_except(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" qt_sql "select array_intersect(array(cast (111.111 as decimalv3(6,3)),cast (222.222 as decimalv3(6,3))), array(cast (222.222 as decimalv3(6,3)),cast (333.333 as decimalv3(6,3))))" @@ -1107,10 +1107,10 @@ suite("test_array_functions_by_literal") { qt_sql_intersect_4 "select array_intersect([1,2,3], [1,2,3], [null], [])" // array_union-with-multiple-arguments - qt_sql_union_1 "select array_union([1,2,3], [1,2,3], [null])" - qt_sql_union_2 "select array_union([1, 2, null], [1, 3, null], [1,2,3,null])" - qt_sql_union_3 "select array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null])" - qt_sql_union_4 "select array_union([1,2,3], [1,2,3], [null], [])" + qt_sql_union_1 "select array_sort(array_union([1,2,3], [1,2,3], [null]))" + qt_sql_union_2 "select array_sort(array_union([1, 2, null], [1, 3, null], [1,2,3,null]))" + qt_sql_union_3 "select array_sort(array_union([1,2,3, null], [1,2,3,null], [1,2,null], [1, null]))" + qt_sql_union_4 "select array_sort(array_union([1,2,3], [1,2,3], [null], []))" // array_popfront function qt_sql "select array_popfront([1,2,3,4,5,6])" --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
