Dmitry Yemanov

Yeah, sorry, fixed the title.

If indices are created before inserting rows, their statistics is zero and the optimizer considers the worst case. If statistics is up-to-date, then decisions are based on that statistics. The...

I agree that such an info does not make any practical sense.

AFAIU, you're not correct regarding ALTER ANY TABLE, it's enough to have ALTER permission for the particular table to recalculate its indices. However, I doubt such a flexibility makes sense...

> I don't understand why, but the original, non translated version of this query crashes the connection and nothing is logged in firebird.log... Does the crash happen on both FB...

> ```sql > select > ID, PERIOD_TYPE, STARTING_AT, ENDING_AT, > STORE, ns.NAME as STORE_NAME, > DEVICE, nd.NAME as DEVICE_NAME, nd.NUMBER as DEVICE_NUMBER > from PERIODS > left outer join NAMES...

I'd expect DATEADD/DATEDIFF being in sync with EXTRACT re. SECOND handling and we can see that fractions are returned by EXTRACT: ```sql SQL> select extract(second from current_timestamp) from rdb$database; EXTRACT...

@asfernandes, it's kinda expected for DAY/MONTH/YEAR, because (a) they're defined as integers in the SQL spec and (b) EXTRACT returns them as integers. So rounding is understandable. However, SECOND may...

This commit surely helps the described situation. I still have some doubts though. `DBB_shutdown_*` flags are normally set via `notify_shutdown() -> SHUT_blocking_ast() -> shutdown()` call chain. It works when the...

A workaround could also be to add `isc_dpb_shut_force` option to _gbak_, but I'd rather avoid that.