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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010237
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajoralways2009-08-11 13:202011-02-04 09:12
ReportervillindView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010237: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2009-08-11 13:20 villind New Issue
2009-08-11 13:20 villind Assigned To => rafaroda
2009-08-13 14:20 rafaroda Assigned To rafaroda => pjuvara
2011-02-04 09:12 jpabloae Assigned To pjuvara => rmorley


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker