Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007253Openbravo ERPA. Platformpublic2009-01-30 10:072009-04-21 12:39
Reporterjpabloae 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo - 2.6.27
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007253: wad.lib fails in PostgreSQL
Description    [java] 3333 [main] INFO org.openbravo.data.Sqlc - File: ./src/org/openbravo/wad/Wad_data.xsql processed
     [java] 3405 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] select (case when count(*)=0 then 0 else 1 end) as buildxml
     [java] from ad_system_info
     [java] where last_build < (select max(updated)
     [java] from (select max(updated) updated
     [java] from ad_model_object
     [java] union
     [java] select max(updated)
     [java] from ad_model_object_mapping))
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: syntax error at or near "updated"
     [java] org.postgresql.util.PSQLException: ERROR: syntax error at or near "updated"
Steps To Reproduce1. check out trunk at the given revision and configure it.
2. run "ant install.source".
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-30 10:07jpabloaeNew Issue
2009-01-30 10:07jpabloaeAssigned To => alostale
2009-01-30 10:07jpabloaesf_bug_id0 => 2548428
2009-01-30 10:07jpabloaeRegression testing => No
2009-01-30 10:59svnbotCheckin
2009-01-30 10:59svnbotNote Added: 0012872
2009-01-30 10:59svnbotStatusnew => resolved
2009-01-30 10:59svnbotResolutionopen => fixed
2009-01-30 10:59svnbotsvn_revision => 12533
2009-01-30 11:54jpabloaeStatusresolved => new
2009-01-30 11:54jpabloaeResolutionfixed => open
2009-01-30 11:54jpabloaeNote Added: 0012880
2009-01-30 12:03svnbotCheckin
2009-01-30 12:03svnbotNote Added: 0012884
2009-01-30 12:03svnbotStatusnew => resolved
2009-01-30 12:03svnbotResolutionopen => fixed
2009-01-30 12:03svnbotsvn_revision12533 => 12551
2009-04-21 12:39psarobeStatusresolved => closed

Notes
(0012872)
svnbot   
2009-01-30 10:59   
Repository: openbravo
Revision: 12533
Author: alostale
Date: 2009-01-30 10:58:59 +0100 (Fri, 30 Jan 2009)

fixed bug 0007253: wad.lib fails in PostgreSQL

---
U trunk/src-wad/src/org/openbravo/wad/Wad_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12533&sc=1 [^]
(0012880)
jpabloae   
2009-01-30 11:54   
Now it fails in Oracle:

/src/org/openbravo/wad/Wad_data.xsql processed
     [java] 572 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] select (case when count(*)=0 then 0 else 1 end) as buildxml
     [java] from ad_system_info
     [java] where last_build < (select max(updated)
     [java] from (select max(updated) as updated
     [java] from ad_model_object
     [java] union
     [java] select max(updated)
     [java] from ad_model_object_mapping) as upd)
     [java]
     [java] Exception:java.sql.SQLException: ORA-00907: missing right parenthesis
     [java]
     [java] java.sql.SQLException: ORA-00907: missing right parenthesis
(0012884)
svnbot   
2009-01-30 12:03   
Repository: openbravo
Revision: 12551
Author: alostale
Date: 2009-01-30 12:03:05 +0100 (Fri, 30 Jan 2009)

fixed bug 0007253: wad.lib fails in Oracle

---
U trunk/src-wad/src/org/openbravo/wad/Wad_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12551&sc=1 [^]