Select brings inconsitent results when database cache is low

[Sebastian Zürcher]

Hello

DB-Version: 11.0.1.2744
DB-Size: ~1g
We tested it also with the newest 11.0.1.XXXX EBF release.

We have a complex sql query with five subquerys and the group by clause. If I restrict the database server cache to 16m (with the option "-ch 16m") we get randomized different results from the same sql query (these issue is reproducible on different machines). Our customer have the same issue on his system without reducing the cache with the -ch option and with 8g of free memory.

What is a possible explanation for such a behavior?

We think that it would be better to get a warning message or a database server crash than inconsistent results.

If anyone need more information about the sql query or our environment please ask.

Thanks
Sebastian

[Sebastian Zürcher]

I posted the question also on stackoverflow with the full sql and a printscreen:

http://stackoverflow.com/questions/17776947/sql-anywhere-11-select-brings-inconsistent-results-when-database-cache-is-low