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)
|