Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010237Openbravo ERPA. Platformpublic2009-08-11 13:202011-02-04 09:12
Reportervillind 
Assigned Tormorley 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010237: Functional index support for DDLUtils
DescriptionCurrently the DDLUtils does not support functional indexes. When functional indexes are defined in the database and exported, only the index name is exported.

These are needed for making unique indexes that have nullable columns and null values are considered equal.

Also text based case insensitive searches would benefit of this feature.
Steps To ReproduceExample indexes:

CREATE UNIQUE INDEX bpartnerprod_prtempl_u2
ON m_product_template
USING btree
  (c_bpartner_id,m_product_id,COALESCE(bw_cmf_department_id,0));


CREATE INDEX c_bpartner_name2 on c_bpartner (upper(name));
Proposed SolutionAdd support for functional indexes.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-08-11 13:20villindNew Issue
2009-08-11 13:20villindAssigned To => rafaroda
2009-08-13 14:20rafarodaAssigned Torafaroda => pjuvara
2011-02-04 09:12jpabloaeAssigned Topjuvara => rmorley

There are no notes attached to this issue.