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)