Running query against SQL Server with FreeTDS's bsqldb returns blank output
1
vote
1
answer
1552
views
Here is the query I ran
select CAST(PageGuid as varchar(max)) + ',' + CAST(TenantGuid as varchar(max)) + '/' + CAST(OriginalFileGuid as varchar(max))
from Pages
This worked with tsql but when run with bsqldb I get empty lines instead of results.
I confirmed that bsqldb works by running other simple queries. So why is this one not working?
Here is the verbose output
bsqldb:163: Verbose operation enabled
bsqldb:212: Query:
select CAST(PageGuid as varchar(max)) + ',' + CAST(TenantGuid as varchar(max)) + '/' + CAST(OriginalFileGuid as varchar(max)) from Pages
bsqldb:186: dbsqlsend(): OK
bsqldb:194: dbsqlok(): OK
bsqldb:289: calling dbresults: OK
Result set 1
Freeing prior allocations
Allocating buffers
Allocating compute buffers
Metadata
col name source type size varies
------ ------------------------------ ------------------------------ --------------- ------ ------
1 text 64512 1
Data
Retrieving return status... none
11084 rows affected
Retrieving output parameters... none
bsqldb:615: dbresults() returned NO_MORE_RESULTS (2):
bsqldb:212: Query:
I'm using FreeTDS 0.64RC1, FreeBSD 8, and SQL Server 2008
Asked by David
(203 rep)
Aug 26, 2011, 10:51 AM
Last activity: Dec 5, 2012, 09:45 PM
Last activity: Dec 5, 2012, 09:45 PM