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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035202
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajorrandom2017-02-07 17:582017-03-06 10:37
ReporterguillermogilView Statuspublic 
Assigned Tomarvintm 
PriorityhighResolutionfixedFixed in VersionRR16Q4.2
StatusclosedFix in branchFixed in SCM revisiona778e59fed09
ProjectionnoneETAnoneTarget VersionRR16Q4.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customerOBPS
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035202: It is possible to have duplicated primary keys on WebSQL

DescriptionIt is possible to have duplicated primary keys on WebSQL if you have a lot of products with duplicated names and an small pagination.
When the query is done it orders by name and since there are a lot that have the same value it can rely on errors in WebPOS console and losses of some record.

It will be needed to review each masterdata to ensure the proper behavior of them.
Steps To ReproduceN/A
Proposed SolutionSee diff attached for product query and apply it on the other queries.
It is needed to order by a unique constraint.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0035191 closedmarvintm It is possible to have duplicated primary keys on WebSQL 

-  Notes
(0094160)
hgbot (developer)
2017-02-08 19:10

 Repository: retail/backports/3.0RR16Q4.2/org.openbravo.retail.posterminal
Changeset: a778e59fed09501e5f3fc690121161235b6775e0
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Feb 08 19:00:21 2017 +0100
URL: http://code.openbravo.com/retail/backports/3.0RR16Q4.2/org.openbravo.retail.posterminal/rev/a778e59fed09501e5f3fc690121161235b6775e0 [^]

Fixed issue 35202. Added id in the order by of masterdata queries to ensure that pagination works even if several records have the same name

---
M src/org/openbravo/retail/posterminal/master/BPCategory.java
M src/org/openbravo/retail/posterminal/master/BPLocation.java
M src/org/openbravo/retail/posterminal/master/Brand.java
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
M src/org/openbravo/retail/posterminal/master/Category.java
M src/org/openbravo/retail/posterminal/master/CategoryTree.java
M src/org/openbravo/retail/posterminal/master/Characteristic.java
M src/org/openbravo/retail/posterminal/master/CharacteristicValue.java
M src/org/openbravo/retail/posterminal/master/Product.java
M src/org/openbravo/retail/posterminal/master/ReturnReason.java
M src/org/openbravo/retail/posterminal/master/SalesRepresentative.java
M src/org/openbravo/retail/posterminal/master/ServicePriceRuleRange.java
M src/org/openbravo/retail/posterminal/master/ServicePriceRuleVersion.java
M src/org/openbravo/retail/posterminal/master/ServiceProduct.java
M src/org/openbravo/retail/posterminal/master/ServiceProductCategory.java
M src/org/openbravo/retail/posterminal/master/TaxRate.java
---

- Issue History
Date Modified Username Field Change
2017-02-08 15:34 marvintm Type defect => backport
2017-02-08 15:34 marvintm Target Version => RR16Q4.2
2017-02-08 19:10 hgbot Checkin
2017-02-08 19:10 hgbot Note Added: 0094160
2017-02-08 19:10 hgbot Status scheduled => resolved
2017-02-08 19:10 hgbot Resolution open => fixed
2017-02-08 19:10 hgbot Fixed in SCM revision => http://code.openbravo.com/retail/backports/3.0RR16Q4.2/org.openbravo.retail.posterminal/rev/a778e59fed09501e5f3fc690121161235b6775e0 [^]
2017-03-01 15:19 marvintm Assigned To Retail => marvintm
2017-03-06 10:37 guilleaer Review Assigned To => guilleaer
2017-03-06 10:37 guilleaer Status resolved => closed
2017-03-06 10:37 guilleaer Fixed in Version => RR16Q4.2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker