关于clickhouse左连接 获取右表关联不到的数据有默认值的问题

在ck中执行如下sql：

select l.*, r.* from
( select 'a' as a ) l
left join
( select '1' as a, 1 as b ) r
on l.a = r.a;

得到的右表结果是有默认值填充：

去除默认值：

select l.*, r.* from
( select 'a' as a ) l
left join
( select '1' as a, 1 as b ) r
on l.a = r.a SETTINGS join_use_nulls = 1;

更多clickhouse设置参考：
https://clickhouse.com/docs/en/operations/settings/settings#join_use_nulls