原创

Spring-sharding-jdbc-采坑记录

1、 Cannot support multiple schemas in one SQL
a.bill_no like "%"#{param}"%" or ---> a.bill_no like CONCAT('%',#{param},'%') or

2、sql 缺少第某位的参数
2.1 INSERT INTO tm_car_check_standard_template(`id_own_org`,`template_detail`)
values (CAST(#{idOwnOrg} as unsigned), CAST(#{standardTemplateList} as json))
不支持cast json
CAST(#{standardTemplateList} as json) ---> #{standardTemplateList
2.2 INSERT INTO xxx_table SELECT yyy from zzz where
不知,拆成2段
正文到此结束
本文目录