测试 Sql:
SELECT
*
FROM
(
select 1 as user_id,‘李华’ as user_name
union
select 2 as user_id,‘韩冲’ as user_name
) user_info
LEFT JOIN
(
select 1 as user_id,‘新西兰’ as address_name
) address
ON user_info.user_id=address.user_id
预期结果：
1,李华,1,新西兰
2,韩冲,NULL,NULL
实际结果：
1,李华,1,新西兰
2,韩冲,1,新西兰
palo版本：
|version|5.1.0|
|version_comment|Baidu Doris(Palo) version 0.13.15-4e19c23|