Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5, 10.6
-
None
Description
create procedure pr(a int) select a; |
set sql_mode=''; |
call pr('foo'); |
set sql_mode='STRICT_ALL_TABLES'; |
call pr('foo'); |
drop procedure pr; |
MariaDB [test]> show warnings;
|
+---------+------+--------------------------------------------------------------+ |
| Level | Code | Message | |
+---------+------+--------------------------------------------------------------+ |
| Warning | 1366 | Incorrect integer value: 'foo' for column ``.``.`a` at row 1 | |
+---------+------+--------------------------------------------------------------+ |
1 row in set (0.000 sec) |
ERROR 1366 (22007): Incorrect integer value: 'foo' for column ``.``.`a` at row 1 |