FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Brian,

I'll check what the Sybase dblibrary dbsqlok() does when it is called in
this way (i.e. nothing has been sent to check the status of...)
If it hangs like ours, then I suggest we leave as is. Otherwise, we
obviously need to check some sort of state flag or other....

WRT the sqsh behaviour. Well I changed ct_results() a while back such that
it only returned "result" data to the calling program if the CS_EXPOSE_FMT
config option was set. sounds like there may be something in that area. I'll
take a look....

Bill

> -----Original Message-----
> From: Brian Bruns [SMTP:camber AT ais.org]
> Sent: 25 November 2002 13:59
> To:   'freetds AT lists.ibiblio.org'
> Subject:      RE: [freetds] src/dblib/rpc.c and its unittest
> 
> 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
> > 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds