Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1092

update and delete event_types are labeled with incorrect/garbled characters

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.2
    • 1.1.3
    • ?
    • 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"

      Attachments

        Activity

          People

            markus makela markus makela
            dshjoshi Dipti Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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