create function fails
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Using 3.6 to access Vertica 7.0. When trying to create a function, even a simple one like:
CREATE OR REPLACE FUNCTION testfun() RETURN varchar(250) AS BEGIN RETURN 'foobar'; END;
I get the following error message:
Error: [Vertica][VJDBC](4856) ERROR: Syntax error at or near "EOL" SQLState: 42601 ErrorCode: 4856 Error occured in: CREATE OR REPLACE FUNCTION testfun() RETURN varchar(250) AS BEGIN RETURN 'foobar'
Feels like one of the plugins might have altered the query, and eventually broke it. Would be nice if SQuirreL could help in trecking went wrong, like:
- display the raw string sent to the server
- display if any plugins altered the query
A little googling showed that DBVisualizer has/had similar problems, but couldnt find tickets for SQuirreL. I'm definitely not a poweruser, so thought it might require simple changes to settings to fix this, I dont know where to look. So, it does not feel intuitive.
(Looked into the jdbcdebug.log, but only contained SQLState and ErrorCode)
Thx
V