Hi Team, Any update on this Thanks Abhishek Bhandary
From: Mahadev Mishal <[email protected]> Sent: Monday, October 13, 2025 8:25 PM To: [email protected] Cc: Abhishek Bhandary <[email protected]> Subject: Unexpected Behavior with Subquery and ORDER BY in FilterableTable Implementation 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:[email protected]] [cid:[email protected]] 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>
