注册

netcore客户端驱动bug

 2021/12/31 1471 2

【DM版本】:DM8
【操作系统】:centos
【CPU】:
【问题描述】*:MERGE SQL语句,多个同名参数绑定有问题,insert 多个同名参数绑定正常
【驱动版本】:DmProvider[1.1.0]
表结构:biaojiegou.bmp

SQL:

MERGE INTO SYNCTOOL.TABLE_1 A USING 
 (select count(*) co FROM SYNCTOOL.TABLE_1 WHERE COLUMN_1 =:COLUMN_1)
 B ON(B.co<>0) 
 WHEN MATCHED THEN
 UPDATE  SET COLUMN_2 =:COLUMN_2
  WHERE COLUMN_1 =:COLUMN_1
  WHEN NOT MATCHED THEN
 INSERT(COLUMN_1, COLUMN_2)
 VALUES(:COLUMN_1, :COLUMN_2)

绑定参数:

   IDataParameter[] cmdParms = new IDataParameter[2];
   cmdParms[0] = new DmParameter(":COLUMN_1", "2");
   cmdParms[1] = new DmParameter(":COLUMN_2", "2");

 执行时报异常:
   Parameter Index Out Of Range
   at Dm.DmParameterCollection.CheckIndex(Int32 index)
   at Dm.DmCommand.BindParameters(Int32& rowCount, DmDataReader rd, CommandBehavior behavior)
   at Dm.DmCommand.do_ExecuteNonQuery()
   at Dm.DmCommand.ExecuteNonQuery()

回答 0
暂无回答
扫一扫
联系客服