Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.2
-
None
Description
On MariaDB Master
MariaDB [test]> insert into t1 values (0,0); |
Query OK, 1 row affected (0.04 sec) |
|
MariaDB [test]> select * from t1;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 0 | 0 | |
+------+------+
|
1 row in set (0.00 sec) |
|
MariaDB [test]> update t1 set b=1 where a = 0; |
Query OK, 1 row affected (0.03 sec) |
Rows matched: 1 Changed: 1 Warnings: 0 |
|
MariaDB [test]> select * from t1;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 0 | 1 | |
+------+------+
|
1 row in set (0.00 sec) |
MariaDB [test]> insert into t1 values (0, 2); |
Query OK, 1 row affected (0.03 sec) |
MariaDB [test]> delete from t1 where b = 1; |
Query OK, 1 row affected (0.03 sec) |
|
On mxs_adapter machine
[root@eb9c5aaf87f8 /]# /usr/bin/mxs_adapter -ucdcuser -pcdc -hmaxscale -P4001 test t1 |
1 rows and 0 transactions inserted in 5.44538 seconds. GTID = 0-1-3 |
1 rows and 1 transactions inserted in 0.331933 seconds. GTID = 0-1-4 |
1 rows and 0 transactions inserted in 5.54281 seconds. GTID = 0-1-4 |
1 rows and 1 transactions inserted in 0.324007 seconds. GTID = 0-1-5 |
1 rows and 1 transactions inserted in 0.493277 seconds. GTID = 0-1-6 |
on MariaDB ColumnStore
MariaDB [test]> select * from t1;
|
+------+------+--------+--------------+------------+----------+-----------+------------+
|
| a | b | domain | event_number | event_type | sequence | server_id | timestamp |
|
+------+------+--------+--------------+------------+----------+-----------+------------+
|
| 0 | 0 | 0 | 1 | insert | 3 | 1 | 1512936904 | |
| 0 | 0 | 0 | 1 | _CpNoTf_ | 4 | 1 | 1512937641 | |
| 0 | 1 | 0 | 2 | _CpNoTf_ | 4 | 1 | 1512937641 | |
| 0 | 2 | 0 | 1 | insert | 5 | 1 | 1512937971 | |
| 0 | 1 | 0 | 1 | NULL | 6 | 1 | 1512938047 | |
+------+------+--------+--------------+------------+----------+-----------+------------+
|
5 rows in set (0.03 sec) |
Issue: Note the event_type for update event on MariaDB ColumnStore is showing as "CpNoTf"
Issue: Note the event_type for delete event on MariaDB ColumnStore is showing as "NULL"