Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK ---------------------------------------------------------------------------------------------
Key: CORE-5216 URL: http://tracker.firebirdsql.org/browse/CORE-5216 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Dmitry Yemanov set term ^; select cast('' as timestamp) from rdb$database ^ -- ERROR: -- Statement failed, SQLSTATE = 22018 -- conversion error from string "" recreate procedure qwe123 returns(res timestamp) as begin res = cast('' as timestamp); suspend; end ^ execute procedure qwe123 ^ -- ERROR: -- Statement failed, SQLSTATE = 22018 -- conversion error from string "" -- At procedure 'QWE123' line: 5, col: 3 execute block returns(res timestamp) as begin res = cast('' as timestamp); suspend; end ^ -- ERROR: -- Statement failed, SQLSTATE = 22018 -- conversion error from string "" Something like "At anonymous block line: 5, col: 3" should be reported in this case. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel