Karol Bieniaszewski
Karol Bieniaszewski
> Yes, and this is exactly what is called "bypass security checks": assign role to a user session even if this user wasn't granted rights to use this role. The...
My English is to bad probably, but I see that @mrotteveel understands my goal.
@aafemt exactly :) Validation is not the subject of this ticket, because the validation happens on our side — in our regular database procedure, here named SETUP_ROLE_XXX. Whether the entire...
Forget about the token — we only need the `FORCE` flag for SET ROLE. That’s all we need; the authentication logic is handled on our side.
@hvlad But he doesn't know how to set the correct parameters for the procedure 🙂 Token, or whatever the parameter(s) of the procedure will be. In the procedure will be...
During implementation, ensure it's possible to drop the primary key (PK), even if a foreign key (FK) relies on its index.
This is a typical case, and I suppose the NULL comparison should be removed by the engine here, as this is a simple scenario. In more complex cases, however, it...
> Firebird compresses data on pages and this cannot be disabled. It saves disk space but spends CPU cycles on reading. But it read here from memory, so no compression...
Is this fresh started query or hot one with data in the cache? If it is fresh, the maybe Firebird read page by page from SSD, and other RDBS ask...
> Unless and until this is indeed in the standard, I don't think we should implement this. Why. Normal insert is error prone. You can simply mistakenly set wrong field.