Re: XML type returns SQL_CHAR type
Sebastien FLAESCH <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Organization | Four Js Development Tools |
| Message-ID | <[email protected]> |
Back to the inital problem: For now with 0.95.5 I get invalid SQLDescribeCol
info when using the XML type:
sqltype = SQL_CHAR (1)
precision = 2147483647
With other ODBC drivers I get:
sqltype = SQL_SS_XML (-152)
precision = 0
Attached, the TDSDUMP.
You can see:
token.c:1537:tds7_get_data_info:
colname = t
type = 241 (xml)
server's type = 241 (xml)
column_varint_size = 8
column_size = 2147483647 (2147483647 on server)
Seb
On 06/20/2015 12:30 PM, Frediano Ziglio wrote:
> Il 19/Giu/2015 11:53, "Sebastien FLAESCH" <[email protected]> ha scritto:
>>
>> Seems that when using the XML type, SQLDescribeCol() returns SQL_CHAR, and
>> precision=2147483647 ... expected?
>>
>> BTW what are [N]VARCHAR(MAX) types supposed to return in SQLDescribeCol()?
>>
>> Seb
>>
>
> don't remember. Should be part of describecol test.
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
tdsdump.log
(text/x-log, 37.8 KB)
log.c:167:Starting log file for FreeTDS 0.95.5 on 2015-07-02 11:26:13 with debug flags 0x4fff. iconv.c:328:tds_iconv_open(0x22880a0, UTF-8) iconv.c:187:local name for ISO-8859-1 is ISO-8859-1 iconv.c:187:local name for UTF-8 is UTF-8 iconv.c:187:local name for UCS-2LE is UCS-2LE iconv.c:187:local name for UCS-2BE is UCS-2BE iconv.c:346:setting up conversions for client charset "UTF-8" iconv.c:348:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion iconv.c:395:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion iconv.c:400:tds_iconv_open: done net.c:202:Connecting to 10.0.40.27 port 1681 (TDS version 7.3) net.c:274:tds_open_socket: connect(2) returned "Operation now in progress" net.c:313:tds_open_socket() succeeded util.c:165:Changed query state from DEAD to IDLE packet.c:740:Sending packet 0000 12 01 00 3a 00 00 00 00-00 00 1a 00 06 01 00 20 |...:.... ....... | 0010 00 01 02 00 21 00 0c 03-00 2d 00 04 04 00 31 00 |....!... .-....1.| 0020 01 ff 09 00 00 00 00 00-02 4d 53 53 51 4c 53 65 |........ .MSSQLSe| 0030 72 76 65 72 00 a9 04 00-00 00 |rver.... ..| packet.c:639:Received packet 0000 04 01 00 2b 00 00 01 00-00 00 1a 00 06 01 00 20 |...+.... ....... | 0010 00 01 02 00 21 00 01 03-00 22 00 00 04 00 22 00 |....!... ."....".| 0020 01 ff 0c 00 07 d0 00 00-02 00 00 |........ ...| login.c:1106:detected flag 2 login.c:852:quietly sending TDS 7+ login packet token.c:326:tds_process_login_tokens() packet.c:639:Received packet 0000 04 01 01 a5 00 33 01 00-e3 1f 00 01 08 6d 00 73 |.....3.. .....m.s| 0010 00 76 00 74 00 65 00 73-00 74 00 31 00 06 6d 00 |.v.t.e.s .t.1..m.| 0020 61 00 73 00 74 00 65 00-72 00 ab 7a 00 45 16 00 |a.s.t.e. r..z.E..| 0030 00 02 00 27 00 43 00 68-00 61 00 6e 00 67 00 65 |...'.C.h .a.n.g.e| 0040 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a| 0050 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e| 0060 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 6d |.x.t. .t .o. .'.m| 0070 00 73 00 76 00 74 00 65-00 73 00 74 00 31 00 27 |.s.v.t.e .s.t.1.'| 0080 00 2e 00 0f 49 00 44 00-41 00 5c 00 53 00 51 00 |....I.D. A.\.S.Q.| 0090 4c 00 45 00 58 00 50 00-52 00 45 00 53 00 53 00 |L.E.X.P. R.E.S.S.| 00a0 32 00 00 01 00 00 00 e3-08 00 07 05 09 04 d0 00 |2....... ........| 00b0 34 00 e3 17 00 02 0a 75-00 73 00 5f 00 65 00 6e |4......u .s._.e.n| 00c0 00 67 00 6c 00 69 00 73-00 68 00 00 ab 7a 00 47 |.g.l.i.s .h...z.G| 00d0 16 00 00 01 00 27 00 43-00 68 00 61 00 6e 00 67 |.....'.C .h.a.n.g| 00e0 00 65 00 64 00 20 00 6c-00 61 00 6e 00 67 00 75 |.e.d. .l .a.n.g.u| 00f0 00 61 00 67 00 65 00 20-00 73 00 65 00 74 00 74 |.a.g.e. .s.e.t.t| 0100 00 69 00 6e 00 67 00 20-00 74 00 6f 00 20 00 75 |.i.n.g. .t.o. .u| 0110 00 73 00 5f 00 65 00 6e-00 67 00 6c 00 69 00 73 |.s._.e.n .g.l.i.s| 0120 00 68 00 2e 00 0f 49 00-44 00 41 00 5c 00 53 00 |.h....I. D.A.\.S.| 0130 51 00 4c 00 45 00 58 00-50 00 52 00 45 00 53 00 |Q.L.E.X. P.R.E.S.| 0140 53 00 32 00 00 01 00 00-00 ad 36 00 01 73 0b 00 |S.2..... ..6..s..| 0150 03 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.| 0160 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.| 0170 65 00 72 00 76 00 65 00-72 00 00 00 00 00 0c 00 |e.r.v.e. r.......| 0180 07 d0 e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.......4 .0.9.6..| 0190 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ........| 01a0 00 00 00 00 00 - |.....| token.c:335:looking for login token, got e3(ENVCHANGE) token.c:115:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:335:looking for login token, got ab(INFO) token.c:115:tds_process_default_tokens() marker is ab(INFO) token.c:2339:tds_process_msg() reading message 5701 from server token.c:2411:tds_process_msg() calling client msg handler odbc.c:2349:msgno 5701 20003 token.c:2424:tds_process_msg() returning TDS_SUCCESS token.c:335:looking for login token, got e3(ENVCHANGE) token.c:115:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2173:tds_process_env_chg(): 5 bytes of collation data received token.c:2174:tds->conn->collation was 0000 00 00 00 00 00 - |.....| iconv.c:796:setting server single-byte charset to "CP1252" token.c:2184:tds->conn->collation now 0000 09 04 d0 00 34 - |....4| token.c:335:looking for login token, got e3(ENVCHANGE) token.c:115:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:335:looking for login token, got ab(INFO) token.c:115:tds_process_default_tokens() marker is ab(INFO) token.c:2339:tds_process_msg() reading message 5703 from server token.c:2411:tds_process_msg() calling client msg handler odbc.c:2349:msgno 5703 20003 token.c:2424:tds_process_msg() returning TDS_SUCCESS token.c:335:looking for login token, got ad(LOGINACK) token.c:373:server reports TDS version 73.b.0.3 token.c:375:Product name for 0x730b0003 is 2008 token.c:407:Product version 8C0007D0 token.c:335:looking for login token, got e3(ENVCHANGE) token.c:115:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2230:changing block size from 4096 to 4096 token.c:335:looking for login token, got fd(DONE) token.c:115:tds_process_default_tokens() marker is fd(DONE) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE token.c:439:tds_process_login_tokens() returning TDS_SUCCESS odbc.c:1510:SQLAllocHandle(3, 0x22851f0, 0x7fff94411a10) odbc.c:1684:_SQLAllocStmt(0x22851f0, 0x7fff94411a10) odbc_export.h:263:SQLExecDirect(0x22bc890, SELECT @@VERSION, -3) prepare_query.c:198:parsing 0 parameters odbc.c:3289:_SQLExecute(0x22bc890) odbc.c:3306:_SQLExecute() starting with state 0 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 01 01 00 3e 00 00 01 00-16 00 00 00 12 00 00 00 |...>.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 53 00 |........ ......S.| 0020 45 00 4c 00 45 00 43 00-54 00 20 00 40 00 40 00 |E.L.E.C. T. .@.@.| 0030 56 00 45 00 52 00 53 00-49 00 4f 00 4e 00 |V.E.R.S. I.O.N.| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94411878, 0x7fff9441187c, 0x6914) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 01 9e 00 33 01 00-81 01 00 00 00 00 00 21 |.....3.. .......!| 0010 00 e7 58 02 09 04 d0 00-34 00 d1 74 01 4d 00 69 |..X..... 4..t.M.i| 0020 00 63 00 72 00 6f 00 73-00 6f 00 66 00 74 00 20 |.c.r.o.s .o.f.t. | 0030 00 53 00 51 00 4c 00 20-00 53 00 65 00 72 00 76 |.S.Q.L. .S.e.r.v| 0040 00 65 00 72 00 20 00 32-00 30 00 31 00 34 00 20 |.e.r. .2 .0.1.4. | 0050 00 2d 00 20 00 31 00 32-00 2e 00 30 00 2e 00 32 |.-. .1.2 ...0...2| 0060 00 30 00 30 00 30 00 2e-00 38 00 20 00 28 00 58 |.0.0.0.. .8. .(.X| 0070 00 36 00 34 00 29 00 20-00 0a 00 09 00 46 00 65 |.6.4.). .....F.e| 0080 00 62 00 20 00 32 00 30-00 20 00 32 00 30 00 31 |.b. .2.0 . .2.0.1| 0090 00 34 00 20 00 32 00 30-00 3a 00 30 00 34 00 3a |.4. .2.0 .:.0.4.:| 00a0 00 32 00 36 00 20 00 0a-00 09 00 43 00 6f 00 70 |.2.6. .. ...C.o.p| 00b0 00 79 00 72 00 69 00 67-00 68 00 74 00 20 00 28 |.y.r.i.g .h.t. .(| 00c0 00 63 00 29 00 20 00 4d-00 69 00 63 00 72 00 6f |.c.). .M .i.c.r.o| 00d0 00 73 00 6f 00 66 00 74-00 20 00 43 00 6f 00 72 |.s.o.f.t . .C.o.r| 00e0 00 70 00 6f 00 72 00 61-00 74 00 69 00 6f 00 6e |.p.o.r.a .t.i.o.n| 00f0 00 0a 00 09 00 45 00 78-00 70 00 72 00 65 00 73 |.....E.x .p.r.e.s| 0100 00 73 00 20 00 45 00 64-00 69 00 74 00 69 00 6f |.s. .E.d .i.t.i.o| 0110 00 6e 00 20 00 28 00 36-00 34 00 2d 00 62 00 69 |.n. .(.6 .4.-.b.i| 0120 00 74 00 29 00 20 00 6f-00 6e 00 20 00 57 00 69 |.t.). .o .n. .W.i| 0130 00 6e 00 64 00 6f 00 77-00 73 00 20 00 4e 00 54 |.n.d.o.w .s. .N.T| 0140 00 20 00 36 00 2e 00 31-00 20 00 3c 00 58 00 36 |. .6...1 . .<.X.6| 0150 00 34 00 3e 00 20 00 28-00 42 00 75 00 69 00 6c |.4.>. .( .B.u.i.l| 0160 00 64 00 20 00 37 00 36-00 30 00 31 00 3a 00 20 |.d. .7.6 .0.1.:. | 0170 00 53 00 65 00 72 00 76-00 69 00 63 00 65 00 20 |.S.e.r.v .i.c.e. | 0180 00 50 00 61 00 63 00 6b-00 20 00 31 00 29 00 0a |.P.a.c.k . .1.)..| 0190 00 fd 10 00 c1 00 01 00-00 00 00 00 00 00 |........ ......| token.c:564:processing result tokens. marker is 81(TDS7_RESULT) token.c:1568:processing TDS7 result metadata. mem.c:644:tds_free_all_results() token.c:1593:set current_results (1 column) to tds->res_info token.c:1600:setting up 1 columns token.c:1537:tds7_get_data_info: colname = type = 39 (varchar) server's type = 231 (x UCS-2 varchar) column_varint_size = 2 column_size = 600 (600 on server) token.c:1609: name size/wsize type/wtype utype token.c:1610: -------------------- --------------- --------------- ------- token.c:1615: 600/600 39/231 0 util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3709:odbc_process_tokens: returning result_type 4049 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4049 token.c:549:tds_process_tokens(0x22880a0, 0x7fff94411878, 0x7fff9441187c, 0x6914) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is d1(ROW) token.c:680:tds_process_tokens::SET_RETURN stopping on current token util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3709:odbc_process_tokens: returning result_type 4040 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4040 odbc.c:1803:SQLBindCol(0x22bc890, 1, 1, 0x7fff944119a0, 100, 0x7fff94411998) odbc.c:4039:SQLFetch(0x22bc890) odbc.c:3774:_SQLFetch(0x22bc890, 1, 0) token.c:549:tds_process_tokens(0x22880a0, 0x7fff94411838, 0x7fff9441183c, 0x6508) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is d1(ROW) token.c:1946:tds_process_row(): reading column 0 data.c:534:tds_get_data: type 39, varint size 2 data.c:587:tds_get_data(): wire column size is 372 util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3709:odbc_process_tokens: returning result_type 4040 convert_tds2sql.c:241:odbc_tds2sql: src is 231 dest = 1 odbc.c:4288:SQLCloseCursor(0x22bc890) odbc.c:4185:_SQLFreeStmt(0x22bc890, 0, 0) query.c:2186:tds_send_cancel: not in_cancel and not idle packet.c:770:Sending packet 0000 06 01 00 08 00 00 01 00- |........| token.c:549:tds_process_tokens(0x22880a0, 0x7fff9441190c, (nil), 0x0) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is fd(DONE) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2092: rows_affected = 1 packet.c:639:Received packet 0000 04 01 00 15 00 33 01 00-fd 20 00 fd 00 00 00 00 |.....3.. . ......| 0010 00 00 00 00 00 - |.....| token.c:564:processing result tokens. marker is fd(DONE) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 1 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:4084:SQLFreeHandle(3, 0x22bc890) odbc.c:4185:_SQLFreeStmt(0x22bc890, 1, 0) odbc.c:1510:SQLAllocHandle(3, 0x22851f0, 0x22bc980) odbc.c:1684:_SQLAllocStmt(0x22851f0, 0x22bc980) odbc_export.h:305:SQLSetCursorName(0x22cd120, scu1, -3) odbc_export.h:263:SQLExecDirect(0x22cd120, drop table t1, -3) prepare_query.c:198:parsing 0 parameters odbc.c:3289:_SQLExecute(0x22cd120) odbc.c:3306:_SQLExecute() starting with state 0 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 01 01 00 38 00 00 01 00-16 00 00 00 12 00 00 00 |...8.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 64 00 |........ ......d.| 0020 72 00 6f 00 70 00 20 00-74 00 61 00 62 00 6c 00 |r.o.p. . t.a.b.l.| 0030 65 00 20 00 74 00 31 00- |e. .t.1.| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a08, 0x7fff94412a0c, 0x6914) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 15 00 33 01 00-fd 00 00 c7 00 00 00 00 |.....3.. ........| 0010 00 00 00 00 00 - |.....| token.c:564:processing result tokens. marker is fd(DONE) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3682:odbc_process_tokens: processed TDS_DONE_RESULT token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a08, 0x7fff94412a0c, 0x26914) token.c:552:tds_process_tokens() state is COMPLETED odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4046 odbc.c:4631:_SQLRowCount(0x22cd120, 0x7fff94412ad0), -1 rows odbc.c:4642:SQLRowCount returns 0, row count -1 odbc.c:869:SQLMoreResults(0x22cd120) odbc.c:4084:SQLFreeHandle(3, 0x22cd120) odbc.c:4185:_SQLFreeStmt(0x22cd120, 1, 0) odbc.c:1510:SQLAllocHandle(3, 0x22851f0, 0x22bc980) odbc.c:1684:_SQLAllocStmt(0x22851f0, 0x22bc980) odbc_export.h:305:SQLSetCursorName(0x22bcbc0, scu1, -3) odbc_export.h:263:SQLExecDirect(0x22bcbc0, create table t1 ( k integer, t xml ), -3) prepare_query.c:198:parsing 0 parameters odbc.c:3289:_SQLExecute(0x22bcbc0) odbc.c:3306:_SQLExecute() starting with state 0 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 01 01 00 66 00 00 01 00-16 00 00 00 12 00 00 00 |...f.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 63 00 |........ ......c.| 0020 72 00 65 00 61 00 74 00-65 00 20 00 74 00 61 00 |r.e.a.t. e. .t.a.| 0030 62 00 6c 00 65 00 20 00-74 00 31 00 20 00 28 00 |b.l.e. . t.1. .(.| 0040 20 00 6b 00 20 00 69 00-6e 00 74 00 65 00 67 00 | .k. .i. n.t.e.g.| 0050 65 00 72 00 2c 00 20 00-74 00 20 00 78 00 6d 00 |e.r.,. . t. .x.m.| 0060 6c 00 20 00 29 00 - |l. .).| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a08, 0x7fff94412a0c, 0x6914) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 15 00 33 01 00-fd 00 00 c6 00 00 00 00 |.....3.. ........| 0010 00 00 00 00 00 - |.....| token.c:564:processing result tokens. marker is fd(DONE) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3682:odbc_process_tokens: processed TDS_DONE_RESULT token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a08, 0x7fff94412a0c, 0x26914) token.c:552:tds_process_tokens() state is COMPLETED odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4046 odbc.c:4631:_SQLRowCount(0x22bcbc0, 0x7fff94412ad0), -1 rows odbc.c:4642:SQLRowCount returns 0, row count -1 odbc.c:869:SQLMoreResults(0x22bcbc0) odbc.c:4084:SQLFreeHandle(3, 0x22bcbc0) odbc.c:4185:_SQLFreeStmt(0x22bcbc0, 1, 0) odbc.c:1510:SQLAllocHandle(3, 0x22851f0, 0x22bc980) odbc.c:1684:_SQLAllocStmt(0x22851f0, 0x22bc980) odbc_export.h:305:SQLSetCursorName(0x22cd460, scu1, -3) odbc_export.h:284:SQLPrepare(0x22cd460, insert into t1 VALUES (?,?), -3) odbc.c:1490:SQLBindParameter(0x22cd460, 1, 1, 4, 4, 0, 0, 0x2288020, 0, 0x22cd310) odbc.c:1391:_SQLBindParameter(0x22cd460, 1, 1, 4, 4, 0, 0, 0x2288020, 0, 0x22cd310) odbc.c:1490:SQLBindParameter(0x22cd460, 2, 1, 1, -10, 268435456, 0, 0x22ce338, 0, 0x22cd670) odbc.c:1391:_SQLBindParameter(0x22cd460, 2, 1, 1, -10, 268435456, 0, 0x22ce338, 0, 0x22cd670) odbc.c:3598:SQLExecute(0x22cd460) prepare_query.c:198:parsing 0 parameters sql2tds.c:174:type=4 sql2tds.c:182:trace sql2tds.c:174:type=-10 sql2tds.c:182:trace odbc.c:3612:SQLExecute returns SQL_NEED_DATA (start_parse_prepared_query failed) odbc.c:6150:SQLParamData(0x22cd460, 0x7fff94412af0) [param_num 2, param_data_called = 0] odbc.c:6194:SQLParamData returns SQL_NEED_DATA odbc.c:6205:SQLPutData(0x22cd460, 0x22cd3c0, 42) prepare_query.c:295:continue_parse_prepared_query with parameter 2 odbc.c:6213:SQLPutData returns SQL_SUCCESS, 268435414 bytes left odbc.c:6150:SQLParamData(0x22cd460, 0x7fff94412af0) [param_num 2, param_data_called = 1] prepare_query.c:198:parsing 2 parameters odbc.c:3289:_SQLExecute(0x22cd460) odbc.c:3306:_SQLExecute() starting with state 0 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING query.c:1633:tds_put_data_info putting status data.c:741:tds_generic_put: colsize = 4 data.c:813:tds_generic_put: not null param varint_size = 1 query.c:1633:tds_put_data_info putting status data.c:741:tds_generic_put: colsize = 42 data.c:813:tds_generic_put: not null param varint_size = 8 util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 03 01 01 30 00 00 01 00-16 00 00 00 12 00 00 00 |...0.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 0d 00 00 00 00 01 26 04-00 00 00 63 32 00 00 00 |......&. ...c2...| 0030 09 04 d0 00 34 32 00 00-00 40 00 50 00 31 00 20 |....42.. [email protected]. | 0040 00 49 00 4e 00 54 00 2c-00 40 00 50 00 32 00 20 |.I.N.T., [email protected]. | 0050 00 4e 00 56 00 41 00 52-00 43 00 48 00 41 00 52 |.N.V.A.R .C.H.A.R| 0060 00 28 00 4d 00 41 00 58-00 29 00 00 00 63 3e 00 |.(.M.A.X .)...c>.| 0070 00 00 09 04 d0 00 34 3e-00 00 00 69 00 6e 00 73 |......4> ...i.n.s| 0080 00 65 00 72 00 74 00 20-00 69 00 6e 00 74 00 6f |.e.r.t. .i.n.t.o| 0090 00 20 00 74 00 31 00 20-00 56 00 41 00 4c 00 55 |. .t.1. .V.A.L.U| 00a0 00 45 00 53 00 20 00 28-00 40 00 50 00 31 00 2c |.E.S. .( [email protected].,| 00b0 00 40 00 50 00 32 00 29-00 00 00 26 04 04 01 00 |[email protected].) ...&....| 00c0 00 00 00 00 e7 ff ff 09-04 d0 00 34 54 00 00 00 |........ ...4T...| 00d0 00 00 00 00 54 00 00 00-3c 00 62 00 6f 00 6f 00 |....T... <.b.o.o.| 00e0 6b 00 20 00 49 00 53 00-42 00 4e 00 3d 00 22 00 |k. .I.S. B.N.=.".| 00f0 31 00 32 00 33 00 22 00-3e 00 3c 00 74 00 69 00 |1.2.3.". >.<.t.i.| 0100 74 00 6c 00 65 00 3e 00-41 00 42 00 43 00 3c 00 |t.l.e.>. A.B.C.<.| 0110 2f 00 74 00 69 00 74 00-6c 00 65 00 3e 00 3c 00 |/.t.i.t. l.e.>.<.| 0120 2f 00 62 00 6f 00 6f 00-6b 00 3e 00 00 00 00 00 |/.b.o.o. k.>.....| token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129c8, 0x7fff944129cc, 0x6914) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 39 00 33 01 00-ff 11 00 c3 00 01 00 00 |...9.3.. ........| 0010 00 00 00 00 00 79 00 00-00 00 ac 00 00 00 01 00 |.....y.. ........| 0020 00 00 00 00 00 26 04 04-01 00 00 00 fe 00 00 e0 |.....&.. ........| 0030 00 00 00 00 00 00 00 00-00 |........ .| token.c:564:processing result tokens. marker is ff(DONEINPROC) token.c:2075:tds_process_end: more_results = 1 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2092: rows_affected = 1 util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0 odbc.c:3703:odbc_process_tokens: processed TDS_DONEINPROC_RESULT odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4054 token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129c8, 0x7fff944129cc, 0x6914) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is ac(PARAM) token.c:625:processing parameters for op 13 token.c:627:calling tds_process_param_result token.c:1297:tds_process_param_result(0x22880a0, 0x7fff94412958) token.c:1641:tds_get_data_info(0x22880a0, 0x22bcc70, 1) [for parameter] token.c:1703:processing result. type = 38(integer-null), varint_size 1 token.c:1708:processing result. column_size 4 data.c:534:tds_get_data: type 38, varint size 1 data.c:587:tds_get_data(): wire column size is 4 log.c:442:type integer-null has value 1 token.c:631:1 hidden return parameters token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4053, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3682:odbc_process_tokens: processed TDS_DONEPROC_RESULT token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129c8, 0x7fff944129cc, 0x26914) token.c:552:tds_process_tokens() state is COMPLETED odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4046 odbc.c:6194:SQLParamData returns SQL_SUCCESS odbc.c:4631:_SQLRowCount(0x22cd460, 0x7fff94412ad0), 1 rows odbc.c:4642:SQLRowCount returns 0, row count 1 odbc.c:869:SQLMoreResults(0x22cd460) odbc.c:4084:SQLFreeHandle(3, 0x22cd460) odbc.c:4185:_SQLFreeStmt(0x22cd460, 1, 0) query.c:1886:tds_submit_unprepare() emkut06000 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 03 01 00 2d 00 00 01 00-16 00 00 00 12 00 00 00 |...-.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 0f 00 00 00 00 00 26 04-04 01 00 00 00 |......&. .....| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a48, 0x7fff94412a4c, 0x100) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 1a 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3.. y.......| 0010 e0 00 00 00 00 00 00 00-00 00 |........ ..| token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:1510:SQLAllocHandle(3, 0x22851f0, 0x22bc980) odbc.c:1684:_SQLAllocStmt(0x22851f0, 0x22bc980) odbc_export.h:305:SQLSetCursorName(0x22cd460, scu1, -3) odbc.c:6638:SQLSetStmtAttr(0x22cd460, -1, (nil), -5) odbc.c:6337:_SQLSetStmtAttr(0x22cd460, -1, (nil), -5) odbc.c:6638:SQLSetStmtAttr(0x22cd460, -2, 0x2, -5) odbc.c:6337:_SQLSetStmtAttr(0x22cd460, -2, 0x2, -5) odbc_export.h:284:SQLPrepare(0x22cd460, select t from t1 where k = 1, -3) odbc.c:3598:SQLExecute(0x22cd460) prepare_query.c:198:parsing 0 parameters odbc.c:3289:_SQLExecute(0x22cd460) odbc.c:3306:_SQLExecute() starting with state 0 query.c:2327:tds_cursor_declare() cursor id = 0 query.c:2374:tds_cursor_open() cursor id = 0 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING query.c:2501:tds_cursor_open (): RPC call set up query.c:2505:tds_cursor_open (): cursor open completed packet.c:740:Sending packet 0000 03 01 00 90 00 00 01 00-16 00 00 00 12 00 00 00 |........ ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 02 00 00 00 00 01 26 04-00 00 00 63 3c 00 00 00 |......&. ...c<...| 0030 09 04 d0 00 34 3c 00 00-00 73 00 65 00 6c 00 65 |....4<.. .s.e.l.e| 0040 00 63 00 74 00 20 00 74-00 20 00 66 00 72 00 6f |.c.t. .t . .f.r.o| 0050 00 6d 00 20 00 20 00 20-00 74 00 31 00 20 00 77 |.m. . . .t.1. .w| 0060 00 68 00 65 00 72 00 65-00 20 00 6b 00 20 00 3d |.h.e.r.e . .k. .=| 0070 00 20 00 31 00 00 01 26-04 04 04 00 00 00 00 01 |. .1...& ........| 0080 26 04 04 04 20 00 00 00-01 26 04 04 00 00 00 00 |&... ... .&......| util.c:165:Changed query state from WRITING to PENDING token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129e8, 0x7fff944129ec, 0x6900) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 a6 00 33 01 00-81 02 00 00 00 00 00 0b |.....3.. ........| 0010 00 f1 00 01 74 00 00 00-00 00 00 00 38 07 52 00 |....t... ....8.R.| 0020 4f 00 57 00 53 00 54 00-41 00 54 00 a4 07 00 01 |O.W.S.T. A.T.....| 0030 02 00 74 00 31 00 a5 06-00 01 01 00 02 00 14 ff |..t.1... ........| 0040 11 00 c1 00 00 00 00 00-00 00 00 00 79 00 00 00 |........ ....y...| 0050 00 ac 00 00 00 01 00 00-00 00 00 00 26 04 04 f3 |........ ....&...| 0060 de bc 0a ac 02 00 00 01-00 00 00 00 00 00 26 04 |........ ......&.| 0070 04 04 00 00 00 ac 03 00-00 01 00 00 00 00 00 00 |........ ........| 0080 26 04 04 04 00 00 00 ac-04 00 00 01 00 00 00 00 |&....... ........| 0090 00 00 26 04 04 ff ff ff-ff fe 00 00 e0 00 00 00 |..&..... ........| 00a0 00 00 00 00 00 00 - |......| token.c:564:processing result tokens. marker is 81(TDS7_RESULT) token.c:1568:processing TDS7 result metadata. mem.c:644:tds_free_all_results() token.c:1590:set current_results to cursor->res_info token.c:1600:setting up 2 columns token.c:1537:tds7_get_data_info: colname = t type = 241 (xml) server's type = 241 (xml) column_varint_size = 8 column_size = 2147483647 (2147483647 on server) token.c:1537:tds7_get_data_info: colname = ROWSTAT type = 56 (int) server's type = 56 (int) column_varint_size = 0 column_size = 4 (4 on server) token.c:1609: name size/wsize type/wtype utype token.c:1610: -------------------- --------------- --------------- ------- token.c:1615: t 2147483647/2147483647 241/241 0 token.c:1615: ROWSTAT 4/4 56/56 0 token.c:564:processing result tokens. marker is ff(DONEINPROC) token.c:2075:tds_process_end: more_results = 1 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2092: rows_affected = 0 token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is ac(PARAM) token.c:625:processing parameters for op 2 token.c:627:calling tds_process_param_result token.c:1297:tds_process_param_result(0x22880a0, 0x7fff94412978) token.c:1641:tds_get_data_info(0x22880a0, 0x22ce6a0, 1) [for parameter] token.c:1703:processing result. type = 38(integer-null), varint_size 1 token.c:1708:processing result. column_size 4 data.c:534:tds_get_data: type 38, varint size 1 data.c:587:tds_get_data(): wire column size is 4 log.c:442:type integer-null has value 180150003 token.c:627:calling tds_process_param_result token.c:1297:tds_process_param_result(0x22880a0, 0x7fff94412978) token.c:1641:tds_get_data_info(0x22880a0, 0x22ce750, 1) [for parameter] token.c:1703:processing result. type = 38(integer-null), varint_size 1 token.c:1708:processing result. column_size 4 data.c:534:tds_get_data: type 38, varint size 1 data.c:587:tds_get_data(): wire column size is 4 log.c:442:type integer-null has value 4 token.c:627:calling tds_process_param_result token.c:1297:tds_process_param_result(0x22880a0, 0x7fff94412978) token.c:1641:tds_get_data_info(0x22880a0, 0x22ce820, 1) [for parameter] token.c:1703:processing result. type = 38(integer-null), varint_size 1 token.c:1708:processing result. column_size 4 data.c:534:tds_get_data: type 38, varint size 1 data.c:587:tds_get_data(): wire column size is 4 log.c:442:type integer-null has value 4 token.c:627:calling tds_process_param_result token.c:1297:tds_process_param_result(0x22880a0, 0x7fff94412978) token.c:1641:tds_get_data_info(0x22880a0, 0x22ce910, 1) [for parameter] token.c:1703:processing result. type = 38(integer-null), varint_size 1 token.c:1708:processing result. column_size 4 data.c:534:tds_get_data: type 38, varint size 1 data.c:587:tds_get_data(): wire column size is 4 log.c:442:type integer-null has value -1 token.c:631:4 hidden return parameters token.c:638:stored internal cursor id 180150003 token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3682:odbc_process_tokens: processed TDS_DONE_RESULT token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129e8, 0x7fff944129ec, 0x26900) token.c:552:tds_process_tokens() state is COMPLETED odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 query.c:2875:tds_cursor_setname() cursor id = 180150003 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 03 01 00 46 00 00 01 00-16 00 00 00 12 00 00 00 |...F.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 08 00 00 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&| 0030 04 04 02 00 00 00 00 00-a7 04 00 09 04 d0 00 34 |........ .......4| 0040 04 00 73 63 75 31 - |..scu1| token.c:549:tds_process_tokens(0x22880a0, 0x7fff944129e8, 0x7fff944129ec, 0x6914) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 1a 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3.. y.......| 0010 e0 00 00 00 00 00 00 00-00 00 |........ ..| token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3458:_SQLExecute: odbc_process_tokens returned result_type 4046 odbc.c:3621:SQLExecute returns SQL_SUCCESS odbc.c:4551:SQLNumResultCols(0x22cd460, 0x7fff94412ada) odbc_export.h:195:SQLDescribeCol(0x22cd460, 1, (nil), 0, 0x7fff94412aaa, 0x7fff94412aa8, 0x7fff94412aa0, 0x7fff94412a9e, 0x7fff94412a9c) odbc.c:6638:SQLSetStmtAttr(0x22cd460, 5, (nil), -5) odbc.c:6337:_SQLSetStmtAttr(0x22cd460, 5, (nil), -5) odbc.c:6638:SQLSetStmtAttr(0x22cd460, 27, 0xa, -5) odbc.c:6337:_SQLSetStmtAttr(0x22cd460, 27, 0xa, -5) odbc.c:6638:SQLSetStmtAttr(0x22cd460, 26, 0x22bc9c8, -5) odbc.c:6337:_SQLSetStmtAttr(0x22cd460, 26, 0x22bc9c8, -5) odbc_export.h:195:SQLDescribeCol(0x22cd460, 1, (nil), 0, 0x7fff94412a82, 0x7fff94412a80, 0x7fff94412a78, 0x7fff94412a76, 0x7fff94412a74) odbc.c:1803:SQLBindCol(0x22cd460, 1, 1, (nil), 0, 0x22ce820) odbc.c:4068:SQLFetchScroll(0x22cd460, 1, 0) odbc.c:3774:_SQLFetch(0x22cd460, 1, 0) query.c:2517:tds_cursor_setrows() cursor id = 180150003 query.c:2618:tds_cursor_fetch() cursor id = 180150003 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 03 01 00 44 00 00 01 00-16 00 00 00 12 00 00 00 |...D.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 07 00 02 00 00 00 26 04-04 f3 de bc 0a 00 00 26 |......&. .......&| 0030 04 04 02 00 00 00 00 00-26 04 00 00 00 26 04 04 |........ &....&..| 0040 0a 00 00 00 - |....| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412968, 0x7fff9441296c, 0x6d00) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 93 00 33 01 00-81 ff ff d1 fe ff ff ff |.....3.. ........| 0010 ff ff ff ff 54 00 00 00-3c 00 62 00 6f 00 6f 00 |....T... <.b.o.o.| 0020 6b 00 20 00 49 00 53 00-42 00 4e 00 3d 00 22 00 |k. .I.S. B.N.=.".| 0030 31 00 32 00 33 00 22 00-3e 00 3c 00 74 00 69 00 |1.2.3.". >.<.t.i.| 0040 74 00 6c 00 65 00 3e 00-41 00 42 00 43 00 3c 00 |t.l.e.>. A.B.C.<.| 0050 2f 00 74 00 69 00 74 00-6c 00 65 00 3e 00 3c 00 |/.t.i.t. l.e.>.<.| 0060 2f 00 62 00 6f 00 6f 00-6b 00 3e 00 00 00 00 00 |/.b.o.o. k.>.....| 0070 01 00 00 00 ff 11 00 c1-00 01 00 00 00 00 00 00 |........ ........| 0080 00 79 00 00 00 00 fe 00-00 e0 00 00 00 00 00 00 |.y...... ........| 0090 00 00 00 - |...| token.c:564:processing result tokens. marker is 81(TDS7_RESULT) token.c:1568:processing TDS7 result metadata. token.c:1577:no meta data token.c:564:processing result tokens. marker is d1(ROW) token.c:671:tds_process_tokens(). set current_results to cursor->res_info token.c:680:tds_process_tokens::SET_RETURN stopping on current token util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3709:odbc_process_tokens: returning result_type 4040 token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412968, 0x7fff9441296c, 0x6508) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is d1(ROW) token.c:671:tds_process_tokens(). set current_results to cursor->res_info token.c:1946:tds_process_row(): reading column 0 data.c:534:tds_get_data: type 241, varint size 8 token.c:1946:tds_process_row(): reading column 1 data.c:534:tds_get_data: type 56, varint size 0 data.c:587:tds_get_data(): wire column size is 4 util.c:165:Changed query state from READING to PENDING odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 0 odbc.c:3637: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3709:odbc_process_tokens: returning result_type 4040 token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412968, 0x7fff9441296c, 0x6508) util.c:165:Changed query state from PENDING to READING token.c:564:processing result tokens. marker is ff(DONEINPROC) token.c:2075:tds_process_end: more_results = 1 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2092: rows_affected = 1 token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE odbc.c:3636:odbc_process_tokens: tds_process_tokens returned 1 odbc.c:3637: result_type=1, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0 odbc.c:3906:SQLFetch: NO_DATA_FOUND token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a24, (nil), 0x2282a) token.c:552:tds_process_tokens() state is COMPLETED odbc.c:4922:SQLGetData(0x22cd460, 1, 1, 0x7fff94411970, 4096, 0x7fff94411968) error.c:414:odbc_errs_add: "Invalid cursor state" odbc.c:4288:SQLCloseCursor(0x22cd460) odbc.c:4185:_SQLFreeStmt(0x22cd460, 0, 0) query.c:2814:tds_cursor_close() cursor id = 180150003 mem.c:644:tds_free_all_results() util.c:165:Changed query state from IDLE to WRITING util.c:165:Changed query state from WRITING to PENDING packet.c:740:Sending packet 0000 03 01 00 2d 00 00 01 00-16 00 00 00 12 00 00 00 |...-.... ........| 0010 02 00 00 00 00 00 00 00-00 00 01 00 00 00 ff ff |........ ........| 0020 09 00 02 00 00 00 26 04-04 f3 de bc 0a |......&. .....| token.c:549:tds_process_tokens(0x22880a0, 0x7fff94412a88, 0x7fff94412a8c, 0x100) util.c:165:Changed query state from PENDING to READING packet.c:639:Received packet 0000 04 01 00 1a 00 33 01 00-79 00 00 00 00 fe 00 00 |.....3.. y.......| 0010 e0 00 00 00 00 00 00 00-00 00 |........ ..| token.c:564:processing result tokens. marker is 79(RETURNSTATUS) token.c:564:processing result tokens. marker is fe(DONEPROC) token.c:2075:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2092: rows_affected = 0 token.c:2095:tds_process_end() state set to TDS_IDLE util.c:165:Changed query state from READING to IDLE token.c:778:TDS_OP_CURSORCLOSE util.c:83:logic error: cannot change query state from IDLE to PENDING util.c:165:Changed query state from IDLE to IDLE mem.c:886:tds_cursor_deallocated() : freeing cursor_id 180150003