I have the community edition 6.1.2-0
that's really intrigiung...
Column must appear in the GROUP BY
Moderator: NorbertKrupa
Re: Column must appear in the GROUP BY
So it looks like it's related to prepared statements not being handled properly.
Can you please help me out writing a prepared statement query from SquirrelSQL?
(I tried and it gave me this error
PREPARE stmt (varchar) AS
SELECT * FROM my_table WHERE name = $1;
Can you please help me out writing a prepared statement query from SquirrelSQL?
(I tried and it gave me this error
)Error: [Vertica][VJDBC](4412) ERROR: Prepared statements are currently unsupported
SQLState: 0A000
ErrorCode: 4412
PREPARE stmt (varchar) AS
SELECT * FROM my_table WHERE name = $1;
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Column must appear in the GROUP BY
Hi,
It's not SQuirreL that doesn't support prepared statements, it's Vertica.
Since they have a specific error for it, perhaps prepared statements are in the development pipeline?
It's not SQuirreL that doesn't support prepared statements, it's Vertica.
Code: Select all
dbadmin=> PREPARE stmt (varchar) AS
dbadmin-> SELECT * FROM my_table WHERE name = $1;
ERROR 4412: Prepared statements are currently unsupported
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Column must appear in the GROUP BY
Right,
When I said 'not handled properly' I was talking about the vertica driver.
And this makes me think that this is the reason for my original problem, since all queries from the app are prepared statements. Any idea on the ETA for this feature in the driver side? if not, where/who should I ask?
Thanks
When I said 'not handled properly' I was talking about the vertica driver.
And this makes me think that this is the reason for my original problem, since all queries from the app are prepared statements. Any idea on the ETA for this feature in the driver side? if not, where/who should I ask?
Thanks
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Column must appear in the GROUP BY
Hi,
Check the vertica.log file to see what is the exact SQL statement that is being passed to Vertica. If it is PREPARE statement, then it's not a driver issue If you still think it's a driver issue then I suggest contacting Vertica directly. However, since you are using CE, I'm not sure if you can get support.
Check the vertica.log file to see what is the exact SQL statement that is being passed to Vertica. If it is PREPARE statement, then it's not a driver issue If you still think it's a driver issue then I suggest contacting Vertica directly. However, since you are using CE, I'm not sure if you can get support.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.