Re: Problem retrieveing results from a query with an IMAGE field

"Daniel A. Veiga" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <50078.201.253.227.42.1212602750.squirrel@www.advtechnology.com.ar>
This is the TDSDUMP log generated for the same program I sent the
unixODBC log file for. I hope it helps ...

                              Daniel

> Daniel A. Veiga wrote:
>>    I can reproduce the problem systematically:
>>      - If no row has any data in the IMAGE field -> no problem
>>      - When a field has something in the blob column I get an error
>> when trying to close the cursor (Linux Driver Manager log follows)
>>
>> [ODBC][32484][SQLFreeStmt.c][140]
>>                 Entry:
>>                         Statement = 0x750380
>>                         Option = 0
>> [ODBC][32484][SQLFreeStmt.c][246]
>>                 Exit:[SQL_ERROR]
>
> Please post a TDSDUMP log of the session.
>
>>        If I try to call SQLGetDiagRec to get extended information,
>> the
>> result is SQL_NO_DATA (strange, should report something if the
>> previous function returned SQL_ERROR or SQL_SUCCESS_WITH_INFO)
>
> There are places in the ODBC code where diagnostic messages should be
> produced but aren't.  You may have found one.
>
> HTH.
>
> --jkl
>

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.log (application/octet-stream, 50.9 KB)
log.c:190:Starting log file for FreeTDS 0.83.dev.20080523
	on 2008-06-04 14:56:37 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:204:Connecting to 172.16.5.100 port 1433 (TDS version 8.0)
