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/17 01:53:00 UTC

[jira] [Created] (ASTERIXDB-3018) Suboptimal runtime behavior for weakly typed SELECT a.*, b.* queries

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

             Summary: Suboptimal runtime behavior for weakly typed SELECT a.*, b.* queries
                 Key: ASTERIXDB-3018
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3018
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: COMP - Compiler, RT - Runtime
    Affects Versions: 0.9.7
            Reporter: Michael J. Carey
            Assignee: Dmitry Lychagin
             Fix For: 0.9.8
         Attachments: doncdata-open.sqlpp

USE DonCData; 
SELECT c.*, o.*
FROM customers c, orders o
WHERE c.custid = o.custid

works for Don C data where only PK's are in the type:

SUCCESS: Execution time: 25.876371ms Elapsed time: 26.57911ms Size: 2.51 Kb

There should be a runtime warning when we double-deposit custid's into the query's result objects!

Here is the setup script for this version of the Don C data: [^doncdata-open.sqlpp]



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