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)