This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new d3f9f9b6104 [fix](stream_load)streamload with double quotes #27942
(#39634)
d3f9f9b6104 is described below
commit d3f9f9b6104861a67d7f76fa8abe2349b614bc3d
Author: amory <[email protected]>
AuthorDate: Mon Sep 23 17:48:30 2024 +0800
[fix](stream_load)streamload with double quotes #27942 (#39634)
---
be/src/util/slice.h | 4 +--
.../data_types/serde/data_type_serde_text_test.cpp | 4 +--
.../load_p0/stream_load/csv_with_double_quotes.csv | 1 +
.../stream_load/test_csv_with_double_quotes.out | 2 ++
.../stream_load/test_stream_load_properties.out | 42 +++++++++++-----------
5 files changed, 28 insertions(+), 25 deletions(-)
diff --git a/be/src/util/slice.h b/be/src/util/slice.h
index 0c5c16d7141..7259bff1716 100644
--- a/be/src/util/slice.h
+++ b/be/src/util/slice.h
@@ -168,8 +168,8 @@ public:
bool trim_quote() {
int32_t begin = 0;
bool change = false;
- if (size > 2 && ((data[begin] == '"' && data[size - 1] == '"') ||
- (data[begin] == '\'' && data[size - 1] == '\''))) {
+ if (size >= 2 && ((data[begin] == '"' && data[size - 1] == '"') ||
+ (data[begin] == '\'' && data[size - 1] == '\''))) {
data += 1;
size -= 2;
change = true;
diff --git a/be/test/vec/data_types/serde/data_type_serde_text_test.cpp
b/be/test/vec/data_types/serde/data_type_serde_text_test.cpp
index 09a98819d8b..942e1b9c23d 100644
--- a/be/test/vec/data_types/serde/data_type_serde_text_test.cpp
+++ b/be/test/vec/data_types/serde/data_type_serde_text_test.cpp
@@ -486,8 +486,8 @@ TEST(TextSerde, ComplexTypeSerdeTextTest) {
"{\"hello "
"world\":0.2222222,\"hello2\":null,null:1111.1,\"NULL\":null,\"null\":"
"null,\"null\":0.1}"},
- {"{ ,.amory:111.2343, \"\":112, dggs:13.14,
NULL:12.2222222, :NULL}",
- "{\"\":NULL, NULL:12.44}", "{}", "{}", "NULL", "{}",
"NULL",
+ {"{ ,.amory:111.2343, :112, dggs:13.14,
NULL:12.2222222, :NULL}",
+ "{:NULL, NULL:12.44}", "{}", "{}", "NULL", "{}",
"NULL",
"{NULL:NULL, null:NULL}",
"{hello world:0.2222222, hello2:NULL, NULL:1111.1,
NULL:NULL, null:NULL, "
"null:0.1}"}),
diff --git
a/regression-test/data/load_p0/stream_load/csv_with_double_quotes.csv
b/regression-test/data/load_p0/stream_load/csv_with_double_quotes.csv
index 44ae3f4550f..e3bfb17c43a 100644
--- a/regression-test/data/load_p0/stream_load/csv_with_double_quotes.csv
+++ b/regression-test/data/load_p0/stream_load/csv_with_double_quotes.csv
@@ -6,3 +6,4 @@
"6","7","3","abc","2022-12-01","2022-12-01:09:30:31"
"7","8","3","abc","2022-12-01","2022-12-01:09:30:31"
"8","9","3","abc","2022-12-01","2022-12-01:09:30:31"
+"2","","","",2023-07-15,"2023-07-20:05:48:31"
diff --git
a/regression-test/data/load_p0/stream_load/test_csv_with_double_quotes.out
b/regression-test/data/load_p0/stream_load/test_csv_with_double_quotes.out
index 0ae5ebe7f7a..924f0b9a51f 100644
--- a/regression-test/data/load_p0/stream_load/test_csv_with_double_quotes.out
+++ b/regression-test/data/load_p0/stream_load/test_csv_with_double_quotes.out
@@ -1,5 +1,6 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
-- !sql --
+\N \N \N "" 2023-07-15 \N
\N \N \N "abc" \N \N
\N \N \N "abc" \N \N
\N \N \N "abc" \N \N
@@ -11,6 +12,7 @@
-- !sql --
1 2 3 abc 2022-12-01 2022-12-01T09:30:31
+2 \N \N 2023-07-15 2023-07-20T05:48:31
2 3 3 abc 2022-12-01 2022-12-01T09:30:31
3 4 3 abc 2022-12-01 2022-12-01T09:30:31
4 5 3 abc 2022-12-01 2022-12-01T09:30:31
diff --git
a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
index b4219a11cd5..53db777f241 100644
--- a/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
+++ b/regression-test/data/load_p0/stream_load/test_stream_load_properties.out
@@ -266,50 +266,50 @@
85 2023-08-11 true -7 24304 -2043877415
-2024144417867729183 \N 5363.0244 -5.78615669042831E8
-99999999.9 -99999999.9 2023-07-15T01:07:41 2023-08-13
2023-01-20T11:57:48 i WQ9dh9ajPu0y
{"country":"France","capital":"Paris","population":67081000} \N \N
\N true 1 2 3 4 5 6.0 7.0
888888888 999999999 2023-08-24 2023-08-24T12:00
2023-08-24 2023-08-24T12:00 我能吞下玻璃而不伤身体 我能吞下玻璃而不伤身体
我能吞下玻璃而不伤身体 \N \N \N \N
-- !sql_max_filter_ratio --
-2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
+2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
3 [0, 0, 0, 0, 0, 0] [65, 65, 65, 65, 65, 65] [-4963, -4963,
-4963, -4963, -4963, -4963] [-1415431954, -1415431954, -1415431954,
-1415431954, -1415431954, -1415431954] [-3804309860450207000,
-3804309860450207000, -3804309860450207000, -3804309860450207000,
-3804309860450207000, -3804309860450207000] [8209240008557215376,
8209240008557215376, 8209240008557215376, 8209240008557215376,
8209240008557215376, 8209240008557215376] [-5058.13, -5058.13, -5058.13,
-5058.13, -5058.13] [1034763010.6 [...]
-4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
+4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
4 [0, 0, 0, 0, 0, 0] [63, 63, 63, 63, 63, 63] [11399, 11399,
11399, 11399, 11399, 11399] [-583523026, -583523026, -583523026,
-583523026, -583523026, -583523026] [8801164674137231293,
8801164674137231293, 8801164674137231293, 8801164674137231293,
8801164674137231293, 8801164674137231293] [-8287675635310193906,
-8287675635310193906, -8287675635310193906, -8287675635310193906,
-8287675635310193906, -8287675635310193906] [23243.16, 23243.16, 23243.16,
23243.16, 23243.16] [716719993.249115, [...]
8 [1, 1, 1, 1, 1, 1] [-11, -11, -11, -11, -11, -11] [-9648, -9648,
-9648, -9648, -9648, -9648] [-505356927, -505356927, -505356927,
-505356927, -505356927, -505356927] [7604760670442035037,
7604760670442035037, 7604760670442035037, 7604760670442035037,
7604760670442035037, 7604760670442035037] [1634770507625165798,
1634770507625165798, 1634770507625165798, 1634770507625165798,
1634770507625165798, 1634770507625165798] [10822.962, 10822.962, 10822.962,
10822.962, 10822.962] [1987551048.86 [...]
-16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
+16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
16 [1, 1, 1, 1, 1, 1] [-7, -7, -7, -7, -7, -7] [18655, 18655,
18655, 18655, 18655, 18655] [6240356, 6240356, 6240356, 6240356, 6240356,
6240356] [4552179257266841393, 4552179257266841393, 4552179257266841393,
4552179257266841393, 4552179257266841393, 4552179257266841393]
[323868824766329978, 323868824766329978, 323868824766329978,
323868824766329978, 323868824766329978, 323868824766329978] [2972.2478,
2972.2478, 2972.2478, 2972.2478, 2972.2478] [-1177167334.995008,
-1177167334.995008, -1 [...]
-17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
-41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
+17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
+41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
44 [0, 0, 0, 0, 0, 0] [61, 61, 61, 61, 61, null] [-23419,
-23419, -23419, -23419, -23419, -23419] [378600280, 378600280,
378600280, 378600280, 378600280, 378600280] [6788166268039991679,
6788166268039991679, 6788166268039991679, 6788166268039991679,
6788166268039991679, 6788166268039991679] [-2814786606977504852,
-2814786606977504852, -2814786606977504852, -2814786606977504852,
-2814786606977504852, -2814786606977504852] [-20151.432, -20151.432,
-20151.432, -20151.432, -20151.432] [-1248 [...]
48 [0, 0, 0, 0, 0, null] [88, 88, 88, 88, 88, 88] [-18899,
-18899, -18899, -18899, -18899, -18899] [1953750640, 1953750640,
1953750640, 1953750640, 1953750640, 1953750640] [-6083034186246180312,
-6083034186246180312, -6083034186246180312, -6083034186246180312,
-6083034186246180312, -6083034186246180312] [7861718260607212662,
7861718260607212662, 7861718260607212662, 7861718260607212662,
7861718260607212662, 7861718260607212662] [20562.791, 20562.791, 20562.791,
20562.791, 20562.791] [-15 [...]
49 [0, 0, 0, 0, 0, 0] [126, 126, 126, 126, 126, 126] [31661, 31661,
31661, 31661, 31661, 31661] [359703581, 359703581, 359703581, 359703581,
359703581, 359703581] [-2399575246807057939, -2399575246807057939,
-2399575246807057939, -2399575246807057939, -2399575246807057939,
-2399575246807057939] [7684667782059034391, 7684667782059034391,
7684667782059034391, 7684667782059034391, 7684667782059034391,
7684667782059034391] [-504.68152, -504.68152, -504.68152, -504.68152,
-504.68152] [2121528 [...]
-52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
-61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
+52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
+61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
76 [1, 1, 1, 1, 1, 1] [-63, -63, -63, -63, -63, -63] [25799, 25799,
25799, 25799, 25799, 25799] [-1387912656, -1387912656, -1387912656,
-1387912656, -1387912656, -1387912656] [8967926767558546181,
8967926767558546181, 8967926767558546181, 8967926767558546181,
8967926767558546181, 8967926767558546181] [-3537865898119184476,
-3537865898119184476, -3537865898119184476, -3537865898119184476,
-3537865898119184476, -3537865898119184476] [5311.188, 5311.188, 5311.188,
5311.188, 5311.188] [17362 [...]
-- !sql_max_filter_ratio --
-2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
+2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
3 [0, 0, 0, 0, 0, 0] [65, 65, 65, 65, 65, 65] [-4963, -4963,
-4963, -4963, -4963, -4963] [-1415431954, -1415431954, -1415431954,
-1415431954, -1415431954, -1415431954] [-3804309860450207000,
-3804309860450207000, -3804309860450207000, -3804309860450207000,
-3804309860450207000, -3804309860450207000] [8209240008557215376,
8209240008557215376, 8209240008557215376, 8209240008557215376,
8209240008557215376, 8209240008557215376] [-5058.13, -5058.13, -5058.13,
-5058.13, -5058.13] [1034763010.6 [...]
-4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
+4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
8 [1, 1, 1, 1, 1, 1] [-11, -11, -11, -11, -11, -11] [-9648, -9648,
-9648, -9648, -9648, -9648] [-505356927, -505356927, -505356927,
-505356927, -505356927, -505356927] [7604760670442035037,
7604760670442035037, 7604760670442035037, 7604760670442035037,
7604760670442035037, 7604760670442035037] [1634770507625165798,
1634770507625165798, 1634770507625165798, 1634770507625165798,
1634770507625165798, 1634770507625165798] [10822.962, 10822.962, 10822.962,
10822.962, 10822.962] [1987551048.86 [...]
-16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
-17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
-41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
+16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
+17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
+41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
44 [0, 0, 0, 0, 0, 0] [61, 61, 61, 61, 61, null] [-23419,
-23419, -23419, -23419, -23419, -23419] [378600280, 378600280,
378600280, 378600280, 378600280, 378600280] [6788166268039991679,
6788166268039991679, 6788166268039991679, 6788166268039991679,
6788166268039991679, 6788166268039991679] [-2814786606977504852,
-2814786606977504852, -2814786606977504852, -2814786606977504852,
-2814786606977504852, -2814786606977504852] [-20151.432, -20151.432,
-20151.432, -20151.432, -20151.432] [-1248 [...]
48 [0, 0, 0, 0, 0, null] [88, 88, 88, 88, 88, 88] [-18899,
-18899, -18899, -18899, -18899, -18899] [1953750640, 1953750640,
1953750640, 1953750640, 1953750640, 1953750640] [-6083034186246180312,
-6083034186246180312, -6083034186246180312, -6083034186246180312,
-6083034186246180312, -6083034186246180312] [7861718260607212662,
7861718260607212662, 7861718260607212662, 7861718260607212662,
7861718260607212662, 7861718260607212662] [20562.791, 20562.791, 20562.791,
20562.791, 20562.791] [-15 [...]
49 [0, 0, 0, 0, 0, 0] [126, 126, 126, 126, 126, 126] [31661, 31661,
31661, 31661, 31661, 31661] [359703581, 359703581, 359703581, 359703581,
359703581, 359703581] [-2399575246807057939, -2399575246807057939,
-2399575246807057939, -2399575246807057939, -2399575246807057939,
-2399575246807057939] [7684667782059034391, 7684667782059034391,
7684667782059034391, 7684667782059034391, 7684667782059034391,
7684667782059034391] [-504.68152, -504.68152, -504.68152, -504.68152,
-504.68152] [2121528 [...]
-52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
-61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
+52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
+61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
76 [1, 1, 1, 1, 1, 1] [-63, -63, -63, -63, -63, -63] [25799, 25799,
25799, 25799, 25799, 25799] [-1387912656, -1387912656, -1387912656,
-1387912656, -1387912656, -1387912656] [8967926767558546181,
8967926767558546181, 8967926767558546181, 8967926767558546181,
8967926767558546181, 8967926767558546181] [-3537865898119184476,
-3537865898119184476, -3537865898119184476, -3537865898119184476,
-3537865898119184476, -3537865898119184476] [5311.188, 5311.188, 5311.188,
5311.188, 5311.188] [17362 [...]
-- !sql_max_filter_ratio --
-2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
+2 [0, 0, 0, 0, 0, 0] [117, 117, 117, 117, 117, 117] [-4744, -4744,
-4744, -4744, -4744, -4744] [-1593211961, -1593211961, -1593211961,
-1593211961, -1593211961, -1593211961] [-3869640069299678780,
-3869640069299678780, -3869640069299678780, -3869640069299678780,
-3869640069299678780, -3869640069299678780] [8491817458398170567,
8491817458398170567, 8491817458398170567, 8491817458398170567,
8491817458398170567, 8491817458398170567] [-30948.857, -30948.857, -30948.857,
-30948.857, -30948.85 [...]
3 [0, 0, 0, 0, 0, 0] [65, 65, 65, 65, 65, 65] [-4963, -4963,
-4963, -4963, -4963, -4963] [-1415431954, -1415431954, -1415431954,
-1415431954, -1415431954, -1415431954] [-3804309860450207000,
-3804309860450207000, -3804309860450207000, -3804309860450207000,
-3804309860450207000, -3804309860450207000] [8209240008557215376,
8209240008557215376, 8209240008557215376, 8209240008557215376,
8209240008557215376, 8209240008557215376] [-5058.13, -5058.13, -5058.13,
-5058.13, -5058.13] [1034763010.6 [...]
-4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
+4 [0, 0, 0, 0, 0, 0] [-67, -67, -67, -67, -67, -67] [-30372,
-30372, -30372, -30372, -30372, -30372] [181502941, 181502941,
181502941, 181502941, 181502941, 181502941] [-2062236823576972800,
-2062236823576972800, -2062236823576972800, -2062236823576972800,
-2062236823576972800, -2062236823576972800] [6357002962400127842,
6357002962400127842, 6357002962400127842, 6357002962400127842,
6357002962400127842, 6357002962400127842] [21235.783, 21235.783, 21235.783,
21235.783, 21235.783] [-110169 [...]
8 [1, 1, 1, 1, 1, 1] [-11, -11, -11, -11, -11, -11] [-9648, -9648,
-9648, -9648, -9648, -9648] [-505356927, -505356927, -505356927,
-505356927, -505356927, -505356927] [7604760670442035037,
7604760670442035037, 7604760670442035037, 7604760670442035037,
7604760670442035037, 7604760670442035037] [1634770507625165798,
1634770507625165798, 1634770507625165798, 1634770507625165798,
1634770507625165798, 1634770507625165798] [10822.962, 10822.962, 10822.962,
10822.962, 10822.962] [1987551048.86 [...]
-16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
-17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
-41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
+16 [0, 0, 0, 0, 0, 0] [-43, -43, -43, -43, -43, -43] [13560, 13560,
13560, 13560, 13560, 13560] [-1743686513, -1743686513, -1743686513,
-1743686513, -1743686513, -1743686513] [7234719406392208769,
7234719406392208769, 7234719406392208769, 7234719406392208769,
7234719406392208769, 7234719406392208769] [-3871745630024229413,
-3871745630024229413, -3871745630024229413, -3871745630024229413,
-3871745630024229413, -3871745630024229413] [12225.427, 12225.427,
12225.427, 12225.427, 12225.427] [ [...]
+17 [1, 1, 1, 1, 1, 1] [126, 126, 126, 126, 126, 126] [28165, 28165,
28165, 28165, 28165, 28165] [2032059721, 2032059721, 2032059721,
2032059721, 2032059721, 2032059721] [-2686776977990574879,
-2686776977990574879, -2686776977990574879, -2686776977990574879,
-2686776977990574879, -2686776977990574879] [-8498149444423102876,
-8498149444423102876, -8498149444423102876, -8498149444423102876,
-8498149444423102876, -8498149444423102876] [-21681.223, -21681.223,
-21681.223, -21681.223, -21681.2 [...]
+41 [0, 0, 0, 0, 0, 0] [-25, -25, -25, -25, -25, -25] [28704, 28704,
28704, 28704, 28704, 28704] [-437867812, -437867812, -437867812,
-437867812, -437867812, -437867812] [5508042206505207079,
5508042206505207079, 5508042206505207079, 5508042206505207079,
5508042206505207079, 5508042206505207079] [462527544684407597,
462527544684407597, 462527544684407597, 462527544684407597, 462527544684407597,
462527544684407597] [13629.614, 13629.614, 13629.614, 13629.614,
13629.614] [213722401.337962, [...]
44 [0, 0, 0, 0, 0, 0] [61, 61, 61, 61, 61, null] [-23419,
-23419, -23419, -23419, -23419, -23419] [378600280, 378600280,
378600280, 378600280, 378600280, 378600280] [6788166268039991679,
6788166268039991679, 6788166268039991679, 6788166268039991679,
6788166268039991679, 6788166268039991679] [-2814786606977504852,
-2814786606977504852, -2814786606977504852, -2814786606977504852,
-2814786606977504852, -2814786606977504852] [-20151.432, -20151.432,
-20151.432, -20151.432, -20151.432] [-1248 [...]
48 [0, 0, 0, 0, 0, null] [88, 88, 88, 88, 88, 88] [-18899,
-18899, -18899, -18899, -18899, -18899] [1953750640, 1953750640,
1953750640, 1953750640, 1953750640, 1953750640] [-6083034186246180312,
-6083034186246180312, -6083034186246180312, -6083034186246180312,
-6083034186246180312, -6083034186246180312] [7861718260607212662,
7861718260607212662, 7861718260607212662, 7861718260607212662,
7861718260607212662, 7861718260607212662] [20562.791, 20562.791, 20562.791,
20562.791, 20562.791] [-15 [...]
49 [0, 0, 0, 0, 0, 0] [126, 126, 126, 126, 126, 126] [31661, 31661,
31661, 31661, 31661, 31661] [359703581, 359703581, 359703581, 359703581,
359703581, 359703581] [-2399575246807057939, -2399575246807057939,
-2399575246807057939, -2399575246807057939, -2399575246807057939,
-2399575246807057939] [7684667782059034391, 7684667782059034391,
7684667782059034391, 7684667782059034391, 7684667782059034391,
7684667782059034391] [-504.68152, -504.68152, -504.68152, -504.68152,
-504.68152] [2121528 [...]
-52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
-61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
+52 [0, 0, 0, 0, 0, 0] [-7, -7, -7, -7, -7, -7] [-6985, -6985,
-6985, -6985, -6985, -6985] [826683531, 826683531, 826683531, 826683531,
826683531, 826683531] [-8966681855246736361, -8966681855246736361,
-8966681855246736361, -8966681855246736361, -8966681855246736361,
-8966681855246736361] [4814686163176635446, 4814686163176635446,
4814686163176635446, 4814686163176635446, 4814686163176635446,
4814686163176635446] [-6490.2471, -6490.2471, -6490.2471, -6490.2471,
-6490.2471] [1076976372.03 [...]
+61 [1, 1, 1, 1, 1, 1] [121, 121, 121, 121, 121, 121] [31806, 31806,
31806, 31806, 31806, 31806] [-1410915562, -1410915562, -1410915562,
-1410915562, -1410915562, -1410915562] [-250403393155768717,
-250403393155768717, -250403393155768717, -250403393155768717,
-250403393155768717, -250403393155768717] [4301573778529723431,
4301573778529723431, 4301573778529723431, 4301573778529723431,
4301573778529723431, 4301573778529723431] [10719.892, 10719.892, 10719.892,
10719.892, 10719.892] [107378 [...]
76 [1, 1, 1, 1, 1, 1] [-63, -63, -63, -63, -63, -63] [25799, 25799,
25799, 25799, 25799, 25799] [-1387912656, -1387912656, -1387912656,
-1387912656, -1387912656, -1387912656] [8967926767558546181,
8967926767558546181, 8967926767558546181, 8967926767558546181,
8967926767558546181, 8967926767558546181] [-3537865898119184476,
-3537865898119184476, -3537865898119184476, -3537865898119184476,
-3537865898119184476, -3537865898119184476] [5311.188, 5311.188, 5311.188,
5311.188, 5311.188] [17362 [...]
-- !sql_squence --
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
