MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: should be Set column with default value to null
Posted by: Filipe Silva
Date: February 20, 2017 12:11PM

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,

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Set foreign key column with default value to null
Fredrik Tyboni
February 10, 2017 07:34AM
Re: should be Set column with default value to null
Fredrik Tyboni
February 10, 2017 07:35AM
Re: should be Set column with default value to null
Filipe Silva
February 20, 2017 12:11PM
Re: should be Set column with default value to null
Fredrik Tyboni
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.