"ORDER BY BINARY a" is not like in InnoDB

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(32) CHARACTER SET latin1) ENGINE=InnoDB;

INSERT INTO t1 VALUES ('A'),('A ');

SELECT QUOTE(a) FROM t1 ORDER BY a, BINARY(a) DESC;

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

| QUOTE(a) |

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

| 'A '     |

| 'A'      |

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

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(32) CHARACTER SET latin1) ENGINE=ColumnStore;

INSERT INTO t1 VALUES ('A'),('A ');

SELECT QUOTE(a) FROM t1 ORDER BY a, BINARY(a) DESC;

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

| QUOTE(a) |

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

| 'A'      |

| 'A '     |

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