View Issue Details

IDProjectCategoryView StatusLast Update
0000390HopperInterBasepublic2012-07-13 18:11
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.1 
Fixed in Version1.0.2 
Summary0000390: "expression evaluation not supported" in certain assignment, datatype dependent
Descriptionwhen debugging trigger "after update" expression :

 vHTE = coalesce(new.FARE_MONTHT,0.0);

with
declare varialbe vHTE numeric(15,2)
FARE_MONTHT numeric(15,2)

the message "expression evaluation not supported" is raised

FARE_MONTHT needs to have 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-27 09:29 Martijn Tonies New Issue
2012-06-27 09:30 Martijn Tonies Status new => confirmed
2012-07-05 08:48 Martijn Tonies Assigned To => Martijn Tonies
2012-07-05 08:48 Martijn Tonies Status confirmed => assigned
2012-07-05 09:41 Martijn Tonies Summary "expression evaluation not supported" in certain trigger construct => "expression evaluation not supported" in certain assignment, datatype dependent
2012-07-05 09:42 Martijn Tonies Status assigned => resolved
2012-07-05 09:42 Martijn Tonies Fixed in Version => 1.0.2
2012-07-05 09:42 Martijn Tonies Resolution open => fixed
2012-07-13 18:11 Martijn Tonies Status resolved => closed