Hi @Ruben Q L<mailto:[email protected]>
Thanks! I will check the replies and will subscribe to the dev list. Regards, Mahadev ________________________________ From: Ruben Q L <[email protected]> Sent: Friday, October 17, 2025 2:58:30 PM To: [email protected] <[email protected]> Cc: Mahadev Mishal <[email protected]>; Ninad Kulkarni <[email protected]> Subject: EXTERNAL: Re: Unexpected Behavior with Subquery and ORDER BY in FilterableTable Implementation [Use caution with links & attachments] Hello, There were some replies on this topic, see https://lists.apache.org/thread/6x6ly6wdns99dymg1gr7jgsvd45sdf6z<https://urldefense.com/v3/__https://lists.apache.org/thread/6x6ly6wdns99dymg1gr7jgsvd45sdf6z__;!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPhKG3VVi$> 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<https://urldefense.com/v3/__https://calcite.apache.org/community/*mailing-lists__;Iw!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPh0HcL7V$> 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]<mailto:[email protected]>> Sent: Monday, October 13, 2025 8:25 PM To: [email protected]<mailto:[email protected]> Cc: Abhishek Bhandary <[email protected]<mailto:[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. [X] [X] 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://urldefense.com/v3/__https://www.facebook.com/ROKAutomation__;!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPnuOetNh$> [Rockwell Automation Instagram] <https://urldefense.com/v3/__https://www.instagram.com/rokautomation/__;!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPq25kAgn$> [Rockwell Automation LinkedIn] <https://urldefense.com/v3/__http://www.linkedin.com/company/rockwell-automation__;!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPuD71ty7$> [Rockwell Automation Twitter] <https://urldefense.com/v3/__https://twitter.com/ROKAutomation__;!!JhrIYaSK6lFZ!tMz7LreXem8AD724N-I6iStCggB2gMPcOG780XfYp12wJKoDSOVoF9FDs2FU4K5ZjktyZTgMckv6pPSyda1NPvLOWN3t$>
