log.txt (72.3 KB)
执行某存储过程导致该报错，可复现
版本号：4.3.5.0
存储过程：
CREATE DEFINER = root@% PROCEDURE check_daily() MODIFIES SQL DATA BEGIN DECLARE done INT DEFAULT 0; DECLARE v_table VARCHAR(255); DECLARE cur CURSOR FOR SELECT DISTINCT table_name FROM binary.field_config; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; DELETE FROM table_data_stat; OPEN cur; read_loop: LOOP FETCH cur INTO v_table; IF done = 1 THEN LEAVE read_loop; END IF; SET @dyn_sql = CONCAT( 'INSERT INTO table_data_stat ', '(table_name, row_count, max_td_date, max_sid, stat_time) ‘, ‘SELECT ‘, ‘’’’, v_table, ‘’’, ', 'COUNT(*), ', 'MAX(td_date), ', 'MAX(sid), ', 'NOW() ', ‘FROM binary.’, v_table ); PREPARE stmt FROM @dyn_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END LOOP; CLOSE cur; SELECT * FROM table_data_stat ORDER BY row_count DESC; END