Project

General

Profile

Bug #11413

Investigate CQ optimization for preselect component with dynamic component

Added by Alexandru Lungu 3 months ago. Updated 3 months ago.

Status:
WIP
Priority:
Normal
Assignee:
Alexandru Lungu
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

#2 Updated by Alexandru Lungu 3 months ago

  • Assignee set to Alexandru Lungu
  • Status changed from New to WIP

Refer to #11397-7:

  • construct a for each block with a CQ that has a preselect component and dynamic component (RAQ), generated due to a BY component over a field that is not indexed.
  • optimizer will generate a multi-table AQ (dynamic query) with the preselect and dynamic components
  • the AQ is invalidated and the original fallback (the preselect query) is invalidated. This is an invalid state.
The issue here is whether the preselect component should have been optimized into an AQ. But first, we need to research what is the query state in 4GL:
  • is the query invalidating only on the second component of the CQ?
  • is the query completely preselected?
  • other

Currently, trunk/16535 silenced the preselect query invalidation invalid state exception.

Also available in: Atom PDF