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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005674
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2008-10-27 12:282009-04-21 11:09
ReporterpnudingView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11417
ProjectionnoneETAnoneTarget Version2.50
OSAnyDatabaseAnyJava version
OS VersionallDatabase versionPostgres 8.3Ant version
Product VersionpiSCM revision9194 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005674: Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields

DescriptionSince version 8.3 Postgresql does not automatically convert strings to numeric values anymore, but requires the call of to_number for this.
There are many places where we currently miss this call, meaning the affected numeric filters etc. only work on Oracle but not on Postgres
In addition some old to_number calls are in place for ID fields which are now no longer appropriate as the IDs are alphanumeric.

A code inspection is needed and agreed by Paolo Juvara to proactively find and resolve all of these issues:
Go trough all manual code (.xsql files in src-wad, src-trl and src).
For each
- check each parameter whether it its target (column) is numeric and add to_number
- look at existing occurences of to_number - if these point to an id-field remove it

Please trigger the necessary steps (I understand some of this is already ongoing) and derive sub-issues as you see it as appropriate
Attached is a list of excessive to_number occurrences for ID fields kindly provided by Stefan Hühner. He can also be contacted for further questions
TagsUUID project
Attached Filestxt file icon list.txt [^] (1,911 bytes) 2008-10-27 12:28 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0006698 closedshuehner Partial list of broken/not useful xsql methods which are currently not used 
related to defect 0006630 closedshuehner OrderLine Selector filter fields: business partner & product are broken when selector is opened with salesOrders only filter 
related to defect 0006631 closedshuehner Invoice selector: Filter field Order does not work with non numeric-only input 
related to defect 0006634 closedshuehner Financial Management || Receivables & Payables || Analysis Tools || Cash Report || Cash Report > Cashbook filter is broken 
related to defect 0006643 closedshuehner Create AP Expense Invoices process does not work correctly when run with newly created user (having non-numeric user_id) 
related to defect 0006644 closedshuehner Remittance cancellation & Remittance return processes do not work 
related to defect 0006653 closedshuehner Payment Tracker; Filter fiels Amount From & Amount to do not work on postgresql 8.3 
related to defect 0006656 closedshuehner Payment Report: Filter fiels Amount From & Amount to do not work on postgresql 8.3 
related to defect 0006660 closedshuehner General Ledger Report, Filter field: From Amount does not work on postgresql 8.3 
related to defect 0006662 closedshuehner Order Line selector: Field field "Total Amount From" does not work on postgresql 8.3 
related to defect 0006664 closedshuehner Order selector: Field field "Total Amount From" does not work on postgresql 8.3 
related to defect 0006688 closedAinhoaPagola Shipment in -> Create From Multiple Popup -> OK, error reporting does not work 
related to defect 0006690 closedshuehner Warehouse Management || Transactions || Incoming Shipment || Shipment in ->Create From Multiple Popup does not work on pgsql 8.3 
related to defect 0006693 closedrafaroda CreateFromMultipleShipment_data.xsql - method insert does not work with uuid 

-  Notes
(0011611)
shuehner (administrator)
2008-12-19 16:38

 One review of all .xsql files has been done and a number of issues was identified and reported. All issues have been marked as related to this one so they can be tracked easily.

- Issue History
Date Modified Username Field Change
2008-10-27 12:28 pnuding New Issue
2008-10-27 12:28 pnuding Assigned To => cromero
2008-10-27 12:28 pnuding sf_bug_id 0 => 2200509
2008-10-27 12:28 pnuding File Added: list.txt
2008-10-27 12:28 pnuding Regression testing => No
2008-10-27 14:36 shuehner Issue Monitored: shuehner
2008-11-03 11:39 rafaroda Target Version trunk => 2.50
2008-11-03 11:39 rafaroda Tag Attached: UUID project
2008-11-03 11:43 rafaroda Status new => scheduled
2008-11-03 11:43 rafaroda Assigned To cromero => shuehner
2008-11-03 11:43 rafaroda fix_in_branch => trunk
2008-12-03 19:03 pjuvara Priority normal => high
2008-12-19 16:33 shuehner Relationship added related to 0006698
2008-12-19 16:33 shuehner Relationship added related to 0006630
2008-12-19 16:33 shuehner Relationship added related to 0006631
2008-12-19 16:33 shuehner Relationship added related to 0006634
2008-12-19 16:33 shuehner Relationship added related to 0006643
2008-12-19 16:33 shuehner Relationship added related to 0006644
2008-12-19 16:33 shuehner Relationship added related to 0006653
2008-12-19 16:34 shuehner Relationship added related to 0006656
2008-12-19 16:34 shuehner Relationship added related to 0006660
2008-12-19 16:34 shuehner Relationship added related to 0006662
2008-12-19 16:34 shuehner Relationship added related to 0006664
2008-12-19 16:34 shuehner Relationship added related to 0006688
2008-12-19 16:34 shuehner Relationship added related to 0006690
2008-12-19 16:34 shuehner Relationship added related to 0006693
2008-12-19 16:38 shuehner Status scheduled => resolved
2008-12-19 16:38 shuehner svn_revision => 11417
2008-12-19 16:38 shuehner Resolution open => fixed
2008-12-19 16:38 shuehner Note Added: 0011611
2009-01-09 17:48 shuehner Issue End Monitor: shuehner
2009-04-21 11:09 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker