It is matching the wrong ones too...

MariaDB [test]> SELECT * FROM test_like  WHERE ( dep LIKE "%05%" )  ;

+------+

| dep  |

+------+

| 50   |

| 10   |

+------+

2 rows in set (0.02 sec)

interesting. I tested with a varchar (3) instead of varchar (2). The result is columnstore in correct :

CREATE TABLE `test_like3` (`dep` varchar(3) DEFAULT NULL) ENGINE=columnstore DEFAULT CHARSET=utf8;

INSERT INTO test_like3 VALUES ('05'),('5'),('50'),('10');

SELECT count(*) FROM test_like3  WHERE ( dep LIKE "05%" )  ;

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

| count(*) |

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

|        1 |

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

SELECT count(*) FROM test_like3  WHERE ( dep LIKE "%05%" )  ;

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

| count(*) |

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

|        1 |

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

And the matching is correct : 

 # mysql 13:11:04 > SELECT * FROM test_like3  WHERE ( dep LIKE "%05%" )  ;

+------+

| dep  |

+------+

| 05   |

+------+

Four pull requests open. Two on engine (develop and develop-1.0), two on regression suite (master and 1.0).

The cause was essentially the LIKE was truncated to the length of the column when the column was a non-dictionary column (< 8 bytes). So for the original test case the LIKE on "%05%" became a LIKE on "%0" which matches 10 and 50. LIKE is now pushed through expression step instead of simple filter step which has an 8 byte limitation on non-dictionary CHAR/VARCHAR.

Build verified: 1.0.9-1

MariaDB [mytest]> SELECT count FROM test_like WHERE ( dep LIKE "05%" ) ;
----------

count

----------

----------
1 row in set (0.01 sec)

MariaDB [mytest]> SELECT count FROM test_like WHERE ( dep LIKE "%05%" ) ;
----------

count

----------

----------
1 row in set (0.01 sec)

Build verified: Github source 1.1.0-1

[root@localhost mariadb-columnstore-server]# git show
commit 349cae544b6bc71910267a3b3b0fa3fb57b0a587
Merge: bd13090 2ecb85c
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Thu May 4 16:06:16 2017 -0500

Merge pull request #50 from mariadb-corporation/10.2-fixes

10.2 fixes

[root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
[root@localhost mariadb-columnstore-engine]# git show
commit b4883e6abd18fb63c4af450679c2720cdb537dad
Merge: 85a5eaa 83331f4
Author: dhall-InfiniDB <david.hall@mariadb.com>
Date: Thu May 11 09:43:28 2017 -0500

Merge pull request #182 from mariadb-corporation/MCOL-712

MCOL-712 Support TEXT for GROUP BY

MariaDB [mytest]> CREATE TABLE `test_like` (
-> `dep` varchar(2) DEFAULT NULL
-> ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.10 sec)

MariaDB [mytest]> INSERT INTO test_like VALUES ('05'),('5'),('50'),('10');
Query OK, 4 rows affected (0.08 sec)
Records: 4 Duplicates: 0 Warnings: 0

MariaDB [mytest]> SELECT * FROM test_like;
------

------

------
4 rows in set (0.03 sec)

MariaDB [mytest]> SELECT count FROM test_like WHERE ( dep LIKE "05%" ) ;
----------

count

----------

----------
1 row in set (0.01 sec)

MariaDB [mytest]>
MariaDB [mytest]> SELECT count FROM test_like WHERE ( dep LIKE "%05%" ) ;
----------

count

----------

----------
1 row in set (0.01 sec)