INTERNAL 3594: Internal Optimizer Error (11)
Recently i encountered a bug while executing a SQL query with the pyodbc module for Python (2.7).
|('VX001', '[VX001] INTERNAL 3594: Internal Optimizer Error (11)\nDETAIL: "PlanExprFixup: No mapping found" == 0\nHINT: Please report this error to Vertica; try restating your query\n (3594) (SQLExecDirectW)') DROP TABLE IF EXISTS buyers;|
This message only occurs on 1 of my Vertica DB tables. I did not encounter this error on any other table. Things i have tried so far:
- DELETING and CREATING the table
- Stripping the SQL query from comments
None of them seem to be working so far. Anyone has a suggestion? I could not find alot of information regarding this bug.
Vertica 126.96.36.199. If anyone is wondering