[ 
https://issues.apache.org/jira/browse/TAJO-914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14064593#comment-14064593
 ] 

ASF GitHub Bot commented on TAJO-914:
-------------------------------------

GitHub user hyunsik opened a pull request:

    https://github.com/apache/tajo/pull/78

    TAJO-914: join queries with constant values can cause schema mismatch in 
logical plan

    This is a temporal solution, but it effectively fixes the critical problem.
    
    Its essential solution would be TAJO-895. Please see the detail at 
https://issues.apache.org/jira/browse/TAJO-914.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/hyunsik/tajo TAJO-914

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/tajo/pull/78.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #78
    
----
commit 3f47df51d1868e59f2de2c6b29d5d38b2b5cb5f6
Author: Hyunsik Choi <[email protected]>
Date:   2014-07-07T04:39:05Z

    TAJO-913: Add some missed tests for constant value group-by keys.

commit 627967b2077dbd68a5401110b42ea04b4fddfeac
Author: Hyunsik Choi <[email protected]>
Date:   2014-07-07T06:37:25Z

    Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into 
TAJO-913

commit 9ef919dd12407865e0e83599893ac06cdb90b51a
Author: Hyunsik Choi <[email protected]>
Date:   2014-07-08T03:17:55Z

    TAJO-914: join queries with constant values can cause schema mismatch in 
logical plan.

commit f016b57abd7ad265949c3bbb98d08fe8335738db
Author: Hyunsik Choi <[email protected]>
Date:   2014-07-17T05:35:47Z

    Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into 
TAJO-914
    
    Conflicts:
        
tajo-core/src/test/java/org/apache/tajo/engine/query/TestGroupByQuery.java
        
tajo-core/src/test/resources/queries/TestGroupByQuery/testGroupByWithConstantKeys2.sql
        
tajo-core/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result

----


> join queries with constant values can cause schema mismatch in logical plan
> ---------------------------------------------------------------------------
>
>                 Key: TAJO-914
>                 URL: https://issues.apache.org/jira/browse/TAJO-914
>             Project: Tajo
>          Issue Type: Bug
>          Components: planner/optimizer
>            Reporter: Hyunsik Choi
>            Assignee: Hyunsik Choi
>             Fix For: 0.9.0
>
>
> The following query can cause a schema mismatch problem between join node and 
> its both child scan nodes. The main cause that '##' col1 are evaluated in 
> both ScanNode. Because a schema cannot include the same column names, one 
> col1 is omitted. So, it causes the schema mismatch problem.
> {noformat}
> select l_orderkey, '##' as col1 from lineitem join orders on l_orderkey = 
> o_orderkey group by l_orderkey, col1
> {noformat}
> This is a critical bug. So, I've uploaded the urgent workaround bug fix. 
> Later, I'll fix it in more valid and stable manner. I already created the 
> Jira issue (TAJO-895) for that way.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to