Error 1708

Severity

16

Message text

Warning: Row size (%d bytes) could exceed row size limit, which is %d bytes. 

Explanation

This is an information message printed when creating a table or adding and modifying table columns using the alter table command). This message is printed when the size of the data row of the table being created or altered exceeds the maximum data row size allowed in the server (maximum row size depends on the lock scheme of the table).

This error does not terminate the execution of the statement and allows the table to be created or altered. But, when an application tries to insert or update a row that is larger than the displayed size limit, that operation will fail with an error such as 511.

Action

Carefully design the schema so that the data row size is under the maximum data row size, which depends on lock scheme, allowed by the server.

Versions in which this error is raised

Version 12.5 and later