DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ADDTARGETChecK`()

BEGIN

declare vintcp varchar(100);

declare valias varchar(100);

declare intcpcount integer;

declare i int default 0;

set intcpcount = 0;

 select count(*) into intcpcount from mms_target_master_temp; 

  if(intcpcount >0) then

  while i<intcpcount do 

        select chld_intcp_value into vintcp from mms_target_master_temp LIMIT 1;

        select GEN_ALIAS into valias from  mms_target_master_temp where chld_intcp_value=vintcp LIMIT 1;

        set infinidb_vtable_mode=2;

        set sql_safe_updates=0;

        UPDATE MMS_CRI SET NOI_FLAG='HIGH', CLI_ALIAS=valias WHERE CALLING_IMEI=vintcp or CALLING_IMSI=vintcp or CALLINGPARTY=vintcp ;

        UPDATE MMS_CRI SET NOI_FLAG='HIGH',CLD_ALIAS=valias WHERE CALLED_IMEI=vintcp or CALLED_IMSI=vintcp  or CALLEDPARTY=vintcp;

        delete from mms_target_master_temp where chld_intcp_value=vintcp;

         set i=i+1;

     end while;

 end if;

END$$

DELIMITER ;

Error Code: 1178. The storage engine for the table doesn't support This stored procedure syntax is not supported by Columnstore in this version