16.20 - Performing Bit-Byte Operations against Arguments with Non-Equal Lengths - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

Teradata Database
Teradata Vantage NewSQL Engine
Programming Reference

This topic applies only to the BITOR, BITXOR, and BITAND functions.

If the target_arg and bit_mask_arg arguments passed to these functions differ in length:

  • The target_arg and bit_mask_arg arguments are aligned on their least significant byte/bit.
  • The smaller argument is padded with zeros to the left until it becomes the same size as the larger argument.

    Teradata Database pads to the left (instead of to the right) so that the hexadecimal byte literals, serving as bit masks, will not have to be changed every time the size of a byte string is changed.