Internal Consistency Checks

Invantive SQL executes many internal consistency to ensure correctness of the results. Some of these consistency checks are only done during testing phases for reasons such as performance. These checks are automatically checked on testing environments and excluded on production environments.

However, during test or production use you can explicitly disable or enable these checks by setting environment variables to the value 'true' or 'false'. The checks can individually be disabled or enabled, or all together.

To explicitly enable all consistency checks, set the environment variable INVANTIVE_CHECK_ALL to true. To explicitly disable all consistency checks, set the environment variable INVANTIVE_CHECK_ALL to false.

First determine with help of support the message code to explicitly enable or disable a consistency check. Then set the environment variable INVANTIVE_CHECK_<message code> to the correct value.