panbingkun
panbingkun
cc @cloud-fan @mihailom-db
Currently only show `normalized` collation name.
If necessary, we can also show columns: `CaseSensitivity` and `AccentSensitivity`
Another option: - when execute `SHOW COLLATIONS ...`, only show columns: `name`, `provider` and `version` - when execute `DESCRIBE COLLATIONS ...`, will display columns: `name`, `provider`, `version`, `binary_equality`, `binary_ordering`, `lowercase_equality`,...
> Apart from SQL API, we need to support other APIs as well, which should be used by calling `Session.catalog.collation`. Because of this, your approach might need to be reworked...
> I believe for now we agreed to have only `SHOW COLLATION(S)` as a command, and then add support for both LIKE and ILIKE operators for searching. But it is...
@mihailom-db All suggestions have been updated and verified locally as follows:
> Hi @panbingkun this is starting to look like what we want to get as a result. Thanks for taking the initiative. Apart from the SQL command for SHOW COLLATIONS...
> Hi @panbingkun I left some comments for you, sorry for the delay. I believe you are really close to getting to the point of what we want from SHOW...
Hi, @mihailom-db, I have a few questions to ask: - Does the `CATALOG` here correspond to spark's `catalog`? (the default value should be `spark_catalog`, not `SYSTEM`) Meanwhile, does `SCHEMA` correspond...