freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group
List archive

Re: [freetds] XML type returns SQL_CHAR type

From: Sebastien FLAESCH <sf AT 4js.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] XML type returns SQL_CHAR type
Date: Thu, 02 Jul 2015 11:28:43 +0200
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" <sf AT 4js.com> 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
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
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.. .@.P.1. |
0040 00 49 00 4e 00 54 00 2c-00 40 00 50 00 32 00 20 |.I.N.T., .@.P.2. |
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. .( .@.P.1.,|
00b0 00 40 00 50 00 32 00 29-00 00 00 26 04 04 01 00 |.@.P.2.) ...&....|
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
Re: [freetds] XML type returns SQL_CHAR type, Sebastien FLAESCH, 07/02/2015
- Re: [freetds] XML type returns SQL_CHAR type, Frediano Ziglio, 07/02/2015
  - Re: [freetds] XML type returns SQL_CHAR type, Sebastien FLAESCH, 07/03/2015
    - Re: [freetds] XML type returns SQL_CHAR type, Frediano Ziglio, 07/03/2015
- <Possible follow-up(s)>
- Re: [freetds] XML type returns SQL_CHAR type, Sebastien FLAESCH, 07/02/2015