Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7647

Virtual column and RBR (Galera Cluster)

    XMLWordPrintable

    Details

    • Sprint:
      5.5.54

      Description

      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?

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              leomkkwan Leo Kwan
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: