526互联

Code: 43, e.displayText() = DB::Exception: Invalid types of arguments 2 and 3 of if (version 20.8.3.18 (official build))错误

发布时间 2023-04-07 14:44:33作者: asjzmxk
Mysql当ifnull()和sum()联合使用时不会出现问题，如以下sql查询语句：

select

ifnull(sum(`sales_total`),0) sales_total,

ifnull(sum(`order_count`),0) order_count,

ifnull(sum(`avg_price_consumer`),0) avg_price_consumer,

ifnull(sum(`avg_price_car`),0) avg_price_car,

ifnull(sum(consumer_num_buy),0) consumer_num_buy,

ifnull(sum(consumer_num_total),0) consumer_num_total

from ssa_business_stats_sales_order_minute

但是在clickhouse中执行会出现错误： Code: 43, e.displayText() = DB::Exception: Invalid types of arguments 2 and 3 of if (version 20.8.3.18 (official build))

解决办法：去掉ifnull()，应为clickhouse中sum()查询null值会默认为0