Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation
On 5-3-2015 20:52, Jim Starkey wrote: >> On Mar 5, 2015, at 2:30 PM, Roman Simakov wrote: >> >> >>> 5 марта 2015 г., в 20:26, Jim Starkey написал(а): >>> >>> "read imaginary» >> >> Is it not the same as "read uncommited"? :) > > Oh, certainly not! Read imaginary invents whole new record(s) conforming to > the search criteria with random numbers/strings for other fields. Read > imaginary is what you use when you have an infinite number monkeys, lots of > patience, and need a complete copy of Shakespeare free of copyright > constraints. Sounds like a good way to generate random testdata ;) Mark -- Mark Rotteveel -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation
> On Mar 5, 2015, at 2:30 PM, Roman Simakov wrote: > > >> 5 марта 2015 г., в 20:26, Jim Starkey написал(а): >> >> "read imaginary» > > Is it not the same as "read uncommited"? :) Oh, certainly not! Read imaginary invents whole new record(s) conforming to the search criteria with random numbers/strings for other fields. Read imaginary is what you use when you have an infinite number monkeys, lots of patience, and need a complete copy of Shakespeare free of copyright constraints. > > -- > Roman Simakov > > > > > > > -- > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation
> 5 марта 2015 г., в 20:26, Jim Starkey написал(а): > > "read imaginary» Is it not the same as "read uncommited"? :) -- Roman Simakov -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation
> On Mar 5, 2015, at 1:04 PM, Ann Harrison wrote: > > > >> On Mar 5, 2015, at 11:26 AM, "liviusliv...@poczta.onet.pl" >> wrote: >> >> Hi, >> >> It is usefull for testing purposes. Consider monitoring what actually is in >> some table from other connection or software before some long task has >> finished. > > Nothing is in a table until it is committed, so there's nothing to monitor. That may be logically correct, but physically, an uncommitted record is there, at least in Firebird MVCC. So it would be possible, I suppose, to implement read uncommitted, though there is a nast problem that an uncommitted record would mask a committed version, but that's part and parcel of read uncommitted. But hey, why stop there? How about "read rolledback", "read deleted", "read imaginary", and 'read whatever" (Monty's default mode for MySQL)? > > > > Best regards, > > Ann > -- > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Odp: READ UNCOMMITTED implementation
> On Mar 5, 2015, at 11:26 AM, "liviusliv...@poczta.onet.pl" > wrote: > > Hi, > > It is usefull for testing purposes. Consider monitoring what actually is in > some table from other connection or software before some long task has > finished. Nothing is in a table until it is committed, so there's nothing to monitor. Best regards, Ann -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Odp: READ UNCOMMITTED implementation
Hi, It is usefull for testing purposes. Consider monitoring what actually is in some table from other connection or software before some long task has finished. Regards, Karol Bieniaszewski - Reply message - Od: "Mark Rotteveel" Do: "For discussion among Firebird Developers" Temat: [Firebird-devel] READ UNCOMMITTED implementation Data: śr., mar 4, 2015 08:38 What is the use case for it? As far as I recall the sql standard doesn't require it (and maybe even discourages it) but has it include because some systems already had it. Mark - Reply message - Van: "marius adrian popa" Aan: "For discussion among Firebird Developers" Onderwerp: [Firebird-devel] READ UNCOMMITTED implementation Datum: wo, mrt. 4, 2015 08:12 Seems that we need F111-01 implemented https://github.com/rowland/fb/issues/42 http://www.firebirdsql.org/en/sql-conformance/-- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel