0011752: Default values of WAD generated windows do not work always.

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011752

Openbravo ERP

A. Platform

public

2009-12-11 18:45

2012-03-29 17:14

Reporter

shuehner

Assigned To

alostale

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

2.40

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

0011752: Default values of WAD generated windows do not work always.

Description

The select statement used by wad to retrieve the list of column having a default value (FieldsData.selectDefaultValue) does not have an order by and is used two times per Tab.

The order of rows returned without order by is random (but in practice often the same)

If the database returns the rows with different order in two different wad-compilations it will works but the generated code is different which is ugly.

If the database returns the rows with different order inside one wad-compilation (can happen as wad calls the same select twice per tab) no compilation error will happen but the default values will be assigned randomly (i.e. line-number default value assigned into another field)

Steps To Reproduce

No always reproducible steps available

Proposed Solution

Add order by to the select to garantee deterministic order.

Additional Information