Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0007095 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-01-23 12:28 | 2009-03-06 12:34 | |||
Reporter | mtaal | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 12228 | ||||
Projection | none | ETA | none | Target Version | pi | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | 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 | 0007095: Add onCreateDefault to AD_TABLE.classname column | |||||||
Description | The AD_TABLE.classname column is not-null therefore it requires an onCreateDefault definition. Below is a snippet of a chat with Asier on how to do that. Probably: adding this the classname column in AD_TABLE.xml is enough: <onCreateDefault><![CDATA[NAME]]></onCreateDefault> Skype chat: Asier Lostalé: <column name="UIPATTERN" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false"> <default><![CDATA[S]]></default> <onCreateDefault><![CDATA[CASE WHEN PROCEDURENAME IS NOT NULL THEN 'S' WHEN ISJASPER='Y' THEN 'S' ELSE 'M' END]]></onCreateDefault> </column> [12:18:03] … it is a sql clause [12:18:18] Martin Taal: ha ok in the ad_column [12:18:31] Asier Lostalé: ? [12:18:39] Martin Taal: no [12:18:49] … where do you specify this then? [12:18:59] Asier Lostalé: it should be in the xml that defines the ad_table table [12:19:12] … in the classname column definition [12:20:16] Martin Taal: so I need to add this manually to the xml? [12:20:24] Asier Lostalé: yes [12:20:31] Martin Taal: ok and then do create.database [12:20:40] Asier Lostalé: :) [12:20:50] Martin Taal: or can I create it directly in postgres to test it? [12:20:52] Asier Lostalé: if you do create database you will not see anything [12:21:04] … it is difficult to test [12:21:10] Martin Taal: :-( [12:21:23] … I mean where does DBSourcemanager place this code? [12:21:26] Asier Lostalé: to test if you should remove phyisical column from db [12:21:34] Martin Taal: in a trigger, a function, ...? [12:21:45] Asier Lostalé: and then update.database [12:22:12] … let's talk [12:23:56] … select oncd from yourtable [12:24:40] … name | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0012594) svnbot (reporter) 2009-01-24 17:39 |
Repository: openbravo Revision: 12228 Author: mtaal Date: 2009-01-24 17:39:41 +0100 (Sat, 24 Jan 2009) Fixes issue 7095, Add onCreateDefault to AD_TABLE.classname column --- U trunk/src-db/database/model/tables/AD_TABLE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=12228&sc=1 [^] |
Issue History | |||
Date Modified | Username | Field | Change |
2009-01-23 12:28 | mtaal | New Issue | |
2009-01-23 12:28 | mtaal | Assigned To | => mtaal |
2009-01-23 12:28 | mtaal | sf_bug_id | 0 => 2530904 |
2009-01-23 12:28 | mtaal | Regression testing | => No |
2009-01-24 17:39 | svnbot | Checkin | |
2009-01-24 17:39 | svnbot | Note Added: 0012594 | |
2009-01-24 17:39 | svnbot | Status | new => resolved |
2009-01-24 17:39 | svnbot | Resolution | open => fixed |
2009-01-24 17:39 | svnbot | svn_revision | => 12228 |
2009-03-06 12:34 | psarobe | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |