Category: Developer News

From Dmitry Yemanov: As you might know, Firebird 2.0 no longer allows to alter/drop procedures that are used by active statements. However, we’ve got many requests from customers to restore the previous behaviour, because now it’s impossible to upgrade metadata under load. While we don’t consider this practice safe, I’d like to report that the new limitation is removed in the v2.0.1 release, thus rolling back to the prior logic. All potentially confusing situations (when two different versions of the procedure may coexist in memory simultaneously) are reported in firebird.log.

Curious about what you can expect from Firebird team in 2007? Check out the new official roadmap!

Query cancelation

Implementation of the statement cancellation feature has been committed into the version 2.1. It works via the monitoring tables – you just need to issue the DELETE command against the MON$STATEMENTS table (there’s no API implementation yet). It could be done by the application itself (using a secondary attachment) or by a server administrator. Examples:

DELETE FROM MON$STATEMENTS
WHERE MON$STATEMENT_ID = ?

or

DELETE FROM MON$STATEMENTS
WHERE MON$ATTACHMENT_ID = ? AND MON$STATEMENT_STATE = 1 -- active

The feature works for both SS and CS engines. The client application receives the GDS error code isc_cancelled.

Trusted authentication on Windows

Ability to authenticate Firebird users through a Windows domain is now available in the source tree and will be included into the v2.1 release. An up-to-date client library is required in order to use this feature. CURRENT_USER represents a logged in Windows domain user in this case. It’s expected that firebird.conf will introduce an option allowing you to choose between native-only, trusted-only and mixed authentication modes.