This is an automated email from the ASF dual-hosted git repository.
Gabriel39 pushed a commit to branch branch-4.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.1 by this push:
new 8bd2fec41db [fix](regression) Restore missing ES query results on
branch-4.1 (#68852)
8bd2fec41db is described below
commit 8bd2fec41db532e0312cd7fd3cb03c943665e569
Author: Gabriel <[email protected]>
AuthorDate: Sat Oct 10 15:20:57 2026 +0800
[fix](regression) Restore missing ES query results on branch-4.1 (#68852)
### What problem does this PR solve?
Related PR: #66425
`test_es_query` fails with `Missing output block for tag 'sql01'`
because its expected output lost all 18 external-table query blocks in
each of the two scroll-mode passes during an output refresh.
Restore the 36 missing blocks verbatim from the generated baseline
before commit `78c1626259`, in their original positions. The query SQL
is unchanged, and all existing catalog results, including their updated
floating-point formatting, are preserved. Add a comment documenting that
both query groups need results for each scroll mode.
### Release note
None
### Check List (For Author)
- Test:
- [x] Manual test: compiled the suite with Groovy 4.0.19 and exercised
the regression framework's actual `OutputUtils.iterator` using all query
tags in execution order for both scroll modes. Before the fix it fails
at `sql01`; after the fix it parses all 312 blocks and 1,002 rows.
- [x] Verified restored blocks match the historical generated baseline
byte for byte and all 156 query SQL statements are unchanged.
- [x] `git diff --check`
- Full Doris/Elasticsearch integration execution was not run locally.
- Behavior changed: No product behavior change; restores regression
result checking.
- Does this need documentation: No.
---
.../data/external_table_p2/es/test_es_query.out | 206 +++++++++++++++++++++
.../external_table_p2/es/test_es_query.groovy | 1 +
2 files changed, 207 insertions(+)
diff --git a/regression-test/data/external_table_p2/es/test_es_query.out
b/regression-test/data/external_table_p2/es/test_es_query.out
index b80b954e165..3148827034d 100644
--- a/regression-test/data/external_table_p2/es/test_es_query.out
+++ b/regression-test/data/external_table_p2/es/test_es_query.out
@@ -1,4 +1,107 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql01 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+
+-- !sql02 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+
+-- !sql03 --
+2022-08-08 2022-08-08T12:10:10 2022-08-08T12:10:10
2022-08-08T04:10:10 2022-08-08T20:10:10
+2022-08-08 2022-08-09T12:10:10 2022-08-09T12:10:10
2022-08-09T12:10:10 2022-08-09T12:10:10
+2022-08-08 2022-08-10T12:10:10 2022-08-10T12:10:10
2022-08-10T04:10:10 2022-08-10T20:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+
+-- !sql04 --
+I'm not null or empty
+
+-- !sql05 --
+
+I'm not null or empty
+
+-- !sql06 --
+I'm not null or empty
+
+-- !sql07 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string2
[1, 2, 3, 4] 2022-08-08 2022-08-09T12:10:10 text2 ["2020-01-01",
"2020-01-02"] 4.0 [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-09T12:10:10 2022-08-09T12:10:10 2022-08-09T12:10:10 2222
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","firs [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string3
[1, 2, 3, 4] 2022-08-08 2022-08-10T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 5.0 [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-10T12:10:10
2022-08-10T12:10:10 2022-08-10T20:10:10 3333 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] I'm not null or emp [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string4
[1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] \N [{"last":"Smith" [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"]
string_ignore_above_10 [1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10
text_ignore_above_10 ["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, - [...]
+
+-- !sql08 --
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+
+-- !sql09 --
+string1
+string2
+string3
+string4
+string_ignore_above_10
+
+-- !sql10 --
+text#1
+text2
+text3_4*5
+text3_4*5
+text_ignore_above_10
+
+-- !sql11 --
+2022-08-08T12:10:10
+2022-08-09T12:10:10
+2022-08-10T12:10:10
+2022-08-11T12:10:10
+2022-08-11T12:10:10
+
+-- !sql12 --
+12345
+2222
+3333
+4444
+4444
+
+-- !sql21 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
+
+-- !sql22 --
+2022-08-08 2022-08-08T12:10:10 2022-08-08T12:10:10
2022-08-08T04:10:10 2022-08-08T20:10:10
+2022-08-08 2022-08-09T12:10:10 2022-08-09T12:10:10
2022-08-09T12:10:10 2022-08-09T12:10:10
+2022-08-08 2022-08-10T12:10:10 2022-08-10T12:10:10
2022-08-10T04:10:10 2022-08-10T20:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+
+-- !sql23 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string2
[1, 2, 3, 4] 2022-08-08 2022-08-09T12:10:10 text2 ["2020-01-01",
"2020-01-02"] 4.0 [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-09T12:10:10 2022-08-09T12:10:10 2022-08-09T12:10:10 2222
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","first [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string3
[1, 2, 3, 4] 2022-08-08 2022-08-10T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 5.0 [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-10T12:10:10
2022-08-10T12:10:10 2022-08-10T20:10:10 3333 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] [{"last":"Smith","f [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string4
[1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] [{"last":"Smith","f [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"]
string_ignore_above_10 [1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10
text_ignore_above_10 ["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, - [...]
+
+-- !sql24 --
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+
+-- !sql25 --
+2022-08-08T12:10:10
+2022-08-09T12:10:10
+2022-08-10T12:10:10
+2022-08-11T12:10:10
+2022-08-11T12:10:10
+
+-- !sql26 --
+12345
+2222
+3333
+4444
+4444
+
-- !sql_5_02 --
[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]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] \N
string1 text#1 3.14 2022-08-08T00:00 12345 2022-08-08T20:10:10
123456789
@@ -709,6 +812,109 @@ string_ignore_above_10 text_ignore_above_10
4444
4444
+-- !sql01 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+
+-- !sql02 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+
+-- !sql03 --
+2022-08-08 2022-08-08T12:10:10 2022-08-08T12:10:10
2022-08-08T04:10:10 2022-08-08T20:10:10
+2022-08-08 2022-08-09T12:10:10 2022-08-09T12:10:10
2022-08-09T12:10:10 2022-08-09T12:10:10
+2022-08-08 2022-08-10T12:10:10 2022-08-10T12:10:10
2022-08-10T04:10:10 2022-08-10T20:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+
+-- !sql04 --
+I'm not null or empty
+
+-- !sql05 --
+
+I'm not null or empty
+
+-- !sql06 --
+I'm not null or empty
+
+-- !sql07 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770] \N
[{"last":"Smith", [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string2
[1, 2, 3, 4] 2022-08-08 2022-08-09T12:10:10 text2 ["2020-01-01",
"2020-01-02"] 4.0 [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-09T12:10:10 2022-08-09T12:10:10 2022-08-09T12:10:10 2222
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","firs [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string3
[1, 2, 3, 4] 2022-08-08 2022-08-10T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 5.0 [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-10T12:10:10
2022-08-10T12:10:10 2022-08-10T20:10:10 3333 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] I'm not null or emp [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string4
[1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] \N [{"last":"Smith" [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"]
string_ignore_above_10 [1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10
text_ignore_above_10 ["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, - [...]
+
+-- !sql08 --
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+
+-- !sql09 --
+string1
+string2
+string3
+string4
+string_ignore_above_10
+
+-- !sql10 --
+text#1
+text2
+text3_4*5
+text3_4*5
+text_ignore_above_10
+
+-- !sql11 --
+2022-08-08T12:10:10
+2022-08-09T12:10:10
+2022-08-10T12:10:10
+2022-08-11T12:10:10
+2022-08-11T12:10:10
+
+-- !sql12 --
+12345
+2222
+3333
+4444
+4444
+
+-- !sql21 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
+
+-- !sql22 --
+2022-08-08 2022-08-08T12:10:10 2022-08-08T12:10:10
2022-08-08T04:10:10 2022-08-08T20:10:10
+2022-08-08 2022-08-09T12:10:10 2022-08-09T12:10:10
2022-08-09T12:10:10 2022-08-09T12:10:10
+2022-08-08 2022-08-10T12:10:10 2022-08-10T12:10:10
2022-08-10T04:10:10 2022-08-10T20:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+2022-08-08 2022-08-11T12:10:10 2022-08-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10
+
+-- !sql23 --
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-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 12345
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","fi [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string2
[1, 2, 3, 4] 2022-08-08 2022-08-09T12:10:10 text2 ["2020-01-01",
"2020-01-02"] 4.0 [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-09T12:10:10 2022-08-09T12:10:10 2022-08-09T12:10:10 2222
[1, -2, -3, 4] [1, 0, 1, 1] [32768, 32769, -32769, -32770]
[{"last":"Smith","first [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string3
[1, 2, 3, 4] 2022-08-08 2022-08-10T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 5.0 [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-10T12:10:10
2022-08-10T12:10:10 2022-08-10T20:10:10 3333 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] [{"last":"Smith","f [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"] string4
[1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10 text3_4*5
["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, -32770] [{"last":"Smith","f [...]
+["2020-01-01 12:00:00", "2020-01-02 13:01:01"] [-1, 0, 1, 2] [0, 1, 2, 3]
["d", "e", "f"] [128, 129, -129, -130] ["192.168.0.1", "127.0.0.1"]
string_ignore_above_10 [1, 2, 3, 4] 2022-08-08 2022-08-11T12:10:10
text_ignore_above_10 ["2020-01-01", "2020-01-02"] 6.0 [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-11T12:10:10
2022-08-11T12:10:10 2022-08-11T11:10:10 4444 [1, -2, -3, 4] [1, 0,
1, 1] [32768, 32769, -32769, - [...]
+
+-- !sql24 --
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+[{"name":"Andy","age":18},{"name":"Tim","age":28}]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] "Andy"
"White"
+
+-- !sql25 --
+2022-08-08T12:10:10
+2022-08-09T12:10:10
+2022-08-10T12:10:10
+2022-08-11T12:10:10
+2022-08-11T12:10:10
+
+-- !sql26 --
+12345
+2222
+3333
+4444
+4444
+
-- !sql_5_02 --
[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]
[{"last":"Smith","first":"John"},{"last":"White","first":"Alice"}] \N
string1 text#1 3.14 2022-08-08T00:00 12345 2022-08-08T20:10:10
123456789
diff --git a/regression-test/suites/external_table_p2/es/test_es_query.groovy
b/regression-test/suites/external_table_p2/es/test_es_query.groovy
index c3d6b75ecca..eb4baad90fe 100644
--- a/regression-test/suites/external_table_p2/es/test_es_query.groovy
+++ b/regression-test/suites/external_table_p2/es/test_es_query.groovy
@@ -411,6 +411,7 @@ suite("test_es_query", "p2,external") {
}
+ // The output file needs both external-table and catalog result blocks
for each scroll mode.
sql """set enable_es_parallel_scroll=true"""
query_catalogs()
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
