"SELECT DISTINCT col FROM table LIMIT O,N" ignores offset

DROP TABLE IF EXISTS a;

CREATE TABLE a (a INT) ENGINE=Columnstore;

INSERT INTO a VALUES (1), (1), (2), (3);

SELECT DISTINCT a FROM a LIMIT 2;

/*

+------+

| a    |

+------+

|    1 |

|    2 |

+------+

*/

SELECT DISTINCT a FROM a LIMIT 2,2;

/*

+------+

| a    |

+------+

|    1 |

|    2 |

+------+

Expected:

+------+

| a    |

+------+

|    3 |

+------+

*/

SELECT DISTINCT a FROM a ORDER BY 1 LIMIT 2,2;

/*

+------+

| a    |

+------+

|    3 |

+------+

*/