[
https://issues.apache.org/jira/browse/CALCITE-3128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16870827#comment-16870827
]
Feng Zhu commented on CALCITE-3128:
-----------------------------------
The generated code for query seems to be OK.
{code:java}
public org.apache.calcite.linq4j.Enumerable bind(final
org.apache.calcite.DataContext root) {
final org.apache.calcite.linq4j.Enumerable _inputEnumerable =
org.apache.calcite.linq4j.Linq4j.asEnumerable(new Integer[] {0});
final org.apache.calcite.linq4j.AbstractEnumerable left = new
org.apache.calcite.linq4j.AbstractEnumerable(){
public org.apache.calcite.linq4j.Enumerator enumerator() {
return new org.apache.calcite.linq4j.Enumerator(){
public final org.apache.calcite.linq4j.Enumerator inputEnumerator =
_inputEnumerable.enumerator();
public void reset() {inputEnumerator.reset();}
public boolean moveNext() {return inputEnumerator.moveNext();}
public void close() {inputEnumerator.close();}
public Object current() {return null;}
};
}
};
final org.apache.calcite.linq4j.Enumerable _inputEnumerable0 =
org.apache.calcite.linq4j.Linq4j.asEnumerable(new Integer[] {0});
final org.apache.calcite.linq4j.AbstractEnumerable right = new
org.apache.calcite.linq4j.AbstractEnumerable(){
public org.apache.calcite.linq4j.Enumerator enumerator() {
return new org.apache.calcite.linq4j.Enumerator(){
public final org.apache.calcite.linq4j.Enumerator inputEnumerator =
_inputEnumerable0.enumerator();
public void reset() {inputEnumerator.reset();}
public boolean moveNext() {return inputEnumerator.moveNext();}
public void close() {inputEnumerator.close();}
public Object current() {return null;}
};
}
};
return left.hashJoin(right, new
org.apache.calcite.linq4j.function.Function1() {
public org.apache.calcite.runtime.FlatLists.ComparableEmptyList
apply(Integer v1) {
return org.apache.calcite.runtime.FlatLists.COMPARABLE_EMPTY_LIST;
}
public Object apply(Object v1) {
return apply((Integer) v1);
}
}
, new org.apache.calcite.linq4j.function.Function1() {
public org.apache.calcite.runtime.FlatLists.ComparableEmptyList
apply(Integer v1) {
return org.apache.calcite.runtime.FlatLists.COMPARABLE_EMPTY_LIST;
}
public Object apply(Object v1) {
return apply((Integer) v1);
}
}
, new org.apache.calcite.linq4j.function.Function2() {
public Object[] apply(Integer left, Integer right) {
return new Object[] {left, right};
}
public Object[] apply(Object left, Object right) {
return apply((Integer) left, (Integer) right);
}
}
, null, false, false);
}
{code}
> Joining two tables producing only NULLs will return 0 rows
> ----------------------------------------------------------
>
> Key: CALCITE-3128
> URL: https://issues.apache.org/jira/browse/CALCITE-3128
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.20.0
> Reporter: Muhammad Gelbana
> Priority: Major
>
> The following queries will return 0 rows while they're expected to ruturn
> rows with NULLs in them.
> {code:sql}
> SELECT *
> FROM (SELECT NULLIF(5, 5)) a, (SELECT NULLIF(5, 5)) b
> {code}
> {code:sql}
> SELECT *
> FROM (VALUES (NULLIF(5, 5)), (NULLIF(5, 5))) a, (VALUES (NULLIF(5, 5)),
> (NULLIF(5, 5))) b
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
