isql-2 must be snapshot, and this is the default isolation for isql transactions (so, no need for set transaction).
Point is: there is an inconsistency in the currently Firebird behavior that can be easily reproduced.
I'll open a ticket in the tracker. Since I have zero knowledge about FB code, I cannot fix it by myself. IMHO, this ia a serious problem that deserves attention.
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
| Why do you think that one isql have transaction read commited but second have snapshot? I do not see your transaction command. If you depend on automatic transactions started by isql, then both are the same, no randomness... Regards, Karol Bieniaszewski |
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
