Project

General

Profile

Bug #7

misconversion of multi-table FOR/REPEAT/DO with UNIQUE component

Added by Stanislav Lomany almost 15 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:

History

#1 Updated by Stanislav Lomany almost 15 years ago

@45264 - testcase:

def temp-table tt1 field f1 as integer.
    create tt1. f1 = 1.
    create tt1. f1 = 2.

    def temp-table tt2 field f2 as integer.
    create tt2. f2 = 1.
    create tt2. f2 = 2.

    repeat preselect each tt1, tt2:
      find next tt2.
      if avail tt2 then message "test1".
      else leave.
    end.

Note that as far as I've checked, Progress 9.1 doesn't allow unique elements in multi-table queries.

#2 Updated by Stanislav Lomany almost 15 years ago

@45112 - issue description:

Multi-table FOR/REPEAT/DO cycle containing an UNIQUE component, converted to a preselect / presort query. The conversion output is mistakenly converted and looks like this:

query = new PreselectQuery("b.b1 asc");
query.addComponent(a, ((String) null));
query.setIterationType(QueryConstants.UNIQUE);
query.addComponent(b, ((String) null));
query.setIterationType(QueryConstants.UNIQUE);

#3 Updated by Redmine Admin almost 15 years ago

@45125 - Status changed from WIP to Hold

#4 Updated by Stanislav Lomany over 14 years ago

Imported from JPRM on 2012-04-12 11:23:00.41:

TASKID      = 6100
PROJECTID   = 124
STATUS      = 3 (Hold)
DESCRIPTION = misconversion of multi-table FOR/REPEAT/DO with UNIQUE component
OWNER       = SVL
ASSIGNEE    = 
BILLABLE    = false
PRIORITY    = 5 (Normal)
PHASE       = 52 (Problem Resolution)
COMPONENT   = 97
ESTEFFORT   = 0.000000
ESTSTART    = 2011-10-03
ESTSTOP     = 
ACTSTOP     = 
CASENUM     = 
VENDORID    = 
COMMENT     = ''
LASTWIP     = 2011-10-17

Also available in: Atom PDF