[ 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)