[FLINK-36085] Refactor SHOW operations with LIKE/ILIKE

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0-preview
• Component/s: Table SQL / API, Table SQL / Planner
• Assignee: Sergey Nuyanzin
• Reporter: Sergey Nuyanzin
• Created: 18/Aug/24 20:26
• Updated: 02/Sep/24 09:35
• Resolved: 20/Aug/24 11:46

Description

Current implementation has several issues
1. every operation implements its own support of LIKE, ILIKE while common logic could be extracted and reused
2. Some operation generate invalid SQL for asSummaryString and the format is different between show operations
3. Some operations throw NPE if database or catalog is not set instead of ValidationException

so the logic could be generalized for this SQL SHOW operations

Issue Links

• links to: Fixed in one of commits of PR#25200