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

Virtual column and RBR (Galera Cluster)

    XMLWordPrintable

Details

    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.