当前使用版本(必填,否则不予处理)
3.5.3.1
该问题是如何引起的?(确定最新版也有问题再提!!!)
重现步骤(如果有就写完整)
原sql
UPDATE customer_info c SET c.commodity_quantity = (SELECT IFNULL(sum(co.total_quantity), 0) AS total_quantity FROM customer_order co WHERE co.customer_id = 1) WHERE c.customer_id = 1
解析后
UPDATE customer_info c SET c.commodity_quantity = (SELECT IFNULL(sum(co.total_quantity), 0) AS total_quantity FROM customer_order co WHERE co.customer_id = 1) WHERE c.customer_id = 1 AND c.tenant_id = 1
期望:
UPDATE customer_info c SET c.commodity_quantity = (SELECT IFNULL(sum(co.total_quantity), 0) AS total_quantity FROM customer_order co WHERE co.customer_id = 1 AND co.tenant_id = 1) WHERE c.customer_id = 1 AND c.tenant_id = 1
报错信息
Comment From: miemieYaho
下个版本将修复