Query and Query-Integrated Block Tests¶

Functionality Tested¶

The tests should cover the following:

(all forms including multi-table forms)
FIND
- FIRST/LAST/NEXT/PREVIOUS, plus the implicit unique find
- FIND literal (i.e., the short form for find the unique record with the literal value on the primary (unique) index)
FOR blocks and loops including FIRST, LAST, EACH and no qualifier
DO PRESELECT
REPEAT PRESELECT
OPEN QUERY
- with and without DEFINE QUERY
- multiple OPEN QUERY statements sharing same DEFINE QUERY
other features
- USE-INDEX (can affect ordering)
- SCROLLING queries
  - NEXT, PREV, FIRST, CURRENT and LAST along with QUERY-OFF-END behavior
  - REPOSITION with ROWID, RECID, ROW, FORWARDS and BACKWARDS
  - INDEXED-REPOSITION
  - NUM-RESULTS
- BREAK keyword generating groups including ACCUM, ACCUMULATE, FIRST-OF, LAST-OF
- BY clause used for ordering is important
- complex BY clauses (expressions, not just fields)
- default ordering if no BY clause exists
  - single-table query on a table (without index)
  - single-table query on a table (with index)
  - multi-table query on tables (with/without index combinations)
  - DESCENDING
- [LEFT] OUTER-JOIN clause
- MAX-ROWS limit
- FIELDS/EXCEPT options
- all non-FIND types should have some multi-table tests:
  - all permanent tables
  - all temp-tables
  - mixture of permanent tables and temp-tables