todaysoftware

Use DisposeAsync to fix Synchronous IO exception

1

Also required changing some assemblies to .NET standard 2.1, and some applications to .NET core 3.1, as a result I created a new branch/version of 4.1

Setting the procedure name when the database is not connected causes the above exception. To fix this I moved the code that generates the SQL from where it sets the...

Firebird 5 taking excessive amount of time to prepare a query with partial index

1

The same query worked fine under Firebird 3 but FB 5.0.2 is taking a huge amount of time to prepare it, my guess is that the optimizer ends up going...

Partial index using ranges not been selected in plan

6

In Firebird 5.0.1 when using a partial index with various range selections it always seems to fall back to a table scan (PLAN NATURAL) ``` CREATE INDEX AUDIT_LINETYPE ON AUDIT(LINETYPE)...

Queries failing with Firebird and LinqToDB version 6 (RC3) when trying a "boolean" comparison

2

### Description We are NOT using the actual SQL boolean type (introduced in Firebird version 3) but instead using a smallint value in the database with 1/0 equating to true/false....