In this blog post, let’s learn about the error message “25313 AA compiler with version less than or equal to version1 and higher than or equal to version2 is required to compile the query. The current compiler version is version3.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25313 AA compiler with version less than or equal to version1 and higher than or equal to version2 is required to compile the query. The current compiler version is version3.
Reason for the Error
The query affects one or more nodes with an MXV lower than the current compiler version.
Solution
Explicitly use a compiler with version in the specified interval