Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0010237 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | major | always | 2009-08-11 13:20 | 2011-02-04 09:12 | |||||||
| Reporter | villind | View Status | public | |||||||||
| Assigned To | rmorley | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | PostgreSQL | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0010237: Functional index support for DDLUtils | |||||||||||
| Description | Currently 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 Reproduce | Example 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 Solution | Add support for functional indexes. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |