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:
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