Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034650Openbravo ERPA. Platformpublic2016-11-28 17:302017-03-15 20:18
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q2Fixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034650: Ability to generate indexes to speed up searching using 'contains' operators
DescriptionAbility to generate indexes to speed up searching using 'contains' (LIKE/ILIKE) operators.

Project info: http://wiki.openbravo.com/wiki/Projects:Support_Indexes_To_Speed_Up_Contains_Search [^]
Steps To ReproduceIn description
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 00301793.0PR15Q4 closed AugustoMauch DBSourceManager support indexes with functions 
has duplicate defect 0034646 closed caristu Comments should be queried from user tables 
related to defect 0036862 closed alostale update.database throws NPE in PostgreSQL 9.6 
blocks defect 0035210 closed markmm82 sequential scans in c_bpartner using partner selector drop down filter 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-11-28 17:30caristuNew Issue
2016-11-28 17:30caristuAssigned To => platform
2016-11-28 17:30caristuModules => Core
2016-11-28 17:30caristuTriggers an Emergency Pack => No
2016-11-28 17:31caristuDescription Updatedbug_revision_view_page.php?rev_id=13912#r13912
2016-11-28 17:31caristuRelationship addedhas duplicate 0034646
2017-01-11 09:03hgbotCheckin
2017-01-11 09:03hgbotNote Added: 0093319
2017-01-11 09:21hgbotCheckin
2017-01-11 09:21hgbotNote Added: 0093325
2017-01-11 09:21hgbotStatusnew => resolved
2017-01-11 09:21hgbotResolutionopen => fixed
2017-01-11 09:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b3923337f9a663735bcdd5a3de6d1633ee92a42f [^]
2017-01-11 09:22caristuReview Assigned To => alostale
2017-01-11 09:22caristuTarget Version => 3.0PR17Q2
2017-01-16 12:34caristuAssigned Toplatform => caristu
2017-01-20 08:11alostaleNote Added: 0093742
2017-01-20 08:11alostaleStatusresolved => closed
2017-01-20 08:11alostaleFixed in Version => 3.0PR17Q2
2017-02-09 10:04alostaleRelationship addedblocks 0035210
2017-02-09 10:06alostaleRelationship addedrelated to 0030179
2017-03-15 20:18hudsonbotCheckin
2017-03-15 20:18hudsonbotNote Added: 0095080
2017-09-15 09:30caristuRelationship addedrelated to 0036862

Notes
(0093319)
hgbot   
2017-01-11 09:03   
Repository: erp/devel/dbsm-main
Changeset: 27052c7ed1ac8673e5b6963f1b69dea18874c1cb
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Jan 11 08:42:19 2017 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/27052c7ed1ac8673e5b6963f1b69dea18874c1cb [^]

related to issue 34650: Ability to create indexes to speed up 'contains' search

---
M src-test/src/org/openbravo/dbsm/test/base/DbsmTest.java
M src-test/src/org/openbravo/dbsm/test/model/IndexBaseTest.java
M src-test/src/org/openbravo/dbsm/test/model/ModelSuite.java
M src-test/src/org/openbravo/dbsm/test/model/OperatorClassIndexes.java
M src-test/src/org/openbravo/dbsm/test/model/recreation/AddDropConstraints.java
M src/mapping.xml
M src/org/apache/ddlutils/PlatformInfo.java
M src/org/apache/ddlutils/alteration/ModelComparator.java
M src/org/apache/ddlutils/io/DBSMValueSuppressionStrategy.java
M src/org/apache/ddlutils/model/Index.java
M src/org/apache/ddlutils/platform/SqlBuilder.java
M src/org/apache/ddlutils/platform/oracle/Oracle8Builder.java
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlBuilder.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlModelLoader.java
M src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java
A src-test/model/excludeFilter/excludePgTrgmFunctions.xml
A src-test/model/indexes/CONTAINS_SEARCH_INDEX.xml
A src-test/model/indexes/ICONTAINS_SEARCH_INDEX.xml
A src-test/model/indexes/MULTIPLE_CONTAINS_SEARCH_INDEX.xml
A src-test/model/indexes/PARTIAL_CONTAINS_SEARCH_INDEX.xml
A src-test/src/org/openbravo/dbsm/test/model/ContainsSearchIndexes.java
A src/org/apache/ddlutils/alteration/ContainsSearchIndexInformationChange.java
A src/org/openbravo/ddlutils/util/DBSMContants.java
---
(0093325)
hgbot   
2017-01-11 09:21   
Repository: erp/devel/pi
Changeset: b3923337f9a663735bcdd5a3de6d1633ee92a42f
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Jan 11 09:15:48 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b3923337f9a663735bcdd5a3de6d1633ee92a42f [^]

fixes issue 34650: Ability to create indexes to speed up 'contains' search

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/excludeFilter.xml
M src-db/database/model/prescript-PostgreSql.sql
---
(0093742)
alostale   
2017-01-20 08:11   
reviewed within project
(0095080)
hudsonbot   
2017-03-15 20:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/54e102bef53e [^]
Maturity status: Test