Regarding the MySQL Cluster documentation we are not allowed to modify a column to
NOT NULL on
ONLINE tables. i.e.
decimal(11,8) NOT NULL
Our hosting provider tells us the same limitation also applies to
OFFLINE tables, but I cannot find any indication in the documentation confirming this. In their opinion the only possible solution to modify or add a NOT NULL column is to recreate the whole table.
Can someone tell me if the above statement is right? What are the best steps to apply this schema change?