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>




Reply via email to