Unable to alter Database On Connect Trigger
--------------------------------------------
Key: CORE-6234
URL: http://tracker.firebirdsql.org/browse/CORE-6234
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.5
Environment: Windows 10 x64
Firebird 3.0.5.33220 (x64)
Reporter: Luciano Mendes
Priority: Critical
ACTUAL RESULT
- Unable to alter Database On Connect Trigger
- The following exception happen when it is tried to update an existing
Database On Connect Trigger:
===========================================
Error: *** IBPP::SQLException ***
Context: Statement::Prepare(
ALTER TRIGGER DATABASE_ON_CONNECT ACTIVE
ON CONNECT POSITION 0
AS
BEGIN
END )
Message: isc_dsql_prepare failed
SQL Message : -104
Invalid token
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 1
ON
===========================================
EXPECTED RESULT
- The user should be able to update any Database On Connect Trigger without any
issue
STEPS TO REPRODUCE THE ISSUE
1- Create a Database On Connect Trigger using the following DDL script:
=====================================
SET TERM ^ ;
CREATE TRIGGER DATABASE_ON_CONNECT
ACTIVE ON CONNECT POSITION 0
AS
BEGIN
END^
SET TERM ; ^
=====================================
2- Try to update the Database On Connect Trigger using the following DDL script:
=====================================
SET TERM ^ ;
ALTER TRIGGER DATABASE_ON_CONNECT ACTIVE
ON CONNECT POSITION 0
AS
BEGIN
END^
SET TERM ; ^
=====================================
IMPORTAN NOTES:
-This issue is NOT reproducible on Firebird 2.5.9
--
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
