Introduction
Implicit data type conversion refers to the automatic conversion of data types performed by HetuEngine when users access its resources via a client and the data types used in queries do not match those defined in the tables. This feature minimizes errors due to strict data type validation and enhances user experience.
Currently, HetuEngine supports implicit data type conversion in the following scenarios:
- Data insertion (Insert): Automatically converts input data to the corresponding data type of the target table during insertion.
- Conditional judgment (Where): Converts different types of data into comparable types within conditional expressions.
- Arithmetic operations (+, -, *, /): Transforms operands into compatible types during arithmetic calculations.
- Function calls (Concatenation Operation ||): Changes various data types into the types required by functions or operators during function calls or string concatenations.
These implicit conversion capabilities allow users to bypass manual handling of data type mismatches, streamlining operational procedures and boosting query efficiency.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.