This is an automated email from the ASF dual-hosted git repository.

morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 11afd321cb [fix](es catalog) fix issue with select and insert from es 
catalog core (#24318)
11afd321cb is described below

commit 11afd321cb0d75f4eff66ad645ecb19ea125a846
Author: qiye <jianliang5...@gmail.com>
AuthorDate: Wed Sep 13 23:07:31 2023 +0800

    [fix](es catalog) fix issue with select and insert from es catalog core 
(#24318)
    
    Issue Number: close #24315
    
    The root cause of this issue is that Elasticsearch's long type allows 
inserting floats and strings. Doris did not handle these cases when doing type 
conversion. The current strategy is to take the integer before the decimal 
point if a float or string is found.
---
 be/src/exec/es/es_scroll_parser.cpp                | 21 ++++++++++--
 .../elasticsearch/scripts/data/data1.json          |  3 +-
 .../elasticsearch/scripts/data/data1_es6.json      |  3 +-
 .../elasticsearch/scripts/data/data2.json          |  3 +-
 .../elasticsearch/scripts/data/data2_es6.json      |  3 +-
 .../elasticsearch/scripts/data/data3.json          |  3 +-
 .../elasticsearch/scripts/data/data3_es6.json      |  3 +-
 .../elasticsearch/scripts/data/data4.json          |  3 +-
 .../elasticsearch/scripts/index/es6_test1.json     |  5 ++-
 .../elasticsearch/scripts/index/es6_test2.json     |  5 ++-
 .../elasticsearch/scripts/index/es7_test1.json     |  5 ++-
 .../elasticsearch/scripts/index/es7_test2.json     |  5 ++-
 .../data/external_table_p0/es/test_es_query.out    | 38 +++++++++++-----------
 .../es/test_es_query_no_http_url.out               |  6 ++--
 14 files changed, 70 insertions(+), 36 deletions(-)

diff --git a/be/src/exec/es/es_scroll_parser.cpp 
b/be/src/exec/es/es_scroll_parser.cpp
index de1209a00c..34397b8468 100644
--- a/be/src/exec/es/es_scroll_parser.cpp
+++ b/be/src/exec/es/es_scroll_parser.cpp
@@ -347,7 +347,16 @@ template <typename T>
 Status insert_int_value(const rapidjson::Value& col, PrimitiveType type,
                         vectorized::IColumn* col_ptr, bool pure_doc_value, 
bool nullable) {
     if (col.IsNumber()) {
-        T value = (T)(sizeof(T) < 8 ? col.GetInt() : col.GetInt64());
+        T value;
+        // ES allows inserting float and double in int/long types.
+        // To parse these numbers in Doris, we direct cast them to int types.
+        if (col.IsDouble()) {
+            value = static_cast<T>(col.GetDouble());
+        } else if (col.IsFloat()) {
+            value = static_cast<T>(col.GetFloat());
+        } else {
+            value = (T)(sizeof(T) < 8 ? col.GetInt() : col.GetInt64());
+        }
         col_ptr->insert_data(const_cast<const 
char*>(reinterpret_cast<char*>(&value)), 0);
         return Status::OK();
     }
@@ -363,8 +372,14 @@ Status insert_int_value(const rapidjson::Value& col, 
PrimitiveType type,
     RETURN_ERROR_IF_COL_IS_NOT_STRING(col, type);
 
     StringParser::ParseResult result;
-    const std::string& val = col.GetString();
-    size_t len = col.GetStringLength();
+    std::string val = col.GetString();
+    // ES allows inserting numbers and characters containing decimals in 
numeric types.
+    // To parse these numbers in Doris, we remove the decimals here.
+    size_t pos = val.find(".");
+    if (pos != std::string::npos) {
+        val = val.substr(0, pos);
+    }
+    size_t len = val.length();
     T v = StringParser::string_to_int<T>(val.c_str(), len, &result);
     RETURN_ERROR_IF_PARSING_FAILED(result, col, type);
 
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1.json
index 0302467868..72984ed360 100755
--- a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1.json
+++ b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1.json
@@ -7,6 +7,7 @@
   "test6": 1659931810000,
   "test7": 1659931810000,
   "test8": "2022-08-08T12:10:10Z",
+  "test9": 12345,
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -26,4 +27,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1_es6.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1_es6.json
index 30e91abe62..f53336db0b 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1_es6.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data1_es6.json
@@ -3,6 +3,7 @@
   "test2": "text#1",
   "test3": 3.14,
   "test4": "2022-08-08",
+  "test5": 12345,
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -22,4 +23,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2.json
index c6f7d3e2f6..07ba275a8a 100755
--- a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2.json
+++ b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2.json
@@ -7,6 +7,7 @@
   "test6": 1660018210000,
   "test7": "2022-08-09 12:10:10",
   "test8": 1660018210000,
+  "test9": 2222.2,
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -26,4 +27,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2_es6.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2_es6.json
index 1481200c46..80ba73539b 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2_es6.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data2_es6.json
@@ -3,6 +3,7 @@
   "test2": "text2",
   "test3": 4,
   "test4": "2022-08-08",
+  "test5": 2222.2,
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -22,4 +23,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3.json
index 73631d8261..c5ef6fb675 100755
--- a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3.json
+++ b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3.json
@@ -7,6 +7,7 @@
   "test6": 1660104610000,
   "test7": 1660104610000,
   "test8": "2022-08-10T12:10:10",
+  "test9": 3333.22,
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -26,4 +27,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3_es6.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3_es6.json
index 90f7d636fa..f467c3b31f 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3_es6.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data3_es6.json
@@ -3,6 +3,7 @@
   "test2": "text3_4*5",
   "test3": 5.0,
   "test4": "2022-08-08",
+  "test5": "3333.22",
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -22,4 +23,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data4.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data4.json
index 954ca884d6..d58882150f 100755
--- a/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data4.json
+++ b/docker/thirdparties/docker-compose/elasticsearch/scripts/data/data4.json
@@ -7,6 +7,7 @@
   "test6": 1660191010000,
   "test7": "2022-08-11 12:10:10",
   "test8": "2022-08-11T12:10:10+09:00",
+  "test9": "4444.22",
   "c_bool": [true, false, true, true],
   "c_byte": [1, -2, -3, 4],
   "c_short": [128, 129, -129, -130],
@@ -26,4 +27,4 @@
     {"name": "Andy", "age": 18},
     {"name": "Tim", "age": 28}
   ]
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test1.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test1.json
index 6019fa99bd..a9863d8993 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test1.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test1.json
@@ -24,6 +24,9 @@
         "test4": {
           "type": "date"
         },
+        "test5": {
+          "type": "long"
+        },
         "c_bool": {
           "type": "boolean"
         },
@@ -85,4 +88,4 @@
       }
     }
   }
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test2.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test2.json
index 1ab8e8fdcb..f29f305225 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test2.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es6_test2.json
@@ -27,6 +27,9 @@
         "test4": {
           "type": "date"
         },
