Performing Bit-Byte Operations against Arguments with Non-Equal Lengths

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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.