net.c:258:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:296:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:738:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:663:Received packet
0000 04 01 01 91 00 36 01 00-e3 21 00 01 09 44 00 42 |.....6.. .!...D.B|
0010 00 43 00 4f 00 4e 00 54-00 52 00 4f 00 4c 00 06 |.C.O.N.T .R.O.L..|
0020 6d 00 61 00 73 00 74 00-65 00 72 00 ab 7e 00 45 |m.a.s.t. e.r..~.E|
0030 16 00 00 02 00 34 00 43-00 61 00 6d 00 62 00 69 |.....4.C .a.m.b.i|
0040 00 61 00 64 00 6f 00 20-00 65 00 6c 00 20 00 63 |.a.d.o.  .e.l. .c|
0050 00 6f 00 6e 00 74 00 65-00 78 00 74 00 6f 00 20 |.o.n.t.e .x.t.o. |
0060 00 64 00 65 00 20 00 62-00 61 00 73 00 65 00 20 |.d.e. .b .a.s.e. |
0070 00 64 00 65 00 20 00 64-00 61 00 74 00 6f 00 73 |.d.e. .d .a.t.o.s|
0080 00 20 00 61 00 20 00 27-00 44 00 42 00 43 00 4f |. .a. .' .D.B.C.O|
0090 00 4e 00 54 00 52 00 4f-00 4c 00 27 00 2e 00 05 |.N.T.R.O .L.'....|
00a0 41 00 42 00 45 00 4a 00-41 00 00 00 00 e3 08 00 |A.B.E.J. A.......|
00b0 07 05 0a 0c d0 00 00 00-e3 17 00 02 0a 75 00 73 |........ .....u.s|
00c0 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
00d0 00 00 ab 64 00 47 16 00-00 01 00 27 00 43 00 68 |...d.G.. ...'.C.h|
00e0 00 61 00 6e 00 67 00 65-00 64 00 20 00 6c 00 61 |.a.n.g.e .d. .l.a|
00f0 00 6e 00 67 00 75 00 61-00 67 00 65 00 20 00 73 |.n.g.u.a .g.e. .s|
0100 00 65 00 74 00 74 00 69-00 6e 00 67 00 20 00 74 |.e.t.t.i .n.g. .t|
0110 00 6f 00 20 00 75 00 73-00 5f 00 65 00 6e 00 67 |.o. .u.s ._.e.n.g|
0120 00 6c 00 69 00 73 00 68-00 2e 00 05 41 00 42 00 |.l.i.s.h ....A.B.|
0130 45 00 4a 00 41 00 00 00-00 ad 36 00 01 71 00 00 |E.J.A... ..6..q..|
0140 01 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.|
0150 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.|
0160 65 00 72 00 76 00 65 00-72 00 00 00 00 00 08 00 |e.r.v.e. r.......|
0170 02 f8 e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.......4 .0.9.6..|
0180 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ........|
0190 00                     -                        |.|

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:2495:tds_process_msg() reading message from server
token.c:2560:tds_process_msg() calling client msg handler
odbc.c:2083:msgno 5701 20003
token.c:2573: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:2325:tds_process_env_chg(): 5 bytes of collation data received
token.c:2326:tds->collation was
0000 00 00 00 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2336:tds->collation now
0000 0a 0c d0 00 00         -                        |.....|

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:2495:tds_process_msg() reading message from server
token.c:2560:tds_process_msg() calling client msg handler
odbc.c:2083:msgno 5703 20003
token.c:2573: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:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
token.c:2276:                rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
odbc.c:4737:SQLGetFunctions: fFunction is 1
odbc.c:4737:SQLGetFunctions: fFunction is 2
odbc.c:4737:SQLGetFunctions: fFunction is 1001
odbc.c:4737:SQLGetFunctions: fFunction is 3
odbc.c:4737:SQLGetFunctions: fFunction is 4
odbc.c:4737:SQLGetFunctions: fFunction is 1002
odbc.c:4737:SQLGetFunctions: fFunction is 72
odbc.c:4737:SQLGetFunctions: fFunction is 5
odbc.c:4737:SQLGetFunctions: fFunction is 1003
odbc.c:4737:SQLGetFunctions: fFunction is 6
odbc.c:4737:SQLGetFunctions: fFunction is 6
odbc.c:4737:SQLGetFunctions: fFunction is 56
odbc.c:4737:SQLGetFunctions: fFunction is 40
odbc.c:4737:SQLGetFunctions: fFunction is 7
odbc.c:4737:SQLGetFunctions: fFunction is 1004
odbc.c:4737:SQLGetFunctions: fFunction is 8
odbc.c:4737:SQLGetFunctions: fFunction is 9
odbc.c:4737:SQLGetFunctions: fFunction is 41
odbc.c:4737:SQLGetFunctions: fFunction is 1005
odbc.c:4737:SQLGetFunctions: fFunction is 10
odbc.c:4737:SQLGetFunctions: fFunction is 11
odbc.c:4737:SQLGetFunctions: fFunction is 12
odbc.c:4737:SQLGetFunctions: fFunction is 59
odbc.c:4737:SQLGetFunctions: fFunction is 13
odbc.c:4737:SQLGetFunctions: fFunction is 1021
odbc.c:4737:SQLGetFunctions: fFunction is 60
odbc.c:4737:SQLGetFunctions: fFunction is 15
odbc.c:4737:SQLGetFunctions: fFunction is 1006
odbc.c:4737:SQLGetFunctions: fFunction is 16
odbc.c:4737:SQLGetFunctions: fFunction is 14
odbc.c:4737:SQLGetFunctions: fFunction is 1007
odbc.c:4737:SQLGetFunctions: fFunction is 42
odbc.c:4737:SQLGetFunctions: fFunction is 17
odbc.c:4737:SQLGetFunctions: fFunction is 43
odbc.c:4737:SQLGetFunctions: fFunction is 1008
odbc.c:4737:SQLGetFunctions: fFunction is 1009
odbc.c:4737:SQLGetFunctions: fFunction is 1010
odbc.c:4737:SQLGetFunctions: fFunction is 1012
odbc.c:4737:SQLGetFunctions: fFunction is 44
odbc.c:4737:SQLGetFunctions: fFunction is 45
odbc.c:4737:SQLGetFunctions: fFunction is 1014
odbc.c:4737:SQLGetFunctions: fFunction is 46
odbc.c:4737:SQLGetFunctions: fFunction is 47
odbc.c:4737:SQLGetFunctions: fFunction is 61
odbc.c:4737:SQLGetFunctions: fFunction is 62
odbc.c:4737:SQLGetFunctions: fFunction is 63
odbc.c:4737:SQLGetFunctions: fFunction is 18
odbc.c:4737:SQLGetFunctions: fFunction is 48
odbc.c:4737:SQLGetFunctions: fFunction is 64
odbc.c:4737:SQLGetFunctions: fFunction is 19
odbc.c:4737:SQLGetFunctions: fFunction is 65
odbc.c:4737:SQLGetFunctions: fFunction is 66
odbc.c:4737:SQLGetFunctions: fFunction is 67
odbc.c:4737:SQLGetFunctions: fFunction is 49
odbc.c:4737:SQLGetFunctions: fFunction is 20
odbc.c:4737:SQLGetFunctions: fFunction is 1016
odbc.c:4737:SQLGetFunctions: fFunction is 50
odbc.c:4737:SQLGetFunctions: fFunction is 21
odbc.c:4737:SQLGetFunctions: fFunction is 1017
odbc.c:4737:SQLGetFunctions: fFunction is 1018
odbc.c:4737:SQLGetFunctions: fFunction is 1019
odbc.c:4737:SQLGetFunctions: fFunction is 22
odbc.c:4737:SQLGetFunctions: fFunction is 68
odbc.c:4737:SQLGetFunctions: fFunction is 69
odbc.c:4737:SQLGetFunctions: fFunction is 1020
odbc.c:4737:SQLGetFunctions: fFunction is 51
odbc.c:4737:SQLGetFunctions: fFunction is 52
odbc.c:4737:SQLGetFunctions: fFunction is 53
odbc.c:4737:SQLGetFunctions: fFunction is 70
odbc.c:4737:SQLGetFunctions: fFunction is 54
odbc.c:4737:SQLGetFunctions: fFunction is 23
odbc.c:4737:SQLGetFunctions: fFunction is 1011
odbc.c:5652:SQLGetInfo(0x71d0c0, 77, 0x7fff9d7077c0, 20, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 77, 0x7fff9d7077c0, 20, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 10000, 0x7fff9d7077c0, 5, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 10000, 0x7fff9d7077c0, 5, (nil)
odbc.c:5977:SQLSetConnectAttr(0x71d0c0, 109, 0x6713c0, -3)
odbc.c:5892:_SQLSetConnectAttr(0x71d0c0, 109, 0x6713c0, -3)
odbc.c:255:change_database: executing USE DBCONTROL
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
write.c:136:tds_put_string converting 13 bytes of "USE DBCONTROL"
write.c:164:tds_put_string wrote 26 bytes
util.c:162:Changed query state from QUERYING to PENDING
net.c:769:Sending packet
0000 01 01 00 22 00 00 01 00-55 00 53 00 45 00 20 00 |...".... U.S.E. .|
0010 44 00 42 00 43 00 4f 00-4e 00 54 00 52 00 4f 00 |D.B.C.O. N.T.R.O.|
0020 4c 00                  -                        |L.|

token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d7087e4, 0x7fff9d7087e0, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 af 00 36 01 00-e3 27 00 01 09 44 00 42 |.....6.. .'...D.B|
0010 00 43 00 4f 00 4e 00 54-00 52 00 4f 00 4c 00 09 |.C.O.N.T .R.O.L..|
0020 44 00 42 00 43 00 4f 00-4e 00 54 00 52 00 4f 00 |D.B.C.O. N.T.R.O.|
0030 4c 00 ab 66 00 45 16 00-00 01 00 28 00 43 00 68 |L..f.E.. ...(.C.h|
0040 00 61 00 6e 00 67 00 65-00 64 00 20 00 64 00 61 |.a.n.g.e .d. .d.a|
0050 00 74 00 61 00 62 00 61-00 73 00 65 00 20 00 63 |.t.a.b.a .s.e. .c|
0060 00 6f 00 6e 00 74 00 65-00 78 00 74 00 20 00 74 |.o.n.t.e .x.t. .t|
0070 00 6f 00 20 00 27 00 44-00 42 00 43 00 4f 00 4e |.o. .'.D .B.C.O.N|
0080 00 54 00 52 00 4f 00 4c-00 27 00 2e 00 05 41 00 |.T.R.O.L .'....A.|
0090 42 00 45 00 4a 00 41 00-00 01 00 e3 08 00 07 05 |B.E.J.A. ........|
00a0 0a 0c d0 00 00 00 fd 00-00 e2 00 00 00 00 00    |........ .......|

token.c:510:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:510:processing result tokens.  marker is  ab(INFO)
token.c:108:tds_process_default_tokens() marker is ab(INFO)
token.c:2495:tds_process_msg() reading message from server
token.c:2560:tds_process_msg() calling client msg handler
odbc.c:2083:msgno 5701 20003
token.c:2573:tds_process_msg() returning TDS_SUCCEED
token.c:510:processing result tokens.  marker is  e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2325:tds_process_env_chg(): 5 bytes of collation data received
token.c:2326:tds->collation was
0000 0a 0c d0 00 00         -                        |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2336:tds->collation now
0000 0a 0c d0 00 00         -                        |.....|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2276:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d7087e4, 0x7fff9d7087e0, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
error.c:609:SQLGetDiagRec(2, 0x71d0c0, 1, 0x7fff9d708810, 0x7fff9d7083ec, 0x7fff9d708610, 512, 0x7fff9d7083e8)
error.c:512:_SQLGetDiagRec(2, 0x71d0c0, 1, 0x7fff9d708810, 0x7fff9d7083ec, 0x7fff9d708610, 512, 0x7fff9d7083e8)
error.c:609:SQLGetDiagRec(2, 0x71d0c0, 2, 0x7fff9d708810, 0x7fff9d7083ec, 0x7fff9d708610, 512, 0x7fff9d7083e8)
error.c:512:_SQLGetDiagRec(2, 0x71d0c0, 2, 0x7fff9d708810, 0x7fff9d7083ec, 0x7fff9d708610, 512, 0x7fff9d7083e8)
error.c:609:SQLGetDiagRec(2, 0x71d0c0, 1, 0x7fff9d7089e0, 0x7fff9d7089d8, 0x7fff9d7079d0, 4096, 0x7fff9d7089de)
error.c:512:_SQLGetDiagRec(2, 0x71d0c0, 1, 0x7fff9d7089e0, 0x7fff9d7089d8, 0x7fff9d7079d0, 4096, 0x7fff9d7089de)
odbc.c:5652:SQLGetInfo(0x71d0c0, 72, 0x70587c, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 72, 0x70587c, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 26, 0x705878, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 26, 0x705878, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 44, 0x7fff9d709374, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 44, 0x7fff9d709374, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 146, 0x705858, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 146, 0x705858, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 147, 0x705868, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 147, 0x705868, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 150, 0x70585c, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 150, 0x70585c, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 151, 0x70586c, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 151, 0x70586c, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 167, 0x705864, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 167, 0x705864, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 168, 0x705874, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 168, 0x705874, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 144, 0x705860, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 144, 0x705860, 4, (nil)
odbc.c:5652:SQLGetInfo(0x71d0c0, 145, 0x705870, 4, (nil))
odbc.c:4906:_SQLGetInfo(0x71d0c0, 145, 0x705870, 4, (nil)
odbc.c:1552:SQLAllocStmt(0x71d0c0, 0x765160)
odbc.c:1451:_SQLAllocStmt(0x71d0c0, 0x765160)
odbc.c:4141:SQLGetStmtAttr(0x71d4b0, 10010, 0x7fff9d70a268, 8, (nil))
odbc.c:3979:_SQLGetStmtAttr(0x71d4b0, 10010, 0x7fff9d70a268, 8, (nil))
odbc.c:4141:SQLGetStmtAttr(0x71d4b0, 10011, 0x7fff9d70a268, 8, (nil))
odbc.c:3979:_SQLGetStmtAttr(0x71d4b0, 10011, 0x7fff9d70a268, 8, (nil))
odbc.c:4141:SQLGetStmtAttr(0x71d4b0, 10012, 0x7fff9d70a268, 8, (nil))
odbc.c:3979:_SQLGetStmtAttr(0x71d4b0, 10012, 0x7fff9d70a268, 8, (nil))
odbc.c:4141:SQLGetStmtAttr(0x71d4b0, 10013, 0x7fff9d70a268, 8, (nil))
odbc.c:3979:_SQLGetStmtAttr(0x71d4b0, 10013, 0x7fff9d70a268, 8, (nil))
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 12, (nil), 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 12, (nil), 0)
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 7, 0x1, 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 7, 0x1, 0)
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 6, 0x3, 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 6, 0x3, 0)
odbc.c:4186:SQLPrepare(0x71d4b0, select * from _test order by id
, -3)
odbc.c:3295:SQLExecute(0x71d4b0)
odbc.c:3020:_SQLExecute(0x71d4b0)
odbc.c:3025:_SQLExecute() starting with state 0
query.c:2053:tds_cursor_declare() cursor id = 0
query.c:2103:tds_cursor_open() cursor id = 0
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
query.c:2231:tds_cursor_open (): RPC call set up 
query.c:2235:tds_cursor_open (): cursor open completed
net.c:769:Sending packet
0000 03 01 00 80 00 00 01 00-ff ff 02 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 42 00-00 00 0a 0c d0 00 00 42 |&....cB. .......B|
0020 00 00 00 73 00 65 00 6c-00 65 00 63 00 74 00 20 |...s.e.l .e.c.t. |
0030 00 2a 00 20 00 66 00 72-00 6f 00 6d 00 20 00 5f |.*. .f.r .o.m. ._|
0040 00 74 00 65 00 73 00 74-00 20 00 6f 00 72 00 64 |.t.e.s.t . .o.r.d|
0050 00 65 00 72 00 20 00 62-00 79 00 20 00 69 00 64 |.e.r. .b .y. .i.d|
0060 00 0d 00 0a 00 00 01 26-04 04 08 00 00 00 00 01 |.......& ........|
0070 26 04 04 01 20 00 00 00-01 26 04 04 00 00 00 00 |&... ... .&......|

util.c:162:Changed query state from QUERYING to PENDING
token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a1a4, 0x7fff9d70a1a0, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 f7 00 36 01 00-81 05 00 00 00 10 00 38 |.....6.. .......8|
0010 02 69 00 64 00 00 00 09-00 a7 10 00 0a 0c d0 00 |.i.d.... ........|
0020 00 05 76 00 61 00 6c 00-6f 00 72 00 00 00 09 00 |..v.a.l. o.r.....|
0030 22 ff ff ff 7f 05 00 5f-00 74 00 65 00 73 00 74 |"......_ .t.e.s.t|
0040 00 03 62 00 6c 00 6f 00-00 00 09 00 26 04 0b 49 |..b.l.o. ....&..I|
0050 00 44 00 5f 00 41 00 55-00 54 00 4f 00 49 00 4e |.D._.A.U .T.O.I.N|
0060 00 43 00 5f 00 00 00 00-00 38 07 72 00 6f 00 77 |.C._.... .8.r.o.w|
0070 00 73 00 74 00 61 00 74-00 a4 0d 00 01 05 00 5f |.s.t.a.t ......._|
0080 00 74 00 65 00 73 00 74-00 a5 0f 00 01 01 00 02 |.t.e.s.t ........|
0090 01 00 03 01 00 04 01 00-05 00 14 a9 02 00 01 00 |........ ........|
00a0 ff 01 00 c1 00 00 00 00-00 79 00 00 00 00 ac 0d |........ .y......|
00b0 00 00 01 38 00 00 00 26-04 04 f0 de bc 0a ac 0d |...8...& ........|
00c0 00 00 01 38 00 00 00 26-04 04 08 00 00 00 ac 0d |...8...& ........|
00d0 00 00 01 38 00 00 00 26-04 04 01 00 00 00 ac 0d |...8...& ........|
00e0 00 00 01 38 00 00 00 26-04 04 2d 00 00 00 fe 00 |...8...& ..-.....|
00f0 00 e0 00 00 00 00 00   -                        |.......|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1521:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1542:set current_results to cursor->res_info
token.c:1556:setting up column 0
token.c:1491:tds7_get_data_info: 
	colname = id (2 bytes)
	type = 56 (int)
	server's type = 56 (int)
	column_varint_size = 0
	column_size = 4 (4 on server)
token.c:1556:setting up column 1
token.c:3338:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 16
	Client charset: ISO-8859-1
	Client column_size: 16
token.c:1491:tds7_get_data_info: 
	colname = valor (5 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 16 (16 on server)
token.c:1556:setting up column 2
token.c:1491:tds7_get_data_info: 
	colname = blo (3 bytes)
	type = 34 (image)
	server's type = 34 (image)
	column_varint_size = 4
	column_size = 2147483647 (2147483647 on server)
token.c:1556:setting up column 3
token.c:1491:tds7_get_data_info: 
	colname = ID_AUTOINC_ (11 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:1556:setting up column 4
token.c:1491:tds7_get_data_info: 
	colname = rowstat (7 bytes)
	type = 56 (int)
	server's type = 56 (int)
	column_varint_size = 0
	column_size = 4 (4 on server)
token.c:510:processing result tokens.  marker is  a9(ORDERBY)
token.c:108:tds_process_default_tokens() marker is a9(ORDERBY)
token.c:223:Eating ORDERBY token
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2245:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2276:                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 2
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x71ae30, 0x7fff9d70a148)
token.c:1577:tds_get_data_info(0x71ae30, 0x768500, 1) [for parameter]token.c:1640:processing result. type = 38(integer-null), varint_size 1
token.c:1661:processing result. column_size 4
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
log.c:481:type integer-null has value 180150000
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x71ae30, 0x7fff9d70a148)
token.c:1577:tds_get_data_info(0x71ae30, 0x7689f0, 1) [for parameter]token.c:1640:processing result. type = 38(integer-null), varint_size 1
token.c:1661:processing result. column_size 4
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
log.c:481:type integer-null has value 8
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x71ae30, 0x7fff9d70a148)
token.c:1577:tds_get_data_info(0x71ae30, 0x768e90, 1) [for parameter]token.c:1640:processing result. type = 38(integer-null), varint_size 1
token.c:1661:processing result. column_size 4
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
log.c:481:type integer-null has value 1
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x71ae30, 0x7fff9d70a148)
token.c:1577:tds_get_data_info(0x71ae30, 0x769330, 1) [for parameter]token.c:1640:processing result. type = 38(integer-null), varint_size 1
token.c:1661:processing result. column_size 4
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
log.c:481:type integer-null has value 45
token.c:573:4 hidden return parameters
token.c:580:stored internal cursor id 180150000
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2276:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a1a4, 0x7fff9d70a1a0, 0x100)
token.c:498:tds_process_tokens() state is COMPLETED
query.c:2493:tds_cursor_setname() cursor id = 180150000
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:769:Sending packet
0000 03 01 00 39 00 00 01 00-ff ff 08 00 00 00 00 00 |...9.... ........|
0010 26 04 04 f0 de bc 0a 00-00 26 04 04 02 00 00 00 |&....... .&......|
0020 00 00 a7 0d 00 0a 0c d0-00 00 0d 00 53 51 4c 5f |........ ....SQL_|
0030 43 55 52 37 31 64 34 62-30                      |CUR71d4b 0|

