Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035267 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | minor | always | 2017-02-14 18:15 | 2017-04-06 18:01 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR17Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | bb32e2fbd564 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | guilleaer | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035267: Some indexes can be improved | |||||||
| Description | Some indexes in the Retail distribution and other modules affect columns which in many cases have a significant amount of null values. These indexes could be improved so that only the not null records are included. This shouldn't impact the queries executed against these tables, and will significantly reduce the size of the index. The only downside is that the update to this release may be a bit slower due to some indexes having to be recreated. More info can be found here: http://wiki.openbravo.com/wiki/Constraints_and_Triggers#Partial_indexes [^] | |||||||
| Steps To Reproduce | . | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
|
(0094360) hgbot (developer) 2017-02-15 14:08 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: b8550e1aa9053f73f0b185f0e93ae23af22945e1 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Feb 14 18:35:39 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^] Fixed issue 35267. Transformed several indexes to be partial --- M src-db/database/model/modifiedTables/C_IMPORT_ENTRY_ARCHIVE.xml M src-db/database/model/modifiedTables/C_ORDER.xml M src-db/database/model/modifiedTables/FIN_FINACC_TRANSACTION.xml M src-db/database/model/tables/OBPOS_APPLICATIONS.xml M src-db/database/model/tables/OBPOS_APP_CASHUP.xml M src-db/database/model/tables/OBPOS_APP_PAYMENT.xml M src-db/database/model/tables/OBPOS_TERMINALTYPE.xml --- |
|
(0094361) hgbot (developer) 2017-02-15 14:08 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 5afb363b4da539fee0d1e1125c48de49990851a1 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Feb 15 11:01:00 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5afb363b4da539fee0d1e1125c48de49990851a1 [^] Related to issue 35267. Changed back index in cashup parent column, as it was used for the master/slave cashup query. --- M src-db/database/model/tables/OBPOS_APP_CASHUP.xml --- |
|
(0094362) hgbot (developer) 2017-02-15 14:09 |
Repository: erp/pmods/org.openbravo.retail.sessions Changeset: a3770a9d60dab49d45b4601b68dd356de2520a72 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Feb 15 14:09:03 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^] Fixed issue 35267. Transformed several indexes to be partial --- M src-db/database/model/modifiedTables/OBPOS_APP_PAYMENT_TYPE.xml --- |
|
(0094363) hgbot (developer) 2017-02-15 14:09 |
Repository: erp/pmods/org.openbravo.mobile.warehouse Changeset: 4716f87f08e505092ac710332e699d6c5582c53a Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Feb 15 14:09:31 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^] Fixed issue 35267. Transformed several indexes to be partial --- M src-db/database/model/tables/OBWH_MENU.xml --- |
|
(0094442) hgbot (developer) 2017-02-17 08:56 |
Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Tue Feb 14 18:35:39 2017 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3 [^] Fixed issue 35267. Transformed several indexes to be partial --- M src-db/database/model/tables/OBPOS_APP_CASHUP.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-02-14 18:15 | marvintm | New Issue | |
| 2017-02-14 18:15 | marvintm | Assigned To | => marvintm |
| 2017-02-14 18:15 | marvintm | Triggers an Emergency Pack | => No |
| 2017-02-15 14:08 | hgbot | Checkin | |
| 2017-02-15 14:08 | hgbot | Note Added: 0094360 | |
| 2017-02-15 14:08 | hgbot | Status | new => resolved |
| 2017-02-15 14:08 | hgbot | Resolution | open => fixed |
| 2017-02-15 14:08 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^] |
| 2017-02-15 14:08 | hgbot | Checkin | |
| 2017-02-15 14:08 | hgbot | Note Added: 0094361 | |
| 2017-02-15 14:09 | hgbot | Checkin | |
| 2017-02-15 14:09 | hgbot | Note Added: 0094362 | |
| 2017-02-15 14:09 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/b8550e1aa9053f73f0b185f0e93ae23af22945e1 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^] |
| 2017-02-15 14:09 | hgbot | Checkin | |
| 2017-02-15 14:09 | hgbot | Note Added: 0094363 | |
| 2017-02-15 14:09 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/a3770a9d60dab49d45b4601b68dd356de2520a72 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^] |
| 2017-02-17 08:56 | hgbot | Checkin | |
| 2017-02-17 08:56 | hgbot | Note Added: 0094442 | |
| 2017-02-17 08:56 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse/rev/4716f87f08e505092ac710332e699d6c5582c53a [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/bb32e2fbd564aec7c8c762eefbfea62cce4b1eb3 [^] |
| 2017-03-06 13:21 | guilleaer | Review Assigned To | => guilleaer |
| 2017-03-06 13:21 | guilleaer | Status | resolved => closed |
| 2017-03-06 13:21 | guilleaer | Fixed in Version | => RR17Q2 |
| 2017-04-06 18:01 | marvintm | Description Updated | View Revisions |
| 2017-04-06 18:01 | marvintm | Relationship added | has duplicate 0035206 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |