Constraints
- If an out-of-bounds error occurs during numeric calculation, OmniData throws an out-of-bounds exception.
- When comparing character strings, ensure that constants are enclosed in single quotation marks. Example: select * from table where char = '123'
- The decimal (38,38) data type is not supported.
- The timestamp data type is not supported. It is processed in the native calculation approach.
- Operator pushdown is unavailable for transaction tables, which are processed in the native calculation approach.
- Operator pushdown is unavailable for bucket tables, which are processed in the native calculation approach.
- Ensure that the ANALYZE information of a data table is the latest. Otherwise, the pushdown selectivity is inaccurate.
Parent topic: Feature Overview