FirebirdSQL logo
 Procedural SQL (PSQL)Compatibility Issues 

Unify display of system procedures and functions & packages with other system objects

Alex Peshkov

Tracker tickets: #7411, #7475

The SHOW SYSTEM command of isql now lists system packages and their procedures and functions.

Display statement BLR

Adriano dos Santos Fernandes

Tracker ticket: #6910

The SET EXEC_PATH_DISPLAY command is a debug command to show the BLR (compiled form) of the statement.When a statement is executed, it retrieves the compiled execution path of a DML statement formatted as BLR text.

SET EXEC_PATH_DISPLAY {BLR | OFF};
Warning

This feature is intimately tied to engine internals.Its usage is discouraged if you do not understand very well how these internals are subject to change between versions.

Replication information added to SHOW DATABASE output

Dmitry Yemanov

Tracker tickets: #7001, #7425

The SHOW DATABASE command now reports the “Replica mode” and “Publication” state.