Start a new topic

Delimeter 'GO' only works when lower case

[This topic is migrated from our old forums. The original author name has been removed]

Hi, Started getting errors around 'GO' after upgrading to 9.2.4. Just happened to notice the ones with lowercase 'go' worked fine. Changing 'GO' to 'go' will run fine as in the sample below. eg. GRANT SELECT ON [dbo].[pension_benefit_rate] TO [EFG_CORPORATE\HR_PENSION_ADMIN_PL] AS [dbo] GO Returns message: 10:17:28 [GRANT - 0 row(s), 0.000 secs] [Error Code: 102, SQL State: 42000] Incorrect syntax near 'GO'. GRANT SELECT ON [dbo].[pension_benefit_rate] TO [EFG_CORPORATE\HR_PENSION_ADMIN_PL] AS [dbo] go returns: 10:18:05 [GRANT - 0 row(s), 0.019 secs] Command processed. No rows were affected Connection information Microsoft SQL Server 10.50.1600 jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.8 Product information Product: DbVisualizer Pro 9.2.4 [Build #2423] OS: Windows 7 OS Version: 6.1 OS Arch: x86 Java Version: 1.7.0_76 Java VM: Java HotSpot(TM) Client VM Java Vendor: Oracle Corporation Java Home: c:\program files (x86)\dbvisualizer\jre DbVis Home: C:\Program Files (x86)\DbVisualizer

[This reply is migrated from our old forums.]

Re: Delimeter 'GO' only works when lower case
Hi, Thanks for reporting this. It is a regression bug that will be fixed in the next maintenance release. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Delimeter 'GO' only works when lower case
Thanks Hans Gary Edited by: empire_1 on 19-Mar-2015 4:21 PM
[This reply is migrated from our old forums.]

Re: Delimeter 'GO' only works when lower case
Hi, We have just released 9.2.6 with a fix for the issue you reported. http://www.dbvis.com/download/ Regards Roger