Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008860Openbravo ERPA. Platformpublic2009-05-01 13:492009-06-04 00:00
jpabloae 
mtaal 
immediatemajoralways
closedno change required 
302.6.16
pi 
 
Core
No
0008860: testSystemValidation junit test does not detect incosistencies in PostgreSQL
org.openbravo.test.system.SystemValidatorTest.testSystemValidation does not detect any database inconsistencies. On the same changeset and with Oracle issue 0008859 is raised.
No tags attached.
related to defect 0008859 closed mtaal C_TEMP_SELECTION and C_TEMP_SELECTION2 present in the database ant not in the AD 
Issue History
2009-05-01 13:49jpabloaeNew Issue
2009-05-01 13:49jpabloaeAssigned To => rafaroda
2009-05-01 13:49jpabloaeRegression testing => No
2009-05-04 17:52jpabloaeNote Added: 0016020
2009-05-04 17:52jpabloaePriorityurgent => immediate
2009-05-05 10:21pjuvaraAssigned Torafaroda => mtaal
2009-05-05 10:38shuehnerNote Added: 0016033
2009-05-05 10:44mtaalNote Added: 0016034
2009-05-05 10:59shuehnerNote Added: 0016035
2009-05-05 11:14mtaalNote Added: 0016037
2009-05-05 11:24mtaalRelationship addedrelated to 0008859
2009-05-05 12:01psarobeStatusnew => scheduled
2009-05-05 12:01psarobefix_in_branch => pi
2009-05-05 14:54mtaalNote Added: 0016056
2009-05-05 14:54mtaalStatusscheduled => resolved
2009-05-05 14:54mtaalResolutionopen => no change required
2009-05-05 14:54mtaalFixed in SCM revision => .
2009-05-05 14:54mtaalfix_in_branchpi =>
2009-06-03 12:21psarobeStatusresolved => closed
2009-06-04 00:00anonymoussf_bug_id0 => 2800777

Notes
(0016020)
jpabloae   
2009-05-04 17:52   
As a new policy the failing tests will get a immediate priority.
(0016033)
shuehner   
2009-05-05 10:38   
Note: this two tables are special. They are temporary tables. On oracle they do exist all the time but on postgres they are only created when used and do not exist outside the database session where they have been created.
(0016034)
mtaal   
2009-05-05 10:44   
Okay, this explains why the test fails on Oracle and passes on postgres.
There are two options:
1) add the table to the AD, this would however result in a failing test on postgres (and oracle will pass)
2) ignore this specific table in the test

I vote for 2)

gr. Martin
(0016035)
shuehner   
2009-05-05 10:59   
Second option for this test looks good to me also. Question how do we check for compatibility for this tables? Or more generally compatibility for all manual small db-objects created in pre-script / post-script for postgres and oracle...
(0016037)
mtaal   
2009-05-05 11:14   
Hi Stefan,
Imo it is difficult to check for consistency of temporary db-objects. Do you know if there are many of those 'manual small' db-objects? Or what types are there?

gr. Martin
(0016056)
mtaal   
2009-05-05 14:54   
Closing this issue as it the solution will be handled in issue 8859. For the more general question on how to handle manual db-objects a new issue should be opened, or before we should discuss this topic by email/skype.

gr. Martin