Re: FOR UPDATE support in SELECT clause
In this case you lock rows, but there are not subsequent operation which will use this lock. FOR UPDATE only makes sense as a part of transaction. On Tue, Nov 28, 2017 at 4:56 PM, Dmitriy Setrakyanwrote: > On Tue, Nov 28, 2017 at 12:34 AM, Vladimir Ozerov > wrote: > > > I do not see any use case for this. Why would you want to do this? > > > > Atomic cache supports locking to my knowledge. The use case would be > identical in SQL use case - to lock a row. Why not? >
Re: FOR UPDATE support in SELECT clause
On Tue, Nov 28, 2017 at 12:34 AM, Vladimir Ozerovwrote: > I do not see any use case for this. Why would you want to do this? > Atomic cache supports locking to my knowledge. The use case would be identical in SQL use case - to lock a row. Why not?
Re: FOR UPDATE support in SELECT clause
I do not see any use case for this. Why would you want to do this? On Tue, Nov 28, 2017 at 11:18 AM, Dmitriy Setrakyanwrote: > On Mon, Nov 27, 2017 at 11:33 PM, Vladimir Ozerov > wrote: > > > Hi Denis, > > > > "FOR UPDATE" is not supported at the moment. We will add it's support for > > transactional case [1]. In non-transactional case it would behave in the > > same way as normal SELECT. > > > > Why only for transactional cases? Why can't we lock for non-transactional > cases as well? >
Re: FOR UPDATE support in SELECT clause
On Mon, Nov 27, 2017 at 11:33 PM, Vladimir Ozerovwrote: > Hi Denis, > > "FOR UPDATE" is not supported at the moment. We will add it's support for > transactional case [1]. In non-transactional case it would behave in the > same way as normal SELECT. > Why only for transactional cases? Why can't we lock for non-transactional cases as well?
Re: FOR UPDATE support in SELECT clause
Hi Denis, "FOR UPDATE" is not supported at the moment. We will add it's support for transactional case [1]. In non-transactional case it would behave in the same way as normal SELECT. [1] https://issues.apache.org/jira/browse/IGNITE-6937 On Thu, Oct 19, 2017 at 3:21 AM, Denis Magdawrote: > Vladimir, Alex P., > > In addition to that please review INSERT, UPDATE, DELETE, MERGE commands > syntax. Are all the parameters (DIRECT, SORTED, etc.) supported by Ignite > and if, yes, then how? I’m doubt that Ignite fully supports H2 syntax: > https://apacheignite-sql.readme.io/v2.1/docs/dml > > — > Denis > > > On Oct 18, 2017, at 2:02 PM, Denis Magda wrote: > > > > Vladimir, Igniters, > > > > I’m editing the new version of our SELECT page [1] that initially > consisted of the content fully copied from H2. > > > > For instance, there we had the following statement that’s not true for > Ignite: "If FOR UPDATE is specified, the tables are locked for writing. > When using MVCC, only the selected rows are locked as in an UPDATE > statement. In this case, aggregate, GROUP BY, DISTINCTqueries or joins are > not allowed in this case." > > > > How do we process FOR UPDATE parameter in Ignite right now? Please do a > proof-read of the page at all confirming the rest data applies for Ignite. > > > > [1] https://apacheignite-sql.readme.io/v2.1/docs/select > > > > — > > Denis > >
Re: FOR UPDATE support in SELECT clause
Vladimir, Alex P., In addition to that please review INSERT, UPDATE, DELETE, MERGE commands syntax. Are all the parameters (DIRECT, SORTED, etc.) supported by Ignite and if, yes, then how? I’m doubt that Ignite fully supports H2 syntax: https://apacheignite-sql.readme.io/v2.1/docs/dml — Denis > On Oct 18, 2017, at 2:02 PM, Denis Magdawrote: > > Vladimir, Igniters, > > I’m editing the new version of our SELECT page [1] that initially consisted > of the content fully copied from H2. > > For instance, there we had the following statement that’s not true for > Ignite: "If FOR UPDATE is specified, the tables are locked for writing. When > using MVCC, only the selected rows are locked as in an UPDATE statement. In > this case, aggregate, GROUP BY, DISTINCTqueries or joins are not allowed in > this case." > > How do we process FOR UPDATE parameter in Ignite right now? Please do a > proof-read of the page at all confirming the rest data applies for Ignite. > > [1] https://apacheignite-sql.readme.io/v2.1/docs/select > > — > Denis
FOR UPDATE support in SELECT clause
Vladimir, Igniters, I’m editing the new version of our SELECT page [1] that initially consisted of the content fully copied from H2. For instance, there we had the following statement that’s not true for Ignite: "If FOR UPDATE is specified, the tables are locked for writing. When using MVCC, only the selected rows are locked as in an UPDATE statement. In this case, aggregate, GROUP BY, DISTINCTqueries or joins are not allowed in this case." How do we process FOR UPDATE parameter in Ignite right now? Please do a proof-read of the page at all confirming the rest data applies for Ignite. [1] https://apacheignite-sql.readme.io/v2.1/docs/select — Denis