Executing input file that contain strings ending with \

[npandrei]

I have a script file that contains strings ending with \. When running sqlcmd -S localhost -U sa -i script.sql, I get the following error:

Incorrect syntax near 'GO'.

These steps should allow to reproduce the issue:

docker run -it -u 0 -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=demo1234!' -p 1433:1433 mcr.microsoft.com/azure-sql-edge /bin/bash
# apt-get update && apt-get install -y curl gnupg2 software-properties-common
# curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
# add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/prod.list)"
# apt-get update && apt-get install -y sqlcmd
# export SQLCMDPASSWORD=demo1234!
# /opt/mssql/bin/sqlservr &

wait for sql server to start

# sqlcmd -l 1 -S localhost -U sa -Q "SELECT 1"

create script.sql with these contents

-- script.sql


USE [master]
GO
IF DB_ID (N'demo') IS NOT NULL
DROP DATABASE [demo];
GO
CREATE DATABASE [demo]
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled\'))
begin
EXEC [demo].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

# sqlcmd -S localhost -U sa -i script.sql

and you should see the Incorrect syntax near 'GO'. error.

Any thoughts on what I can do to overcome this issue ?

[shueybubbles]

Do you have a repro that's using valid TSQL syntax? And do you know if it happens on both Linux and Windows?

[npandrei]

Do you have a repro that's using valid TSQL syntax? And do you know if it happens on both Linux and Windows?

I have tried it only on linux and a colleague tried it on his Macbook Pro M1 device. Both produced this error.

The code I added above runs fine in sqlcmd (the classic one) and in Sql Management Studio. go-sqlcmd is the only one throwing the error.

If I remove the GO statements, it seems to behave correctly though:

USE [master]

if ('2' = '2\')
begin
SELECT '1'
end

SELECT '2'

[npandrei]

here is another example of a script with the same issue in go-sqlcmd

USE [master]
GO

if ('2' = '2\')
begin
SELECT '1'
end
GO

SELECT '2'
GO

in Sql Management Studio runs fine:

but go-sqlcmd's output is:

[npandrei]

This runs fine in go-sqlcmd, and the only difference from the script above is the '2\' -> '2'.

USE [master]
GO

if ('2' = '2')
begin
SELECT '1'
end
GO

SELECT '2'
GO

[shueybubbles]

the batch parser is treating \' as an escaped quote

E:\git\go-sqlcmd\cmd\sqlcmd>sqlcmd
1> print 'hey\'
2~