Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.1.1
-
None
Description
The following stored procedure triggers an error:
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 ;
|
mms_target_master_temp is an InnoDB table, MMS_CRI is a ColumnStore table. The error triggered is:
Error Code: 1178. The storage engine for the table doesn't support This stored procedure syntax is not supported by Columnstore in this version
|
It does not error in InfiniDB. It appears to me that the update is trigging a rnd_init which errors because we are in an update.