In this blog post, let’s learn about the error message “221 Cannot build temporary file for new table table-name.” in Hydra and the description of the error.
Error Message
221 Cannot build temporary file for new table table-name.
Error Details
The WHERE clause in this statement includes a test of a noncharacter column using the LIKE or MATCHES keyword and the special characters that stand for multiple characters (for example, asterisk and question mark in MATCHES and percent and underscore with LIKE). Use these tests only with columns that are defined as CHAR or VARCHAR in the database. No automatic data conversion is provided. Check that the columns in the WHERE clause are as you intended. If so, the definition of the table(s) has probably changed.