LP:1028296 - Changing Server SQL Mode not apply to stored procedures

Changing Server SQL Mode not apply to stored procedures

SET sql_mode='NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE';

Query: insert into bonus_results (calc_date, id_prod_type, id_user) value ('2012-08-00', 1, 2)

Error Code: 1292
Incorrect date value: '2012-08-00' for column 'calc_date' at row 1

It's right, but same SQL in stored procedures continue work

Workaround only recreate all stored procedures