mysql cr debug_mysql 存储过程使用dbforge 跟踪debug ，多了很多CALL cr_debug.UPDATE_WATCH3，如果去掉...

CREATEDEFINER=`rootdba`@`%`PROCEDURE`case_30day_ser4`(OUTout_flagINT,out_tableVARCHAR(200))BEGINDECLAREcr_stack_depthINTEGERDEFAULTcr_debug.ENTER_MODULE2('case_30day_ser4...

CREATE DEFINER=`rootdba`@`%` PROCEDURE `case_30day_ser4`(OUT out_flag INT,out_table VARCHAR(200))

BEGIN

DECLARE cr_stack_depth INTEGER DEFAULT cr_debug.ENTER_MODULE2('case_30day_ser4', 'parts', 7, 100632)/*[cr_debug.1]*/;

DECLARE l_serial_number VARCHAR(50);

DECLARE l_Account_Name VARCHAR(200);

DECLARE l_open_date DATETIME ;

DECLARE l_row_num_team VARCHAR(20);

DECLARE l_sub_gbu VARCHAR(30);

DECLARE l_num INT;

/*定义游标*/

DECLARE cu_case CURSOR FOR SELECT DISTINCT `serial_number`,`Account_Name`,`open_date`,`row_num_team` , `sub_gbu` FROM temp_case_ser7 ORDER BY row_num_team,open_date;

DECLARE CONTINUE HANDLER FOR NOT FOUND BEGIN/*[cr_debug.3 5]*/

DECLARE cr_stack_depth INTEGER DEFAULT cr_debug.ENTER_HANDLER('case_30day_ser4_Handler', 'case_30day_ser4', 'parts', 7, 100632)/*[cr_debug.2]*/;

CALL cr_debug.UPDATE_WATCH3('l_serial_number', l_serial_number, 'VARCHAR(50)', cr_stack_depth)/*[cr_debug.2]*/;

CALL cr_debug.UPDATE_WATCH3('l_Account_Name', l_Account_Name, 'VARCHAR(200)', cr_stack_depth)/*[cr_debug.2]*/;

CALL cr_debug.UPDATE_WATCH3('l_open_date', l_open_date, 'DATETIME', cr_stack_depth)/*[cr_debug.2]*/;

CALL cr_debug.UPDATE_WATCH3('l_row_num_team', l_row_num_team, 'VARCHAR(20)', cr_stack_depth)/*[cr_debug.2]*/;

CALL cr_debug.UPDATE_WATCH3('l_sub_gbu', l_sub_gbu, 'VARCHAR(30)', cr_stack_depth)/*[cr_debug.2]*/;

展开