org.springframework.transaction.CannotCreateTransactionException: Could not create JDBC savepoint; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 9 near "SAVEPOINT SAVEPOINT_1"
You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 9 near "SAVEPOINT SAVEPOINT_1"
【业务影响】
select gg.SCGG_TYWYSBM as id, SC_TYWYSBM as materialId, SCPP_TYWYSBM as brandId, SCPP_MC as brandName,
JLDLDW as unit, d1.ZDMC as normName, GG_SZ as normNum, GG_DW as normUnit, d2.ZDMC as normUnitName,
BZZL_SZ as standWeight, gg.JG_TYWYSBM as orgId
from hs_sc_gg gg
left join sys_dict d1 on d1.ZDM = 'canMaterialUnit' and gg.JLDLDW = d1.ZDZ
left join sys_dict d2 on d2.ZDM = 'normUnit' and gg.GG_DW = d2.ZDZ
where gg.SCBS = '0' and gg.SC_TYWYSBM = #{materialId}
and (((gg.JG_TYWYSBM is null or gg.JG_TYWYSBM = '') and JLDLDW in ('1','99')) or gg.JG_TYWYSBM = #{orgId})
order by gg.JG_TYWYSBM, gg.SCPP_TYWYSBM
org.springframework.transaction.CannotCreateTransactionException: Could not create JDBC savepoint; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 9 near "SAVEPOINT SAVEPOINT_1"