MySQL Forums
Forum List  »  Connector/Node.js

Unexpected NULL Fields errors when updating or inserting record - MySQL XDevAPI NodeJs Connector 8.0.23
Posted by: Kevin Lau
Date: February 26, 2021 02:18AM

In the older versions, statement like below was good if passing a null value to it.

`First_Name` VARCHAR(60) NULL,
After upgrading to 8.0.23. If not passing any value or null to update or insert a nullable field, it will have errors such as this.

The error statement: "Error: Column name is required in ColumnIdentifier."
Occurred when passing a null value during update operations.


The error statement: "Error: Wrong number of fields in row being inserted"
Occurred when passing a null value during insert operations. The number of field is correct. The error will go away when given non-null value to a column.

It isn't inconsistent to the specification of Mysql Schema. Is this the expected behavior? What's the workaround without major version refactoring? Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Unexpected NULL Fields errors when updating or inserting record - MySQL XDevAPI NodeJs Connector 8.0.23
February 26, 2021 02:18AM


Sorry, only registered users may post in this forum.

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.