[BUG] Invalid handling of DESCRIBE TABLES queries with the SQL search engine

[Smjert]

Describe the bug

Executing a SQL DESCRIBE TABLES LIKE <table pattern> query, causes the TABLE_NAME field in the results to contain the table pattern, instead of the actual table name.

To Reproduce

Steps to reproduce the behavior:

1. Login anonymous in the future playground.
2. Select the OTEL demo environment.
3. Select Discover from the menu on the left hand side
4. In the data source selection dropdown, type open, then select opensearch_dashboards_sample_data_logs
5. Set the Global Time Filter start to 1 Year ago.
6. Click into the query textbox
7. Run DESCRIBE TABLES LIKE *o*
   • The TABLE_NAME field is *o* which seems unexpected.

Expected behavior

• Steps 7: The table name that matched the pattern, not the pattern.

OpenSearch Version

2.18

Dashboards Version

2.18

Plugins

Alerting, anomaly-detection, asynchronous-search, cross-cluster-replication, custom-codecs, flow-framework, geospatial, index-management, job-scheduler, knn, ml, neural-search, notifications, notifications-core, observability, performance-analyzer, reports-scheduler, security, security-analytics, skills, sql, system-templates, query-insights

Screenshots

N/A

Host/Environment:

• OS: macOS
• Browser and version Google Chrome, version 131.0.6778.205

Additional context

N/A