crazyleeyang opened a new issue #5971:
URL: https://github.com/apache/incubator-doris/issues/5971
**Describe the bug**
left join时出现非预期结果
**To Reproduce**
**doris表1:sku_doris1**
```sql
CREATE TABLE sku_doris1
(
sku_id int(11) NOT NULL
) ENGINE=OLAP
DISTRIBUTED BY HASH(sku_id) BUCKETS 1
PROPERTIES(
"storage_type" = "COLUMN",
"replication_num" = "1"
);
```
**sku_doris1表插入数据**
```sql
insert into sku_doris1 (sku_id) values (100),(101),(102),(103);
```
**doris表1:sku_doris2**
```sql
CREATE TABLE sku_doris2
(
sku_id int(11) NOT NULL
) ENGINE=OLAP
DISTRIBUTED BY HASH(sku_id) BUCKETS 1
PROPERTIES(
"storage_type" = "COLUMN",
"replication_num" = "1"
);
```
**sku_doris2表插入数据**
```sql
insert into sku_doris2 (sku_id) values (10000),(10001),(10002),(10003);
```
查询语句
```sql
select a.sku_id, c.price from sku_doris1 a left join
(select sku_id, 999 as price from sku_doris2 b)c
on a.sku_id=c.sku_id;
```
**期待的结果为**
| sku_id | price |
| ---- | ---- |
| 100 | NULL |
| 101 | NULL |
| 102 | NULL |
| 103 | NULL |
**期待的结果为**
| sku_id | price |
| ---- | ---- |
| 100 | 999 |
| 101 | 999 |
| 102 | 999 |
| 103 | 999 |
**环境信息**
* 版本:Doris version 0.12.21-release
--
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:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
