Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0027453 | Openbravo ERP | 08. Project and service management | public | 2014-08-24 14:08 | 2015-09-15 15:56 |
| Reporter | shuehner | ||||
| Assigned To | AtulOpenbravo | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | dmiguelez | ||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0027453: pl function c_project_generate has broken sql | ||||
| Description | This functions contains the following sql: 182 SELECT COALESCE(MAX(C_UOM_ID), '100'), 183 MAX(C_Tax_ID) -- UOM 100=EA 184 INTO v_C_UOM_ID, 185 v_C_Tax_ID 186 FROM M_PRODUCT p, 187 C_TAX t 188 WHERE P.C_TaxCategory_ID=t.C_TaxCategory_ID 189 AND P.M_Product_ID=CUR_PLines.M_Product_ID 190 ORDER BY t.IsDefault DESC; Note: line numbers as per \sf+ c_project_generate This sql is broken as leads to the following error when executed 'with some random product': obpi93=# SELECT COALESCE(MAX(C_UOM_ID), '100'), MAX(C_Tax_ID) -- UOM 100=EA FROM M_PRODUCT p, C_TAX t WHERE P.C_TaxCategory_ID=t.C_TaxCategory_ID AND P.M_Product_ID='0DC5C5281B3643DEAB978EB04139516B' ORDER BY t.IsDefault DESC; ERROR: column "t.isdefault" must appear in the GROUP BY clause or be used in an aggregate function LINE 7: ORDER BY t.IsDefault DESC; Note: This code seems to be unchanged since hg-revision 0 (from 2007) Note: similar bug technically as in 27452. That sql also functionally is questionable as either the order by is useless or the code is functionally wrong. | ||||
| Steps To Reproduce | Review code & or run that sql snipped | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2014-08-24 14:08 | shuehner | New Issue | |||
| 2014-08-24 14:08 | shuehner | Assigned To | => dmiguelez | ||
| 2014-08-24 14:08 | shuehner | Modules | => Core | ||
| 2014-08-24 14:08 | shuehner | Triggers an Emergency Pack | => No | ||
| 2014-08-24 14:08 | shuehner | Note Added: 0069667 | |||
| 2014-08-24 14:09 | shuehner | Description Updated | bug_revision_view_page.php?rev_id=6444#r6444 | ||
| 2014-09-03 14:02 | eduardo_Argal | Assigned To | dmiguelez => eduardo_Argal | ||
| 2015-07-21 07:12 | AtulOpenbravo | Assigned To | eduardo_Argal => AtulOpenbravo | ||
| 2015-07-21 07:12 | AtulOpenbravo | Status | new => scheduled | ||
| 2015-09-14 16:57 | hgbot | Checkin | |||
| 2015-09-14 16:57 | hgbot | Note Added: 0080377 | |||
| 2015-09-14 16:57 | hgbot | Status | scheduled => resolved | ||
| 2015-09-14 16:57 | hgbot | Resolution | open => fixed | ||
| 2015-09-14 16:57 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bb2a1e39085308d1688052d6da4ee958b663ea01 [^] | ||
| 2015-09-14 16:58 | dmiguelez | Review Assigned To | => dmiguelez | ||
| 2015-09-14 16:58 | dmiguelez | Note Added: 0080378 | |||
| 2015-09-14 16:58 | dmiguelez | Status | resolved => closed | ||
| 2015-09-15 15:56 | hudsonbot | Checkin | |||
| 2015-09-15 15:56 | hudsonbot | Note Added: 0080404 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||