Creating procedure with undeclared var or select from not existent table cause drop of connection -------------------------------------------------------------------------------------------------
Key: CORE-4843 URL: http://tracker.firebirdsql.org/browse/CORE-4843 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0 Beta 2 Environment: WI-T3.0.0.31877 Firebird 3.0 Beta 2 Reporter: Karol Bieniaszewski Try to create procedure with select form not existent table or with undeclared var SET TERM ^ ; CREATE PROCEDURE IMPORT_SWIAT ( ) RETURNS ( INFO varchar(31) ) AS BEGIN /* write your code here */ ILE = 0; SELECT S.ID FROM SWIAT S WHERE S.NAZWA=:SWIAT INTO :INFO; END^ SET TERM ; ^ you got Error: *** IBPP::SQLException *** Context: Statement::Execute( body..... Message: isc_dsql_execute2 failed SQL Message : -206 Column does not belong to referenced table Engine Code : 335544351 Engine Message : unsuccessful metadata update unknown ISC error 336397265 Dynamic SQL Error SQL error code = -206 Column unknown ILE At line <Missing arg #1 - possibly status vector overflow>, column <Missing arg #2 - possibly status vector overflow> ------------------------------------------------------------- and you loose connection to database Server work without total crash Sometimes it generate write to log INET/inet_error: read errno = 10054 but sometimes not -- 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 ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel