CODEWITHSUNDEEP
mysqlmariadb
Vishnu
Vishnu

Reputation: 9

Why can't I insert a NULL value into a column after MySQL Re-installation?

Why can't I insert a NULL value into a column after MySQL Re-installation?

INSERT INTO table_name () VALUE () After Re-Installation insert query not working on my local database. But it's working on the same table on my VPS. If I set any default value for that columns its working on a local database, But on VPS no need to set default values .

version() ~ 10.1.21-MariaDB

Upvotes: 0

Views: 740

Answers (1)

elenst
elenst

Reputation: 3987

With MariaDB 10.1.21 or MariaDB 10.2.4, if you have a BEFORE INSERT trigger and columns without default values, and your insert statement is silently ignored, you are most likely affected by the regression bug which prevents INSERTs under certain circumstances.

Previous and later versions should not be affected, the problem was fixed in 10.1.22 and 10.2.5.

As of today (March 14th, 2017), 10.1.22 goes through final release preparations and can become available any moment now. 10.2.5 will be released later.

Upvotes: 1

Related Questions