You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Michael J. Carey (Jira)" <ji...@apache.org> on 2022/02/25 15:44:00 UTC

[jira] [Updated] (ASTERIXDB-3021) Missing cross product warning

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

Michael J. Carey updated ASTERIXDB-3021:
----------------------------------------
    Description: 
The following query runs happily - which it should - but fails to issue a cross-product warning - which it should definitely issue in this case:

USE DonCData; 
SELECT * FROM customers, orders;

(This is using data from the open source docs.)

Here's the query plan with a JOIN with a TRUE condition (which should cause the warning):

!Screen Shot 2022-02-25 at 7.35.59 AM.png|width=830,height=842!

  was:
The following query runs happily - which it should - but fails to issue a cross-product warning:

USE DonCData; 
SELECT * FROM customers, orders;

(This is using data from the open source docs.)

!Screen Shot 2022-02-25 at 7.34.22 AM.png|width=802,height=873!

 

Here's the query plan with a JOIN with a TRUE condition (which should cause the warning):

!Screen Shot 2022-02-25 at 7.35.59 AM.png|width=830,height=842!


> Missing cross product warning
> -----------------------------
>
>                 Key: ASTERIXDB-3021
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3021
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler, SQL - Translator SQL++
>    Affects Versions: 0.9.7
>            Reporter: Michael J. Carey
>            Assignee: Dmitry Lychagin
>            Priority: Major
>             Fix For: 0.9.7
>
>         Attachments: Screen Shot 2022-02-25 at 7.35.59 AM-1.png, Screen Shot 2022-02-25 at 7.35.59 AM.png
>
>
> The following query runs happily - which it should - but fails to issue a cross-product warning - which it should definitely issue in this case:
> USE DonCData; 
> SELECT * FROM customers, orders;
> (This is using data from the open source docs.)
> Here's the query plan with a JOIN with a TRUE condition (which should cause the warning):
> !Screen Shot 2022-02-25 at 7.35.59 AM.png|width=830,height=842!



--
This message was sent by Atlassian Jira
(v8.20.1#820001)