Large Objects and UPDATE
The behavior of truncated LOB updates differs in ANSI and Teradata session modes. The following table explains the differences in truncation behavior.
|
In this session mode … |
The following behavior occurs when non‑pad bytes are truncated on insertion … |
|
ANSI |
an exception condition is raised. The UPDATE fails. |
|
Teradata |
no exception condition is raised. The UPDATE succeeds: the truncated LOB is stored. |