token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a194, 0x7fff9d70a190, 0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 16 00 36 01 00-79 00 00 00 00 fe 00 00 |.....6.. y.......|
0010 e0 00 00 00 00 00      -                        |......|

token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2276:                rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
odbc.c:3327:odbc_process_tokens: tds_process_tokens returned 2
odbc.c:3328:    result_type=2, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3174:_SQLExecute: odbc_process_tokens returned result_type 4046
odbc.c:4141:SQLGetStmtAttr(0x71d4b0, 6, 0x768e1c, 4, (nil))
odbc.c:3979:_SQLGetStmtAttr(0x71d4b0, 6, 0x768e1c, 4, (nil))
odbc.c:4162:SQLNumResultCols(0x71d4b0, 0x7fff9d70a32a)
odbc.c:1750:SQLDescribeCol(0x71d4b0, 1, 0x768e60, 128, 0x7fff9d70a32a, 0x768ee0, 0x768f64, 0x768f68, 0x7fff9d70a328)
odbc.c:2042:SQLColAttribute(0x71d4b0, 1, 14, 0x768ee2, 128, 0x7fff9d70a32a, (nil))
odbc.c:1814:_SQLColAttribute(0x71d4b0, 1, 14, 0x768ee2, 128, 0x7fff9d70a32a, (nil))
odbc.c:1855:odbc:SQLColAttribute: fDescType is 14
odbc.c:2042:SQLColAttribute(0x71d4b0, 1, 11, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1814:_SQLColAttribute(0x71d4b0, 1, 11, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1855:odbc:SQLColAttribute: fDescType is 11
odbc.c:1750:SQLDescribeCol(0x71d4b0, 2, 0x768f78, 128, 0x7fff9d70a32a, 0x768ff8, 0x76907c, 0x769080, 0x7fff9d70a328)
odbc.c:2042:SQLColAttribute(0x71d4b0, 2, 14, 0x768ffa, 128, 0x7fff9d70a32a, (nil))
odbc.c:1814:_SQLColAttribute(0x71d4b0, 2, 14, 0x768ffa, 128, 0x7fff9d70a32a, (nil))
odbc.c:1855:odbc:SQLColAttribute: fDescType is 14
odbc.c:2042:SQLColAttribute(0x71d4b0, 2, 1013, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1814:_SQLColAttribute(0x71d4b0, 2, 1013, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1855:odbc:SQLColAttribute: fDescType is 1013
odbc.c:1750:SQLDescribeCol(0x71d4b0, 3, 0x769090, 128, 0x7fff9d70a32a, 0x769110, 0x769194, 0x769198, 0x7fff9d70a328)
odbc.c:2042:SQLColAttribute(0x71d4b0, 3, 14, 0x769112, 128, 0x7fff9d70a32a, (nil))
odbc.c:1814:_SQLColAttribute(0x71d4b0, 3, 14, 0x769112, 128, 0x7fff9d70a32a, (nil))
odbc.c:1855:odbc:SQLColAttribute: fDescType is 14
odbc.c:1750:SQLDescribeCol(0x71d4b0, 4, 0x7691a8, 128, 0x7fff9d70a32a, 0x769228, 0x7692ac, 0x7692b0, 0x7fff9d70a328)
odbc.c:2042:SQLColAttribute(0x71d4b0, 4, 14, 0x76922a, 128, 0x7fff9d70a32a, (nil))
odbc.c:1814:_SQLColAttribute(0x71d4b0, 4, 14, 0x76922a, 128, 0x7fff9d70a32a, (nil))
odbc.c:1855:odbc:SQLColAttribute: fDescType is 14
odbc.c:2042:SQLColAttribute(0x71d4b0, 4, 11, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1814:_SQLColAttribute(0x71d4b0, 4, 11, (nil), 0, (nil), 0x7fff9d70a2c8)
odbc.c:1855:odbc:SQLColAttribute: fDescType is 11
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 5, 0x31, 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 5, 0x31, 0)
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 27, 0x14, 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 27, 0x14, 0)
odbc.c:6276:SQLSetStmtAttr(0x71d4b0, 25, 0x7696a4, 0)
odbc.c:6000:_SQLSetStmtAttr(0x71d4b0, 25, 0x7696a4, 0)
odbc.c:1567:SQLBindCol(0x71d4b0, 1, 4, 0x7692d0, 4, 0x7692d4)
odbc.c:1567:SQLBindCol(0x71d4b0, 2, 1, 0x7692d8, 17, 0x7692e9)
odbc.c:1567:SQLBindCol(0x71d4b0, 4, 4, 0x7692f9, 4, 0x7692fd)
odbc.c:3726:SQLFetchScroll(0x71d4b0, 2, 0)
odbc.c:3458:_SQLFetch(0x71d4b0, 2, 0)
query.c:2247:tds_cursor_setrows() cursor id = 180150000
query.c:2349:tds_cursor_fetch() cursor id = 180150000
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:769:Sending packet
0000 03 01 00 2e 00 00 01 00-ff ff 07 00 02 00 00 00 |........ ........|
0010 26 04 04 f0 de bc 0a 00-00 26 04 04 01 00 00 00 |&....... .&......|
0020 00 00 26 04 00 00 00 26-04 04 14 00 00 00       |..&....& ......|

token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a064, 0x7fff9d70a060, 0x6d00)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 02 20 00 36 01 00-81 ff ff d1 01 00 00 00 |... .6.. ........|
0010 06 00 70 72 75 65 62 61-10 fe ff c3 0b 00 00 00 |..prueba ........|
0020 00 40 01 00 00 01 00 00-00 64 75 6d 6d 79 54 53 |.@...... .dummyTS|
0030 00 16 00 00 00 48 6f 6c-61 20 31 2c 20 32 2c 20 |.....Hol a 1, 2, |
0040 33 20 70 72 6f 62 61 6e-64 6f 2e 04 00 00 00 00 |3 proban do......|
0050 01 00 00 00 d1 02 00 00-00 06 00 70 72 75 65 62 |........ ...prueb|
0060 61 00 04 00 00 00 00 01-00 00 00 d1 03 00 00 00 |a....... ........|
0070 06 00 70 72 75 65 62 61-00 04 00 00 00 00 01 00 |..prueba ........|
0080 00 00 d1 04 00 00 00 06-00 70 72 75 65 62 61 00 |........ .prueba.|
0090 04 00 00 00 00 01 00 00-00 d1 05 00 00 00 06 00 |........ ........|
00a0 70 72 75 65 62 61 00 04-00 00 00 00 01 00 00 00 |prueba.. ........|
00b0 d1 06 00 00 00 06 00 70-72 75 65 62 61 00 04 00 |.......p rueba...|
00c0 00 00 00 01 00 00 00 d1-07 00 00 00 06 00 70 72 |........ ......pr|
00d0 75 65 62 61 00 04 00 00-00 00 01 00 00 00 d1 08 |ueba.... ........|
00e0 00 00 00 06 00 70 72 75-65 62 61 00 04 00 00 00 |.....pru eba.....|
00f0 00 01 00 00 00 d1 09 00-00 00 06 00 70 72 75 65 |........ ....prue|
0100 62 61 00 04 00 00 00 00-01 00 00 00 d1 0a 00 00 |ba...... ........|
0110 00 06 00 70 72 75 65 62-61 00 04 00 00 00 00 01 |...prueb a.......|
0120 00 00 00 d1 0b 00 00 00-06 00 70 72 75 65 62 61 |........ ..prueba|
0130 00 04 00 00 00 00 01 00-00 00 d1 0c 00 00 00 06 |........ ........|
0140 00 70 72 75 65 62 61 00-04 00 00 00 00 01 00 00 |.prueba. ........|
0150 00 d1 0d 00 00 00 06 00-70 72 75 65 62 61 00 04 |........ prueba..|
0160 00 00 00 00 01 00 00 00-d1 0e 00 00 00 06 00 70 |........ .......p|
0170 72 75 65 62 61 00 04 00-00 00 00 01 00 00 00 d1 |rueba... ........|
0180 0f 00 00 00 06 00 70 72-75 65 62 61 00 04 00 00 |......pr ueba....|
0190 00 00 01 00 00 00 d1 10-00 00 00 06 00 70 72 75 |........ .....pru|
01a0 65 62 61 00 04 00 00 00-00 01 00 00 00 d1 11 00 |eba..... ........|
01b0 00 00 06 00 70 72 75 65-62 61 00 04 00 00 00 00 |....prue ba......|
01c0 01 00 00 00 d1 12 00 00-00 06 00 70 72 75 65 62 |........ ...prueb|
01d0 61 00 04 00 00 00 00 01-00 00 00 d1 13 00 00 00 |a....... ........|
01e0 06 00 70 72 75 65 62 61-00 04 00 00 00 00 01 00 |..prueba ........|
01f0 00 00 d1 14 00 00 00 06-00 70 72 75 65 62 61 00 |........ .prueba.|
0200 04 00 00 00 00 01 00 00-00 ff 11 00 e0 00 14 00 |........ ........|
0210 00 00 79 00 00 00 00 fe-00 00 e0 00 14 00 00 00 |..y..... ........|

token.c:510:processing result tokens.  marker is  81(TDS7_RESULT)
token.c:1521:processing TDS7 result metadata.
token.c:1530:no meta data
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3327:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3328:    result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3398:odbc_process_tokens: returning result_type 4040
token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a064, 0x7fff9d70a060, 0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is 22 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
util.c:162:Changed query state from READING to PENDING
odbc.c:3327:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3328:    result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3398:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 4
convert_tds2sql.c:62:convert_tds2sql: src is 39 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen = 17 
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 4
token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a140, (nil), 0x2282a)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3726:SQLFetchScroll(0x71d4b0, 6, 20)
odbc.c:3458:_SQLFetch(0x71d4b0, 6, 20)
query.c:2349:tds_cursor_fetch() cursor id = 180150000
util.c:142:logic error: cannot change query state from PENDING to QUERYING
util.c:334:tdserror(0x71c4c0, 0x71ae30, 20019, 0)
odbc.c:2083:msgno 20019 20003
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
util.c:162:Changed query state from PENDING to QUERYING
error.c:609:SQLGetDiagRec(3, 0x71d4b0, 1, 0x7fff9d709d80, 0x7fff9d70995c, 0x7fff9d709b80, 512, 0x7fff9d709958)
error.c:512:_SQLGetDiagRec(3, 0x71d4b0, 1, 0x7fff9d709d80, 0x7fff9d70995c, 0x7fff9d709b80, 512, 0x7fff9d709958)
error.c:609:SQLGetDiagRec(3, 0x71d4b0, 2, 0x7fff9d709d80, 0x7fff9d70995c, 0x7fff9d709b80, 512, 0x7fff9d709958)
error.c:512:_SQLGetDiagRec(3, 0x71d4b0, 2, 0x7fff9d709d80, 0x7fff9d70995c, 0x7fff9d709b80, 512, 0x7fff9d709958)
error.c:609:SQLGetDiagRec(3, 0x71d4b0, 1, 0x7fff9d709f00, 0x7fff9d709ef8, 0x7fff9d708ef0, 4096, 0x7fff9d709efe)
error.c:512:_SQLGetDiagRec(3, 0x71d4b0, 1, 0x7fff9d709f00, 0x7fff9d709ef8, 0x7fff9d708ef0, 4096, 0x7fff9d709efe)
odbc.c:3910:SQLFreeStmt(0x71d4b0, 2)
odbc.c:3831:_SQLFreeStmt(0x71d4b0, 2, 0)
odbc.c:3910:SQLFreeStmt(0x71d4b0, 3)
odbc.c:3831:_SQLFreeStmt(0x71d4b0, 3, 0)
odbc.c:3742:SQLFreeHandle(3, 0x0x71d4b0)
odbc.c:3831:_SQLFreeStmt(0x71d4b0, 1, 0)
query.c:1934:tds_send_cancel: not in_cancel and not idle
query.c:1943:tds_send_cancel: sending cancel packet
net.c:769:Sending packet
0000 06 01 00 08 00 00 01 00-                        |........|

token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a144, (nil), 0x0)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  d1(ROW)
token.c:612:tds_process_tokens(). set current_results to cursor->res_info
token.c:2210:tds_process_row(): reading column 0 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 1 
token.c:1959:tds_get_data: type 39, varint size 2
token.c:2019:tds_get_data(): wire column size is 6 
token.c:2210:tds_process_row(): reading column 2 
token.c:1959:tds_get_data: type 34, varint size 4
token.c:2019:tds_get_data(): wire column size is -1 
token.c:2210:tds_process_row(): reading column 3 
token.c:1959:tds_get_data: type 38, varint size 1
token.c:2019:tds_get_data(): wire column size is 4 
token.c:2210:tds_process_row(): reading column 4 
token.c:1959:tds_get_data: type 56, varint size 0
token.c:2019:tds_get_data(): wire column size is 4 
token.c:510:processing result tokens.  marker is  ff(DONEINPROC)
token.c:2245:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 1
token.c:2276:                rows_affected = 20
token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2276:                rows_affected = 20
net.c:663:Received packet
0000 04 01 00 11 00 36 01 00-fd 20 00 fd 00 00 00 00 |.....6.. . ......|
0010 00                     -                        |.|

