View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001140Database Workbench v5Generalpublic2015-01-13 10:542018-02-06 13:41
ReporterWolfgang Rohdewald Assigned ToMartijn Tonies  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
PlatformI86 32, VirtualboxOSWindowsOS VersionWindows 7 Pro
Product Version5.0.6 
Fixed in Version5.4.0 
Summary0001140: Interpreted debugger (InterBase, Firebird, MySQL) cannot handle computed fields
DescriptionI just discovered the trigger debugger but since I use many computed fields I can only use it for rather trivial triggers.

The example runs correctly from isql. The inserted record will have id=1000.

But the trigger debugger says

Dynamic SQL Error
SQL Error code = -206
Column unknown
NEW.COMPVALUE
At line 1, column 71
Steps To Reproducecreate table t1
(
        id bigint,
        compvalue bigint computed by (id+1)
);

set term ^^ ;
create trigger ba_t1 for t1 active before insert as
begin
   if (new.compvalue=10) then
           new.id=1000;
end ^^
set term ; ^^

insert into t1 values(9);
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-01-13 10:54 Wolfgang Rohdewald New Issue
2015-01-13 12:37 Martijn Tonies Assigned To => Martijn Tonies
2015-01-13 12:37 Martijn Tonies Status new => acknowledged
2018-01-18 12:56 Martijn Tonies Status acknowledged => assigned
2018-01-18 12:56 Martijn Tonies Category Firebird Module => General
2018-01-18 12:56 Martijn Tonies Summary firebird: trigger debugger cannot handle computed fields => Interpreted debugger (InterBase, Firebird, MySQL) cannot handle computed fields
2018-01-18 14:03 Martijn Tonies Status assigned => resolved
2018-01-18 14:03 Martijn Tonies Fixed in Version => 5.4.0
2018-01-18 14:03 Martijn Tonies Resolution open => fixed
2018-02-06 13:41 Martijn Tonies Status resolved => closed