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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028708
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminoralways2015-01-21 11:162015-01-21 11:16
ReporterjecharriView Statuspublic 
Assigned ToAugustoMauch 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028708: Case statement is not supported in Order By clause

DescriptionCase 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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 Modules => Core
2015-01-21 11:16 jecharri Triggers an Emergency Pack => No


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker