More news from Dmitry Y.

Getting back to some old ideas
Adriano dos Santos Fernandes has started a new brainstorming attempt targeted to the old subject of domains being used in procedure parameters and PSQL variables. He offers the prototype implementation and asks for comments. Possibilities to allow NOT NULL and CHECK constraints for parameters/variables are also being discussed. If you’re interested, please follow the discussion in the “firebird-architect” list.

Better error reporting
Did you ever debug a big complex procedure that fails in runtime with a famous “arithmetic exception” error? How much time did it take to find the problematic statement?
Now it should become much easier. Starting with v2.0, you get a stack trace which mentions the failed procedure/trigger along with all its callers. And the next (post-2.0) Firebird version will also report you the line and column numbers (inside the current PSQL body) of the failed statement.

Thanks to Eugene Putilin and Vlad Horsun for this contribution.