Vijay Sarathy created ASTERIXDB-3135:
----------------------------------------

             Summary: CBO: Hint productivity does not return warning if unknown 
collection
                 Key: ASTERIXDB-3135
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3135
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler
            Reporter: Vijay Sarathy


|EXPLAIN SELECT COUNT(DISTINCT r.destinationairport) FROM airport a JOIN route 
r ON r.sourceairport /*+ productivity z 600.0 */ = a.faa WHERE a.city = 'San 
Francisco' AND a.country = 'United States';|

This query should generate a warning since there is no collection or alias "z"



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to