Wail Y. Alkowaileet created ASTERIXDB-3333:
----------------------------------------------
Summary: Avoid warning when comparing missing fields in
range-filters
Key: ASTERIXDB-3333
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3333
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Affects Versions: 0.9.9
Reporter: Wail Y. Alkowaileet
Assignee: Wail Y. Alkowaileet
Fix For: 0.9.9
Data:
{noformat}{ "orderno": 1001, "custid": "C41", "order_date": "2017-04-29",
"ship_date": "2017-05-03", "items": [ { "itemno": 347, "qty": 5, "price": 19.99
}, { "itemno": 193, "qty": 2, "price": 28.89 } ] }
{ "orderno": 1002, "custid": "C13", "order_date": "2017-05-01", "ship_date":
"2017-05-03", "items": [ { "itemno": 460, "qty": 95, "price": 100.99 }, {
"itemno": 680, "qty": 150, "price": 8.75 } ] }
{ "orderno": 1003, "custid": "C31", "order_date": "2017-06-15", "ship_date":
"2017-06-16", "items": [ { "itemno": 120, "qty": 2, "price": 88.99 }, {
"itemno": 460, "qty": 3, "price": 99.99 } ] }
{ "orderno": 1004, "custid": "C35", "order_date": "2017-07-10", "ship_date":
"2017-07-15", "items": [ { "itemno": 680, "qty": 6, "price": 9.99 }, {
"itemno": 195, "qty": 4, "price": 35.00 } ] }
{ "orderno": 1005, "custid": "C37", "order_date": "2017-08-30", "items": [ {
"itemno": 460, "qty": 2, "price": 99.98 }, { "itemno": 347, "qty": 120,
"price": 22.00 }, { "itemno": 780, "qty": 1, "price": 1500.00 }, { "itemno":
375, "qty": 2, "price": 149.98 } ] }
{ "orderno": 1006, "custid": "C41", "order_date": "2017-09-02", "ship_date":
"2017-09-04", "items": [ { "itemno": 680, "qty": 51, "price": 25.98 }, {
"itemno": 120, "qty": 65, "price": 85.00 }, { "itemno": 460, "qty": 120,
"price": 99.98 } ] }
{ "orderno": 1007, "custid": "C13", "order_date": "2017-09-13", "ship_date":
"2017-09-20", "items": [ { "itemno": 185, "qty": 5, "price": 21.99 }, {
"itemno": 680, "qty": 1, "price": 20.50 } ] }
{ "orderno": 1008, "custid": "C13", "order_date": "2017-10-13", "items": [ {
"itemno": 460, "qty": 20, "price": 99.99 } ] }
{ "orderno": 1009, "custid": "C13", "order_date": "2017-10-13", "items": [ ] }
{noformat}
DDL:
{noformat}
DROP DATAVERSE test IF EXISTS;
CREATE DATAVERSE test;
USE test;
CREATE DATASET orders
PRIMARY KEY (orderno: int) WITH {
"storage-format":{"format": "column"}
};{noformat}
Query:
{noformat}FROM orders AS o, o.items AS i
LET revenue = i.qty * i.price
WHERE revenue > 5000
SELECT o.orderno, i.itemno, revenue
ORDER by revenue desc; {noformat}
Throws a warning because the array items can be empty.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
