Removing line prompts when running sqlcmd as a subprocess from a script on Linux

[HoundThe]

I've tried to replace the legacy sqlcmd with the sqlcmd-go, but I've noticed a difference that I can't find in the documentation.

When running sqlcmd-go from a program, by creating a subprocess and writing/reading stdin/stdout a line prompts can be found in the output. This does not happen with original sqlcmd.

Example:
Program writes to the process stdin following commands:

• SET NOCOUNT ON;
• select * ...;
• go
• exit

Then the stdout output will look like this

1> 2> 3> 
<QUERY OUTPUT>
1> 

Is there a way to avoid this, while keeping the ability to interactively communicate commands via stdin/stdout as a subprocess?

[shueybubbles]

i think it's a bug just due to being an untested scenario. Is this behavior documented somewhere in the original sqlcmd and I missed it?

[HoundThe]

I didn't find any documentation for this behavior.

EDIT: What I wrote here before was wrong, so I removed it, happened because by accident I use sqlcmd instead of ./sqlcmd so I used wrong binary

[shueybubbles]

does the same thing happen if you pipe a file with the script in a console, like

cat my.sql | sqlcmd

or

type my.sql | sqlcmd

[HoundThe]

No it doesn't

$ cat query.sql
SET NOCOUNT ON;
SELECT name FROM sys.databases;
go
exit

$ cat ~/query.sql | /opt/mssql-tools/bin/sqlcmd-go
master
model
msdb
rdsadmin
...

Works same for both sqlcmd-go and sqlcmd, only difference I can see is extra new line at the end for the sqlcmd-go

[HoundThe]

But If I pipe into a file (or less or whatever except leaving it in terminal), it shows up

$ cat query.sql | /opt/mssql-tools/bin/sqlcmd-go
master
model
msdb
rdsadmin
...

$ cat query.sql | /opt/mssql-tools/bin/sqlcmd-go > out.txt
$ cat out.txt
1> 2> 3> master
model
msdb
rdsadmin
...

1> $

This doesn't happen with legacy sqlcmd

The query.sql contents:

SET NOCOUNT ON;
SELECT name FROM sys.databases;
go
exit

[shueybubbles]

thx. Is this Linux-only? I don't see it in my local Windows build but I don't have Linux handy to test with.
It's possible the code that liner package uses to detect whether input is redirected is not correct on Linux.
https://github.com/peterh/liner/blob/master/unixmode.go#L24

FWIW I've tried 3 or 4 different console/input packages for this project and they've all had different quirks/bugs.

We might have to implement our own workaround for Linux.

[HoundThe]

Yes my situation is Linux only, I don't have a Windows machine to test it out

[HoundThe]

Oh actually I do have some machine with SQL Server, it doesn't happen there

[shueybubbles]

@HoundThe can you build the version from Copilot's fix branch and verify it? It worked for me on a WSL Ubuntu

[HoundThe]

I've tried it and it seems to work