Re: Null values in result record are overwritten with previous non-null data when using a prepared query more than once

"Buurman, H.A. (Herbert)" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <2864EA5D33131F4FB33903DB89A0DD360139FE32@MAILSRV01.interlogica.nl> 
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of Frediano Ziglio
> Sent: Friday, 19 June, 2009 10:59
> To: FreeTDS Development Group
> Subject: Re: [freetds] Null values in result record
> areoverwrittenwithprevious non-null data when using a preparedquery
> morethan once
> 
> 

> Could you run your script enabling FreeTDS dumps and send the dump??
> Something like
> 
> TDSDUMP=freetds.log perl myscript.pl
> 
> and send freetds.log
> 

Here you go.

Kind regards,
H. Buurman

<html>
<body>
<pre style="font-size: 7.5pt; font-family: Arial; color: black; font-style: italic; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; margin-bottom: .0001pt">&nbsp;<pre style="font-size: 7.5pt; font-family: Arial; color: black; font-style: italic; margin-left: 0cm; margin-right: 0cm; margin-top: 0cm; margin-bottom: .0001pt"><span lang="nl"><font color="#C0C0C0" style="font-size: 7pt" face="Arial"><i><b><u>Disclaimer</u>

Deze e-mail is verzonden door Interlogica B.V. De inhoud en eventuele bijlagen zijn vertrouwelijk en uitsluitend bestemd voor de
geadresseerde. Interlogica B.V. verzoekt bij onjuiste adressering direct contact met haar op te nemen (<a href="mailto:[email protected]">mailto:[email protected]</a>),
de naam van de afzender en de geadresseerde aan haar op te geven en vervolgens dit e-mailbericht uit uw systeem te verwijderen.
Interlogica B.V. is niet aansprakelijk voor het overbrengen van virussen en het is uw verantwoordelijkheid deze e-mail (en eventuele
bijlagen) te controleren. Interlogica B.V. (geregistreerd bij het Handelsregister nr. 08067177) is gevestigd te Ecofactorij 20,
NL-7325 WC Apeldoorn.

This is an e-mail from Interlogica B.V. Its contents and any attachments are confidential and intended solely for the use of the
individual to whom it is addressed. If received in error, please contact Interlogica B.V. (<a href="mailto:[email protected]">mailto:[email protected]</a>)
quoting the name of the sender and the addressee, then delete it from your system. Please note that Interlogica B.V. does not accept any
responsibility for viruses and it is your responsibility to scan the email and any attachments (if any). Interlogica B.V. 
(registered with the Chamber of Commerce no. 08067177) is resident at Ecofactorij 20, NL-7325 WC Apeldoorn, The Netherlands.
</b></i>
</font>
<p>&nbsp;</p>
</body>
</html>

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.log (application/octet-stream, 40.8 KB) 
log.c:190:Starting log file for FreeTDS 0.82
	on 2009-06-18 08:56:10 with debug flags 0x4fff.
