Hi, Oleksandr! On May 16, Oleksandr Byelkin wrote:
That's different. See:
CREATE VIEW v1 AS SELECT * FROM t1 FOR UPDATE; SELECT * FROM v1, t2;
This is different from
SELECT * FROM t1, t2 FOR UPDATE;
the first locks only t1, the second - both t1 and t2. meant, what the user expectations could be.
Yes, but they are against at least standard, and we should think a lot before implement yet another non-standard feature.
Sure. FOR UPDATE, LOCK IN SHARE MODE, and clauses I've mentioned in another email are all non-standard. The question is not about implementing another non-standard feature, but about how the combination of existing features should work. This is a tradeoff between the principle of the least surprise, how much effort we want to put into this, and whether there's anyone who expects it to work :) Regards, Sergei Chief Architect MariaDB and security@mariadb.org