FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

Perhaps dbsqlok needs to check tds->status? Although I don't quite know uf 
we are setting status with rpc calls, should be.

BTW, has anyone noticed doing 'select * from table1 where 0=1' in sqsh no 
longer returns the column headers? haven't had time to debug it, but 
noticed it on friday.  Any ctlib changes in this area? (friday cvs, sqsh 
2.1, ase 11.0.3 on linux)


On Mon, 25 Nov 2002, Thompson, Bill D (London) wrote:

> James,
> 
> I can reproduce your issue, e.g.
> 
> 2002-11-25 11:54:31.396639 dbsqlok() marker is 253
> 2002-11-25 11:54:31.397077 dbsqlok() found end token
> 2002-11-25 11:54:31.397541 inside tds_process_end() more_results = 0,
> was_cancelled = 0
> 2002-11-25 11:54:31.397970 dbsqlok() end status was success
> 2002-11-25 11:54:31.398428 calling dbresults
> 2002-11-25 11:54:31.398870 inside dbresults()
> 2002-11-25 11:54:31.399294 inside dbresults()
> 2002-11-25 11:54:31.399745 inside dbresults_r()
> 2002-11-25 11:54:31.400201 inside tds_process_result_tokens() state is
> COMPLETED
> 2002-11-25 11:54:31.400640 leaving dbresults() returning 2
> 2002-11-25 11:54:31.403943 in dbsqlok()
> 
> But what has happened prior to the second call to dbsqlok() ( last line of
> this log) is:
> 
> executing dbrpcinit
> Failed: dbrpcinit
> executing dbrpcparam
> Failed: dbrpcparam
> executing dbrpcsend
> Failed: dbrpcsend
> executing dbsqlok
> 
> So in my case at least,  we have called dbsqlok() after the rpc calls have
> failed. Presumably they have sent nothing to the server, so dbsqlok() is
> just waiting on a reply that's never going to come....
> 
> Bill
> 
> > -----Original Message-----
> > From:       James K. Lowden [SMTP:jklowden AT schemamania.org]
> > Sent:       24 November 2002 22:09
> > To: TDS Development Group
> > Subject:    [freetds] src/dblib/rpc.c and its unittest
> > 
> > Progress of a kind on the rpc front.  
> > 
> > I committed what I think ought to be a working version of the db-lib rpc
> > functions.  dbrpcsend() calls Frediano's new tds functions.  
> > 
> > The rpc unittest fails, however, in dbsqlok.  It's not clear why, and
> > there appears to be some end token magic in it that we might want to
> > reëxamine.  
> > 
> > Here's the tail of the log:
> > 
> > 2002-11-24 16:52:11.486975 dbsqlok() marker is 253
> > 2002-11-24 16:52:11.487001 dbsqlok() found end token
> > 2002-11-24 16:52:11.487025 inside tds_process_end() more_results = 0,
> > was_cancelled = 0 
> > 2002-11-24 16:52:11.487053 dbsqlok() end status was success
> > 2002-11-24 16:52:11.487078 inside dbresults()
> > 2002-11-24 16:52:11.487101 inside dbresults()
> > 2002-11-24 16:52:11.487123 inside dbresults_r()
> > 2002-11-24 16:52:11.487147 inside tds_process_result_tokens() state is
> > COMPLETED
> > 2002-11-24 16:52:11.487172 leaving dbresults() returning 2
> > 2002-11-24 16:52:11.487657 in dbsqlok() 
> > 
> > Suggestions welcome.  Repairs solicited.  Thanks for listening.  
> > 
> > --jkl
> > _______________________________________________
> > freetds mailing list
> > freetds AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>