MySQL Forums
Forum List  »  NDB clusters

Re: SQLSTATE[HY000]: General error: 1296 Got error 839 'Illegal null attribute' from NDBCLUSTER [updated]
Posted by: Sucre Sucre
Date: May 27, 2022 03:40AM

Thanks for your reply, Jon.

Just simple insert statement like "insert into supcs_recordings(project_id) value(1027);"

before that what I did is:

I first created the table with the field setting:
`checked` tinyint NOT NULL

and then I altered it with:
ALTER TABLE supcs_recordings CHANGE checked checked tinyint NOT NULL DEFAULT '0';

NDB version: 8.0.21

What I did to solve the problem and it worked: deleted the table and recreated with the DEFAULT VALUE setting set in the create table statement.


Options: ReplyQuote

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.