Invantive UniversalSQL 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.
The following environment variables control internal consistency checks and are available on all platforms and products:
- `INVANTIVE_CHECK_ALL`: explicitly enables all consistency checks when set to `true` (default). To explicitly disable all consistency checks, set to false.
- `INVANTIVE_CHECK_<message code>`: explicitly enable or disable a specific check when requested so by support.