Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019333
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2011-12-19 16:092012-01-31 12:42
ReporterjecharriView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version3.0MP9
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019333: Columns with reference time are not working perfectly

DescriptionColumns with reference time are not working perfectly.

When you have one column with reference type "Time" and you try to put the default value from other column with reference type "time" it is imposible.
Steps To Reproduce-Create two columns:
+First in the "c_invoice" table:em_ti_header timestamp without time zone
+The second in the "c_invoiceline" table:em_ti_lines timestamp without time zone

Import the columns and fields to Openbravo.

-After that, in window "Tables and Columns" select firs the "c_invoice" table and change the reference of the column "EM_Ti_Header" to Time. Do the same with the column "EM_Ti_Lines" in table "c_invoiceline".
-Apart from that, add to column "EM_Ti_Lines" the default value "@SQL=select em_ti_header from c_invoice where c_invoice_id =@C_Invoice_ID@"

-Finally do "ant smartbuild" and restart Tomcat.
-Now try to create a line. You will see the next error [error.txt]
TagsNo tags attached.
Attached Filestxt file icon error.txt [^] (12,468 bytes) 2011-12-19 16:09 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0044735)
AugustoMauch (manager)
2012-01-31 12:42

 There was an error when creating a new line not because the software was faulty, but because the default value SQL statement was not correct.

The field initializer takes for granted that the default value is of the correct type (in this case, Time), but the default value SQL statement returns a Date.

In order to make it work, the default value should be changed from @SQL=select em_ti_header from c_invoice where c_invoice_id =@C_Invoice_ID@ to @SQL=select to_char(em_ti_header,'HH24:MI:SS') from c_invoice where c_invoice_id =@C_Invoice_ID@

- Issue History
Date Modified Username Field Change
2011-12-19 16:09 jecharri New Issue
2011-12-19 16:09 jecharri Assigned To => alostale
2011-12-19 16:09 jecharri File Added: error.txt
2011-12-19 16:09 jecharri Web browser => Google Chrome
2011-12-19 16:09 jecharri Modules => Core
2011-12-19 16:09 jecharri Resolution time => 1331506800
2012-01-25 09:45 alostale Assigned To alostale => AugustoMauch
2012-01-31 12:42 AugustoMauch Note Added: 0044735
2012-01-31 12:42 AugustoMauch Status new => closed
2012-01-31 12:42 AugustoMauch Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker