Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0028708 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | minor | always | 2015-01-21 11:16 | 2015-01-21 11:16 | |||||||
| Reporter | jecharri | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | 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 | OBPS | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | 33690 | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0028708: Case statement is not supported in Order By clause | |||||||||||
| Description | Case statement is not supported in Order By clause | |||||||||||
| Steps To Reproduce | -login as system -go to tables and columns and use CASE statement If you enable the hql log in log4j.lcf you will see that Openbravo is removing the case statement an inserting something strange For case: CASE etapa WHEN 'P' THEN 1 WHEN 'M' THEN 2 WHEN 'E' THEN 3 WHEN 'D' THEN 4 WHEN 'C' THEN 5 ELSE 6 END Openbravo is doing order by e etapa | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-01-21 11:16 | jecharri | New Issue | |
| 2015-01-21 11:16 | jecharri | Assigned To | => AugustoMauch |
| 2015-01-21 11:16 | jecharri | OBNetwork customer | => Yes |
| 2015-01-21 11:16 | jecharri | Modules | => Core |
| 2015-01-21 11:16 | jecharri | Support ticket | => 33690 |
| 2015-01-21 11:16 | jecharri | Triggers an Emergency Pack | => No |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |