This is an automated email from the ASF dual-hosted git repository.
htowaileb pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/asterixdb.git
The following commit(s) were added to refs/heads/master by this push:
new c32ac23fab [ASTERIXDB-3244][EXT]: Add tests for dynamic prefixes
c32ac23fab is described below
commit c32ac23fab67a144315b223c90c505ce1bbbc201
Author: Hussain Towaileb <[email protected]>
AuthorDate: Fri Aug 11 10:45:32 2023 +0300
[ASTERIXDB-3244][EXT]: Add tests for dynamic prefixes
Change-Id: Id065964612324834d61e5c411b19ebc8f8eb6c85
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17720
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Hussain Towaileb <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
---
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../year-2001-month-01-day-01-date/0.json | 3 +++
.../year-2002-month-02-day-02-date/0.json | 3 +++
.../year-2003-month-03-day-03-date/0.json | 3 +++
.../{type-mismatch => query}/test.000.ddl.sqlpp | 24 ++++++++++++++++++++--
.../{type-mismatch => query}/test.010.query.sqlpp | 3 +--
.../test.011.query.sqlpp} | 4 ++--
.../test.012.query.sqlpp} | 4 ++--
.../test.013.query.sqlpp} | 5 +++--
.../test.014.query.sqlpp} | 5 +++--
.../test.015.query.sqlpp} | 4 ++--
.../test.016.query.sqlpp} | 5 +++--
.../test.017.query.sqlpp} | 4 ++--
.../test.018.query.sqlpp} | 8 ++++++--
.../test.019.query.sqlpp} | 6 ++++--
.../test.999.ddl.sqlpp} | 8 +-------
.../s3/filter/type-mismatch/test.000.ddl.sqlpp | 2 +-
.../s3/filter/type-mismatch/test.010.query.sqlpp | 2 +-
.../s3/filter/query/result.010.adm | 1 +
.../s3/filter/query/result.011.adm | 1 +
.../s3/filter/query/result.012.adm | 1 +
.../s3/filter/query/result.013.adm | 1 +
.../s3/filter/query/result.014.adm | 1 +
.../s3/filter/query/result.015.adm | 1 +
.../s3/filter/query/result.016.adm | 1 +
.../s3/filter/query/result.017.adm | 1 +
.../s3/filter/query/result.018.adm | 1 +
.../s3/filter/query/result.019.adm | 1 +
.../runtimets/testsuite_external_dataset_s3.xml | 14 +++++++------
52 files changed, 152 insertions(+), 37 deletions(-)
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..df51393ebe
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "ford", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..e8a0bfdc70
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "ford", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..422e8c4342
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "ford", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..58d56aa490
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "ford", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..b98d4d4735
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "ford", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..29f291610d
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "ford", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..52d4100378
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "ford", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "ford", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..b96e7b3c69
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "ford", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "ford", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..741c46ebd2
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/ford/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "ford", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "ford", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..a718ed07dc
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "lexus", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..d9ac534078
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "lexus", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..c2520acdf0
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "lexus", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..aa5f0533af
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "lexus", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..d6a07a1e76
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "lexus", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..7bc1d0fa82
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "lexus", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..c870b5ed1c
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "lexus", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "lexus", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..325acd8bfb
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "lexus", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "lexus", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..d1e6b0e566
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/lexus/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "lexus", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "lexus", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..01f21f572b
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 1, "company": "toyota", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..5f5a453421
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 1, "company": "toyota", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..fabbc162bd
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/1/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 1, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 1, "company": "toyota", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..3aaf2b68c6
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 2, "company": "toyota", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..fefe0143f9
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 2, "company": "toyota", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..462bfff3bf
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/2/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 2, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 2, "company": "toyota", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
new file mode 100644
index 0000000000..5503907ce8
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2001-month-01-day-01-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "toyota", "year": 2001, "month": 1, "day": 1}
+{"customer_id": 3, "company": "toyota", "year": 2001, "month": 1, "day": 1}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
new file mode 100644
index 0000000000..42a5a75197
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2002-month-02-day-02-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "toyota", "year": 2002, "month": 2, "day": 2}
+{"customer_id": 3, "company": "toyota", "year": 2002, "month": 2, "day": 2}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
new file mode 100644
index 0000000000..32a8f2e55c
--- /dev/null
+++
b/asterixdb/asterix-app/data/json/external-filter/car/toyota/customer/3/maintenance-report/year-2003-month-03-day-03-date/0.json
@@ -0,0 +1,3 @@
+{"customer_id": 3, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "toyota", "year": 2003, "month": 3, "day": 3}
+{"customer_id": 3, "company": "toyota", "year": 2003, "month": 3, "day": 3}
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.000.ddl.sqlpp
similarity index 55%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.000.ddl.sqlpp
index 7b70bd37d2..e8d2a687f0 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.000.ddl.sqlpp
@@ -25,12 +25,32 @@ CREATE TYPE test AS {
};
-CREATE EXTERNAL DATASET test(test) USING S3 (
+CREATE EXTERNAL DATASET company(test) USING S3 (
("accessKeyId"="dummyAccessKey"),
("secretAccessKey"="dummySecretKey"),
("region"="us-west-2"),
("serviceEndpoint"="http://127.0.0.1:8001";),
("container"="playground"),
- ("definition"="external-filter/{name:bigint}"),
+ ("definition"="external-filter/car/{company:string}"),
+ ("format"="json")
+);
+
+CREATE EXTERNAL DATASET customer(test) USING S3 (
+ ("accessKeyId"="dummyAccessKey"),
+ ("secretAccessKey"="dummySecretKey"),
+ ("region"="us-west-2"),
+ ("serviceEndpoint"="http://127.0.0.1:8001";),
+ ("container"="playground"),
+
("definition"="external-filter/car/{company:string}/customer/{customer_id:int}"),
+ ("format"="json")
+);
+
+CREATE EXTERNAL DATASET maintenance(test) USING S3 (
+ ("accessKeyId"="dummyAccessKey"),
+ ("secretAccessKey"="dummySecretKey"),
+ ("region"="us-west-2"),
+ ("serviceEndpoint"="http://127.0.0.1:8001";),
+ ("container"="playground"),
+
("definition"="external-filter/car/{company:string}/customer/{customer_id:int}/maintenance-report/year-{year:int}-month-{month:int}-day-{day:int}-date"),
("format"="json")
);
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.010.query.sqlpp
similarity index 95%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.010.query.sqlpp
index 13b6abe99e..603e82848e 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.010.query.sqlpp
@@ -22,5 +22,4 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.011.query.sqlpp
similarity index 95%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.011.query.sqlpp
index 13b6abe99e..f6873129cd 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.011.query.sqlpp
@@ -22,5 +22,5 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t
+WHERE t.company = "ford";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.012.query.sqlpp
similarity index 95%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.012.query.sqlpp
index 13b6abe99e..a0e5f77e2a 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.012.query.sqlpp
@@ -22,5 +22,5 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t
+WHERE t.company = "cheese";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.013.query.sqlpp
similarity index 92%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.013.query.sqlpp
index 13b6abe99e..b24c12d213 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.013.query.sqlpp
@@ -22,5 +22,6 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t
+WHERE t.company = "ford"
+ AND t.company = "toyota";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.014.query.sqlpp
similarity index 92%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.014.query.sqlpp
index 13b6abe99e..7d43ccc0a7 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.014.query.sqlpp
@@ -22,5 +22,6 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t
+WHERE t.company = "ford"
+ OR t.company = "toyota";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.015.query.sqlpp
similarity index 94%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.015.query.sqlpp
index 13b6abe99e..d5f37b252f 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.015.query.sqlpp
@@ -22,5 +22,5 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM company t
+WHERE t.company IN ["ford", "toyota"];
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.016.query.sqlpp
similarity index 93%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.016.query.sqlpp
index 13b6abe99e..3bbafca169 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.016.query.sqlpp
@@ -22,5 +22,6 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM customer t
+WHERE t.company = "ford"
+ AND t.customer_id = 1;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.017.query.sqlpp
similarity index 95%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.017.query.sqlpp
index 13b6abe99e..0a4c1ea40c 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.017.query.sqlpp
@@ -22,5 +22,5 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM customer t
+WHERE t.customer_id = 1;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.018.query.sqlpp
similarity index 87%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.018.query.sqlpp
index 13b6abe99e..a8fa256d18 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.018.query.sqlpp
@@ -22,5 +22,9 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM maintenance t
+WHERE t.company = "ford"
+ AND t.customer_id = 1
+ AND t.year = 2001
+ AND t.month = 01
+ AND t.day = 01;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.019.query.sqlpp
similarity index 92%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.019.query.sqlpp
index 13b6abe99e..6d435eb1dd 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.019.query.sqlpp
@@ -22,5 +22,7 @@
USE test;
SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+FROM maintenance t
+WHERE t.year = 2001
+ AND t.month = 01
+ AND t.day = 01;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.999.ddl.sqlpp
similarity index 88%
copy from
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
copy to
asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.999.ddl.sqlpp
index 13b6abe99e..36b2bab543 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/query/test.999.ddl.sqlpp
@@ -17,10 +17,4 @@
* under the License.
*/
-// param max-warnings:json=10
-
-USE test;
-
-SELECT value count(*)
-FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+DROP DATAVERSE test IF EXISTS;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
index 7b70bd37d2..c1caa4f4e5 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.000.ddl.sqlpp
@@ -31,6 +31,6 @@ CREATE EXTERNAL DATASET test(test) USING S3 (
("region"="us-west-2"),
("serviceEndpoint"="http://127.0.0.1:8001";),
("container"="playground"),
- ("definition"="external-filter/{name:bigint}"),
+ ("definition"="external-filter/department/{name:bigint}"),
("format"="json")
);
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
index 13b6abe99e..25fefed531 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/external-dataset/s3/filter/type-mismatch/test.010.query.sqlpp
@@ -23,4 +23,4 @@ USE test;
SELECT value count(*)
FROM test t
-WHERE t.name = "department";
\ No newline at end of file
+WHERE t.name = "accounting";
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.010.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.010.adm
new file mode 100644
index 0000000000..c147342cbe
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.010.adm
@@ -0,0 +1 @@
+81
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.011.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.011.adm
new file mode 100644
index 0000000000..a5c750feac
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.011.adm
@@ -0,0 +1 @@
+27
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.012.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.012.adm
new file mode 100644
index 0000000000..c227083464
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.012.adm
@@ -0,0 +1 @@
+0
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.013.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.013.adm
new file mode 100644
index 0000000000..c227083464
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.013.adm
@@ -0,0 +1 @@
+0
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.014.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.014.adm
new file mode 100644
index 0000000000..43c451e0c6
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.014.adm
@@ -0,0 +1 @@
+54
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.015.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.015.adm
new file mode 100644
index 0000000000..43c451e0c6
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.015.adm
@@ -0,0 +1 @@
+54
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.016.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.016.adm
new file mode 100644
index 0000000000..f11c82a4cb
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.016.adm
@@ -0,0 +1 @@
+9
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.017.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.017.adm
new file mode 100644
index 0000000000..a5c750feac
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.017.adm
@@ -0,0 +1 @@
+27
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.018.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.018.adm
new file mode 100644
index 0000000000..e440e5c842
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.018.adm
@@ -0,0 +1 @@
+3
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.019.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.019.adm
new file mode 100644
index 0000000000..a5c750feac
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/external-dataset/s3/filter/query/result.019.adm
@@ -0,0 +1 @@
+27
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_external_dataset_s3.xml
b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_external_dataset_s3.xml
index cd40b1a0ec..50502da39c 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_external_dataset_s3.xml
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/testsuite_external_dataset_s3.xml
@@ -230,12 +230,14 @@
<test-case FilePath="external-dataset/s3/filter" check-warnings="true">
<compilation-unit name="type-mismatch">
<output-dir compare="Text">type-mismatch</output-dir>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/accounting/0.json'. Computed Field Name: 'name'.
Computed Field Type: 'bigint'. Computed Field Value: 'department'. Reason: 'For
input string: "department"'</expected-warn>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/engineering/0.json'. Computed Field Name: 'name'.
Computed Field Type: 'bigint'. Computed Field Value: 'department'. Reason: 'For
input string: "department"'</expected-warn>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/hr/0.json'. Computed Field Name: 'name'. Computed
Field Type: 'bigint'. Computed Field Value: 'department'. Reason: 'For input
string: "department"'</expected-warn>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/last-name/Jones/0.json'. Computed Field Name: 'name'. Computed
Field Type: 'bigint'. Computed Field Value: 'last-name'. Reason: 'For input
string: "last-name"'</expected-warn>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/last-name/miller/0.json'. Computed Field Name: 'name'.
Computed Field Type: 'bigint'. Computed Field Value: 'last-name'. Reason: 'For
input string: "last-name"'</expected-warn>
- <expected-warn>Failed to evaluate computed field. File:
'external-filter/last-name/smith/0.json'. Computed Field Name: 'name'. Computed
Field Type: 'bigint'. Computed Field Value: 'last-name'. Reason: 'For input
string: "last-name"'</expected-warn>
+ <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/accounting/0.json'. Computed Field Name: 'name'.
Computed Field Type: 'bigint'. Computed Field Value: 'accounting'. Reason: 'For
input string: "accounting"'</expected-warn>
+ <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/engineering/0.json'. Computed Field Name: 'name'.
Computed Field Type: 'bigint'. Computed Field Value: 'engineering'. Reason:
'For input string: "engineering"'</expected-warn>
+ <expected-warn>Failed to evaluate computed field. File:
'external-filter/department/hr/0.json'. Computed Field Name: 'name'. Computed
Field Type: 'bigint'. Computed Field Value: 'hr'. Reason: 'For input string:
"hr"'</expected-warn>
+ </compilation-unit>
+ </test-case>
+ <test-case FilePath="external-dataset/s3/filter">
+ <compilation-unit name="query">
+ <output-dir compare="Text">query</output-dir>
</compilation-unit>
</test-case>
<!-- Dynamic prefixes tests end -->
