Hi Team, I'm currently working with Apache Calcite and have implemented a custom table using the FilterableTable interface to expose a virtual view (datamodeling.views). While testing query behavior, I noticed a discrepancy in results between two seemingly equivalent queries.
Below are the snapshots of the results. [cid:15e448a4-4485-46a2-ac69-d0fcc734e7d6] [cid:9915e99b-3fb9-475b-b894-cb58fff4a79e] Is there a recommended approach to preserve sort order when using subqueries in Calcite? Any guidance or suggestions would be greatly appreciated. Please let me know if you need more details. Thank you for your time! [Rockwell Automation]<https://www.rockwellautomation.com/> Mahadev Mishal Senior Software Engineer A-Wing Mississippi Bldg Embassy Tech Zone, Hinjewadi P2, Pune India [Rockwell Automation Facebook]<https://www.facebook.com/ROKAutomation> [Rockwell Automation Instagram] <https://www.instagram.com/rokautomation/> [Rockwell Automation LinkedIn] <http://www.linkedin.com/company/rockwell-automation> [Rockwell Automation Twitter] <https://twitter.com/ROKAutomation>