token.c:510:processing result tokens.  marker is  fd(DONE)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 1
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2276:                rows_affected = 0
query.c:2429:tds_cursor_close() cursor id = 180150000
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:769:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 09 00 02 00 00 00 |........ ........|
0010 26 04 04 f0 de bc 0a   -                        |&......|

token.c:495:tds_process_tokens(0x71ae30, 0x7fff9d70a134, 0x7fff9d70a130, 0x100)
util.c:162:Changed query state from PENDING to READING
net.c:663:Received packet
0000 04 01 00 16 00 36 01 00-79 00 00 00 00 fe 00 00 |.....6.. y.......|
0010 e0 00 14 00 00 00      -                        |......|

token.c:510:processing result tokens.  marker is  79(RETURNSTATUS)
token.c:510:processing result tokens.  marker is  fe(DONEPROC)
token.c:2245:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2261:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2276:                rows_affected = 20
token.c:708:TDS_SP_CURSORCLOSE
util.c:110:logic error: cannot change query state from IDLE to PENDING
mem.c:835:tds_cursor_deallocated() : freeing cursor_id 180150000
mem.c:860:tds_cursor_deallocated() : cursor_id 180150000 found
mem.c:864:tds_cursor_deallocated() : relinking list
mem.c:871:tds_cursor_deallocated() : relinked list
mem.c:887:tds_release_cursor() : freeing cursor_id 180150000
mem.c:889:tds_release_cursor() : freeing cursor results
mem.c:895:tds_release_cursor() : freeing cursor name
mem.c:900:tds_release_cursor() : freeing cursor query
mem.c:904:tds_release_cursor() : cursor_id 180150000 freed
odbc.c:2056:SQLDisconnect(0x71d0c0)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3796:SQLFreeConnect(0x71d0c0)
odbc.c:3768:_SQLFreeConnect(0x71d0c0)
odbc.c:3819:SQLFreeEnv(0x71cf70)
odbc.c:3806:_SQLFreeEnv(0x71cf70)
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.