[BUG] The time filter is ignored when using the SQL query engine

[Smjert]

Describe the bug

The time filter is ignored when using the SQL query engine

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 ecomm, then select the first item opensearch*ecomm*
5. Using SQL query mode, run SELECT * FROM opensearch*ecomm* LIMIT 10
   • Ten results returned, however they are not within the timespan specified by the time filter.

Expected behavior

• Step 5: Ten results (limit in query) are shown in a list of entries with Time and _source, all within the selected timeframe.

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