Code Inspector: Bypassing of table buffer, IN lists
[buffer] [bypassing] [is table of] [SCI] [table of content] [table of contents] [type is table of]
Symptom
If IN lists are used in the WHERE condition, the check “SELECT Statements That Bypass the Table Buffer” in the Code Inspector issues the message “Generically Buffered Key Area not Completely Specified for Table &1″. However, none of the buffered key fields of the table with an IN condition is accessed, in other words, the buffer can be used.
Other terms
SCI, bypassing buffer
Reason and Prerequisites
Implementing Note 1313226 (Code Inspector: IN lists for table buffer workaround) or importing the relevant Support Package has changed the way in which IN lists and OR clauses are handled in connection with a bypassing of the table buffering. For this, the following was ignored: Only if the buffered key fields of a table with generic or single record buffering are compared with an IN list, the table buffer can be bypassed.
Solution
To correct this problem, implement this note. However, implement this note only after you implemented the note mentioned above.