Karol Bieniaszewski
Karol Bieniaszewski
Exit code is ok then. But i see that switch to stop restore immidietly will be also helpfull to do not spend time if someone do not need this.
I see that postgress have this feature and it name it as "incremental sort" in explain plan https://www.pgmustard.com/docs/explain/incremental-sort https://www.postgresql.org/docs/14/using-explain.html
Probably simple fix that restore do not perform check on computed fields at all without calculation about max size. As user normally in select can specify e.g. only one of...
I suppose it is time to implement this :) I suppose work on Window Functions done by @asfernandes can be used here, like e.g. record buffer.
Two things. 1. This is not the support forum. Go to Firebird support forum and ask there. 2. Have you tested the above script if it can be run at...
Why not running query to find duplicates? `SELECT ID+0 FROM MY_TABLE GROUP BY ID+0 HAVING COUNT(*)>1`
@basid-irk but why do you need such info if you can query database to see it?
I do suppose that crating invalid index is no go in database world. And about CPU/IO, index creation is no magic, during creation engine must scan whole data pages for...
When the replicated database become master database, it is not possible to work without real generator values. Also consider that generators can be used as settings flag.
Such setting will be realy good, someone if like, can even setup all generators to replicate. You can add worning about some potetntial performane problems, but i do not see...