The LIMIT operator is stateful. Because its internal state is tightly coupled to the query definition, certain changes to a LIMIT clause break state compatibility and prevent a deployment from resuming from its existing state.
Incompatible changes
The following changes to a LIMIT clause make the deployment incompatible with existing state data:
| Change | Example |
|---|---|
| Limit number | Changing LIMIT 100 to LIMIT 200 |
| Offset number | Changing OFFSET 10 to OFFSET 20 |
| Schema in LIMIT | Adding or removing columns in the SELECT list |
If you apply any of these changes to a running deployment, the deployment becomes incompatible with existing state data.