Submitted by: @helebor

Is duplicated by CORE5873

Attachments:
c5404.sql

line/column numbers are not shown in the error message for first SP,
but are shown in the error message for second SP:

SET TERM ^;
create or alter procedure REP_TMP_CCDM_60106
as
declare variable tmpInt smallint;
begin
select "" from rdb$database into tmpInt;
end
^
SET TERM ;^

/*Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown*/

SET TERM ^;
create or alter procedure REP_TMP_CCDM_60106
as
declare variable tmpInt smallint;
begin
select "d" from rdb$database into tmpInt;
end
^
SET TERM ;^

/*Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-d
-At line 5, column 14*/

The above report came from a v.2.5.6 user, dialect 3.
Tested also in v.3.0.1, although the error message for the first case is more
accurate:
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Zero length identifiers are not allowed

Commits: 0cf8d88

====== Test Details ======

Test covers not all cases from attached file ('c5404.sql').
Waiting for reply on issue 22/Nov/16 06:10 PM