Skip to Content.
Sympa Menu

freetds - Re: [freetds] SuSE Linux: columns of resultset don't match for MS SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Klingler, Karl" <Karl.Klingler AT vsa.de>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SuSE Linux: columns of resultset don't match for MS SQL Server 2000
  • Date: Mon, 7 Jan 2008 15:55:11 +0100

Hello,

if i use MS Query Analyzer for the following query :

select * from hds where PlanMA = 'KLINGLKA' and
CONVERT(DATETIME,[Day],104) = CONVERT(DATETIME,'02.01.2008',104)

i get the (right) result:

Mo Di Mi Do Fr Sa So Day
EXPR1 EXPR2 PlanMA
------ ------ ------ ------ ------ ------ ------ -----------------------
----- ---------------- --------------------
0 0 162 56 0 0 0 2008-01-02 00:00:00.000
HD Summe IT-Support KLINGLKA


On SUSE Linux Enterprise 10 with freetds in isql and in my
ROR-Application (so it's not isql) i get:


SQL> select * from hds where PlanMA = 'KLINGLKA' and
CONVERT(DATETIME,[Day],104) = CONVERT(DATETIME,'02.01.2008',104)
+-------+-------+-------+-------+-------+-------+-------+---------------
---------+------+-----------------+----------------+
| Mo | Di | Mi | Do | Fr | Sa | So | Day
| EXPR1| EXPR2 | PlanMA |
+-------+-------+-------+-------+-------+-------+-------+---------------
---------+------+-----------------+----------------+
| 0 | 0 | 0 | 162 | 56 | 0 | 0 | 2008-01-02
00:00:00.000| HD | Summe IT-Support| KLINGLKA |
+-------+-------+-------+-------+-------+-------+-------+---------------
---------+------+-----------------+----------------+


As you can see the result has an additional 0 which is shown as the
value for Mo.

The values for Mo .. So are all integers.
I tried the stable version 0.64 and the snapshot of today

Can anybody help with this problem? - Thanks!

karl

TDSDUMP:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++
log.c:190:Starting log file for FreeTDS 0.65.dev.20080106
on 2008-01-07 13:47:03 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:192:Connecting to 192.168.170.201 port 1433 (TDS version 8.0)
net.c:248:tds_open_socket: connect(2) returned "Operation now in
progress"
net.c:288:tds_open_socket() succeeded
util.c:162:Changed query state from DEAD to IDLE
login.c:735:quietly sending TDS 7+ login packet
token.c:312:tds_process_login_tokens()
net.c:547:Received header
0000 04 01 01 bd 00 e8 01 00- |........|

net.c:626:Received packet
0000 e3 29 00 01 0d 7a 00 65-00 69 00 74 00 65 00 72 |.)...z.e .i.t.e.r|
0010 00 66 00 61 00 73 00 73-00 75 00 6e 00 67 00 06 |.f.a.s.s .u.n.g..|
0020 6d 00 61 00 73 00 74 00-65 00 72 00 ab 94 00 45 |m.a.s.t. e.r....E|
0030 16 00 00 02 00 38 00 44-00 65 00 72 00 20 00 44 |.....8.D .e.r. .D|
0040 00 61 00 74 00 65 00 6e-00 62 00 61 00 6e 00 6b |.a.t.e.n .b.a.n.k|
0050 00 6b 00 6f 00 6e 00 74-00 65 00 78 00 74 00 20 |.k.o.n.t .e.x.t. |
0060 00 77 00 75 00 72 00 64-00 65 00 20 00 61 00 75 |.w.u.r.d .e. .a.u|
0070 00 66 00 20 00 27 00 7a-00 65 00 69 00 74 00 65 |.f. .'.z .e.i.t.e|
0080 00 72 00 66 00 61 00 73-00 73 00 75 00 6e 00 67 |.r.f.a.s .s.u.n.g|
0090 00 27 00 20 00 67 00 65-00 e4 00 6e 00 64 00 65 |.'. .g.e ...n.d.e|
00a0 00 72 00 74 00 2e 00 0c-53 00 51 00 4c 00 31 00 |.r.t.... S.Q.L.1.|
00b0 2d 00 43 00 4c 00 55 00-53 00 54 00 45 00 52 00 |-.C.L.U. S.T.E.R.|
00c0 00 00 00 e3 08 00 07 05-09 04 d0 00 00 00 e3 17 |........ ........|
00d0 00 02 0a 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |...u.s._ .e.n.g.l|
00e0 00 69 00 73 00 68 00 00-ab 72 00 47 16 00 00 01 |.i.s.h.. .r.G....|
00f0 00 27 00 43 00 68 00 61-00 6e 00 67 00 65 00 64 |.'.C.h.a .n.g.e.d|
0100 00 20 00 6c 00 61 00 6e-00 67 00 75 00 61 00 67 |. .l.a.n .g.u.a.g|
0110 00 65 00 20 00 73 00 65-00 74 00 74 00 69 00 6e |.e. .s.e .t.t.i.n|
0120 00 67 00 20 00 74 00 6f-00 20 00 75 00 73 00 5f |.g. .t.o . .u.s._|
0130 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 2e |.e.n.g.l .i.s.h..|
0140 00 0c 53 00 51 00 4c 00-31 00 2d 00 43 00 4c 00 |..S.Q.L. 1.-.C.L.|
0150 55 00 53 00 54 00 45 00-52 00 00 00 00 ad 36 00 |U.S.T.E. R.....6.|
0160 01 71 00 00 01 16 4d 00-69 00 63 00 72 00 6f 00 |.q....M. i.c.r.o.|
0170 73 00 6f 00 66 00 74 00-20 00 53 00 51 00 4c 00 |s.o.f.t. .S.Q.L.|
0180 20 00 53 00 65 00 72 00-76 00 65 00 72 00 00 00 | .S.e.r. v.e.r...|
0190 00 00 08 00 02 f8 e3 13-00 04 04 34 00 30 00 39 |........ ...4.0.9|
01a0 00 36 00 04 34 00 30 00-39 00 36 00 fd 00 00 00 |.6..4.0. 9.6.....|
01b0 00 00 00 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:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
odbc.c:2022:msgno 5701 20003
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 00 00 00 00 00 - |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:2292:tds->collation now
0000 09 04 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:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
odbc.c:2022:msgno 5703 20003
token.c:2529:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got ad(LOGINACK)
token.c:316:looking for login token, got e3(ENVCHANGE)
token.c:108:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:316:looking for login token, got fd(DONE)
token.c:108:tds_process_default_tokens() marker is fd(DONE)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
token.c:2232: rows_affected = 0
token.c:393:leaving tds_process_login_tokens() returning 1
odbc.c:4615:SQLGetFunctions: fFunction is 1
odbc.c:4615:SQLGetFunctions: fFunction is 2
odbc.c:4615:SQLGetFunctions: fFunction is 1001
odbc.c:4615:SQLGetFunctions: fFunction is 3
odbc.c:4615:SQLGetFunctions: fFunction is 4
odbc.c:4615:SQLGetFunctions: fFunction is 1002
odbc.c:4615:SQLGetFunctions: fFunction is 72
odbc.c:4615:SQLGetFunctions: fFunction is 5
odbc.c:4615:SQLGetFunctions: fFunction is 1003
odbc.c:4615:SQLGetFunctions: fFunction is 6
odbc.c:4615:SQLGetFunctions: fFunction is 6
odbc.c:4615:SQLGetFunctions: fFunction is 56
odbc.c:4615:SQLGetFunctions: fFunction is 40
odbc.c:4615:SQLGetFunctions: fFunction is 7
odbc.c:4615:SQLGetFunctions: fFunction is 1004
odbc.c:4615:SQLGetFunctions: fFunction is 8
odbc.c:4615:SQLGetFunctions: fFunction is 9
odbc.c:4615:SQLGetFunctions: fFunction is 41
odbc.c:4615:SQLGetFunctions: fFunction is 1005
odbc.c:4615:SQLGetFunctions: fFunction is 10
odbc.c:4615:SQLGetFunctions: fFunction is 11
odbc.c:4615:SQLGetFunctions: fFunction is 12
odbc.c:4615:SQLGetFunctions: fFunction is 59
odbc.c:4615:SQLGetFunctions: fFunction is 13
odbc.c:4615:SQLGetFunctions: fFunction is 1021
odbc.c:4615:SQLGetFunctions: fFunction is 60
odbc.c:4615:SQLGetFunctions: fFunction is 15
odbc.c:4615:SQLGetFunctions: fFunction is 1006
odbc.c:4615:SQLGetFunctions: fFunction is 16
odbc.c:4615:SQLGetFunctions: fFunction is 14
odbc.c:4615:SQLGetFunctions: fFunction is 1007
odbc.c:4615:SQLGetFunctions: fFunction is 42
odbc.c:4615:SQLGetFunctions: fFunction is 17
odbc.c:4615:SQLGetFunctions: fFunction is 43
odbc.c:4615:SQLGetFunctions: fFunction is 1008
odbc.c:4615:SQLGetFunctions: fFunction is 1009
odbc.c:4615:SQLGetFunctions: fFunction is 1010
odbc.c:4615:SQLGetFunctions: fFunction is 1012
odbc.c:4615:SQLGetFunctions: fFunction is 44
odbc.c:4615:SQLGetFunctions: fFunction is 45
odbc.c:4615:SQLGetFunctions: fFunction is 1014
odbc.c:4615:SQLGetFunctions: fFunction is 46
odbc.c:4615:SQLGetFunctions: fFunction is 47
odbc.c:4615:SQLGetFunctions: fFunction is 61
odbc.c:4615:SQLGetFunctions: fFunction is 62
odbc.c:4615:SQLGetFunctions: fFunction is 63
odbc.c:4615:SQLGetFunctions: fFunction is 18
odbc.c:4615:SQLGetFunctions: fFunction is 48
odbc.c:4615:SQLGetFunctions: fFunction is 64
odbc.c:4615:SQLGetFunctions: fFunction is 19
odbc.c:4615:SQLGetFunctions: fFunction is 65
odbc.c:4615:SQLGetFunctions: fFunction is 66
odbc.c:4615:SQLGetFunctions: fFunction is 67
odbc.c:4615:SQLGetFunctions: fFunction is 49
odbc.c:4615:SQLGetFunctions: fFunction is 20
odbc.c:4615:SQLGetFunctions: fFunction is 1016
odbc.c:4615:SQLGetFunctions: fFunction is 50
odbc.c:4615:SQLGetFunctions: fFunction is 21
odbc.c:4615:SQLGetFunctions: fFunction is 1017
odbc.c:4615:SQLGetFunctions: fFunction is 1018
odbc.c:4615:SQLGetFunctions: fFunction is 1019
odbc.c:4615:SQLGetFunctions: fFunction is 22
odbc.c:4615:SQLGetFunctions: fFunction is 68
odbc.c:4615:SQLGetFunctions: fFunction is 69
odbc.c:4615:SQLGetFunctions: fFunction is 1020
odbc.c:4615:SQLGetFunctions: fFunction is 51
odbc.c:4615:SQLGetFunctions: fFunction is 52
odbc.c:4615:SQLGetFunctions: fFunction is 53
odbc.c:4615:SQLGetFunctions: fFunction is 70
odbc.c:4615:SQLGetFunctions: fFunction is 54
odbc.c:4615:SQLGetFunctions: fFunction is 23
odbc.c:4615:SQLGetFunctions: fFunction is 1011
odbc.c:5531:SQLGetInfo(0x51cd20, 77, 0x7fff83e32be0, 20, (nil))
odbc.c:4784:_SQLGetInfo(0x51cd20, 77, 0x7fff83e32be0, 20, (nil)
odbc.c:5531:SQLGetInfo(0x51cd20, 10000, 0x7fff83e32be0, 5, (nil))
odbc.c:4784:_SQLGetInfo(0x51cd20, 10000, 0x7fff83e32be0, 5, (nil)
odbc.c:1497:SQLAllocStmt(0x51cd20, 0x5582f0)
odbc.c:1395:_SQLAllocStmt(0x51cd20, 0x5582f0)
odbc.c:4040:SQLGetStmtAttr(0x558540, 10010, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10010, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10011, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10011, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10012, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10012, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10013, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10013, 0x7fff83e33db8, 8, (nil))
odbc.c:4085:SQLPrepare(0x558540, use zeiterfassung , -3)
odbc.c:4149:Creating prepared statement
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:739:Sending packet
0000 03 01 00 60 00 00 01 00-ff ff 0b 00 00 00 00 01 |...`.... ........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 d0 00 00 ff |&....c.. ........|
0020 ff ff ff 00 00 63 24 00-00 00 09 04 d0 00 00 24 |.....c$. .......$|
0030 00 00 00 75 00 73 00 65-00 20 00 7a 00 65 00 69 |...u.s.e . .z.e.i|
0040 00 74 00 65 00 72 00 66-00 61 00 73 00 73 00 75 |.t.e.r.f .a.s.s.u|
0050 00 6e 00 67 00 20 00 00-00 26 04 04 01 00 00 00 |.n.g. .. .&......|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33cac, 0x7fff83e33ca8,
0x104)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 00 2f 00 e8 01 00- |.../....|

net.c:626:Received packet
0000 ff 01 00 e2 00 e8 00 00-00 79 00 00 00 00 ac 0d |........ .y......|
0010 00 00 01 38 00 00 00 26-04 04 01 00 00 00 fe 00 |...8...& ........|
0020 00 e0 00 e8 00 00 00 - |.......|

token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2232: rows_affected = 232
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x51d390, 0x7fff83e33c58)
token.c:1596:processing result. type = 38(integer-null), varint_size 1
token.c:1617:processing result. column_size 4
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4
token.c:573:1 hidden return parameters
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 232
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33cac, 0x7fff83e33ca8,
0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3222:SQLExecute(0x558540)
odbc.c:2947:_SQLExecute(0x558540)
odbc.c:2952:_SQLExecute() starting with state 0
odbc.c:3060:End prepare, execute
query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:739:Sending packet
0000 03 01 00 29 00 00 01 00-0a 00 73 00 70 00 5f 00 |...).... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 26 04 04 01 00 00-00 |..&..... .|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c54, 0x7fff83e33c50,
0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 00 e3 00 e8 01 00- |........|

net.c:626:Received packet
0000 e3 37 00 01 0d 7a 00 65-00 69 00 74 00 65 00 72 |.7...z.e .i.t.e.r|
0010 00 66 00 61 00 73 00 73-00 75 00 6e 00 67 00 0d |.f.a.s.s .u.n.g..|
0020 7a 00 65 00 69 00 74 00-65 00 72 00 66 00 61 00 |z.e.i.t. e.r.f.a.|
0030 73 00 73 00 75 00 6e 00-67 00 ab 7c 00 45 16 00 |s.s.u.n. g..|.E..|
0040 00 01 00 2c 00 43 00 68-00 61 00 6e 00 67 00 65 |...,.C.h .a.n.g.e|
0050 00 64 00 20 00 64 00 61-00 74 00 61 00 62 00 61 |.d. .d.a .t.a.b.a|
0060 00 73 00 65 00 20 00 63-00 6f 00 6e 00 74 00 65 |.s.e. .c .o.n.t.e|
0070 00 78 00 74 00 20 00 74-00 6f 00 20 00 27 00 7a |.x.t. .t .o. .'.z|
0080 00 65 00 69 00 74 00 65-00 72 00 66 00 61 00 73 |.e.i.t.e .r.f.a.s|
0090 00 73 00 75 00 6e 00 67-00 27 00 2e 00 0c 53 00 |.s.u.n.g .'....S.|
00a0 51 00 4c 00 31 00 2d 00-43 00 4c 00 55 00 53 00 |Q.L.1.-. C.L.U.S.|
00b0 54 00 45 00 52 00 00 01-00 e3 08 00 07 05 09 04 |T.E.R... ........|
00c0 d0 00 00 00 ff 01 00 e2-00 00 00 00 00 79 00 00 |........ .....y..|
00d0 00 00 fe 00 00 e0 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:2451:tds_process_msg() reading message from server
token.c:2516:tds_process_msg() calling client msg handler
odbc.c:2022:msgno 5701 20003
token.c:2529: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:2281:tds_process_env_chg(): 5 bytes of collation data received
token.c:2282:tds->collation was
0000 09 04 d0 00 00 - |.....|

iconv.c:985:setting server single-byte charset to "CP1252"
token.c:2292:tds->collation now
0000 09 04 d0 00 00 - |.....|

token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2232: rows_affected = 0
util.c:162:Changed query state from READING to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4054, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3318:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
odbc.c:3101:_SQLExecute: odbc_process_tokens returned result_type 4054
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c54, 0x7fff83e33c50,
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4053, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3294:odbc_process_tokens: row_count=-1
odbc.c:3101:_SQLExecute: odbc_process_tokens returned result_type 4053
error.c:609:SQLGetDiagRec(3, 0x558540, 1, 0x7fff83e33c70,
0x7fff83e33c8c, 0x7fff83e33a70, 512, 0x7fff83e33c88)
error.c:510:_SQLGetDiagRec(3, 0x558540, 1, 0x7fff83e33c70,
0x7fff83e33c8c, 0x7fff83e33a70, 512, 0x7fff83e33c88)
error.c:609:SQLGetDiagRec(3, 0x558540, 2, 0x7fff83e33c70,
0x7fff83e33c8c, 0x7fff83e33a70, 512, 0x7fff83e33c88)
error.c:510:_SQLGetDiagRec(3, 0x558540, 2, 0x7fff83e33c70,
0x7fff83e33c8c, 0x7fff83e33a70, 512, 0x7fff83e33c88)
odbc.c:4061:SQLNumResultCols(0x558540, 0x7fff83e33e26)
odbc.c:4215:_SQLRowCount(0x558540, 0x7fff83e33df4)
odbc.c:4234:SQLRowCount returns 0, row count -1
odbc.c:580:SQLMoreResults(0x558540)
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c64, 0x7fff83e33c60,
0x5914)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 2
odbc.c:3255: result_type=4052, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:607:SQLMoreResults: result_type=4046, row_count=-1, lastrc=0
mem.c:563:tds_free_all_results()
odbc.c:619:SQLMoreResults: row_status=0
odbc.c:621:SQLMoreResults: row_count=-1, lastrc=0
odbc.c:3641:SQLFreeHandle(3, 0x0x558540)
odbc.c:3730:_SQLFreeStmt(0x558540, 1, 0)
query.c:1768:tds_submit_unprepare() y85f406000
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:739:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 01 00 00 00 - |&......|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c14, 0x7fff83e33c10,
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 00 16 00 e8 01 00- |........|

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

token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c14, 0x7fff83e33c10,
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:1497:SQLAllocStmt(0x51cd20, 0x5582f0)
odbc.c:1395:_SQLAllocStmt(0x51cd20, 0x5582f0)
odbc.c:4040:SQLGetStmtAttr(0x558540, 10010, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10010, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10011, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10011, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10012, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10012, 0x7fff83e33db8, 8, (nil))
odbc.c:4040:SQLGetStmtAttr(0x558540, 10013, 0x7fff83e33db8, 8, (nil))
odbc.c:3878:_SQLGetStmtAttr(0x558540, 10013, 0x7fff83e33db8, 8, (nil))
odbc.c:4085:SQLPrepare(0x558540, select * from hds where PlanMA =
'KLINGLKA' and CONVERT(DATETIME,[Day],104) =
CONVERT(DATETIME,'02.01.2008',104) , -3)
odbc.c:4149:Creating prepared statement
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:739:Sending packet
0000 03 01 01 1e 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 d0 00 00 ff |&....c.. ........|
0020 ff ff ff 00 00 63 e2 00-00 00 09 04 d0 00 00 e2 |.....c.. ........|
0030 00 00 00 73 00 65 00 6c-00 65 00 63 00 74 00 20 |...s.e.l .e.c.t. |
0040 00 2a 00 20 00 66 00 72-00 6f 00 6d 00 20 00 68 |.*. .f.r .o.m. .h|
0050 00 64 00 73 00 20 00 77-00 68 00 65 00 72 00 65 |.d.s. .w .h.e.r.e|
0060 00 20 00 50 00 6c 00 61-00 6e 00 4d 00 41 00 20 |. .P.l.a .n.M.A. |
0070 00 3d 00 20 00 27 00 4b-00 4c 00 49 00 4e 00 47 |.=. .'.K .L.I.N.G|
0080 00 4c 00 4b 00 41 00 27-00 20 00 61 00 6e 00 64 |.L.K.A.' . .a.n.d|
0090 00 20 00 43 00 4f 00 4e-00 56 00 45 00 52 00 54 |. .C.O.N .V.E.R.T|
00a0 00 28 00 44 00 41 00 54-00 45 00 54 00 49 00 4d |.(.D.A.T .E.T.I.M|
00b0 00 45 00 2c 00 5b 00 44-00 61 00 79 00 5d 00 2c |.E.,.[.D .a.y.].,|
00c0 00 31 00 30 00 34 00 29-00 20 00 3d 00 20 00 43 |.1.0.4.) . .=. .C|
00d0 00 4f 00 4e 00 56 00 45-00 52 00 54 00 28 00 44 |.O.N.V.E .R.T.(.D|
00e0 00 41 00 54 00 45 00 54-00 49 00 4d 00 45 00 2c |.A.T.E.T .I.M.E.,|
00f0 00 27 00 30 00 32 00 2e-00 30 00 31 00 2e 00 32 |.'.0.2.. .0.1...2|
0100 00 30 00 30 00 38 00 27-00 2c 00 31 00 30 00 34 |.0.0.8.' .,.1.0.4|
0110 00 29 00 20 00 00 00 26-04 04 01 00 00 00 |.). ...& ......|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33cac, 0x7fff83e33ca8,
0x104)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 00 cb 00 e8 01 00- |........|

net.c:626:Received packet
0000 81 0b 00 00 00 08 00 38-02 4d 00 6f 00 00 00 08 |.......8 .M.o....|
0010 00 38 02 44 00 69 00 00-00 08 00 38 02 4d 00 69 |.8.D.i.. ...8.M.i|
0020 00 00 00 08 00 38 02 44-00 6f 00 00 00 08 00 38 |.....8.D .o.....8|
0030 02 46 00 72 00 00 00 08-00 38 02 53 00 61 00 00 |.F.r.... .8.S.a..|
0040 00 08 00 38 02 53 00 6f-00 00 00 08 00 3d 03 44 |...8.S.o .....=.D|
0050 00 61 00 79 00 00 00 00-00 a7 02 00 09 04 d0 00 |.a.y.... ........|
0060 00 05 45 00 58 00 50 00-52 00 31 00 00 00 00 00 |..E.X.P. R.1.....|
0070 a7 10 00 09 04 d0 00 00-05 45 00 58 00 50 00 52 |........ .E.X.P.R|
0080 00 32 00 00 00 08 00 a7-14 00 09 04 00 01 28 06 |.2...... ......(.|
0090 50 00 6c 00 61 00 6e 00-4d 00 41 00 ff 01 00 c1 |P.l.a.n. M.A.....|
00a0 00 00 00 00 00 79 00 00-00 00 ac 0d 00 00 01 38 |.....y.. .......8|
00b0 00 00 00 26 04 04 02 00-00 00 fe 00 00 e0 00 00 |...&.... ........|
00c0 00 00 00 - |...|

token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (11 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = Mo (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info:
colname = Di (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 2
token.c:1490:tds7_get_data_info:
colname = Mi (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 3
token.c:1490:tds7_get_data_info:
colname = Do (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 4
token.c:1490:tds7_get_data_info:
colname = Fr (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 5
token.c:1490:tds7_get_data_info:
colname = Sa (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 6
token.c:1490:tds7_get_data_info:
colname = So (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 7
token.c:1490:tds7_get_data_info:
colname = Day (3 bytes)
type = 61 (datetime)
server's type = 61 (datetime)
column_varint_size = 0
column_size = 8 (8 on server)
token.c:1555:setting up column 8
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 2
Client charset: ISO-8859-1
Client column_size: 2
token.c:1490:tds7_get_data_info:
colname = EXPR1 (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 2 (2 on server)
token.c:1555:setting up column 9
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 16
Client charset: ISO-8859-1
Client column_size: 16
token.c:1490:tds7_get_data_info:
colname = EXPR2 (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 16 (16 on server)
token.c:1555:setting up column 10
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"CP850"
token.c:3294:adjust_character_column_size:
Server charset: CP850
Server column_size: 20
Client charset: ISO-8859-1
Client column_size: 20
token.c:1490:tds7_get_data_info:
colname = PlanMA (6 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33cac, 0x7fff83e33ca8,
0x104)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2232: rows_affected = 0
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is ac(PARAM)
token.c:567:processing parameters for sp 11
token.c:569:calling tds_process_param_result
token.c:1198:tds_process_param_result(0x51d390, 0x7fff83e33c58)
token.c:1596:processing result. type = 38(integer-null), varint_size 1
token.c:1617:processing result. column_size 4
token.c:1915:tds_get_data: type 38, varint size 1
token.c:1975:tds_get_data(): wire column size is 4
token.c:573:1 hidden return parameters
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 0
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33cac, 0x7fff83e33ca8,
0x104)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3222:SQLExecute(0x558540)
odbc.c:2947:_SQLExecute(0x558540)
odbc.c:2952:_SQLExecute() starting with state 0
odbc.c:3060:End prepare, execute
query.c:1631:tds_submit_execute()
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to QUERYING
util.c:162:Changed query state from QUERYING to PENDING
net.c:739:Sending packet
0000 03 01 00 29 00 00 01 00-0a 00 73 00 70 00 5f 00 |...).... ..s.p._.|
0010 65 00 78 00 65 00 63 00-75 00 74 00 65 00 00 00 |e.x.e.c. u.t.e...|
0020 00 00 26 04 04 02 00 00-00 |..&..... .|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c54, 0x7fff83e33c50,
0x6914)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 01 00 00 e8 01 00- |........|

net.c:626:Received packet
0000 81 0b 00 00 00 08 00 38-02 4d 00 6f 00 00 00 08 |.......8 .M.o....|
0010 00 38 02 44 00 69 00 00-00 08 00 38 02 4d 00 69 |.8.D.i.. ...8.M.i|
0020 00 00 00 08 00 38 02 44-00 6f 00 00 00 08 00 38 |.....8.D .o.....8|
0030 02 46 00 72 00 00 00 08-00 38 02 53 00 61 00 00 |.F.r.... .8.S.a..|
0040 00 08 00 38 02 53 00 6f-00 00 00 08 00 3d 03 44 |...8.S.o .....=.D|
0050 00 61 00 79 00 00 00 00-00 a7 02 00 09 04 d0 00 |.a.y.... ........|
0060 00 05 45 00 58 00 50 00-52 00 31 00 00 00 00 00 |..E.X.P. R.1.....|
0070 a7 10 00 09 04 d0 00 00-05 45 00 58 00 50 00 52 |........ .E.X.P.R|
0080 00 32 00 00 00 08 00 a7-14 00 09 04 00 01 28 06 |.2...... ......(.|
0090 50 00 6c 00 61 00 6e 00-4d 00 41 00 d1 00 00 00 |P.l.a.n. M.A.....|
00a0 00 00 00 00 00 00 00 00-00 a2 00 00 00 38 00 00 |........ .....8..|
00b0 00 00 00 00 00 00 00 00-00 17 9a 00 00 00 00 00 |........ ........|
00c0 00 02 00 48 44 10 00 53-75 6d 6d 65 20 49 54 2d |...HD..S umme IT-|
00d0 53 75 70 70 6f 72 74 08-00 4b 4c 49 4e 47 4c 4b |Support. .KLINGLK|
00e0 41 ff 11 00 c1 00 01 00-00 00 79 00 00 00 00 fe |A....... ..y.....|
00f0 00 00 e0 00 01 00 00 00- |........|

token.c:510:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1520:processing TDS7 result metadata.
mem.c:563:tds_free_all_results()
token.c:1544:set current_results (11 columns) to tds->res_info
token.c:1555:setting up column 0
token.c:1490:tds7_get_data_info:
colname = Mo (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 1
token.c:1490:tds7_get_data_info:
colname = Di (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 2
token.c:1490:tds7_get_data_info:
colname = Mi (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 3
token.c:1490:tds7_get_data_info:
colname = Do (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 4
token.c:1490:tds7_get_data_info:
colname = Fr (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 5
token.c:1490:tds7_get_data_info:
colname = Sa (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 6
token.c:1490:tds7_get_data_info:
colname = So (2 bytes)
type = 56 (int)
server's type = 56 (int)
column_varint_size = 0
column_size = 4 (4 on server)
token.c:1555:setting up column 7
token.c:1490:tds7_get_data_info:
colname = Day (3 bytes)
type = 61 (datetime)
server's type = 61 (datetime)
column_varint_size = 0
column_size = 8 (8 on server)
token.c:1555:setting up column 8
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 2
Client charset: ISO-8859-1
Client column_size: 2
token.c:1490:tds7_get_data_info:
colname = EXPR1 (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 2 (2 on server)
token.c:1555:setting up column 9
token.c:3294:adjust_character_column_size:
Server charset: CP1252
Server column_size: 16
Client charset: ISO-8859-1
Client column_size: 16
token.c:1490:tds7_get_data_info:
colname = EXPR2 (5 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 16 (16 on server)
token.c:1555:setting up column 10
token.c:3294:adjust_character_column_size:
Server charset: CP850
Server column_size: 20
Client charset: ISO-8859-1
Client column_size: 20
token.c:1490:tds7_get_data_info:
colname = PlanMA (6 bytes)
type = 39 (varchar)
server's type = 167 (xvarchar)
column_varint_size = 2
column_size = 20 (20 on server)
util.c:162:Changed query state from READING to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3324:odbc_process_tokens: returning result_type 4049
odbc.c:3101:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c54, 0x7fff83e33c50,
0x6914)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:621:tds_process_tokens::SET_RETURN stopping on current token
util.c:162:Changed query state from READING to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3324:odbc_process_tokens: returning result_type 4040
odbc.c:3101:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:4061:SQLNumResultCols(0x558540, 0x7fff83e33e26)
odbc.c:4061:SQLNumResultCols(0x558540, 0x7fff83e33dce)
odbc.c:1981:SQLColAttribute(0x558540, 1, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 1, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 1, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 1, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 1, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 1, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 2, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 2, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 2, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 2, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 2, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 2, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 3, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 3, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 3, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 3, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 3, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 3, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 4, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 4, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 4, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 4, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 4, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 4, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 5, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 5, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 5, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 5, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 5, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 5, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 6, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 6, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 6, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 6, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 6, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 6, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 7, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 7, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 7, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 7, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 7, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 7, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 8, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 8, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 8, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 8, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 8, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 8, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 9, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 9, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 9, 18, 0x7fff83e339e0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 9, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 9, 18, 0x7fff83e33ca0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 9, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 10, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 10, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 10, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 10, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 10, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 10, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 11, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1756:_SQLColAttribute(0x558540, 11, 6, (nil), 0, (nil),
0x7fff83e33b1c)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 11, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 11, 18, 0x7fff83e339e0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:1981:SQLColAttribute(0x558540, 11, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 11, 18, 0x7fff83e33ca0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4061:SQLNumResultCols(0x558540, 0x7fff83e33dce)
odbc.c:3614:SQLFetch(0x558540)
odbc.c:3358:_SQLFetch(0x558540, 1, 0)
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e338d4, 0x7fff83e338d0,
0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is d1(ROW)
token.c:2166:tds_process_row(): reading column 0
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 1
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 2
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 3
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 4
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 5
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 6
token.c:1915:tds_get_data: type 56, varint size 0
token.c:1975:tds_get_data(): wire column size is 4
token.c:2166:tds_process_row(): reading column 7
token.c:1915:tds_get_data: type 61, varint size 0
token.c:1975:tds_get_data(): wire column size is 8
token.c:2166:tds_process_row(): reading column 8
token.c:1915:tds_get_data: type 39, varint size 2
token.c:1975:tds_get_data(): wire column size is 2
token.c:2166:tds_process_row(): reading column 9
token.c:1915:tds_get_data: type 39, varint size 2
token.c:1975:tds_get_data(): wire column size is 16
token.c:2166:tds_process_row(): reading column 10
token.c:1915:tds_get_data: type 39, varint size 2
token.c:1975:tds_get_data(): wire column size is 8
util.c:162:Changed query state from READING to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3324:odbc_process_tokens: returning result_type 4040
odbc.c:1981:SQLColAttribute(0x558540, 1, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 1, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 1, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 1, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 1, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 2, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 2, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 2, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 2, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 2, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 3, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 3, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 3, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 3, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 3, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 4, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 4, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 4, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 4, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 4, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 5, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 5, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 5, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 5, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 5, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 6, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 6, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 6, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 6, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 6, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 7, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 7, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 7, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 7, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 7, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 56 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 8, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 8, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 8, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 8, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 8, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 61 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 9, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 9, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 9, 18, 0x7fff83e339c0, 301, (nil),
(nil))
odbc.c:1756:_SQLColAttribute(0x558540, 9, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 9, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 39 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 10, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 10, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 10, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 10, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 10, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 39 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:1981:SQLColAttribute(0x558540, 11, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1756:_SQLColAttribute(0x558540, 11, 6, (nil), 0, (nil),
0x7fff83e33afc)
odbc.c:1797:odbc:SQLColAttribute: fDescType is 6
odbc.c:1981:SQLColAttribute(0x558540, 11, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1756:_SQLColAttribute(0x558540, 11, 18, 0x7fff83e339c0, 301,
(nil), (nil))
odbc.c:1797:odbc:SQLColAttribute: fDescType is 18
odbc.c:4522:SQLGetData(0x558540, 11, 1, 0x7fff83e33c90, 301,
0x7fff83e33dc8)
convert_tds2sql.c:62:convert_tds2sql: src is 39 dest = 1
convert_tds2sql.c:131:convert_tds2sql: outputting character data destlen
= 301
odbc.c:3614:SQLFetch(0x558540)
odbc.c:3358:_SQLFetch(0x558540, 1, 0)
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e338d4, 0x7fff83e338d0,
0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is ff(DONEINPROC)
token.c:2201:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2232: rows_affected = 1
util.c:162:Changed query state from READING to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4054, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:3318:odbc_process_tokens: processed TDS_DONEINPROC_RESULT
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e338d4, 0x7fff83e338d0,
0x6508)
util.c:162:Changed query state from PENDING to READING
token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3255: result_type=4053, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3294:odbc_process_tokens: row_count=1
odbc.c:3490:SQLFetch: NO_DATA_FOUND
odbc.c:4215:_SQLRowCount(0x558540, 0x7fff83e33df4)
odbc.c:4234:SQLRowCount returns 0, row count 1
odbc.c:580:SQLMoreResults(0x558540)
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c64, 0x7fff83e33c60,
0x5914)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:3254:odbc_process_tokens: tds_process_tokens returned 2
odbc.c:3255: result_type=4052, TDS_DONE_COUNT=10, TDS_DONE_ERROR=0
odbc.c:607:SQLMoreResults: result_type=4046, row_count=-1, lastrc=0
mem.c:563:tds_free_all_results()
odbc.c:619:SQLMoreResults: row_status=0
odbc.c:621:SQLMoreResults: row_count=-1, lastrc=0
odbc.c:3641:SQLFreeHandle(3, 0x0x558540)
odbc.c:3730:_SQLFreeStmt(0x558540, 1, 0)
query.c:1768:tds_submit_unprepare() y85f409000
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:739:Sending packet
0000 03 01 00 17 00 00 01 00-ff ff 0f 00 00 00 00 00 |........ ........|
0010 26 04 04 02 00 00 00 - |&......|

token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c14, 0x7fff83e33c10,
0x100)
util.c:162:Changed query state from PENDING to READING
net.c:547:Received header
0000 04 01 00 16 00 e8 01 00- |........|

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

token.c:510:processing result tokens. marker is 79(RETURNSTATUS)
token.c:510:processing result tokens. marker is fe(DONEPROC)
token.c:2201:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2217:tds_process_end() state set to TDS_IDLE
util.c:162:Changed query state from READING to IDLE
token.c:2232: rows_affected = 1
util.c:110:logic error: cannot change query state from IDLE to PENDING
token.c:495:tds_process_tokens(0x51d390, 0x7fff83e33c14, 0x7fff83e33c10,
0x100)
token.c:498:tds_process_tokens() state is COMPLETED
odbc.c:1995:SQLDisconnect(0x51cd20)
mem.c:563:tds_free_all_results()
util.c:162:Changed query state from IDLE to DEAD
odbc.c:3695:SQLFreeConnect(0x51cd20)
odbc.c:3667:_SQLFreeConnect(0x51cd20)
odbc.c:3718:SQLFreeEnv(0x51df10)
odbc.c:3705:_SQLFreeEnv(0x51df10)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++++++++++++++++




  • Re: [freetds] SuSE Linux: columns of resultset don't match for MS SQL Server 2000, Klingler, Karl, 01/07/2008

Archive powered by MHonArc 2.6.24.

Top of Page