ERROR: syntax error at or near "group" at character 599969

Moderator: NorbertKrupa

Post Reply
User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

ERROR: syntax error at or near "group" at character 599969

Post by Josh » Mon Jul 02, 2012 5:57 pm

Hi,

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
Anyone know what this is? I am running Vertica 5.

Thanks!
Thank you!
Joshua

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: ERROR: syntax error at or near "group" at character 599

Post by JimKnicely » Tue Jul 03, 2012 2:03 pm

Josh,

This is a bug in Vertica 5 that has been fixed in Vertica 6...
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.
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

Re: ERROR: syntax error at or near "group" at character 599

Post by Josh » Sun Jul 22, 2012 8:09 am

Thanks, we upgraded to Vertica 6, release 3 and the error went away.
Thank you!
Joshua

Post Reply

Return to “Vertica Error Codes”