When I try to run the ANALYZE_CONSTTAINTS() function I get a weird error:
Code: Select all
dbadmin=> select analyze_constraints('');
ERROR: syntax error at or near "group" at character 599969
Thanks!
Moderator: NorbertKrupa
Code: Select all
dbadmin=> select analyze_constraints('');
ERROR: syntax error at or near "group" at character 599969
Issue: VER-22148
Component: Front end - Parse & Analyze
Description: Vertica displayed an incorrect error message "ERROR: syntax error at or near "having" at character 91379" after the statement "select analyze_constraints('');" in previous releases. This issue has been resolved.