geometry functions can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.

I tried to search about this error message but the only result is the InfiniDb error string list.

What I think is that those function are not marked as thread safe / reentrant / deterministic, so can not be used in certain processing stage of InfiniDB.

In my case I was trying to join a table using the ST_contains(p.polygon, POINT ()) trick, because I have to join a table using a range...

The query is like the following

select count as trx, sum(cost)
from transactions as t
join ip2city as c on ST_contains(p.polygon, POINT(CONV(hex(ip_bin), 16, 10), 0 ))
group by c.cityName

I tried a lot of method to join those two table, but this is the only one working...

Please if you can point me where to start to look up on this thesis, that we just need to remove / add this function to the list of "good" one.