Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0019333 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | minor | always | 2011-12-19 16:09 | 2012-01-31 12:42 | |||
Reporter | jecharri | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | high | Resolution | no change required | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | 3.0MP9 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | Google Chrome | |||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0019333: Columns with reference time are not working perfectly | |||||||
Description | Columns 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] | |||||||
Tags | No tags attached. | |||||||
Attached Files | 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 |