Dmitry Yemanov
Dmitry Yemanov
In fact, we have plenty of cases where the query is being rewritten before optimization, join transformation is just one of them.
1. `A IN (1)` => `A = 1` 2. `NOT A > 1` => `A complex expression with multiple subqueries And something may also be changed inside the optimizer: 1....
Well, I read #7258 exactly as the engine should track other indices and use any suitable one automagically. But I don't mind if we also offer some manual way. Let's...
1. _free pages_ - already available via SQL/API, could be added to _gstat_ 2. _temp table pages_ - stored outside the database, thus irrelevant 3. _temp blob from procedures or...
> Isn't it exactly purpose of journal_archive_command setting? To let you do whatever you like before, after and during (or instead of) journal delivery to replica. This request is about...
@gladiston A command-line tool to manually apply some set of replication segments is considered. If you include it into the script with the required pre- and post- processing, it should...
> > The RETURNING syntax look weird, but .... Really weird, moreover grammatically UNLIST looks much like CAST and RETURNING is used in PL/SQL for other purposes. May be use...
As for `VALUE` as derived column name, it looks OK for single-column table-value function, but we may have more complex ones in the future. In this case both `` and...
Mark, while `` is mandatory in the SQL specification, ` ` is optional.