HASHBUCKET returns an INTEGER data type.
| IF expression … | THEN … |
|---|---|
| does not appear in the argument list | HASHBUCKET returns an INTEGER value that is the highest hash bucket number. |
| evaluates to NULL | HASHBUCKET returns NULL. |
| evaluates to a valid BYTE(4) row hash value | HASHBUCKET returns the hash bucket number corresponding to the row hash value. The range of values for hash bucket numbers depends on the system setting of the hash bucket size.
|