You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/12/19 20:13:00 UTC
[jira] [Commented] (ASTERIXDB-3333) Avoid warning when comparing missing fields in range-filters
[ https://issues.apache.org/jira/browse/ASTERIXDB-3333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17798728#comment-17798728 ]
ASF subversion and git services commented on ASTERIXDB-3333:
------------------------------------------------------------
Commit 4d609b4210925860a4311e3a191b801c9fa22830 in asterixdb's branch refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=4d609b4210 ]
[ASTERIXDB-3333][COMP] Do not warn on MISSING fields
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
When comparing with missing fields in columnar range-filters,
warnings should not be issued.
Change-Id: Ie079fa94b625ad7c8de32e199217fa4dc97974fe
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18014
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Wail Alkowaileet <wa...@gmail.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
> 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
> Priority: Major
> 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)