Commented by: @dyemanov

Sorry, but the ticket is completely unreadable.

Commented by: maziar navahan (maziar1)

Sorry me For Bad English

For see this Problem in(Engine: Firebird ver 2.1 beta1) Try debug Stored Procedure with bigint type in parameter and Var

in Ibexpert in line with same below code (z_BED is BIGINT) :
IF (z_BED IS NULL) THEN z_BED = 0;

in plan view :
SELECT COUNT() FROM RDB$DATABASE WHERE ( cast(0 as numeric(0,0)) IS NULL)

i dont understand why in bigint type i see :(0 as numeric(0,0))
the same code in same version of Ibexpert for firebird 2.0.1 plan is :(0 as bigint)

is better comment ?

Commented by: @pcisar

This has nothing to do with Firebird, as Firebird doesn't support SP debugging (yet) ! This feature is directly implemented by tools (like IBExpert) in the way that they *emulate* the SP processing locally as it would be performed by Firebird. Hence it's the problem in the 3rd party tool, not Firebird.