"execute all" always splits up statements at semicolon [message #851277] |
Fri, 20 April 2012 20:46 |
Enzo Enzo 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
|
|
|
Powered by
FUDForum. Page generated in 0.02929 seconds