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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0014235

closed

shuehner

Missing order by clause in Field_data.xsql selectDefaultValue method

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2009-12-11 18:45	shuehner	New Issue
2009-12-11 18:45	shuehner	Assigned To	=> rafaroda
2009-12-11 18:45	shuehner	version	pi => 2.40
2009-12-14 14:34	shuehner	Relationship added	related to 0011530
2009-12-14 22:05	shuehner	Relationship deleted	related to 0011530
2010-02-11 18:32	rafaroda	Assigned To	rafaroda => alostale
2010-02-15 12:53	alostale	Status	new => scheduled
2010-02-15 12:53	alostale	fix_in_branch	=> pi
2012-03-29 17:14	shuehner	Relationship added	duplicate of 0014235
2012-03-29 17:14	shuehner	Status	scheduled => closed
2012-03-29 17:14	shuehner	Resolution	open => duplicate