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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009779
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajoralways2009-07-06 17:272009-10-23 00:00
ReporterroklenardicView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision21a9fa7d2fdb
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionUbuntu 9.04Database version8.3.7Ant version1.7.1
Product Version2.50MP2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009779: Create columns from DB bugs

DescriptionCreate columns from DB process within Table & Column window detects the following types wrong with postgres database

1) planned_nights numeric(2) NOT NULL DEFAULT 1
gets detected as
String 131072

2) final_sum numeric
gets detected as
String -5

3) date_in timestamp without time zone NOT NULL
gets detected as
String 19
Steps To ReproduceUse this create table statement

CREATE TABLE hotel_stay
(
  hotel_stay_id character varying(32) NOT NULL,
  ad_client_id character varying(32) NOT NULL,
  ad_org_id character varying(32) NOT NULL,
  isactive character(1) NOT NULL DEFAULT 'Y'::bpchar,
  created timestamp without time zone NOT NULL DEFAULT now(),
  createdby character varying(32) NOT NULL,
  updated timestamp without time zone NOT NULL DEFAULT now(),
  updatedby character varying(32) NOT NULL,
  hotel_room_id character varying(32) NOT NULL,
  hotel_guest_id character varying(32) NOT NULL,
  date_in timestamp without time zone NOT NULL,
  planned_nights numeric(2) NOT NULL DEFAULT 1,
  date_out timestamp without time zone,
  room_rate varchar(60) NOT NULL,
  final_sum numeric,

  CONSTRAINT hotel_stay_key PRIMARY KEY (hotel_stay_id),
  CONSTRAINT adclient_hotelstay FOREIGN KEY (ad_client_id)
      REFERENCES ad_client (ad_client_id),
  CONSTRAINT adorg_hotelstay FOREIGN KEY (ad_org_id)
      REFERENCES ad_org (ad_org_id),
  CONSTRAINT hotelroom_hotelstay FOREIGN KEY (hotel_room_id)
      REFERENCES hotel_room (hotel_room_id),
  CONSTRAINT hotelguest_hotelstay FOREIGN KEY (hotel_guest_id)
      REFERENCES hotel_guest (hotel_guest_id)
);
TagsNo tags attached.
Attached Filesjpg file icon NumericDetect.jpg [^] (49,254 bytes) 2009-07-06 18:03


jpg file icon NumericDetect1.jpg [^] (41,390 bytes) 2009-07-06 18:03

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0010428 closedalostale Create columns from DB process should check that the common columns are present 
related to defect 0011056 closedrafaroda Create columns from db 

-  Notes
(0020789)
hgbot (developer)
2009-10-06 15:33

Repository: erp/devel/pi
Changeset: 21a9fa7d2fdb7a6a9074116e481cf24aae161d30
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Oct 06 15:32:40 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/21a9fa7d2fdb7a6a9074116e481cf24aae161d30 [^]

fixed bug 09779: Create columns from DB bugs

---
M src-db/database/model/functions/AD_TABLE_IMPORT.xml
---

- Issue History
Date Modified Username Field Change
2009-07-06 17:27 roklenardic New Issue
2009-07-06 17:27 roklenardic Assigned To => rafaroda
2009-07-06 18:03 roklenardic File Added: NumericDetect.jpg
2009-07-06 18:03 roklenardic File Added: NumericDetect1.jpg
2009-07-20 23:06 psarobe Assigned To rafaroda => alostale
2009-07-20 23:06 psarobe Priority normal => urgent
2009-07-20 23:06 psarobe Severity minor => major
2009-07-20 23:06 psarobe Status new => scheduled
2009-10-06 09:37 alostale Relationship added related to 0010428
2009-10-06 15:33 hgbot Checkin
2009-10-06 15:33 hgbot Note Added: 0020789
2009-10-06 15:33 hgbot Status scheduled => resolved
2009-10-06 15:33 hgbot Resolution open => fixed
2009-10-06 15:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21a9fa7d2fdb7a6a9074116e481cf24aae161d30 [^]
2009-10-21 15:22 rafaroda Relationship added related to 0011056
2009-10-22 11:22 plujan Status resolved => closed
2009-10-23 00:00 anonymous sf_bug_id 0 => 2884242


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker