I am executing following SQL in ignite. As you can see there is no order by
clause in this SQL. Index is present on field name "id".
SqlFieldsQuery sql = new SqlFieldsQuery("select p.id. p.name from Person p
join table(id bigint = ?) i on p.id = i.id.") .setArgs(new
Object[]{5,4,1,7,3});
What I have observed is ignite always returns query result in an order as
it is provided in input.
E.g. I always get resultant rows in following order. This behaviour is
consistent.
p.id. p.name
5 test5
4 Test4
1 Test1
7 Test7
3 Test3
If I change input "id" sequence, the output changes as per the id sequence
provided.
Can someone please confirm this behaviour?
Also, will it remain same with calcite integration?