+        "test5": {
+          "type": "long"
+        },
         "c_bool": {
           "type": "boolean"
         },
@@ -88,4 +91,4 @@
       }
     }
   }
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test1.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test1.json
index 4f49a1db8b..9ad548d48c 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test1.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test1.json
@@ -38,6 +38,9 @@
       "test8": {
         "type": "date"
       },
+      "test9": {
+        "type": "long"
+      },
       "c_bool": {
         "type": "boolean"
       },
@@ -98,4 +101,4 @@
       }
     }
   }
-}
\ No newline at end of file
+}
diff --git 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test2.json 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test2.json
index 166331f5cc..4532e400e5 100755
--- 
a/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test2.json
+++ 
b/docker/thirdparties/docker-compose/elasticsearch/scripts/index/es7_test2.json
@@ -41,6 +41,9 @@
       "test8": {
         "type": "date"
       },
+      "test9": {
+        "type": "long"
+      },
       "c_bool": {
         "type": "boolean"
       },
@@ -101,4 +104,4 @@
       }
     }
   }
-}
\ No newline at end of file
+}
diff --git a/regression-test/data/external_table_p0/es/test_es_query.out 
b/regression-test/data/external_table_p0/es/test_es_query.out
index c55b4dce3f..b20cb439f4 100644
--- a/regression-test/data/external_table_p0/es/test_es_query.out
+++ b/regression-test/data/external_table_p0/es/test_es_query.out
@@ -24,15 +24,15 @@
 2022-08-08     2022-08-11T12:10:10     2022-08-11T12:10:10     
2022-08-11T12:10:10     2022-08-11T11:10:10
 
 -- !sql62 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        12345
 
 -- !sql63 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        12345
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        2222
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00        
3333
 
 -- !sql64 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        2222
 
 -- !sql65 --
 true   1       128     32768   -1      0       1.0     1       1       1       
2020-01-01T00:00        2020-01-01 12:00:00     a       d       192.168.0.1     
{"name":"Andy","age":18}
@@ -45,7 +45,7 @@ true  1       128     32768   -1      0       1.0     1       
1       1       2020-01-01T00:00        2020-01-01 12:00:00     a       d       
192.168
 true   1       128     32768   -1      0       1.0     1       1       1       
2020-01-01T00:00        2020-01-01 12:00:00     a       d       192.168.0.1     
{"name":"Andy","age":18}
 
 -- !sql67 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        12345
 
 -- !sql68 --
 [1, 0, 1, 1]   [1, -2, -3, 4]  [128, 129, -129, -130]  [32768, 32769, -32769, 
-32770]  [-1, 0, 1, 2]   [0, 1, 2, 3]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]   
 [1, 2, 3, 4]    [1, 2, 3, 4]    [2020-01-01 00:00:00, 2020-01-02 00:00:00]     
 ["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  ["a", "b", "c"] ["d", "e", 
"f"] ["192.168.0.1", "127.0.0.1"]    ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"]
@@ -58,16 +58,16 @@ true        1       128     32768   -1      0       1.0     
1       1       1       2020-01-01T00:00        2020-01-01 12:00:00     a       
d       192.168
 [1, 0, 1, 1]   [1, -2, -3, 4]  [128, 129, -129, -130]  [32768, 32769, -32769, 
-32770]  [-1, 0, 1, 2]   [0, 1, 2, 3]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]   
 [1, 2, 3, 4]    [1, 2, 3, 4]    [2020-01-01 00:00:00, 2020-01-02 00:00:00]     
 ["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  ["a", "b", "c"] ["d", "e", 
"f"] ["192.168.0.1", "127.0.0.1"]    ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"]
 
 -- !sql72 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 
 -- !sql73 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00        
2022-08-10T12:10:10     1660104610000   2022-08-10T12:10:10     
2022-08-10T20:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string4 text3_4*5       6.0     2022-08-08T00:00        
2022-08-11T12:10:10     1660191010000   2022-08-11T12:10:10     
2022-08-11T11:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10     2222
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00        
2022-08-10T12:10:10     1660104610000   2022-08-10T12:10:10     
2022-08-10T20:10:10     3333
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string4 text3_4*5       6.0     2022-08-08T00:00        
2022-08-11T12:10:10     1660191010000   2022-08-11T12:10:10     
2022-08-11T11:10:10     4444
 
 -- !sql74 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10     2222
 
 -- !sql75 --
 true   1       128     32768   -1      0       1.0     1.0     1.0     1.0     
2020-01-01      2020-01-01T12:00        a       d       192.168.0.1     
{"name":"Andy","age":18}
@@ -82,7 +82,7 @@ true  1       128     32768   -1      0       1.0     1.0     
1.0     1.0     2020-01-01      2020-01-01T12:00        a       d       
192.168.0.
 true   1       128     32768   -1      0       1.0     1.0     1.0     1.0     
