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

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

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.1.5
    • Fix Version/s: Icebox
    • Component/s: Connector
    • Labels:
      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

              Assignee:
              toddstoffel Todd Stoffel
              Reporter:
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration