Description:
When I set a item of the section "mysqld" in the file named "my.ini" as follow:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
next, I tried to create a stored procedure routine in the MySQL command shell as follow:
create procedure `myproc1`() select * from mytable1;
and then, MySQL reported an error as follow:
ERROR 1655 (HY000): Cannot create stored routine `myproc1`. Check warnings
Warning 1265: Data truncated for column 'sql_mode' at row 1
After I removed the "sql-mode" item of the section "mysqld", and tried to create the same stored procedure routine again, I'd
How to repeat:
First, set a item of the section "mysqld" in the file named "my.ini" as follow:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Next, try to create a stored procedure routine in the MySQL command shell as follow:
create procedure `myproc1`() select * from mytable1;
Description: When I set a item of the section "mysqld" in the file named "my.ini" as follow: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" next, I tried to create a stored procedure routine in the MySQL command shell as follow: create procedure `myproc1`() select * from mytable1; and then, MySQL reported an error as follow: ERROR 1655 (HY000): Cannot create stored routine `myproc1`. Check warnings Warning 1265: Data truncated for column 'sql_mode' at row 1 After I removed the "sql-mode" item of the section "mysqld", and tried to create the same stored procedure routine again, I'd How to repeat: First, set a item of the section "mysqld" in the file named "my.ini" as follow: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Next, try to create a stored procedure routine in the MySQL command shell as follow: create procedure `myproc1`() select * from mytable1;