[
https://issues.apache.org/jira/browse/ASTERIXDB-3338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3338:
---------------------------------
Labels: triaged (was: )
> CH2 q18 gives spurious hint warnings
> ------------------------------------
>
> Key: ASTERIXDB-3338
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3338
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
>
> CH2 q18:
> SELECT SUM(ol.ol_amount) AS revenue
> FROM orders o, o.o_orderline ol, item i
> WHERE ((
> i.i_data LIKE '%h'
> AND ol.ol_quantity >= 7 AND ol.ol_quantity <= 17
> AND i.i_price between 1 AND 5
> AND o.o_w_id IN [37, 29, 70]
> ) OR (
> i.i_data LIKE '%t'
> AND ol.ol_quantity >= 16 AND ol.ol_quantity <= 26
> AND i.i_price between 1 AND 10
> AND o.o_w_id IN [78, 17, 6]
> ) OR (
> i.i_data LIKE '%m'
> AND ol.ol_quantity >= 24 AND ol.ol_quantity <= 34
> AND i.i_price between 1 AND 15
> AND o.o_w_id IN [91, 95, 15]
> ))
> AND ol.ol_i_id = i.i_id
> AND i.i_price between 1 AND 15;
> Running this query results in the following spurious selectivity warnings.
> Showing 6 of 6 warnings:
> [
> "code": 24073,
> "msg": "Could not apply selectivity hint: Selectivity specified:
> 8.78739416745061, has to be a decimal value greater than 0 and less than 1
> (in line 5, at column 29)"
> ｛
> "code": 24073,
> "msg": "Could not apply selectivity hint: Selectivity specified:
> 3.379115710253998, has to be a decimal value greater than 0 and less than 1
> (in line 5, at column 53)"
> },
>
> { "code": 24073, "msg': "Could not apply selectivity hint: Selectivity
> specified: 7.005644402634054, has to be a decimal value greater than 0 and
> less than 1 (in line 10, at column 29)" }
>
> ,
>
> { "code": 24073, "msg": "Could not apply selectivity hint: Selectivity
> specified: 5.1655691439322675, has to be a decimal value greater than 0 and
> less than 1 (in line 10, at column 54 )" }
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
