Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009549Openbravo ERPA. Platformpublic2009-06-18 18:132009-07-16 17:55
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009549: Use the new ignoreValues features of sqlc to speed up filters with value '%'
DescriptionUse the new ignore values feature to speed up queries using '%' as filter value.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0009550 closed shuehner Use the new ignoreValues features of sqlc to speed up filters with value '%' 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-18 18:13shuehnerNew Issue
2009-06-18 18:13shuehnerAssigned To => shuehner
2009-06-18 18:13shuehnerOBNetwork customer => No
2009-06-18 18:14shuehnerStatusnew => scheduled
2009-06-18 18:14shuehnerfix_in_branch => pi
2009-06-18 18:18hgbotCheckin
2009-06-18 18:18hgbotNote Added: 0017431
2009-06-18 18:18hgbotStatusscheduled => resolved
2009-06-18 18:18hgbotResolutionopen => fixed
2009-06-18 18:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/40b4ded6254d106f1e41bb2c0db668f75eda50ed [^]
2009-07-11 08:22pjuvaraStatusresolved => closed
2009-07-16 17:55anonymoussf_bug_id0 => 2822570

Notes
(0017431)
hgbot   
2009-06-18 18:18   
Repository: erp/devel/pi
Changeset: 40b4ded6254d106f1e41bb2c0db668f75eda50ed
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Jun 18 18:17:46 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/40b4ded6254d106f1e41bb2c0db668f75eda50ed [^]

Fixed 9549: Use the new ignoreValue feature of Sqlc to speed up queries with value '%'

---
M src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/AccountElementValue.java
M src/org/openbravo/erpCommon/info/AccountElementValue_data.xsql
M src/org/openbravo/erpCommon/info/Account_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql
M src/org/openbravo/erpCommon/info/BusinessPartner_data.xsql
M src/org/openbravo/erpCommon/info/DebtPayment_data.xsql
M src/org/openbravo/erpCommon/info/ImageInfo_data.xsql
M src/org/openbravo/erpCommon/info/Invoice.java
M src/org/openbravo/erpCommon/info/InvoiceLine.java
M src/org/openbravo/erpCommon/info/InvoiceLine_data.xsql
M src/org/openbravo/erpCommon/info/Invoice_data.xsql
M src/org/openbravo/erpCommon/info/Locator_data.xsql
M src/org/openbravo/erpCommon/info/ProductComplete.java
M src/org/openbravo/erpCommon/info/ProductComplete_data.xsql
M src/org/openbravo/erpCommon/info/ProductMultiple_data.xsql
M src/org/openbravo/erpCommon/info/Product_data.xsql
M src/org/openbravo/erpCommon/info/Project_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder.java
M src/org/openbravo/erpCommon/info/SalesOrderLine.java
M src/org/openbravo/erpCommon/info/SalesOrderLine_data.xsql
M src/org/openbravo/erpCommon/info/SalesOrder_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceiptLine_data.xsql
M src/org/openbravo/erpCommon/info/ShipmentReceipt_data.xsql
---