You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/08/07 02:56:42 UTC
[GitHub] [incubator-doris] HangyuanLiu opened a new issue #4278: [BUG] TupleIsNull miss in ResultExpr in SelectStmt
HangyuanLiu opened a new issue #4278:
URL: https://github.com/apache/incubator-doris/issues/4278
Left join InlineView Result is error.
Leftjoin has no rows on the match should be NULL populated instead of an expression evaluating the value
**To Reproduce**
Steps to reproduce the behavior:
mysql> select * from t1;
+------+------+------+
| v1 | v2 | v3 |
+------+------+------+
| 1 | 2 | 3 |
| 4 | 5 | 6 |
+------+------+------+
2 rows in set (0.01 sec)
mysql> select * from t2;
+------+------+------+
| v1 | v2 | v3 |
+------+------+------+
| 1 | 2 | 3 |
+------+------+------+
1 row in set (0.01 sec)
mysql> select t1.v1,b.v2 from t1 left join (select v1, v2 is null as v2 from t2) as b on t1.v1=b.v1;
+------+------+
| v1 | v2 |
+------+------+
| 1 | 0 |
| 4 | 1 |
+------+------+
2 rows in set (0.01 sec)
**Expected behavior**
mysql> select t1.v1,b.v2 from t1 left join (select v1, v2 is null as v2 from t2) as b on t1.v1=b.v1;
+------+------+
| v1 | v2 |
+------+------+
| 1 | 0 |
| 4 | NULL |
+------+------+
2 rows in set (0.01 sec)
**Additional context**
Add any other context about the problem here.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #4278: [BUG] TupleIsNull miss in ResultExpr in SelectStmt
Posted by GitBox <gi...@apache.org>.
morningman closed issue #4278:
URL: https://github.com/apache/incubator-doris/issues/4278
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org