Ignoring computed by field as Exception parameter
-------------------------------------------------
Key: CORE-4117
URL: http://tracker.firebirdsql.org/browse/CORE-4117
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2, 2.1.5, 2.0.7, 3.0 Alpha 1
Reporter: GR
CREATE TABLE TEST (
ID INTEGER NOT NULL,
C COMPUTED BY (id * 10)
);
CREATE EXCEPTION EX 'TEXT ';
INSERT INTO TEST(ID)
VALUES (1);
COMMIT;
1. Exception with computed by field as parameter
CREATE OR ALTER TRIGGER TEST_TR FOR TEST
ACTIVE BEFORE UPDATE POSITION 0
as
begin
exception ex new.c;
end
update TEST
set id = 2;
-- returns error without field value
EX.
TEXT .
At trigger 'TEST_TR' line: 5, col: 3.
2. Exception with computed by field as a part of expression
CREATE OR ALTER TRIGGER TEST_TR FOR TEST
ACTIVE BEFORE UPDATE POSITION 0
as
begin
exception ex new.c + 0; -- any expression
end
update TEST
set id = 2;
-- returns correct error with field value
EX.
20.
At trigger 'TEST_TR' line: 5, col: 3.
--
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
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
