Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1600

Improve multi-UPDATE performance when foreign engine table is involved.

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.1.5
    • Icebox
    • MDB Plugin
    • None

    Description

      Here is the test suite that produces 3 affected rows with multi-UPDATE statement. Under the hood CS updates cs1 three times.

      MariaDB [test]> select * from cs1
          -> ;
      +------+------+
      | i    | t    |
      +------+------+
      |    1 | sa   |
      |    7 | NULL |
      |    5 | NULL |
      +------+------+
      3 rows in set (0.04 sec)
       
      MariaDB [test]> select * from i1;
      +------+------+
      | i    | t    |
      +------+------+
      |    1 | a    |
      |    2 | b    |
      |    3 | c    |
      +------+------+
      3 rows in set (0.01 sec)
       
      MariaDB [test]> update cs1 join i1 on i1.i=cs1.i set cs1.t = 'sa';
      Query OK, 3 rows affected (16.40 sec)
      

      Attachments

        Issue Links

          Activity

            People

              toddstoffel Todd Stoffel (Inactive)
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.