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>
