Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5.16, 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2, 11.3
-
None
-
CentOS Linux release 7.4.1708
Description
Reproduction Procedure
Preparation：
set global sql_mode=""; |
|
|
CREATE TABLE t1 ( |
c1 int(11) |
)；
|
|
|
DELIMITER //
|
CREATE definer='rdsAdmin'@'localhost' PROCEDURE add_row(IN c1 INT) SQL SECURITY INVOKER body: BEGIN insert into test.t1(c1) values(c1); END ; |
//
|
DELIMITER ;
|
|
|
call add_row(1);
|
call add_row(2);
|
call add_row(3);
|
Normal case
call add_row(2147483648);
|
show warnings;
|
Exceptions
select count(1) from t1 |
call add_row(2147483648);
|
show warnings;
|
The row number should be 1 but not.
use gdb to debug, find the variable m_current_row_for_warning is not reset or changed by something else
