Hello, There were some replies on this topic, see https://lists.apache.org/thread/6x6ly6wdns99dymg1gr7jgsvd45sdf6z You may have not received them because you are not subscribed to the dev list. If that is the case, I'd suggest to subscribe as described in https://calcite.apache.org/community/#mailing-lists
Best, Ruben On Fri, Oct 17, 2025 at 10:25 AM Abhishek Bhandary <[email protected]> wrote: > 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. > > > > > > > > > > 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! > > > > [image: Rockwell Automation] <https://www.rockwellautomation.com/> > > *Mahadev Mishal* > Senior Software Engineer > > A-Wing Mississippi Bldg Embassy Tech Zone, > Hinjewadi P2, Pune > India > [image: Rockwell Automation Facebook] > <https://www.facebook.com/ROKAutomation> [image: Rockwell Automation > Instagram] <https://www.instagram.com/rokautomation/> [image: Rockwell > Automation LinkedIn] <http://www.linkedin.com/company/rockwell-automation> > [image: Rockwell Automation Twitter] <https://twitter.com/ROKAutomation> > > > > >
