[MCOL-2239] Rows matched: and Changed: are 0 even if rows changed after update - Jira

XML

Word

Printable

To reproduce:

 create table t1 (c1 int) engine=columnstore;

insert into t1 (c1) values(1);

insert into t1 (c1) values(2);

update t1 set c1 = c1 +1;

Rows matched and Changed --> 0

Query OK, 2 rows affected (0.516 sec)

Rows matched: 0  Changed: 0  Warnings: 0

The same testcase works with InnoDB

 create table t1inno (c1 int) engine=columnstore;

insert into t1inno (c1) values(1);

insert into t1inno (c1) values(2);

update t1inno set c1 = c1 +1;

Query OK, 2 rows affected (0.056 sec)

Rows matched: 2  Changed: 2  Warnings: 0

relates to

MCOL-4536 update returns wrong number of rows updated

MCOL-1527 Incorrect 0 row(s) affected on delete with cross engine join

MCOL-1782 UPDATE and DELETE reported incorrect affected row count

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