Hi, i try to follow this discussion and try to understand it. Is this discussion only about Read-only RC or about all RC transactions?
If i understand correctly this bug it look like (correct me if i am wrong): SELECT (SELECT COUNT(*) FROM TEST T2 WHERE T2.SOME_FIELD=1) /* Query 2 */ FROM TEST T WHERE (SELECT COUNT(*) FROM TEST T3 WHERE T3.SOME_FIELD=1)=1 /* Query 1 */ 1. Query 1 return count = 1 2. some transaction commit deletion form table TEST 3. Query 2 return 0 - because it see commit from point 2 if this can happen then this is critical BUG If you consider to put this fix as option in config - then this option should be enabled as default and someone can turn it off if needed regards, Karol Bieniaszewski ------------------------------------------------------------------------------ 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
