View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001655 | Database Workbench v6 | Firebird Module | public | 2018-12-19 03:36 | 2022-08-04 12:25 |
| Reporter | Paul Maliphant | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Product Version | 5.4.4 | ||||
| Fixed in Version | 6.1.0 | ||||
| Summary | 0001655: Exception debugging a Firebird 2.5.8 Trigger | ||||
| Description | Trigger SET TERM ^^ ; CREATE TRIGGER MILKING_DAILY_LIC_LACT_TOT FOR MILKING_DAILY ACTIVE BEFORE UPDATE POSITION 42 AS declare diff float ; declare adj float; begin if ((new.cowpk = old.cowpk) and updating) then begin /* Error executing this line */ if (old.LICLitres is not null) then begin /*Cups put back on ?*/ diff = new.liclitres - old.liclitres ; if (ABS(diff) > 0.1) then begin adj = old.liclitres * -1.0; execute procedure P_COW_LACTATION_TOTALS_UPD(old.cowpk,adj, old.licfat, old.licprotein, old.liclactose, old.licscc, old.hw_map); new.liclitres = new.liclitres + old.liclitres; end end end execute procedure P_COW_LACTATION_TOTALS_UPD(new.cowpk,new.liclitres, new.licfat, new.licprotein, new.liclactose, new.licscc, new.hw_map); end ^^ SET TERM ; ^^ --------------------------- Warning --------------------------- Routine was aborted because of an exception, changes have been rolled back. Exception message: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 143 ) SQL: /* TGDSDebugger.EvalExpression */ select count( * ) from RDB$DATABASE where ( ( ( cast(NULL as Integer) ) = ( cast(NULL as Integer) ) ) and 1 ) --------------------------- OK --------------------------- | ||||
| Steps To Reproduce | F8 on the first line of code in the trigger. See attached screen shot | ||||
| Tags | No tags attached. | ||||
| duplicate of | 0002039 | closed | Martijn Tonies | Trigger debugger error with specific clause using pseudo variables |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-19 03:36 | Paul Maliphant | New Issue | |
| 2018-12-19 03:36 | Paul Maliphant | File Added: TriggerDebug.png | |
| 2022-01-12 13:35 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
| 2022-08-04 12:25 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2022-08-04 12:25 | Martijn Tonies | Status | new => closed |
| 2022-08-04 12:25 | Martijn Tonies | Resolution | open => duplicate |
| 2022-08-04 12:25 | Martijn Tonies | Fixed in Version | => 6.1.0 |
| 2022-08-04 12:25 | Martijn Tonies | Relationship added | duplicate of 0002039 |
