Menu

#1186 create function fails

None
open
nobody
None
5
2018-12-22
2015-03-05
vhermecz
No

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

Discussion


Log in to post a comment.