Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » "execute all" always splits up statements at semicolon
"execute all" always splits up statements at semicolon [message #851277] Fri, 20 April 2012 20:46
Enzo Enzo is currently offline Enzo EnzoFriend
Messages: 1
Registered: April 2012
Junior Member
Hi all

The command "execute all" always breaks statements at semicolons even when it should not.
Example:

drop procedure if exists test
go
create procedure test()
begin
declare a int;
set a=111;
select a;
end
go
call test
go

It splits this file in 6 statements, which is wrong.
If I delete all the semicolons:

drop procedure if exists test
go
create procedure test()
begin
declare a int
set a=111
select a
end
go
call test
go

It correctly splits the file in three statements, but then i get an error at "declare a int" because it needs a semicolon.

Is this a bug?
Is there a way to tell eclipse dtp which delimiter to use?
Is there a workaround?
Thanks in advance.

I use eclipse indigo, dtp 1.9.2 , mysql-connector-java-5.1.19, MySql server 5.4
Previous Topic:Manually expand Data Source Explorer nodes
Next Topic:Accessing Result columns after parsing using SQLQueryParser
Goto Forum:
  


Current Time: Wed Nov 26 20:50:12 GMT 2014

Powered by FUDForum. Page generated in 0.01647 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software