MySQL UI: choose partitioning columns in a dropdown, filter by type and index #3952
Description
Right now custom partitioning column is typed in a text field and expected to be the right type and to have an index. Partitioning itself will break if the column is the wrong type and will do multiple table scans if a non-indexed one was passed. Instead we can have the list tables call account for both on the backend and return an extra boolean for UI, then UI can display a dropdown based on that.
Bonus points for nicer integration with how the partition types are resolved in MySqlConnector.GetQRepPartitions and PartitionHelper.getPartitionForStartAndEnd but returning a MySQL allowlist from the connector is also good.
UI dropdown can default to no partitioning for now, and should handle gracefully when there's no eligible column.