[
https://issues.apache.org/jira/browse/CALCITE-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
jamie12221 closed CALCITE-3417.
-------------------------------
Resolution: Not A Bug
> The alias is invalid in RelBuilder#join(JoinRelType, RexNode)
> -------------------------------------------------------------
>
> Key: CALCITE-3417
> URL: https://issues.apache.org/jira/browse/CALCITE-3417
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.20.0, 1.21.0
> Reporter: jamie12221
> Priority: Trivial
>
> bad code:
> {code}
> RelBuilder relBuilder = RelBuilder.create(config);
> RelNode table = relBuilder
> .scan("testdb","travelrecord")
> .as("t")
> .scan("testdb","address")
> .as("a")
> .join(JoinRelType.INNER, relBuilder.equals(relBuilder.field("t","id"),
> relBuilder.field("a","id")))
>
> .filter(relBuilder.and(relBuilder.equals(relBuilder.field(1,0,"id"),relBuilder.literal(1))))
> .project(relBuilder.field(1,0,"id"), relBuilder.field(1,0,"user_id"))
> .build();
> {code}
> occur exception:
> {noformat}
> java.lang.IllegalArgumentException: no aliased field found; fields are:
> [\{aliases=[address, a],fieldName=id}, \{aliases=[address,
> a],fieldName=addressname}]java.lang.IllegalArgumentException: no aliased
> field found; fields are: [\{aliases=[address, a],fieldName=id},
> \{aliases=[address, a],fieldName=addressname}] at
> org.apache.calcite.tools.RelBuilder.field(RelBuilder.java:511) at
> org.apache.calcite.tools.RelBuilder.field(RelBuilder.java:487)
> {noformat}
>
> but it is ok :
> {code}
> RelBuilder relBuilder = RelBuilder.create(config);
> RelNode table = relBuilder
> .scan("testdb","travelrecord")
> .as("t")
> .scan("testdb","address")
> .as("a")
> .join(JoinRelType.INNER,
> relBuilder.equals(relBuilder.field({color:#de350b}2{color},"t","id"),
> relBuilder.field(2,"a","id")))
>
> .filter(relBuilder.and(relBuilder.equals(relBuilder.field(1,0,"id"),relBuilder.literal(1))))
> .project(relBuilder.field(1,0,"id"), relBuilder.field(1,0,"user_id"))
> .build();
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
