2014-06-25 13:52 GMT+04:00 Dimitry Sibiryakov <s...@ibphoenix.com>: > I.e. a strange application developer start transaction, then, after some > time, start a > query and want to see data consistent to the moment of query start instead of > transaction > start?
Exactly. The same prepared query can re-read fresh data in the same transaction, for instance refresh number of books. > May be it would be better if (s)he use brain and start transaction when it > is really > needed?.. +1. But read commited transaction can see new data. But to see new data during query execution is really funny IMO. -- Roman Simakov ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel