Try to add virtual column in to an existing table. The server is one of the node in a galera cluster, which is RBR.
It's a live table, and update/insert cannot be stopped. Alter table with add new virtual column by RSU without any issue. New row is coming in without problem. However, all PERSISTENT virtual column value will become null, VIRTUAL one is populated without issue.
It may be make sense for these columns become null if it is RBR? but how can I fix this null value after all server have the new table structure?
Are there any statement I can run to force the DB to re-calculate the PERSISTENT virtual column?