Non case sensitive collations cause either 1. not using covering index or 2. adding more space inefficiency in MyRocks. It is better to return errors by default when using case insensitive columns, so that application developers can change collations before filling data. And optionally allow creating case insensitive columns by configuration parameter.
Non case sensitive collations cause either 1. not using covering index or 2. adding more space inefficiency in MyRocks. It is better to return errors by default when using case insensitive columns, so that application developers can change collations before filling data. And optionally allow creating case insensitive columns by configuration parameter.