Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0012954 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2010-04-13 16:48 | 2010-05-19 00:00 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP18 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | b50575200731 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | 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 | 0012954: Tables with source data and reference data at the same time are not allowed | |||||||
| Description | It is not possible to define tables with data populated as reference data and as sourcedata at the same time. | |||||||
| Steps To Reproduce | -Create a new table with ad_module_id, access: all -Add it to AD dataset -In the dataset where clause add: ad_module_id in (:moduleid) and ad_client_id='0'. So data in client 0 should be exported as sourcedata and data in other clients as part of another dataset. -Export database: [exportdatabase] SQL command to read rows from table failed: SELECT * FROM AD_PROPERTY_CONFIGURATION WHERE ad_client_id = '0' and ad_module_id in ('0') ORDER BY AD_PROPERTY_CONFIGURATION_ID [exportdatabase] Couldn't read rows from table AD_PROPERTY_CONFIGURATION [exportdatabase] java.sql.SQLException: Couldn't read rows from table AD_PROPERTY_CONFIGURATION | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0027000) hgbot (developer) 2010-05-06 18:06 |
Repository: erp/devel/pi Changeset: fc60813af2904273a01b67a628b2e3be8dc2cbb0 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Mon May 03 12:34:27 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/fc60813af2904273a01b67a628b2e3be8dc2cbb0 [^] Fixed issue 12954. Tables with source data and reference data at the same time will be allowed, by using a secondary whereclause. --- M src-db/database/lib/dbsourcemanager.jar M src-db/database/model/tables/AD_DATASET_TABLE.xml M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_DATASET_TABLE.xml M src-db/database/sourcedata/AD_ELEMENT.xml M src-db/database/sourcedata/AD_FIELD.xml --- |
|
(0027027) hgbot (developer) 2010-05-07 09:22 |
Repository: erp/devel/pi Changeset: b50575200731f05fb9e57af19e31f51a06a7e117 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Fri May 07 09:22:03 2010 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/b50575200731f05fb9e57af19e31f51a06a7e117 [^] Fixed issue 12954. Tables with source data and reference data at the same time will be allowed, by using a secondary whereclause. --- M src-db/database/lib/dbsourcemanager.jar --- |
|
(0027489) hudsonbot (developer) 2010-05-18 21:43 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/fc60813af290 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^] |
|
(0027495) hudsonbot (developer) 2010-05-18 21:44 |
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated: Changeset: http://code.openbravo.com/erp/devel/main/rev/b50575200731 [^] Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^] Tests: http://builds.openbravo.com/view/devel-int/ [^] OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-04-13 16:48 | alostale | New Issue | |
| 2010-04-13 16:48 | alostale | Assigned To | => marvintm |
| 2010-04-19 08:31 | alostale | Summary | Tables with source data and reference data at the same time are not alled => Tables with source data and reference data at the same time are not allowed |
| 2010-04-19 08:31 | alostale | Status | new => scheduled |
| 2010-04-19 08:31 | alostale | fix_in_branch | => pi |
| 2010-05-06 18:06 | hgbot | Checkin | |
| 2010-05-06 18:06 | hgbot | Note Added: 0027000 | |
| 2010-05-06 18:06 | hgbot | Status | scheduled => resolved |
| 2010-05-06 18:06 | hgbot | Resolution | open => fixed |
| 2010-05-06 18:06 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/fc60813af2904273a01b67a628b2e3be8dc2cbb0 [^] |
| 2010-05-07 09:22 | hgbot | Checkin | |
| 2010-05-07 09:22 | hgbot | Note Added: 0027027 | |
| 2010-05-07 09:22 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/fc60813af2904273a01b67a628b2e3be8dc2cbb0 [^] => http://code.openbravo.com/erp/devel/pi/rev/b50575200731f05fb9e57af19e31f51a06a7e117 [^] |
| 2010-05-18 15:02 | alostale | Status | resolved => closed |
| 2010-05-18 15:02 | alostale | Fixed in Version | => 2.50MP18 |
| 2010-05-18 21:43 | hudsonbot | Checkin | |
| 2010-05-18 21:43 | hudsonbot | Note Added: 0027489 | |
| 2010-05-18 21:44 | hudsonbot | Checkin | |
| 2010-05-18 21:44 | hudsonbot | Note Added: 0027495 | |
| 2010-05-19 00:00 | anonymous | sf_bug_id | 0 => 3003675 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |