Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002551 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | minor | always | 2008-01-25 09:15 | 2008-07-08 11:03 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002551: Alert Rule definition in PG needs fields in capitals | |||||||
| Description | Env.: Trunk PostgreSQL Description: When an alert rule is defined in PG it expects to have all fields in capital letters (which is the default for Oracle), so the message saying there are fields not included appears though they actually are. Workarround: In the query set aliases in capital letters within double quotas ("). Example: select ad_client_id as "AD_CLIENT_ID" ad_role as "AD_ROLE_ID" ... from ... ... | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0003089) alostale (viewer) 2008-01-28 10:30 edited on: 2008-06-12 09:24 |
Logged In: YES user_id=1500722 Originator: YES Tip: *SL_AlerRule_SQL.existsColumn is checking the name taking into account the case. It shouldn't. *Check the way background process is looking for the column name. |
|
(0006140) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1879482 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-08 11:03 | psarobe | Status | resolved => closed |
| 2008-07-08 11:03 | psarobe | Fixed in Version | 2.40alpha-r2 => 2.40beta |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |