0020646: Some isactive columns lack check constraint

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0020646

Openbravo ERP

00. Application dictionary

public

2012-05-30 15:43

2019-10-22 12:54

Reporter

jvazquez

Assigned To

dmiguelez

Priority

none

Severity

minor

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

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

0020646: Some isactive columns lack check constraint

Description

There are some isactive columns that do not have the CONSTRAINT x_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])).

Steps To Reproduce

Go to the src-db/database/model/tables directory. Execute grep -ir ISACTIVE . and if a table has the constraint, it will appear twice - the column definition and th constraint itself.
Some example of tables that will only appear once (as they don't have the constraint are: c_remmittanceline, c_order_discount, ad_module_log, c_acct_rpt_group, etc.

Proposed Solution

First, create a SQL sentence that allows to clearly identify tables that do not have the constraint.
Then add the constraint to resultant set of tables.

Additional Information