iconv.c:197:names for ISO-8859-1: ISO-8859-1
iconv.c:197:names for UTF-8: UTF-8
iconv.c:197:names for UCS-2LE: UCS-2LE
iconv.c:197:names for UCS-2BE: UCS-2BE
iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:210:Connecting to 172.16.1.11 port 1433 (TDS version 8.0)
net.c:264:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:303:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:592:Received header
0000 04 01 01 85 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 e3 21 00 01 09 64 00 62-00 6f 00 74 00 73 00 74 |.!...d.b .o.t.s.t|
0010 00 5f 00 30 00 32 00 06-6d 00 61 00 73 00 74 00 |._.0.2.. m.a.s.t.|
0020 65 00 72 00 ab 6c 00 45-16 00 00 02 00 28 00 43 |e.r..l.E .....(.C|
0030 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 64 |.h.a.n.g .e.d. .d|
0040 00 61 00 74 00 61 00 62-00 61 00 73 00 65 00 20 |.a.t.a.b .a.s.e. |
0050 00 63 00 6f 00 6e 00 74-00 65 00 78 00 74 00 20 |.c.o.n.t .e.x.t. |
0060 00 74 00 6f 00 20 00 27-00 64 00 62 00 6f 00 74 |.t.o. .' .d.b.o.t|
0070 00 73 00 74 00 5f 00 30-00 32 00 27 00 2e 00 08 |.s.t._.0 .2.'....|
0080 44 00 42 00 4f 00 53 00-52 00 56 00 30 00 31 00 |D.B.O.S. R.V.0.1.|
0090 00 01 00 e3 08 00 07 05-09 04 d0 00 2a 00 e3 17 |........ ....*...|
00a0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00b0 00 69 00 73 00 68 00 00-ab 6a 00 47 16 00 00 01 |.i.s.h.. .j.G....|
00c0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
00d0 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
00e0 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
00f0 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0100 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0110 00 08 44 00 42 00 4f 00-53 00 52 00 56 00 30 00 |..D.B.O. S.R.V.0.|
0120 31 00 00 01 00 ad 36 00-01 71 00 00 01 16 4d 00 |1.....6. .q....M.|
0130 69 00 63 00 72 00 6f 00-73 00 6f 00 66 00 74 00 |i.c.r.o. s.o.f.t.|
0140 20 00 53 00 51 00 4c 00-20 00 53 00 65 00 72 00 | .S.Q.L.  .S.e.r.|
0150 76 00 65 00 72 00 00 00-00 00 09 00 07 ff e3 13 |v.e.r... ........|
0160 00 04 04 34 00 30 00 39-00 36 00 04 34 00 30 00 |...4.0.9 .6..4.0.|
0170 39 00 36 00 fd 00 00 00-00 00 00 00 00          |9.6..... .....|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
odbc.c:2032:msgno 5701 20003
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP850"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP850"
token.c:2292:tds->collation now
0000 09 04 d0 00 2a         -                        |....*|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
odbc.c:2032:msgno 5703 20003
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  ad(LOGINACK)
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got  fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232:                rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
odbc.c:4672:SQLGetFunctions: fFunction is 999
odbc.c:5587:SQLGetInfo(0xe768f0, 77, 0x7fff17d29510, 20, (nil))
odbc.c:4841:_SQLGetInfo(0xe768f0, 77, 0x7fff17d29510, 20, (nil)
odbc.c:5587:SQLGetInfo(0xe768f0, 10000, 0x7fff17d29510, 5, (nil))
odbc.c:4841:_SQLGetInfo(0xe768f0, 10000, 0x7fff17d29510, 5, (nil)
odbc.c:5909:SQLSetConnectAttr(0xe768f0, 102, 0x1, 0)
odbc.c:5827:_SQLSetConnectAttr(0xe768f0, 102, 0x1, 0)
odbc.c:213:change_autocommit: executing SET IMPLICIT_TRANSACTIONS OFF
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 29 bytes of "SET IMPLICIT_TRANSACTIONS OFF"
write.c:164:tds_put_string wrote 58 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 42 00 00 01 00-53 00 45 00 54 00 20 00 |...B.... S.E.T. .|
0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.|
0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.|
0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 46 00 |T.I.O.N. S. .O.F.|
0040 46 00                  -                        |F.|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a50c, 0x7fff17d2a508, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 ba 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a50c, 0x7fff17d2a508, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:5587:SQLGetInfo(0xe768f0, 77, 0xe3f698, 20, 0x7fff17d2a7de)
odbc.c:4841:_SQLGetInfo(0xe768f0, 77, 0xe3f698, 20, 0x7fff17d2a7de
odbc.c:5587:SQLGetInfo(0xe768f0, 6, 0xe3f73c, 80, 0x7fff17d2a7de)
odbc.c:4841:_SQLGetInfo(0xe768f0, 6, 0xe3f73c, 80, 0x7fff17d2a7de
odbc.c:5587:SQLGetInfo(0xe768f0, 7, 0xe3f78c, 20, 0x7fff17d2a7de)
odbc.c:4841:_SQLGetInfo(0xe768f0, 7, 0xe3f78c, 20, 0x7fff17d2a7de
odbc.c:5587:SQLGetInfo(0xe768f0, 30, 0xe3f6ac, 2, 0x7fff17d2a7de)
odbc.c:4841:_SQLGetInfo(0xe768f0, 30, 0xe3f6ac, 2, 0x7fff17d2a7de
odbc.c:5587:SQLGetInfo(0xe768f0, 17, 0xe3f6ae, 64, 0x7fff17d2a7de)
odbc.c:4841:_SQLGetInfo(0xe768f0, 17, 0xe3f6ae, 64, 0x7fff17d2a7de
odbc.c:5918:SQLSetConnectOption(0xe768f0, 102, 0)
odbc.c:5827:_SQLSetConnectAttr(0xe768f0, 102, (nil), -3)
odbc.c:213:change_autocommit: executing SET IMPLICIT_TRANSACTIONS ON
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 28 bytes of "SET IMPLICIT_TRANSACTIONS ON"
write.c:164:tds_put_string wrote 56 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 40 00 00 01 00-53 00 45 00 54 00 20 00 |...@.... S.E.T. .|
0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.|
0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.|
0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 4e 00 |T.I.O.N. S. .O.N.|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a98c, 0x7fff17d2a988, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 11 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 fd 00 00 b9 00 00 00 00-00                      |........ .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a98c, 0x7fff17d2a988, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:1504:SQLAllocStmt(0xe768f0, 0xea8ea0)
odbc.c:1403:_SQLAllocStmt(0xe768f0, 0xea8ea0)
odbc.c:4079:SQLGetStmtAttr(0xea9100, 10010, 0x7fff17d2ab18, 8, (nil))
odbc.c:3917:_SQLGetStmtAttr(0xea9100, 10010, 0x7fff17d2ab18, 8, (nil))
odbc.c:4079:SQLGetStmtAttr(0xea9100, 10011, 0x7fff17d2ab18, 8, (nil))
odbc.c:3917:_SQLGetStmtAttr(0xea9100, 10011, 0x7fff17d2ab18, 8, (nil))
odbc.c:4079:SQLGetStmtAttr(0xea9100, 10012, 0x7fff17d2ab18, 8, (nil))
odbc.c:3917:_SQLGetStmtAttr(0xea9100, 10012, 0x7fff17d2ab18, 8, (nil))
odbc.c:4079:SQLGetStmtAttr(0xea9100, 10013, 0x7fff17d2ab18, 8, (nil))
odbc.c:3917:_SQLGetStmtAttr(0xea9100, 10013, 0x7fff17d2ab18, 8, (nil))
odbc.c:4124:SQLPrepare(0xea9100, SELECT Identifier, Value FROM freetds_test with(nolock) WHERE Identifier = ?, 76)
odbc.c:4188:Creating prepared statement
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 3 bytes of "@P1"
write.c:164:tds_put_string wrote 6 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 f6 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 1e 00-00 00 09 04 d0 00 2a 1e |&....c.. ......*.|
0020 00 00 00 40 00 50 00 31-00 20 00 76 00 61 00 72 |[email protected] . .v.a.r|
0030 00 63 00 68 00 61 00 72-00 28 00 38 00 30 00 29 |.c.h.a.r .(.8.0.)|
0040 00 00 00 63 9c 00 00 00-09 04 d0 00 2a 9c 00 00 |...c.... ....*...|
0050 00 53 00 45 00 4c 00 45-00 43 00 54 00 20 00 49 |.S.E.L.E .C.T. .I|
0060 00 64 00 65 00 6e 00 74-00 69 00 66 00 69 00 65 |.d.e.n.t .i.f.i.e|
0070 00 72 00 2c 00 20 00 56-00 61 00 6c 00 75 00 65 |.r.,. .V .a.l.u.e|
0080 00 20 00 46 00 52 00 4f-00 4d 00 20 00 66 00 72 |. .F.R.O .M. .f.r|
0090 00 65 00 65 00 74 00 64-00 73 00 5f 00 74 00 65 |.e.e.t.d .s._.t.e|
00a0 00 73 00 74 00 20 00 77-00 69 00 74 00 68 00 28 |.s.t. .w .i.t.h.(|
00b0 00 6e 00 6f 00 6c 00 6f-00 63 00 6b 00 29 00 20 |.n.o.l.o .c.k.). |
00c0 00 57 00 48 00 45 00 52-00 45 00 20 00 49 00 64 |.W.H.E.R .E. .I.d|
00d0 00 65 00 6e 00 74 00 69-00 66 00 69 00 65 00 72 |.e.n.t.i .f.i.e.r|
00e0 00 20 00 3d 00 20 00 40-00 50 00 31 00 00 00 26 |. .=. .@ .P.1...&|
00f0 04 04 01 00 00 00      -                        |......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2aa84, 0x7fff17d2aa80, 0x104)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 64 01 fa 01 00-                        |...d....|

net.c:671:Received packet
0000 81 02 00 00 00 08 00 af-01 00 09 04 d0 00 2a 0a |........ ......*.|
0010 49 00 64 00 65 00 6e 00-74 00 69 00 66 00 69 00 |I.d.e.n. t.i.f.i.|
0020 65 00 72 00 00 00 09 00-26 04 05 56 00 61 00 6c |e.r..... &..V.a.l|
0030 00 75 00 65 00 ff 11 00-c1 00 00 00 00 00 79 00 |.u.e.... ......y.|
0040 00 00 00 ac 0d 00 00 01-00 00 00 00 26 04 04 01 |........ ....&...|
0050 00 00 00 fe 00 00 e0 00-00 00 00 00             |........ ....|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
	Server charset: CP850
	Server column_size: 1
	Client charset: ISO-8859-1
	Client column_size: 1
token.c:1490:tds7_get_data_info: 
	colname = Identifier (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 1 (1 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info: 
	colname = Value (5 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2aa84, 0x7fff17d2aa80, 0x104)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2232:                rows_affected = 0
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0xe74580, 0x7fff17d2a9f8)
token.c:1596:processing result. type = 38(integer-null), varint_size 1
token.c:1617:processing result. column_size 4
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4 
token.c:573:1 hidden return parameters
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2aa84, 0x7fff17d2aa80, 0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3848:SQLFreeStmt(0xea9100, 3)
odbc.c:3769:_SQLFreeStmt(0xea9100, 3, 0)
odbc.c:1224:SQLBindParameter(0xea9100, 1, 1, 1, 12, 80, 0, 0xeabe50, 1, 0xeaac60)
odbc.c:1125:_SQLBindParameter(0xea9100, 1, 1, 1, 12, 80, 0, 0xeabe50, 1, 0xeaac60)
odbc.c:3237:SQLExecute(0xea9100)
sql2tds.c:150:type=12
sql2tds.c:156:trace
odbc.c:2965:_SQLExecute(0xea9100)
odbc.c:2970:_SQLExecute() starting with state 0
query.c:1768:tds_submit_unprepare() myshc06000
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 01 00 00 00   -                        |&......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab5c, 0x7fff17d2ab58, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 16 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 79 00 00 00 00 fe 00 00-e0 00 00 00 00 00       |y....... ......|

token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab5c, 0x7fff17d2ab58, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3058:Creating prepared statement
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 3 bytes of "@P1"
write.c:164:tds_put_string wrote 6 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 f6 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 1e 00-00 00 09 04 d0 00 2a 1e |&....c.. ......*.|
0020 00 00 00 40 00 50 00 31-00 20 00 56 00 41 00 52 |[email protected] . .V.A.R|
0030 00 43 00 48 00 41 00 52-00 28 00 38 00 30 00 29 |.C.H.A.R .(.8.0.)|
0040 00 00 00 63 9c 00 00 00-09 04 d0 00 2a 9c 00 00 |...c.... ....*...|
0050 00 53 00 45 00 4c 00 45-00 43 00 54 00 20 00 49 |.S.E.L.E .C.T. .I|
0060 00 64 00 65 00 6e 00 74-00 69 00 66 00 69 00 65 |.d.e.n.t .i.f.i.e|
0070 00 72 00 2c 00 20 00 56-00 61 00 6c 00 75 00 65 |.r.,. .V .a.l.u.e|
0080 00 20 00 46 00 52 00 4f-00 4d 00 20 00 66 00 72 |. .F.R.O .M. .f.r|
0090 00 65 00 65 00 74 00 64-00 73 00 5f 00 74 00 65 |.e.e.t.d .s._.t.e|
00a0 00 73 00 74 00 20 00 77-00 69 00 74 00 68 00 28 |.s.t. .w .i.t.h.(|
00b0 00 6e 00 6f 00 6c 00 6f-00 63 00 6b 00 29 00 20 |.n.o.l.o .c.k.). |
00c0 00 57 00 48 00 45 00 52-00 45 00 20 00 49 00 64 |.W.H.E.R .E. .I.d|
00d0 00 65 00 6e 00 74 00 69-00 66 00 69 00 65 00 72 |.e.n.t.i .f.i.e.r|
00e0 00 20 00 3d 00 20 00 40-00 50 00 31 00 00 00 26 |. .=. .@ .P.1...&|
00f0 04 04 01 00 00 00      -                        |......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab7c, 0x7fff17d2ab78, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 64 01 fa 01 00-                        |...d....|

net.c:671:Received packet
0000 81 02 00 00 00 08 00 af-01 00 09 04 d0 00 2a 0a |........ ......*.|
0010 49 00 64 00 65 00 6e 00-74 00 69 00 66 00 69 00 |I.d.e.n. t.i.f.i.|
0020 65 00 72 00 00 00 09 00-26 04 05 56 00 61 00 6c |e.r..... &..V.a.l|
0030 00 75 00 65 00 ff 11 00-c1 00 00 00 00 00 79 00 |.u.e.... ......y.|
0040 00 00 00 ac 0d 00 00 01-00 00 00 00 26 04 04 02 |........ ....&...|
0050 00 00 00 fe 00 00 e0 00-00 00 00 00             |........ ....|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
	Server charset: CP850
	Server column_size: 1
	Client charset: ISO-8859-1
	Client column_size: 1
token.c:1490:tds7_get_data_info: 
	colname = Identifier (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 1 (1 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info: 
	colname = Value (5 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2232:                rows_affected = 0
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0xe74580, 0x7fff17d2aaf8)
token.c:1596:processing result. type = 38(integer-null), varint_size 1
token.c:1617:processing result. column_size 4
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4 
token.c:573:1 hidden return parameters
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab7c, 0x7fff17d2ab78, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3078:End prepare, execute
query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
query.c:1326:tds_put_data_info putting status 
query.c:1420:tds_put_data: colsize = 1
query.c:1449:tds_put_data: not null param varint_size = 2
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 36 00 00 01 00-0a 00 73 00 70 00 5f 00 |...6.... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 26 04 04 02 00 00-00 00 00 a7 50 00 09 04 |..&..... ....P...|
0030 d0 00 2a 01 00 31      -                        |..*..1|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab74, 0x7fff17d2ab70, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 5d 01 fa 01 00-                        |...]....|

net.c:671:Received packet
0000 81 02 00 00 00 08 00 af-01 00 09 04 d0 00 2a 0a |........ ......*.|
0010 49 00 64 00 65 00 6e 00-74 00 69 00 66 00 69 00 |I.d.e.n. t.i.f.i.|
0020 65 00 72 00 00 00 09 00-26 04 05 56 00 61 00 6c |e.r..... &..V.a.l|
0030 00 75 00 65 00 d1 01 00-31 04 11 00 00 00 ff 11 |.u.e.... 1.......|
0040 00 c1 00 01 00 00 00 79-00 00 00 00 fe 00 00 e0 |.......y ........|
0050 00 00 00 00 00         -                        |.....|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
	Server charset: CP850
	Server column_size: 1
	Client charset: ISO-8859-1
	Client column_size: 1
token.c:1490:tds7_get_data_info: 
	colname = Identifier (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 1 (1 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info: 
	colname = Value (5 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4049
odbc.c:3119:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab74, 0x7fff17d2ab70, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4040
odbc.c:3119:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:4256:_SQLRowCount(0xea9100, 0xea8638)
odbc.c:4275:SQLRowCount returns 0, row count -1
odbc.c:4100:SQLNumResultCols(0xea9100, 0x7fff17d2ad40)
odbc.c:4100:SQLNumResultCols(0xea9100, 0x7fff17d2ace6)
odbc.c:1702:SQLDescribeCol(0xea9100, 1, 0xeac310, 128, 0xeabd20, 0xeabd32, 0xeabd28, 0xeabd30, 0xeabd34)
odbc.c:1974:SQLColAttributes(0xea9100, 1, 6, (nil), 0, (nil), 0xeabd40)
odbc.c:1766:_SQLColAttribute(0xea9100, 1, 6, (nil), 0, (nil), 0xeabd40)
odbc.c:1807:odbc:SQLColAttribute: fDescType is 6
odbc.c:1974:SQLColAttributes(0xea9100, 1, 3, (nil), 0, (nil), 0xeabd38)
odbc.c:1766:_SQLColAttribute(0xea9100, 1, 3, (nil), 0, (nil), 0xeabd38)
odbc.c:1807:odbc:SQLColAttribute: fDescType is 3
odbc.c:1702:SQLDescribeCol(0xea9100, 2, 0xeac31b, 128, 0xeabd90, 0xeabda2, 0xeabd98, 0xeabda0, 0xeabda4)
odbc.c:1974:SQLColAttributes(0xea9100, 2, 6, (nil), 0, (nil), 0xeabdb0)
odbc.c:1766:_SQLColAttribute(0xea9100, 2, 6, (nil), 0, (nil), 0xeabdb0)
odbc.c:1807:odbc:SQLColAttribute: fDescType is 6
odbc.c:1974:SQLColAttributes(0xea9100, 2, 3, (nil), 0, (nil), 0xeabda8)
odbc.c:1766:_SQLColAttribute(0xea9100, 2, 3, (nil), 0, (nil), 0xeabda8)
odbc.c:1807:odbc:SQLColAttribute: fDescType is 3
odbc.c:1519:SQLBindCol(0xea9100, 1, 1, 0xe5a3c0, 2, 0xeabd58)
odbc.c:1519:SQLBindCol(0xea9100, 2, 1, 0xe5a3c4, 12, 0xeabdc8)
odbc.c:3653:SQLFetch(0xea9100)
odbc.c:3396:_SQLFetch(0xea9100, 1, 0)
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a674, 0x7fff17d2a670, 0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:2166:tds_process_row(): reading column 0 
token.c:1915:tds_get_data: type 47, varint size 2
token.c:1975:tds_get_data(): wire column size is 1 
token.c:2166:tds_process_row(): reading column 1 
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4 
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:62:convert_tds2sql: src is 47 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen = 2 
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen = 12 
odbc.c:3848:SQLFreeStmt(0xea9100, 0)
odbc.c:3769:_SQLFreeStmt(0xea9100, 0, 0)
query.c:1934:tds_send_cancel: not in_cancel and not idle
query.c:1943:tds_send_cancel: sending cancel packet
net.c:779:Sending packet
0000 06 01 00 08 00 00 01 00-                        |........|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab84, (nil), 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2232:                rows_affected = 1
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2232:                rows_affected = 0
net.c:592:Received header
0000 04 01 00 11 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 fd 20 00 fd 00 00 00 00-00                      |. ...... .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 1
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
odbc.c:3848:SQLFreeStmt(0xea9100, 3)
odbc.c:3769:_SQLFreeStmt(0xea9100, 3, 0)
odbc.c:1224:SQLBindParameter(0xea9100, 1, 1, 1, 12, 80, 0, 0xeabe50, 1, 0xeaac60)
odbc.c:1125:_SQLBindParameter(0xea9100, 1, 1, 1, 12, 80, 0, 0xeabe50, 1, 0xeaac60)
odbc.c:3237:SQLExecute(0xea9100)
sql2tds.c:150:type=12
sql2tds.c:156:trace
odbc.c:2965:_SQLExecute(0xea9100)
odbc.c:2970:_SQLExecute() starting with state 0
query.c:1768:tds_submit_unprepare() myshc09000
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 02 00 00 00   -                        |&......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab5c, 0x7fff17d2ab58, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 16 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 79 00 00 00 00 fe 00 00-e0 00 00 00 00 00       |y....... ......|

token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab5c, 0x7fff17d2ab58, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3058:Creating prepared statement
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 3 bytes of "@P1"
write.c:164:tds_put_string wrote 6 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 f6 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 1e 00-00 00 09 04 d0 00 2a 1e |&....c.. ......*.|
0020 00 00 00 40 00 50 00 31-00 20 00 56 00 41 00 52 |[email protected] . .V.A.R|
0030 00 43 00 48 00 41 00 52-00 28 00 38 00 30 00 29 |.C.H.A.R .(.8.0.)|
0040 00 00 00 63 9c 00 00 00-09 04 d0 00 2a 9c 00 00 |...c.... ....*...|
0050 00 53 00 45 00 4c 00 45-00 43 00 54 00 20 00 49 |.S.E.L.E .C.T. .I|
0060 00 64 00 65 00 6e 00 74-00 69 00 66 00 69 00 65 |.d.e.n.t .i.f.i.e|
0070 00 72 00 2c 00 20 00 56-00 61 00 6c 00 75 00 65 |.r.,. .V .a.l.u.e|
0080 00 20 00 46 00 52 00 4f-00 4d 00 20 00 66 00 72 |. .F.R.O .M. .f.r|
0090 00 65 00 65 00 74 00 64-00 73 00 5f 00 74 00 65 |.e.e.t.d .s._.t.e|
00a0 00 73 00 74 00 20 00 77-00 69 00 74 00 68 00 28 |.s.t. .w .i.t.h.(|
00b0 00 6e 00 6f 00 6c 00 6f-00 63 00 6b 00 29 00 20 |.n.o.l.o .c.k.). |
00c0 00 57 00 48 00 45 00 52-00 45 00 20 00 49 00 64 |.W.H.E.R .E. .I.d|
00d0 00 65 00 6e 00 74 00 69-00 66 00 69 00 65 00 72 |.e.n.t.i .f.i.e.r|
00e0 00 20 00 3d 00 20 00 40-00 50 00 31 00 00 00 26 |. .=. .@ .P.1...&|
00f0 04 04 01 00 00 00      -                        |......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab7c, 0x7fff17d2ab78, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 64 01 fa 01 00-                        |...d....|

net.c:671:Received packet
0000 81 02 00 00 00 08 00 af-01 00 09 04 d0 00 2a 0a |........ ......*.|
0010 49 00 64 00 65 00 6e 00-74 00 69 00 66 00 69 00 |I.d.e.n. t.i.f.i.|
0020 65 00 72 00 00 00 09 00-26 04 05 56 00 61 00 6c |e.r..... &..V.a.l|
0030 00 75 00 65 00 ff 11 00-c1 00 00 00 00 00 79 00 |.u.e.... ......y.|
0040 00 00 00 ac 0d 00 00 01-00 00 00 00 26 04 04 03 |........ ....&...|
0050 00 00 00 fe 00 00 e0 00-00 00 00 00             |........ ....|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
	Server charset: CP850
	Server column_size: 1
	Client charset: ISO-8859-1
	Client column_size: 1
token.c:1490:tds7_get_data_info: 
	colname = Identifier (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 1 (1 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info: 
	colname = Value (5 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2232:                rows_affected = 0
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0xe74580, 0x7fff17d2aaf8)
token.c:1596:processing result. type = 38(integer-null), varint_size 1
token.c:1617:processing result. column_size 4
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4 
token.c:573:1 hidden return parameters
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab7c, 0x7fff17d2ab78, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3078:End prepare, execute
query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
query.c:1326:tds_put_data_info putting status 
query.c:1420:tds_put_data: colsize = 1
query.c:1449:tds_put_data: not null param varint_size = 2
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 36 00 00 01 00-0a 00 73 00 70 00 5f 00 |...6.... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 26 04 04 03 00 00-00 00 00 a7 50 00 09 04 |..&..... ....P...|
0030 d0 00 2a 01 00 32      -                        |..*..2|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab74, 0x7fff17d2ab70, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 59 01 fa 01 00-                        |...Y....|

net.c:671:Received packet
0000 81 02 00 00 00 08 00 af-01 00 09 04 d0 00 2a 0a |........ ......*.|
0010 49 00 64 00 65 00 6e 00-74 00 69 00 66 00 69 00 |I.d.e.n. t.i.f.i.|
0020 65 00 72 00 00 00 09 00-26 04 05 56 00 61 00 6c |e.r..... &..V.a.l|
0030 00 75 00 65 00 d1 01 00-32 00 ff 11 00 c1 00 01 |.u.e.... 2.......|
0040 00 00 00 79 00 00 00 00-fe 00 00 e0 00 00 00 00 |...y.... ........|
0050 00                     -                        |.|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (2 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:3294:adjust_character_column_size:
	Server charset: CP850
	Server column_size: 1
	Client charset: ISO-8859-1
	Client column_size: 1
token.c:1490:tds7_get_data_info: 
	colname = Identifier (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 1 (1 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info: 
	colname = Value (5 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4049
odbc.c:3119:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ab74, 0x7fff17d2ab70, 0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4040
odbc.c:3119:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:4256:_SQLRowCount(0xea9100, 0xea8638)
odbc.c:4275:SQLRowCount returns 0, row count -1
odbc.c:4100:SQLNumResultCols(0xea9100, 0x7fff17d2ad40)
odbc.c:3653:SQLFetch(0xea9100)
odbc.c:3396:_SQLFetch(0xea9100, 1, 0)
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2a674, 0x7fff17d2a670, 0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:2166:tds_process_row(): reading column 0 
token.c:1915:tds_get_data: type 47, varint size 2
token.c:1975:tds_get_data(): wire column size is 1 
token.c:2166:tds_process_row(): reading column 1 
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is -1 
util.c:162:Changed query state from READING to PENDING
odbc.c:3269:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3270:    result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3340:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:62:convert_tds2sql: src is 47 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen = 2 
odbc.c:3848:SQLFreeStmt(0xea9100, 0)
odbc.c:3769:_SQLFreeStmt(0xea9100, 0, 0)
query.c:1934:tds_send_cancel: not in_cancel and not idle
query.c:1943:tds_send_cancel: sending cancel packet
net.c:779:Sending packet
0000 06 01 00 08 00 00 01 00-                        |........|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ad14, (nil), 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2232:                rows_affected = 1
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2232:                rows_affected = 0
net.c:592:Received header
0000 04 01 00 11 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 fd 20 00 fd 00 00 00 00-00                      |. ...... .|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 1
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
odbc.c:4549:SQLGetConnectOption(0xe768f0, 102, 0x7fff17d2ae64)
odbc.c:4464:_SQLGetConnectAttr(0xe768f0, 102, 0x7fff17d2ae64, 256, (nil))
odbc.c:4375:SQLTransact((nil), 0xe768f0, 1)
odbc.c:4366:_SQLTransact((nil), 0xe768f0, 1)
odbc.c:4327:change_transaction(0x0xe768f0,0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 27 bytes of "IF @@TRANCOUNT > 0 ROLLBACK"
write.c:164:tds_put_string wrote 54 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 01 01 00 3e 00 00 01 00-49 00 46 00 20 00 40 00 |...>.... I.F. .@.|
0010 40 00 54 00 52 00 41 00-4e 00 43 00 4f 00 55 00 |@.T.R.A. N.C.O.U.|
0020 4e 00 54 00 20 00 3e 00-20 00 30 00 20 00 52 00 |N.T. .>.  .0. .R.|
0030 4f 00 4c 00 4c 00 42 00-41 00 43 00 4b 00       |O.L.L.B. A.C.K.|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ac8c, 0x7fff17d2ac88, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 1a 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 fd 01 00 c0 00 00 00 00-00 fd 00 00 d2 00 00 00 |........ ........|
0010 00 00                  -                        |..|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2232:                rows_affected = 0
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ac8c, 0x7fff17d2ac88, 0x100)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ac8c, 0x7fff17d2ac88, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:5587:SQLGetInfo(0xe768f0, 24, 0x7fff17d2ad0e, 2, 0x7fff17d2ad0c)
odbc.c:4841:_SQLGetInfo(0xe768f0, 24, 0x7fff17d2ad0e, 2, 0x7fff17d2ad0c
odbc.c:2005:SQLDisconnect(0xe768f0)
odbc.c:3769:_SQLFreeStmt(0xea9100, 1, 1)
query.c:1768:tds_submit_unprepare() myshc0c000
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:779:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 03 00 00 00   -                        |&......|

token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ac7c, 0x7fff17d2ac78, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:592:Received header
0000 04 01 00 16 01 fa 01 00-                        |........|

net.c:671:Received packet
0000 79 00 00 00 00 fe 00 00-e0 00 00 00 00 00       |y....... ......|

token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0xe74580, 0x7fff17d2ac7c, 0x7fff17d2ac78, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3680:SQLFreeHandle(2, 0x0xe768f0)
odbc.c:3706:_SQLFreeConnect(0xe768f0)
odbc.c:3680:SQLFreeHandle(1, 0x0xe72fa0)
odbc.c:3744:_SQLFreeEnv(0xe72fa0)
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.