[#MCOL-1982] mxs_adapter inserts incorrect value in char field

Using mxs_adapter with -z option

MAxScale 2.3.2
mxs_adapter 1.2.2
ColumnStore 1.2.1

 mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdc -h ec2-3-16-150-134.us-east-2.compute.amazonaws.com -P 4001 -r 50 -d -n -z -f bank.lst

The perform insert on source MariaDB Server:

MySQL [bank]> insert into account values (0,1,"test", "0000-00-02")

    -> ;

Query OK, 1 row affected (0.035 sec)

Here is MXS_ADAPTER log

2018-11-29 16:04:56 [bank.client] Read timeout

2018-11-29 16:04:59 [bank.account] INSERT INTO `bank`.`account` (`account_id`,`district_id`,`frequency`,`a_d`) VALUES (0,1,'test','0-00-02')

2018-11-29 16:04:59 [bank.account] DML average: 24ms

2018-11-29 16:05:06 [bank.loan] Read timeout

Here is the data as it shows on source database, after the insert

MySQL [bank]> insert into account values (0,1,"test", "0000-00-02")

    -> ;

Query OK, 1 row affected (0.035 sec)

MySQL [bank]> select * from account where account_id=0 and a_d = "0000-00-02";

+------------+-------------+-----------+------------+

| account_id | district_id | frequency | a_d        |

+------------+-------------+-----------+------------+

|          0 |           1 | test      | 0000-00-02 |

+------------+-------------+-----------+------------+

1 row in set (0.036 sec)

Here is how the data shows up on target columnstore database after mxs_adapter has streamed this insert

MariaDB [bank]> select * from account where account_id=0 and a_d = "0000-00-02";

+------------+-------------+-----------+------------+

| account_id | district_id | frequency | a_d        |

+------------+-------------+-----------+------------+

|          0 |           1 | _CpNoTf_  | 0000-00-02 |

+------------+-------------+-----------+------------+

1 row in set (0.024 sec)

Notice the column "frequency" in source DB Server is "test" vs "CpNoTf" in columnstore

[MCOL-1982] mxs_adapter inserts incorrect value in char field Created: 2018-11-29 Updated: 2018-11-29 Resolved: 2018-11-29
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	?
Affects Version/s:	1.2.1
Fix Version/s:	Icebox