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

["Michael J. Carey (Jira)" <ji...@apache.org>]

Michael J. Carey created ASTERIXDB-3021:
-------------------------------------------

             Summary: 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
             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:

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!



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