[MCOL-3529] UPDATE always returns "0 rows affected" Created: 2019-09-30  Updated: 2019-12-09  Resolved: 2019-12-09

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.4.0
Fix Version/s: 1.4.2

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Epic Link: ColumnStore integration in ES in December 2019
Sprint: 2019-06

 Description   

Build tested: 1.4.0-1

engine commit:
1f47534

MariaDB [mytest]> select * from t2;
------

c1

------

5

------
1 row in set (0.012 sec)

MariaDB [mytest]> update t2 set c1=6;
Query OK, 0 rows affected (0.325 sec)
Rows matched: 0 Changed: 0 Warnings: 0

MariaDB [mytest]> select * from t2;
------

c1

------

6

------
1 row in set (0.009 sec)

MariaDB [mytest]> select count from orders;
----------

count

----------

1500000

----------
1 row in set (0.097 sec)

MariaDB [mytest]> update orders set o_orderkey = 1;
Query OK, 0 rows affected (2.565 sec)
Rows matched: 0 Changed: 0 Warnings: 0

MariaDB [mytest]> select count from orders where o_orderkey = 1;
----------

count

----------

1500000

----------
1 row in set (0.127 sec)

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-10-02 ]

This might not be fixable in 1.4. I'll mark it as 1.4.1 to be investigated.

Comment by Roman [ 2019-12-05 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2019-12-09 ]

Build verified: 1.4.2-1 source

Server

commit 6e1a53f89ee8d4eb9e66257b01898995aa7691de
Author: Sergei Golubchik <serg@mariadb.org>
Date: Mon Dec 2 18:07:11 2019 +0100

MENT-240 change plugin-maturity default to stable

Engine

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit a9717ad49daded3a037313556f68bcad7826fa39
Merge: 3f5e1fd c29c41e
Author: Roman Nozdrin <drrtuy@gmail.com>
Date: Mon Dec 9 11:55:08 2019 +0200

Merge pull request #962 from jmrojas2332/MCOL-3474

MCOL 3474 Fix TIMEDIFF w/ non-temporal data types

Also reproduced the issue source build last week. The issue has been fixed.

Built from source and retest

MariaDB [mytest]> update orders set o_clerk = "Hello, world";
Query OK, 1500000 rows affected (5.267 sec)
Rows matched: 1500000 Changed: 1500000 Warnings: 0

Generated at Thu Feb 08 02:43:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.