Andrej Kirejeŭ
Andrej Kirejeŭ
our own. On Thu, Jun 27, 2019 at 5:49 PM Mikael Lepistö wrote: > @gsbelarus is it your own code which is > using node-pool or 3rd party library? >...
Thanks! Will give it a try.
As for me, it is more critical to have an ability to create FK without index. When referential integrity maintained by simple table scan. We have a lot of FK...
> The user should have ability to decide if FK needs and index or not. > Also, it could be good if engine uses any suitable index without need to...
In real-life databases, what proportion are standalone indexes as compared to hidden indexes of Foreign Keys (FK) and Primary Keys (PK)? I believe the former accounts for less than 1%....
I see your point but not having named parameters makes working with large queries almost impossible. We have queries of hundreds of lines of code with dozens parameters. Just imagine...
It definitely has to be solved as FB server error messages differs for Mac and Windows platforms.
and the way it is implemented current functionality is not affected. just don't provide object with named parameters or don't specify the flag for `prepare` method and everything will work...
here is an example from real life: ```sql INSERT INTO gd_people(contactkey, firstname, surname, middlename, nickname, rank, haddress, hcity, hregion, hzip, hcountry, hdistrict, hphone, wcompanykey, wcompanyname, wdepartment, spouse, children, sex, birthday,...
And, as it was discussed earlier, it would be great to get a firebird error code as well as a text error message.