FirebirdSQL logo
 Procedural SQL (PSQL)Compatibility Issues 

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.