View Issue Details

IDProjectCategoryView StatusLast Update
0000386HopperGeneralpublic2012-07-13 18:11
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version1.0.1 
Fixed in Version1.0.2 
Summary0000386: Debugger SQL error with certain SQL construct in Trigger
DescriptionTrigger example, ON UPDATE:

declare variable i integer;
begin
  select COUNT (x.custid)
 FROM CUSTOMERS x
 WHERE old.custid = x.CUSTID
 into :i;
end


SQL error when debugging that statement.
Additional InformationFails when OLD.CUSTID IS NULL or a VALUE
TagsNo tags attached.
DBMS Version

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-06-26 10:58 Martijn Tonies New Issue
2012-06-26 10:58 Martijn Tonies Status new => confirmed
2012-07-10 09:37 Martijn Tonies Assigned To => Martijn Tonies
2012-07-10 09:37 Martijn Tonies Status confirmed => assigned
2012-07-10 10:18 Martijn Tonies Category Firebird => General
2012-07-10 10:18 Martijn Tonies Additional Information Updated
2012-07-10 10:28 Martijn Tonies Status assigned => resolved
2012-07-10 10:28 Martijn Tonies Fixed in Version => 1.0.2
2012-07-10 10:28 Martijn Tonies Resolution open => fixed
2012-07-13 18:11 Martijn Tonies Status resolved => closed