Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.4.3
-
None
Description
Below are steps to reproduce. As can be seen, the update with join query indeed updates the record but does not return rows affected/rows matched stat is incorrect:
MariaDB [test]> drop table if exists bug4925; |
Query OK, 0 rows affected (0.231 sec) |
|
|
MariaDB [test]> drop table if exists bug4925_1; |
Query OK, 0 rows affected (0.184 sec) |
|
|
MariaDB [test]> create table bug4925 (id int, c1 int)engine=columnstore; |
Query OK, 0 rows affected (0.169 sec) |
|
|
MariaDB [test]> insert into bug4925 values(1,1),(2,2),(3,3),(4,4); |
Query OK, 4 rows affected (0.267 sec) |
Records: 4 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> select * from bug4925; |
+------+------+ |
| id | c1 |
|
+------+------+ |
| 1 | 1 |
|
| 2 | 2 |
|
| 3 | 3 |
|
| 4 | 4 |
|
+------+------+ |
4 rows in set (0.062 sec) |
|
|
MariaDB [test]> create table bug4925_1 (c1 int)engine=columnstore; |
Query OK, 0 rows affected (0.207 sec) |
|
|
MariaDB [test]> insert into bug4925_1 values(10),(100),(1),(2); |
Query OK, 4 rows affected (0.411 sec) |
Records: 4 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> update bug4925 join bug4925_1 using (c1) set bug4925.id=1000 where 1=1 and bug4925_1.c1>1; |
Query OK, 0 rows affected (0.310 sec) |
Rows matched: 0 Changed: 0 Warnings: 0 |
|
|
MariaDB [test]> select * from bug4925; |
+------+------+ |
| id | c1 |
|
+------+------+ |
| 1 | 1 |
|
| 1000 | 2 |
|
| 3 | 3 |
|
| 4 | 4 |
|
+------+------+ |
4 rows in set (0.021 sec) |