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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0047817
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2021-10-06 09:542021-10-22 12:29
ReporteraferrazView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionfixedFixed in VersionPR22Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava 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

0047817: Not able to use a database immutable function in a table index

DescriptionIf you create a new database immutable function and use it in a table index, the install.source fails as the index is created before the function.

If you run update.database instead of install.source it works fine because function is created before the index.
Steps To ReproduceApply attached diff and run ant install.source.
TagsNo tags attached.
Attached Filesdiff file icon Diff.diff [^] (3,527 bytes) 2021-10-06 09:57 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0132338)
hgbot (developer)
2021-10-14 09:52

Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/32 [^]
(0132557)
hgbot (developer)
2021-10-22 10:00

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/443 [^]
(0132581)
hgbot (developer)
2021-10-22 11:42

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: bb422b20c7f51c400c70fbc6fff0629c2045fef4
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 2021-10-22T09:53:11+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/bb422b20c7f51c400c70fbc6fff0629c2045fef4 [^]

Fixes ISSUE-47817: Cannot use new immutable function in function index

Now the immutable functions are created before the tables and its indexes. This way it is possible to
define an immutable function, export it to a module and then reference it from a table index.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0132582)
hgbot (developer)
2021-10-22 11:42

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/443 [^]
(0132585)
hgbot (developer)
2021-10-22 12:29

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: c2c0cfafbfca0d1c651abbe20b622ea4f3f1a52a
Author: Augusto Mauch <augusto.mauch@openbravo.com>
Date: 2021-10-22T09:56:41+02:00
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/c2c0cfafbfca0d1c651abbe20b622ea4f3f1a52a [^]

Fixes ISSUE-47817: Cannot use new immutable function in function index

Now immutable functions are created just before updating the windows, so if an index reference
one of the new immutable functions, they will be already available

---
A src-test/model/indexes/FUNCTION_INDEX_WITH_OB_DEFINED_FUNCTION.xml
A src/org/apache/ddlutils/alteration/AddImmutableFunctionChange.java
A src/org/apache/ddlutils/alteration/AddMutableFunctionChange.java
M src-test/src/org/openbravo/dbsm/test/model/FunctionBasedIndexes.java
M src/org/apache/ddlutils/alteration/AddFunctionChange.java
M src/org/apache/ddlutils/alteration/ModelComparator.java
M src/org/apache/ddlutils/platform/SqlBuilder.java
---
(0132586)
hgbot (developer)
2021-10-22 12:29

Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/32 [^]

- Issue History
Date Modified Username Field Change
2021-10-06 09:54 aferraz New Issue
2021-10-06 09:54 aferraz Assigned To => platform
2021-10-06 09:54 aferraz Modules => Core
2021-10-06 09:54 aferraz Triggers an Emergency Pack => No
2021-10-06 09:57 aferraz File Added: Diff.diff
2021-10-06 09:59 aferraz Summary Not able to use a database function defined by the user in a table index => Not able to use a database immutable function in a table index
2021-10-06 09:59 aferraz Description Updated View Revisions
2021-10-14 09:52 hgbot Note Added: 0132338
2021-10-22 10:00 hgbot Note Added: 0132557
2021-10-22 11:42 hgbot Resolution open => fixed
2021-10-22 11:42 hgbot Status new => closed
2021-10-22 11:42 hgbot Fixed in Version => PR22Q1
2021-10-22 11:42 hgbot Note Added: 0132581
2021-10-22 11:42 hgbot Note Added: 0132582
2021-10-22 12:29 hgbot Note Added: 0132585
2021-10-22 12:29 hgbot Note Added: 0132586


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker