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

UPDATE returns wrong "Rows matched" on multi-tables

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 5.5.2
    • Fix Version/s: 22.08
    • Component/s: DMLProc
    • Labels:
      None
    • Environment:
      Centos 8
    • Sprint:
      2021-14, 2021-15, 2021-16

      Description

      Multi-tables UPDATE returns "Rows matched: 0" when expected 1.
      SELECT ROW_COUNT(); is also 0, when 1 is expected.

      The above happen only if engine=columnstore.
      With InnoDB: "Rows matched: 1" and ROW_COUNT() is 1 as well

      Reproduced with
      plugin_name: COLUMNSTORE_EXTENTS
      plugin_status: ACTIVE
      plugin_type_version: 100510.0
      plugin_library_version: 1.14
      plugin_license: GPL
      plugin_maturity: Stable
      plugin_auth_version: 5.5.2

      Repro:
      -------
      1) - preparation steps:
      create database sam;
      use sam;

      drop table if exists mcs_1;
      drop table if exists mcs_2;
      create table mcs_1(a int, b int(11), c varchar(100) ) engine=columnstore;
      create table mcs_2(a int, b int(11), c varchar(100) ) engine=columnstore;
      insert into mcs_1(a,b, c) VAlues( 33 , 99 , 1 );
      insert into mcs_1(a,b, c) VAlues( 33 , 99 , 2 );
      insert into mcs_1(a,b, c) VAlues( 33 , 99 , 3 );
      insert into mcs_2(a,b, c) VAlues( 33 , 11 , 1 );
      insert into mcs_2(a,b, c) VAlues( 33 , 11 , 2 );
      insert into mcs_2(a,b, c) VAlues( 33 , 11 , 3 );

      2) - repro:
      UPDATE mcs_1 A , mcs_2 B SET A.b = B.b WHERE A.c = B.c LIMIT 1;
      Query OK, 0 rows affected (0.409 sec)
      Rows matched: 0 Changed: 0 Warnings: 0 <========/ expected "Row matched: 1" in InnoDB

      SELECT ROW_COUNT;

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              David.Hall David Hall
              Reporter:
              YK Yakov Kushnirsky
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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