Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009967Openbravo ERPA. Platformpublic2009-07-20 16:052009-08-19 00:00
Reporterrafaroda 
Assigned Tobalamurugan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009967: AD literals default values should not be quoted
DescriptionApplication Dictionary literal default values should not be quoted
Steps To ReproduceIn PostgreSQL:

SELECT t.name AS table, c.name AS column, c.defaultvalue AS default
FROM ad_table t, ad_column c
WHERE c.ad_table_id = t.ad_table_id
AND (c.defaultvalue = '''Y'''OR c.defaultvalue = '''N''')
AND c.ad_reference_id = '20'
ORDER BY t.name
Proposed SolutionReplace 'Y' by Y and 'N' by N
Additional Information
TagsNo tags attached.
Relationships
related to defect 0008900pi closed mtaal Inconsistencies between database default values and application dictionary default values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-20 16:05rafarodaNew Issue
2009-07-20 16:05rafarodaAssigned To => mtaal
2009-07-20 16:05rafarodaRelationship addedrelated to 0008900
2009-07-21 00:08psarobeStatusnew => scheduled
2009-07-21 00:08psarobefix_in_branch => pi
2009-07-21 08:48iciordiaAssigned Tomtaal => rafaroda
2009-07-22 17:08rafarodaAssigned Torafaroda => balamurugan
2009-07-29 13:11hgbotCheckin
2009-07-29 13:11hgbotNote Added: 0018686
2009-07-29 13:11hgbotStatusscheduled => resolved
2009-07-29 13:11hgbotResolutionopen => fixed
2009-07-29 13:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/91d6ebc453fd1b063daec733972c53b6dd76e83c [^]
2009-08-18 10:25plujanStatusresolved => closed
2009-08-19 00:00anonymoussf_bug_id0 => 2839886

Notes
(0018686)
hgbot   
2009-07-29 13:11   
Repository: erp/devel/pi
Changeset: 91d6ebc453fd1b063daec733972c53b6dd76e83c
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Wed Jul 29 16:40:20 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/91d6ebc453fd1b063daec733972c53b6dd76e83c [^]

Fixed Issue 9967: AD literals default values should not be quoted.

---
M src-db/database/sourcedata/AD_COLUMN.xml
---