Alexander Barkov added a comment - 2020-12-16 13:57 The same problem is repeatable with HEX() instead of BINARY(): 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, HEX(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, HEX(a) DESC ; +----------+ | QUOTE(a) | +----------+ | 'A' | | 'A ' | +----------+

Alexander Barkov added a comment - 2020-12-16 14:19 - edited Note, if I remove "col" from the ORDER BY list, it seems to work fine: 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 HEX(a); +----------+ | QUOTE(a) | +----------+ | 'A' | | 'A ' | +----------+ SELECT QUOTE(a) FROM t1 ORDER BY HEX(a) DESC ; +----------+ | QUOTE(a) | +----------+ | 'A ' | | 'A' | +----------+ Without "col" in ORDER BY, it also works fine with BINARY(a): SELECT QUOTE(a) FROM t1 ORDER BY BINARY (a); SELECT QUOTE(a) FROM t1 ORDER BY BINARY (a) DESC ;