[
https://issues.apache.org/jira/browse/ASTERIXDB-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17494324#comment-17494324
]
Dmitry Lychagin commented on ASTERIXDB-3018:
--------------------------------------------
I also get the same error (Cannot infer result columns) when running your
original query (over base datasets) in SQL-compat mode.
> 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
> Priority: Major
> 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)
