0009779: Create columns from DB bugs - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009779

Openbravo ERP

00. Application dictionary

public

2009-07-06 17:27

2009-10-23 00:00

Reporter

roklenardic

Assigned To

alostale

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 9.04

Product Version

2.50MP2

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0009779: Create columns from DB bugs

Description

Create 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 Reproduce

Use 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)
);

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

related to	defect	0010428		closed	alostale	Create columns from DB process should check that the common columns are present
related to	defect	0011056		closed	rafaroda	Create columns from db