You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Vijay Sarathy (Jira)" <ji...@apache.org> on 2023/03/10 23:01:00 UTC

[jira] [Created] (ASTERIXDB-3135) CBO: Hint productivity does not return warning if unknown collection

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)