Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I know that Sybase and MS SQL Server support affected row counts, so why does the FreeTDS connection return -1s for affected rows?

April 26, 2017affected connection counts FreeTDS MS Return row SQL Server support Sybase

0

Posted

I know that Sybase and MS SQL Server support affected row counts, so why does the FreeTDS connection return -1s for affected rows?

1 Answer

0

Posted

Before version 0.53, calling the FreeTDS function to get the number of affected rows would cause a segmentation fault. As of version 0.32, SQL Relay figures out what version of FreeTDS is installed at compile time and only enables affected rows if the FreeTDS version is greater than 0.52. If you compile against an earlier version of FreeTDS, a -1 is returned for affected rows as if the database didn’t support the feature.