Vlad Khorsun comments

Results 290 comments of


                                            Vlad Khorsun

Unexpected Error on Firebird 5.0.1 SuperServer

Thanks, will wait for next message.

CTE retuns empty instantly, but applying where to the empty set in the main query is slow

Did you fetch all rows or just execute the query ? What is the plan of the query that "returns instantly" ?

Grant ROLE session scope

Now explain a bit about tokens management - where should the app get it from, how should the engine validate it, how long should the token be valid, could it...

Grant ROLE session scope

So, you need something like external (user defined) authenticator ? And, perhaps, something like: ``` CREATE [SESSION] ROLE AUTHENTICATED BY ; SET [SESSION] ROLE AUTHENTICATED BY ; ``` `` could...

Grant ROLE session scope

In this case I see no way to satisfy: > If the user connects to the database using ISQL, FlameRobin, etc., they won’t have any special privileges at all. User...

Grant ROLE session scope

Got it.

Fix #7269: Restore deferred primary key indexes

What about extracting code, copied from "creating FK" block below, into separate routine to avoid duplication ?

Fix #7269: Restore deferred primary key indexes

Please, be patient and wait a bit, I'll return to it when time permits.

Fix #7269: Restore deferred primary key indexes

I will add some additional fix after merge.

Fix #7269: Restore deferred primary key indexes

> JFYI: You can create a pull request to a pull request improving it before merging. Yes. But it is too much bureaucracy and not needed in this case.