2020-01-01      2020-01-01T12:00        a       d       192.168.0.1     
{"name":"Andy","age":18}
 
 -- !sql77 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 
 -- !sql78 --
 [1, 0, 1, 1]   [1, -2, -3, 4]  [128, 129, -129, -130]  [32768, 32769, -32769, 
-32770]  [-1, 0, 1, 2]   [0, 1, 2, 3]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]   
 [1, 2, 3, 4]    [1, 2, 3, 4]    [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      ["a", "b", "c"] ["d", "e", "f"] 
["192.168.0.1", "127.0.0.1"]    ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"]
@@ -97,13 +97,13 @@ true        1       128     32768   -1      0       1.0     
1.0     1.0     1.0     2020-01-01      2020-01-01T12:00        a       d       
192.168.0.
 [1, 0, 1, 1]   [1, -2, -3, 4]  [128, 129, -129, -130]  [32768, 32769, -32769, 
-32770]  [-1, 0, 1, 2]   [0, 1, 2, 3]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]   
 [1, 2, 3, 4]    [1, 2, 3, 4]    [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      ["a", "b", "c"] ["d", "e", "f"] 
["192.168.0.1", "127.0.0.1"]    ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"]
 
 -- !sql81 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 
 -- !sql82 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00        
2022-08-10T12:10:10     1660104610000   2022-08-10T12:10:10     
2022-08-10T20:10:10
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string4 text3_4*5       6.0     2022-08-08T00:00        
2022-08-11T12:10:10     1660191010000   2022-08-11T12:10:10     
2022-08-11T11:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string2 text2   4.0     2022-08-08T00:00        
2022-08-09T12:10:10     1660018210000   2022-08-09T12:10:10     
2022-08-09T12:10:10     2222
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string3 text3_4*5       5.0     2022-08-08T00:00        
2022-08-10T12:10:10     1660104610000   2022-08-10T12:10:10     
2022-08-10T20:10:10     3333
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string4 text3_4*5       6.0     2022-08-08T00:00        
2022-08-11T12:10:10     1660191010000   2022-08-11T12:10:10     
2022-08-11T11:10:10     4444
 
 -- !sql83 --
 true   1       128     32768   -1      0       1.0     1.0     1.0     1.0     
2020-01-01      2020-01-01T12:00        a       d       192.168.0.1     
{"name":"Andy","age":18}
@@ -118,7 +118,7 @@ true        1       128     32768   -1      0       1.0     
1.0     1.0     1.0     2020-01-01      2020-01-01T12:00        a       d       
192.168.0.
 true   1       128     32768   -1      0       1.0     1.0     1.0     1.0     
2020-01-01      2020-01-01T12:00        a       d       192.168.0.1     
{"name":"Andy","age":18}
 
 -- !sql85 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 
 -- !sql86 --
 [1, 0, 1, 1]   [1, -2, -3, 4]  [128, 129, -129, -130]  [32768, 32769, -32769, 
-32770]  [-1, 0, 1, 2]   [0, 1, 2, 3]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]   
 [1, 2, 3, 4]    [1, 2, 3, 4]    [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      ["a", "b", "c"] ["d", "e", "f"] 
["192.168.0.1", "127.0.0.1"]    ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"]
diff --git 
a/regression-test/data/external_table_p0/es/test_es_query_no_http_url.out 
b/regression-test/data/external_table_p0/es/test_es_query_no_http_url.out
index e1c30290dc..dbe4800ee8 100644
--- a/regression-test/data/external_table_p0/es/test_es_query_no_http_url.out
+++ b/regression-test/data/external_table_p0/es/test_es_query_no_http_url.out
@@ -6,11 +6,11 @@
 [2020-01-01, 2020-01-02]       [-1, 0, 1, 2]   [0, 1, 2, 3]    ["d", "e", "f"] 
[128, 129, -129, -130]  ["192.168.0.1", "127.0.0.1"]    string1 [1, 2, 3, 4]    
2022-08-08      2022-08-08T12:10:10     text#1  [2020-01-01, 2020-01-02]        
3.14    [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 2, 3, 4]    ["a", "b", "c"] 
["{"name":"Andy","age":18}", "{"name":"Tim","age":28}"] 2022-08-08T12:10:10     
2022-08-08T12:10:10     2022-08-08T20:10:10     [1, -2, -3, 4]  [1, 0, 1, 1]    
[32768, 32769, -32769, -32770]
 
 -- !sql61 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01 00:00:00, 2020-01-02 00:00:00]      
["2020-01-01 12:00:00", "2020-01-02 13:01:01"]  [1, 2, 3, 4]    [1, 1.1, 1.2, 
1.3]      [1, 2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", 
"127.0.0.1"]    ["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        12345
 
 -- !sql71 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 
 -- !sql81 --
-[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10
+[1, 0, 1, 1]   [1, -2, -3, 4]  [2020-01-01, 2020-01-02]        [2020-01-01 
12:00:00, 2020-01-02 13:01:01]      [1, 2, 3, 4]    [1, 1.1, 1.2, 1.3]      [1, 
2, 3, 4]    [32768, 32769, -32769, -32770]  ["192.168.0.1", "127.0.0.1"]    
["a", "b", "c"] [-1, 0, 1, 2]   ["{"name":"Andy","age":18}", 
"{"name":"Tim","age":28}"] [1, 2, 3, 4]    [128, 129, -129, -130]  ["d", "e", 
"f"] [0, 1, 2, 3]    string1 text#1  3.14    2022-08-08T00:00        
2022-08-08T12:10:10     1659931810000   2022-08-08T12:10:10     
2022-08-08T20:10:10     12345
 


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org


Reply via email to