Strict Mode in Release 7.40, SP08Other versions:
Conditions for the Strict Mode
The strict mode of the syntax check in Release 7.40, SP08 applies to all ABAP SQL statements that use one of the following attributes introduced in Release 7.40 SP08:
dbtab~*specified in the
- Minus sign (
-) in front of an operand of an arithmetic expression
- SQL expression as an operand of a simple case distinction
- Use of a complex case distinction
- SQL expression after the addition
GROUP BYof the statement
- SQL expression as an argument of aggregate expressions in the
SELECTlist or in the
- Use of the additions
NOTplus the operators
- Outer join without a comparison between columns on the left and right sides.
- Arrangement of the
INTOclause as the final clause of a
Rules for the Strict Mode
The strict mode in Release 7.40, SP08 covers all rules of the strict mode in Release 7.40, SP05, plus the following rules:
- If the content of a literal, a host variable, or a host expression read in an operand position needs to be converted to the target type, this is done using the rules for lossless assignments. If the assignment cannot be lossless, an exception is raised.
AS tabaliasis used to define an alias name for a database table, this name must also be used in dynamic tokens.
- Comparisons between non-comparable types produce a syntax error or raise an exception.
- If a column specified in the
HAVINGclause outside of an aggregate expression is not specified after
GROUP BY, a syntax error occurs.