MS SQL Server GO batch support

[juszczakn]

dbeaver doesn't currently seem to support the MS SQL GO keyword. I'm going to look into adding support for it.

I think I've located the area where query delimiters are gathered, plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/sql/SQLSyntaxManager.java:115

Having a hard time getting the build working on Linux, I'll see how much progress I can make on it.

[serge-rider]

Did you try to set "GO" as statements delimiter in Preferences->SQL Editor->SQL Processing?

[juszczakn]

@serge-rider I did, unfortunately it only supports a single character it seems.

I was looking at solving this by adding another preference page specifically for MS SQL. See juszczakn@9cb9e76 .
I'm not sure if that is the best approach though, any suggestions? Also, I'm not sure how to test my changes.

[serge-rider]

I think that this issue can be solved by fixing statement delimiter UI. Single character limitation is actually a bug (this restriction was there a long time ago - now it is gone)..
UI fix will be fixed in the next version.
BTW default SQL Server and Sybase drivers have default delimiter "GO". I assume you are using some manually created driver.

[serge-rider]

Workaround:

• Open connection editor, click on "Edit Driver".
• Switch tab on "Adv. parameters".
• Set "Script delimiter" value to "go".

[juszczakn]

I believe I'm using the default jtds driver. Thanks for the workaround.

EDIT: It looks like jtds is using lowercase "go", not uppercase. We use all caps "GO", changed and it fixed the issue for me, thanks.