set textsize 1048576 fails

James Cameron cameron at stl.dec.com
Wed Oct 24 22:29:08 EDT 2001


Summary: a query of 'set textsize 1048576' fails on 0.52 but works on an
earlier version.

I've just tried some of my PHP code that uses FreeTDS on a different
system, with a slightly different version of FreeTDS.  SELECT queries
work fine, but if I use a 'set textsize' query, then sybase_query()
returns FALSE and no further queries on the connection succeed.

I've yet to try the current CVS copy.

Non-working system:
	FreeTDS 0.52-3 (Debian package freetds0)
	PHP 4.0.5-2 (Debian packages php4 and php4-sybase)

Working system:
	FreeTDS from CVS, 6th November 2000
	PHP 4.0.5 (CGI version, installed by hand)

TDSDUMP of failed query, less login.

2001-10-25 11:24:45 inside tds_process_login_tokens()
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is ab
2001-10-25 11:24:48 Msg 5701, Level 0, State 2, Server EVTSQL, Line 0
Changed database context to 'CSMain'.
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is e3
2001-10-25 11:24:48 increasing block size from 4096 to 4096
2001-10-25 11:24:48 inside tds_process_default_tokens() marker is fd
2001-10-25 11:24:48 leaving tds_process_login_tokens() returning 1
2001-10-25 11:24:48 leaving ct_connect() returning 1
2001-10-25 11:24:48 inside ct_cmd_alloc()
2001-10-25 11:24:48 inside ct_command()
2001-10-25 11:24:48 inside ct_send()
Sending packet @ 2001-10-25 11:24:48
0000  01 01 00 1d 00 00 00 00 73 65 74 20 74 65 78 74   |........set
text|
0010  73 69 7a 65 20 31 30 34 38 35 37 36 0d            |size 1048576.|


2001-10-25 11:24:48 inside ct_results()
2001-10-25 11:24:49 processing result tokens.  marker is  fd
2001-10-25 11:24:49 inside ct_cancel()
Sending packet @ 2001-10-25 11:24:49
0000  06 01 00 08 00 00 00 00                           |........|


2001-10-25 11:24:50 inside ct_con_props() action = 25 property = 26
2001-10-25 11:24:50 inside ct_close()
2001-10-25 11:24:50 inside ct_con_drop()

-- 
James Cameron



More information about the FreeTDS mailing list