mssql: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 4 ("@p2"): Data type 0xE7 has an invalid data length or metadata length.

[bbigras]

I have the following error when I do :

_, err = tx.Exec("insert into tbl (fld) values (nullif(?, ''))", "")

mssql: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 4 ("@p2"): Data type 0xE7 has an invalid data length or metadata length.

I have a testcase.

[dimdin]

Hello @BrunoQC bit is mapped to bool, the parameter must be false or true.
What do you expect to do with an empty string?

[bbigras]

I just fixed a typo in the commit.

I expect to insert a NULL when I have an empty string.

If my string is "0" or "1" it works as expected.

[dimdin]

A smaller test case is:

func TestEmptyStringParameter(t *testing.T) {
conn := open(t)
defer conn.Close()
rows, err := conn.Query("select ?", "")
if err != nil {
t.Fatal("Select with empty string failed")
}
rows.Close()
}

[bbigras]

Yes this test case seems better.

In case you didn't know, here's how to use syntax highlighting on Github:

import "log"

import "log"

[dimdin]

thank you