I think that the SQL semantics of SELECT does not guarantee preserving the order of records in the input collection.
Mihai ________________________________ From: Francis Chuang <[email protected]> Sent: Monday, October 13, 2025 2:15 PM To: [email protected] <[email protected]> Subject: Re: Unexpected Behavior with Subquery and ORDER BY in FilterableTable Implementation The images show when they are in moderation, but appears to be removed when posted to the list. I ran the images through a image -> text converter and here are the results: Image 1: ra-testfdm-n=> select name from datamodeling.views order by name asc; name ------------- Action Activity Activity Areas Asset Asset class Asset type Assets Blower_1 Blower_10 Blower_100 Blower_11 Blower_12 Blower_13 Blower_14 Blower_15 Blower_16 Blower_17 Blower_18 Blower_19 Blower_2 Image 2: ra-testfdm-n=> select "$Table"."name" as "name" from (select name, externalid from datamodeling.views order by name asc) "$Table"; name -------------- Dress Blower_100 Blower_10 Blower_11 Blower_1 Blower_12 Blower_13 Blower_14 Blower_15 Blower_16 Blower_17 Blower_18 Blower_19 Blower_20 Blower_21 Blower_2 Blower_22 Blower 23 On 14/10/2025 3:37 am, Mihai Budiu wrote: > I believe that the dev mailing list will strip images from messages. At least > I cannot see them. > > Calcite is really a framework which can be configured in countless ways. You > have to tell us more about your particular setup. > > Mihai > > > ________________________________ > From: Mahadev Mishal <[email protected]> > Sent: Monday, October 13, 2025 7:55 AM > To: [email protected] <[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: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> > > > > >
