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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034646
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2016-11-28 12:122016-12-16 18:39
ReportercaristuView Statuspublic 
Assigned Tocaristu 
PriorityhighResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revision1197b9648445
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034646: Comments should be queried from user tables

DescriptionComments used to keep db consistency in Oracle are currently being stored in the following tables: ALL_TAB_COMMENTS[1] and ALL_COL_COMMENTS [2]. Therefore, users within the same DB can see the comments stored in those tables event if they are not the owners of the comment.

This can cause errors when using the comments to update/export the database as comments from other users could be retrieved instead of the expected ones.


[1] https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm [^]
[2] https://docs.oracle.com/cd/B28359_01/server.111/b28320/statviews_1036.htm#REFRN20040 [^]
Steps To ReproduceIn description
Proposed SolutionUse USER_TAB_COMMENTS and USER_COL_COMENTS tables.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of feature request 00346503.0PR17Q2 closedcaristu Ability to generate indexes to speed up searching using 'contains' operators 
related to feature request 0030525 closedAugustoMauch Provide support in DBSourceManager to define an operator class in index columns 
related to feature request 0032211 closedcaristu support for partial indexes 

-  Notes
(0091889)
hgbot (developer)
2016-11-28 12:47

 Repository: erp/devel/dbsm-main
Changeset: 2c245cca180a01e69a21cfcb3e893c00516bc8af
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 28 12:46:07 2016 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/2c245cca180a01e69a21cfcb3e893c00516bc8af [^]

related to issue 34646: Oracle comments should be stored in user tables

---
M src-test/src/org/openbravo/dbsm/test/model/IndexBaseTest.java
M src-test/src/org/openbravo/dbsm/test/model/OperatorClassIndexes.java
M src/org/apache/ddlutils/platform/oracle/Oracle8Builder.java
M src/org/apache/ddlutils/platform/oracle/OracleModelLoader.java
---
(0091890)
hgbot (developer)
2016-11-28 12:53

 Repository: erp/devel/pi
Changeset: 1197b964844552d650534948effb1515747f3f91
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Mon Nov 28 12:50:17 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1197b964844552d650534948effb1515747f3f91 [^]

fixes issue 34646: Oracle comments should be stored in user tables

---
M src-db/database/lib/dbsourcemanager.jar
---
(0092667)
hudsonbot (developer)
2016-12-16 18:39

 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/dc8bf00badd0 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-11-28 12:12 caristu New Issue
2016-11-28 12:12 caristu Assigned To => platform
2016-11-28 12:12 caristu Modules => Core
2016-11-28 12:12 caristu Triggers an Emergency Pack => No
2016-11-28 12:12 caristu Relationship added related to 0030525
2016-11-28 12:13 caristu Relationship added related to 0032211
2016-11-28 12:13 caristu Assigned To platform => caristu
2016-11-28 12:16 caristu Description Updated View Revisions
2016-11-28 12:18 caristu Description Updated View Revisions
2016-11-28 12:23 caristu Summary Comments should be stored in user => Comments should be stored in user tables
2016-11-28 12:23 caristu Description Updated View Revisions
2016-11-28 12:23 caristu Description Updated View Revisions
2016-11-28 12:47 hgbot Checkin
2016-11-28 12:47 hgbot Note Added: 0091889
2016-11-28 12:53 hgbot Checkin
2016-11-28 12:53 hgbot Note Added: 0091890
2016-11-28 12:53 hgbot Status new => resolved
2016-11-28 12:53 hgbot Resolution open => fixed
2016-11-28 12:53 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1197b964844552d650534948effb1515747f3f91 [^]
2016-11-28 12:53 caristu Review Assigned To => alostale
2016-11-28 14:09 alostale Summary Comments should be stored in user tables => Comments should be queried from user tables
2016-11-28 14:09 alostale Status resolved => closed
2016-11-28 14:09 alostale Fixed in Version => 3.0PR17Q1
2016-11-28 17:31 caristu Relationship added duplicate of 0034650
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092667

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker