Company or project name
Clickhouse
Use case
For full MySQL compatibility, we need to support this command. Recently, we had a customer trying to connect to ClickHouse using the C# MySQL driver (MySQL.Data 9.3). When invoking connection.open(), the driver sends a handful of metadata-related queries over the wire. ClickHouse already handles all other queries without issue, but throws an exception on SHOW COLLATION.
cc: @alexey-milovidov
Describe the solution you'd like
Minimum viable solution: return an empty set and don't throw a syntax error
Ideal solution: return some transformed version of the (already existent) information_schema.collations table data matching the structure outlined in MySQL documentation: https://dev.mysql.com/doc/refman/9.3/en/show-collation.html
Describe alternatives you've considered
No response
Additional context
No response
Company or project name
Clickhouse
Use case
For full MySQL compatibility, we need to support this command. Recently, we had a customer trying to connect to ClickHouse using the C# MySQL driver (MySQL.Data 9.3). When invoking
connection.open(), the driver sends a handful of metadata-related queries over the wire. ClickHouse already handles all other queries without issue, but throws an exception onSHOW COLLATION.cc: @alexey-milovidov
Describe the solution you'd like
Minimum viable solution: return an empty set and don't throw a syntax error
Ideal solution: return some transformed version of the (already existent)
information_schema.collationstable data matching the structure outlined in MySQL documentation: https://dev.mysql.com/doc/refman/9.3/en/show-collation.htmlDescribe alternatives you've considered
No response
Additional context
No response