Re: should be Set column with default value to null
Hi Fredrik,
You are running your database in non-STRICT mode. Please consult the documentation
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict.
You say it is running fine when executing those updates from the database tool but, in fact, you're missing the warning that is being issued in the background.
Connector/J, by default, automatically turns on the STRICT mode on all connections, as such, the same query fails here. This is by design, therefore not a bug.
Thank you,
Subject
Written By
Posted
February 10, 2017 07:34AM
February 10, 2017 07:35AM
Re: should be Set column with default value to null
February 20, 2017 12:11PM
February 21, 2017 12:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.