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

Posted to notifications@asterixdb.apache.org by "Wail Y. Alkowaileet (Jira)" <ji...@apache.org> on 2023/05/05 15:06:00 UTC

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

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wail Y. Alkowaileet updated ASTERIXDB-3135:
-------------------------------------------
    Labels: triaged  (was: )

> 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
>            Assignee: Vijay Sarathy
>            Priority: Major
>              Labels: triaged
>
> |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)