freetds silently truncating text/varchar/etc fields to 80 characters
Robert Jay <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Okay, log file attached. I'm not sure how the list handles attachments, but
i'll find out :)
The bit of Perl that does the insert is (which is pretty straightforward):
#!/usr/bin/perl
use warnings;
use DBI;
use DBD::Sybase;
my $dbh = DBI->connect("DBI:Sybase:server=acmt;database=acmt;", "l_acmt_rw",
"l_acmt_rw")
or die("Failed to connect to database");
my $sql = "INSERT INTO test (test_string) VALUES (?)";
my $v =
"a123456789b123456789c123456789d123456789e123456789f123456789g123456789h123456789i123456789j123456789";
my $sth = $dbh->prepare($sql) or die("Error preparing ($sql):
$DBI::errstr");
$sth->execute($v) or die("Error executing ($sql): $DBI::errstr");
The column test_string is defined in the DB as varchar(120). The DB is
running at compatibility level 90, and freetds.conf is set to tds version
8.0. I tried changing both of these around and it didn't make any
difference that I could see.
In the log file at around line #375 you can see it casting the parameter to
varchar(255) - it got cast to varchar(80) before I patched the code.
Hopefully this comes through okay,
Rob.
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
freetds.log
(application/octet-stream, 27.8 KB)
log.c:196:Starting log file for FreeTDS 0.83.dev.20090421 on 2009-04-24 07:19:11 with debug flags 0x4fff. iconv.c:337:tds_iconv_open(0x827bb00, ISO-8859-1) iconv.c:197:local name for ISO-8859-1 is ISO-8859-1 iconv.c:197:local name for UTF-8 is UTF-8 iconv.c:197:local name for UCS-2LE is UCS-2LE iconv.c:197:local name for UCS-2BE is UCS-2BE iconv.c:365:setting up conversions for client charset "ISO-8859-1" iconv.c:367:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion iconv.c:404:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion iconv.c:407:tds_iconv_open: done net.c:217:Connecting to 10.39.23.95 port 1433 (TDS version 8.0) net.c:273:tds_open_socket: connect(2) returned "Operation now in progress" net.c:313:tds_open_socket() succeeded util.c:162:Changed query state from DEAD to IDLE login.c:770:quietly sending TDS 7+ login packet token.c:314:tds_process_login_tokens() net.c:600:Received header 0000 04 01 01 6f 00 37 01 00- |...o.7..| net.c:654:Received packet 0000 04 01 01 6f 00 37 01 00-e3 17 00 01 04 61 00 63 |...o.7.. .....a.c| 0010 00 6d 00 74 00 06 6d 00-61 00 73 00 74 00 65 00 |.m.t..m. a.s.t.e.| 0020 72 00 ab 62 00 45 16 00-00 02 00 23 00 43 00 68 |r..b.E.. ...#.C.h| 0030 00 61 00 6e 00 67 00 65-00 64 00 20 00 64 00 61 |.a.n.g.e .d. .d.a| 0040 00 74 00 61 00 62 00 61-00 73 00 65 00 20 00 63 |.t.a.b.a .s.e. .c| 0050 00 6f 00 6e 00 74 00 65-00 78 00 74 00 20 00 74 |.o.n.t.e .x.t. .t| 0060 00 6f 00 20 00 27 00 61-00 63 00 6d 00 74 00 27 |.o. .'.a .c.m.t.'| 0070 00 2e 00 08 57 00 4f 00-4c 00 54 00 53 00 54 00 |....W.O. L.T.S.T.| 0080 30 00 35 00 00 01 00 e3-08 00 07 05 09 04 d0 00 |0.5..... ........| 0090 00 00 e3 17 00 02 0a 75-00 73 00 5f 00 65 00 6e |.......u .s._.e.n| 00a0 00 67 00 6c 00 69 00 73-00 68 00 00 ab 6a 00 47 |.g.l.i.s .h...j.G| 00b0 16 00 00 01 00 27 00 43-00 68 00 61 00 6e 00 67 |.....'.C .h.a.n.g| 00c0 00 65 00 64 00 20 00 6c-00 61 00 6e 00 67 00 75 |.e.d. .l .a.n.g.u| 00d0 00 61 00 67 00 65 00 20-00 73 00 65 00 74 00 74 |.a.g.e. .s.e.t.t| 00e0 00 69 00 6e 00 67 00 20-00 74 00 6f 00 20 00 75 |.i.n.g. .t.o. .u| 00f0 00 73 00 5f 00 65 00 6e-00 67 00 6c 00 69 00 73 |.s._.e.n .g.l.i.s| 0100 00 68 00 2e 00 08 57 00-4f 00 4c 00 54 00 53 00 |.h....W. O.L.T.S.| 0110 54 00 30 00 35 00 00 01-00 ad 36 00 01 71 00 00 |T.0.5... ..6..q..| 0120 01 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.| 0130 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.| 0140 65 00 72 00 76 00 65 00-72 00 00 00 00 00 09 00 |e.r.v.e. r.......| 0150 05 77 e3 11 00 04 03 35-00 31 00 32 00 04 34 00 |.w.....5 .1.2..4.| 0160 30 00 39 00 36 00 fd 00-00 00 00 00 00 00 00 |0.9.6... .......| token.c:318:looking for login token, got e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:318:looking for login token, got ab(INFO) token.c:110:tds_process_default_tokens() marker is ab(INFO) token.c:2528:tds_process_msg() reading message 5701 from server token.c:2601:tds_process_msg() calling client msg handler ct.c:334:ct_con_props() action = CS_GET property = 9108 ct.c:486:fetching userdata 0x827baa0 token.c:2614:tds_process_msg() returning TDS_SUCCEED token.c:318:looking for login token, got e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2359:tds_process_env_chg(): 5 bytes of collation data received token.c:2360:tds->collation was 0000 00 00 00 00 00 - |.....| iconv.c:1018:setting server single-byte charset to "CP1252" token.c:2370:tds->collation now 0000 09 04 d0 00 00 - |.....| token.c:318:looking for login token, got e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:318:looking for login token, got ab(INFO) token.c:110:tds_process_default_tokens() marker is ab(INFO) token.c:2528:tds_process_msg() reading message 5703 from server token.c:2601:tds_process_msg() calling client msg handler ct.c:334:ct_con_props() action = CS_GET property = 9108 ct.c:486:fetching userdata 0x827baa0 token.c:2614:tds_process_msg() returning TDS_SUCCEED token.c:318:looking for login token, got ad(LOGINACK) token.c:318:looking for login token, got e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2417:changing block size from 4096 to 512 token.c:318:looking for login token, got fd(DONE) token.c:110:tds_process_default_tokens() marker is fd(DONE) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE token.c:2310: rows_affected = 0 token.c:395:leaving tds_process_login_tokens() returning 1 mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING write.c:134:tds_put_string converting 19 bytes of "set textsize 64512 " write.c:162:tds_put_string wrote 38 bytes util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .| 0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.| 0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00 | .6.4.5. 1.2. .| token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c02c, 0xbfd8c028, 0x100) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 11 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 00 11 00 37 01 00-fd 00 00 be 00 00 00 00 |.....7.. ........| 0010 00 - |.| token.c:512:processing result tokens. marker is fd(DONE) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c02c, 0xbfd8c028, 0x100) token.c:500:tds_process_tokens() state is COMPLETED ct.c:623:leaving ct_connect() returning 1 ct.c:641:ct_cmd_alloc() ct.c:216:setting command state from IDLE to IDLE ct.c:660:ct_cmd_alloc() : allocating command list to head ct.c:682:ct_command() ct.c:216:setting command state from IDLE to IDLE ct.c:216:setting command state from IDLE to IDLE ct.c:216:setting command state from IDLE to READY ct.c:844:ct_send() command_type = 148 mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING write.c:134:tds_put_string converting 8 bytes of "use acmt" write.c:162:tds_put_string wrote 16 bytes util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 01 01 00 18 00 00 01 00-75 00 73 00 65 00 20 00 |........ u.s.e. .| 0010 61 00 63 00 6d 00 74 00- |a.c.m.t.| ct.c:216:setting command state from READY to SENT ct.c:965:ct_send() succeeded ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c2c8, 0xbfd8c2c4, 0x6914) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 97 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 00 97 00 37 01 00-e3 13 00 01 04 61 00 63 |.....7.. .....a.c| 0010 00 6d 00 74 00 04 61 00-63 00 6d 00 74 00 ab 62 |.m.t..a. c.m.t..b| 0020 00 45 16 00 00 01 00 23-00 43 00 68 00 61 00 6e |.E.....# .C.h.a.n| 0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d. .d.a.t.a| 0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n| 0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. | 0060 00 27 00 61 00 63 00 6d-00 74 00 27 00 2e 00 08 |.'.a.c.m .t.'....| 0070 57 00 4f 00 4c 00 54 00-53 00 54 00 30 00 35 00 |W.O.L.T. S.T.0.5.| 0080 00 01 00 e3 08 00 07 05-09 04 d0 00 00 00 fd 00 |........ ........| 0090 00 e2 00 00 00 00 00 - |.......| token.c:512:processing result tokens. marker is e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:512:processing result tokens. marker is ab(INFO) token.c:110:tds_process_default_tokens() marker is ab(INFO) token.c:2528:tds_process_msg() reading message 5701 from server token.c:2601:tds_process_msg() calling client msg handler ct.c:334:ct_con_props() action = CS_GET property = 9108 ct.c:486:fetching userdata 0x827baa0 token.c:2614:tds_process_msg() returning TDS_SUCCEED token.c:512:processing result tokens. marker is e3(ENVCHANGE) token.c:110:tds_process_default_tokens() marker is e3(ENVCHANGE) token.c:2359:tds_process_env_chg(): 5 bytes of collation data received token.c:2360:tds->collation was 0000 09 04 d0 00 00 - |.....| iconv.c:1018:setting server single-byte charset to "CP1252" token.c:2370:tds->collation now 0000 09 04 d0 00 00 - |.....| token.c:512:processing result tokens. marker is fd(DONE) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4052) ct.c:1262:ct_results() results state = 0 ct.c:1263:ct_results() command type = 148 ct.c:1264:ct_results() dynamic cmd = 0 ct.c:1099:ct_results() ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c2c8, 0xbfd8c2c4, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:1796:ct_cmd_drop() ct.c:1827:ct_cmd_drop() : command entry found in list ct.c:1832:ct_cmd_drop() : relinking list ct.c:1839:ct_cmd_drop() : relinked list ct.c:3377:ct_options: CS_SET, option = 5025 ct.c:3575: tds_submit_optioncmd will be action(CS_SET) option(25) arg(0) arglen(1) query.c:3101:tds_submit_optioncmd() mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING write.c:134:tds_put_string converting 29 bytes of "SET IMPLICIT_TRANSACTIONS OFF" write.c:162:tds_put_string wrote 58 bytes util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 01 01 00 42 00 00 01 00-53 00 45 00 54 00 20 00 |...B.... S.E.T. .| 0010 49 00 4d 00 50 00 4c 00-49 00 43 00 49 00 54 00 |I.M.P.L. I.C.I.T.| 0020 5f 00 54 00 52 00 41 00-4e 00 53 00 41 00 43 00 |_.T.R.A. N.S.A.C.| 0030 54 00 49 00 4f 00 4e 00-53 00 20 00 4f 00 46 00 |T.I.O.N. S. .O.F.| 0040 46 00 - |F.| token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c17c, 0xbfd8c178, 0x100) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 11 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 00 11 00 37 01 00-fd 00 00 ba 00 00 00 00 |.....7.. ........| 0010 00 - |.| token.c:512:processing result tokens. marker is fd(DONE) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c17c, 0xbfd8c178, 0x100) token.c:500:tds_process_tokens() state is COMPLETED ct.c:641:ct_cmd_alloc() ct.c:216:setting command state from IDLE to IDLE ct.c:660:ct_cmd_alloc() : allocating command list to head ct.c:682:ct_command() ct.c:216:setting command state from IDLE to IDLE ct.c:216:setting command state from IDLE to IDLE ct.c:216:setting command state from IDLE to READY ct.c:844:ct_send() command_type = 148 mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING write.c:134:tds_put_string converting 16 bytes of "select @@version" write.c:162:tds_put_string wrote 32 bytes util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 01 01 00 28 00 00 01 00-73 00 65 00 6c 00 65 00 |...(.... s.e.l.e.| 0010 63 00 74 00 20 00 40 00-40 00 76 00 65 00 72 00 |c.t. .@. @.v.e.r.| 0020 73 00 69 00 6f 00 6e 00- |s.i.o.n.| ct.c:216:setting command state from READY to SENT ct.c:965:ct_send() succeeded ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c528, 0xbfd8c524, 0x6914) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 01 9e 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 01 9e 00 37 01 00-81 01 00 00 00 21 00 e7 |.....7.. .....!..| 0010 58 02 09 04 d0 00 00 00-d1 7a 01 4d 00 69 00 63 |X....... .z.M.i.c| 0020 00 72 00 6f 00 73 00 6f-00 66 00 74 00 20 00 53 |.r.o.s.o .f.t. .S| 0030 00 51 00 4c 00 20 00 53-00 65 00 72 00 76 00 65 |.Q.L. .S .e.r.v.e| 0040 00 72 00 20 00 32 00 30-00 30 00 35 00 20 00 2d |.r. .2.0 .0.5. .-| 0050 00 20 00 39 00 2e 00 30-00 30 00 2e 00 31 00 33 |. .9...0 .0...1.3| 0060 00 39 00 39 00 2e 00 30-00 36 00 20 00 28 00 49 |.9.9...0 .6. .(.I| 0070 00 6e 00 74 00 65 00 6c-00 20 00 58 00 38 00 36 |.n.t.e.l . .X.8.6| 0080 00 29 00 20 00 0a 00 09-00 4f 00 63 00 74 00 20 |.). .... .O.c.t. | 0090 00 31 00 34 00 20 00 32-00 30 00 30 00 35 00 20 |.1.4. .2 .0.0.5. | 00a0 00 30 00 30 00 3a 00 33-00 33 00 3a 00 33 00 37 |.0.0.:.3 .3.:.3.7| 00b0 00 20 00 0a 00 09 00 43-00 6f 00 70 00 79 00 72 |. .....C .o.p.y.r| 00c0 00 69 00 67 00 68 00 74-00 20 00 28 00 63 00 29 |.i.g.h.t . .(.c.)| 00d0 00 20 00 31 00 39 00 38-00 38 00 2d 00 32 00 30 |. .1.9.8 .8.-.2.0| 00e0 00 30 00 35 00 20 00 4d-00 69 00 63 00 72 00 6f |.0.5. .M .i.c.r.o| 00f0 00 73 00 6f 00 66 00 74-00 20 00 43 00 6f 00 72 |.s.o.f.t . .C.o.r| 0100 00 70 00 6f 00 72 00 61-00 74 00 69 00 6f 00 6e |.p.o.r.a .t.i.o.n| 0110 00 0a 00 09 00 53 00 74-00 61 00 6e 00 64 00 61 |.....S.t .a.n.d.a| 0120 00 72 00 64 00 20 00 45-00 64 00 69 00 74 00 69 |.r.d. .E .d.i.t.i| 0130 00 6f 00 6e 00 20 00 6f-00 6e 00 20 00 57 00 69 |.o.n. .o .n. .W.i| 0140 00 6e 00 64 00 6f 00 77-00 73 00 20 00 4e 00 54 |.n.d.o.w .s. .N.T| 0150 00 20 00 35 00 2e 00 32-00 20 00 28 00 42 00 75 |. .5...2 . .(.B.u| 0160 00 69 00 6c 00 64 00 20-00 33 00 37 00 39 00 30 |.i.l.d. .3.7.9.0| 0170 00 3a 00 20 00 53 00 65-00 72 00 76 00 69 00 63 |.:. .S.e .r.v.i.c| 0180 00 65 00 20 00 50 00 61-00 63 00 6b 00 20 00 31 |.e. .P.a .c.k. .1| 0190 00 29 00 0a 00 fd 10 00-c1 00 01 00 00 00 |.)...... ......| token.c:512:processing result tokens. marker is 81(TDS7_RESULT) token.c:1528:processing TDS7 result metadata. mem.c:603:tds_free_all_results() token.c:1552:set current_results (1 column) to tds->res_info token.c:1563:setting up column 0 token.c:3379:adjust_character_column_size: Server charset: UCS-2LE Server column_size: 600 Client charset: ISO-8859-1 Client column_size: 300 token.c:1498:tds7_get_data_info: colname = (0 bytes) type = 39 (varchar) server's type = 231 (x UCS-2 varchar) column_varint_size = 2 column_size = 300 (600 on server) util.c:162:Changed query state from READING to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4049) token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c528, 0xbfd8c524, 0x6914) util.c:162:Changed query state from PENDING to READING token.c:512:processing result tokens. marker is d1(ROW) token.c:623:tds_process_tokens::SET_RETURN stopping on current token util.c:162:Changed query state from READING to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4040) ct.c:2261:ct_describe() ct.c:1887:_ct_get_client_type(type 39, user 0, size 300) ct.c:2282:ct_describe() datafmt->datatype = 0 server type 39 ct.c:1434:ct_bind() datafmt count = 1 column_number = 1 ct.c:1493:ct_fetch(0x827be68, -99999, -99999, -99999, 0xbfd8c77c) token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c528, (nil), 0x1608) util.c:162:Changed query state from PENDING to READING token.c:512:processing result tokens. marker is d1(ROW) token.c:2244:tds_process_row(): reading column 0 token.c:1986:tds_get_data: type 39, varint size 2 token.c:2050:tds_get_data(): wire column size is 378 util.c:162:Changed query state from READING to PENDING ct.c:1558:inside ct_fetch() process_row_tokens returned 1 ct.c:1708:_ct_bind_data() ct.c:1715:_ct_bind_data(): column 0 is type 39 and has length 189 ct.c:2000:_ct_get_server_type(0) ct.c:1887:_ct_get_client_type(type 39, user 0, size 300) cs.c:493:cs_convert(0x82781c8, 0xbfd8c408, 0x829e090, 0xbfd8c35c, 0xbfd8c585, 0xbfd8c780) ct.c:2000:_ct_get_server_type(0) ct.c:2000:_ct_get_server_type(0) cs.c:529:converting type 47 (189 bytes) to type = 47 (255 bytes) cs.c:543:cs_convert() srctype == desttype cs.c:575:cs_convert() desttype = character cs.c:654:cs_convert() returning CS_SUCCEED ct.c:1493:ct_fetch(0x827be68, -99999, -99999, -99999, 0xbfd8c77c) ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c528, 0xbfd8c524, 0x6914) util.c:162:Changed query state from PENDING to READING token.c:512:processing result tokens. marker is fd(DONE) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 1 util.c:110:logic error: cannot change query state from IDLE to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4052) ct.c:1262:ct_results() results state = 2 ct.c:1263:ct_results() command type = 148 ct.c:1264:ct_results() dynamic cmd = 0 ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c528, 0xbfd8c524, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:1796:ct_cmd_drop() ct.c:1827:ct_cmd_drop() : command entry found in list ct.c:1832:ct_cmd_drop() : relinking list ct.c:1839:ct_cmd_drop() : relinked list ct.c:2868:ct_capability() ct.c:3021:ct_capability returns success, value TRUE ct.c:641:ct_cmd_alloc() ct.c:216:setting command state from IDLE to IDLE ct.c:660:ct_cmd_alloc() : allocating command list to head ct.c:3045:ct_dynamic(717) ct.c:4535:_ct_allocate_dynamic() attaching dynamic command to head ct.c:216:setting command state from IDLE to READY ct.c:844:ct_send() command_type = 160 mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING write.c:134:tds_put_string converting 3 bytes of "@P1" write.c:162:tds_put_string wrote 6 bytes util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 03 01 00 b2 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........| 0010 26 04 00 00 00 63 20 00-00 00 09 04 d0 00 00 20 |&....c . ....... | 0020 00 00 00 40 00 50 00 31-00 20 00 76 00 61 00 72 |[email protected] . .v.a.r| 0030 00 63 00 68 00 61 00 72-00 28 00 32 00 35 00 35 |.c.h.a.r .(.2.5.5| 0040 00 29 00 00 00 63 56 00-00 00 09 04 d0 00 00 56 |.)...cV. .......V| 0050 00 00 00 49 00 4e 00 53-00 45 00 52 00 54 00 20 |...I.N.S .E.R.T. | 0060 00 49 00 4e 00 54 00 4f-00 20 00 74 00 65 00 73 |.I.N.T.O . .t.e.s| 0070 00 74 00 20 00 28 00 74-00 65 00 73 00 74 00 5f |.t. .(.t .e.s.t._| 0080 00 73 00 74 00 72 00 69-00 6e 00 67 00 29 00 20 |.s.t.r.i .n.g.). | 0090 00 56 00 41 00 4c 00 55-00 45 00 53 00 20 00 28 |.V.A.L.U .E.S. .(| 00a0 00 40 00 50 00 31 00 29-00 00 00 26 04 04 01 00 |[email protected].) ...&....| 00b0 00 00 - |..| ct.c:216:setting command state from READY to SENT ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c518, 0xbfd8c514, 0x6914) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 2f 00 37 01 00- |.../.7..| net.c:654:Received packet 0000 04 01 00 2f 00 37 01 00-ff 11 00 c3 00 00 00 00 |.../.7.. ........| 0010 00 79 00 00 00 00 ac 0d-00 00 01 00 00 00 00 26 |.y...... .......&| 0020 04 04 01 00 00 00 fe 00-00 e0 00 00 00 00 00 |........ .......| token.c:512:processing result tokens. marker is ff(DONEINPROC) token.c:2279:tds_process_end: more_results = 1 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2310: rows_affected = 0 token.c:512:processing result tokens. marker is 79(RETURNSTATUS) token.c:512:processing result tokens. marker is ac(PARAM) token.c:569:processing parameters for sp 11 token.c:571:calling tds_process_param_result token.c:1200:tds_process_param_result(0x827bb00, 0xbfd8c3a4) token.c:1584:tds_get_data_info(0x827bb00, 0x82aeaa0, 1) [for parameter]token.c:1647:processing result. type = 38(integer-null), varint_size 1 token.c:1668:processing result. column_size 4 token.c:1986:tds_get_data: type 38, varint size 1 token.c:2050:tds_get_data(): wire column size is 4 log.c:486:type integer-null has value 1 token.c:575:1 hidden return parameters token.c:512:processing result tokens. marker is fe(DONEPROC) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4053) ct.c:1099:ct_results() ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c518, 0xbfd8c514, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:3045:ct_dynamic(720) ct.c:4560:_ct_locate_dynamic() looking for DBD1 ct.c:4563:_ct_locate_dynamic() matching with DBD1 ct.c:216:setting command state from READY to READY ct.c:844:ct_send() command_type = 160 ct.c:891:ct_send(CS_DESCRIBE_INPUT) ct.c:216:setting command state from READY to SENT ct.c:1099:ct_results() ct.c:2317:ct_res_info() ct.c:2336:ct_res_info(): Number of columns is 0 ct.c:1099:ct_results() ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c518, 0xbfd8c514, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:3045:ct_dynamic(718) ct.c:4560:_ct_locate_dynamic() looking for DBD1 ct.c:4563:_ct_locate_dynamic() matching with DBD1 ct.c:3086:ct_dynamic() calling param_clear ct.c:216:setting command state from READY to READY ct.c:3105:ct_param() ct.c:3106:ct_param() data addr = 0x829e090 data length = 100 ct.c:4085: _ct_fill_param() status = 0 ct.c:2000:_ct_get_server_type(0) ct.c:844:ct_send() command_type = 160 ct.c:3998:paraminfoalloc: status = 0, maxlen 0 ct.c:3999:paraminfoalloc: name = , varint size 2 column_type 47 size 100, 100 column_cur_size 100 column_output = 0 ct.c:3827:paramrowalloc, size = 100, data = 0x82af760, row_size = 0 query.c:1674:tds_submit_execute() mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to QUERYING query.c:1357:tds_put_data_info putting status query.c:1453:tds_put_data: colsize = 100 query.c:1515:tds_put_data: not null param varint_size = 2 util.c:162:Changed query state from QUERYING to PENDING net.c:781:Sending packet 0000 03 01 00 99 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 00 00 af 64 00 09 04 |..&..... ....d...| 0030 d0 00 00 64 00 61 31 32-33 34 35 36 37 38 39 62 |...d.a12 3456789b| 0040 31 32 33 34 35 36 37 38-39 63 31 32 33 34 35 36 |12345678 9c123456| 0050 37 38 39 64 31 32 33 34-35 36 37 38 39 65 31 32 |789d1234 56789e12| 0060 33 34 35 36 37 38 39 66-31 32 33 34 35 36 37 38 |3456789f 12345678| 0070 39 67 31 32 33 34 35 36-37 38 39 68 31 32 33 34 |9g123456 789h1234| 0080 35 36 37 38 39 69 31 32-33 34 35 36 37 38 39 6a |56789i12 3456789j| 0090 31 32 33 34 35 36 37 38-39 |12345678 9| ct.c:216:setting command state from READY to SENT ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c2c8, 0xbfd8c2c4, 0x6914) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 1f 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 00 1f 00 37 01 00-ff 11 00 c3 00 01 00 00 |.....7.. ........| 0010 00 79 00 00 00 00 fe 00-00 e0 00 00 00 00 00 |.y...... .......| token.c:512:processing result tokens. marker is ff(DONEINPROC) token.c:2279:tds_process_end: more_results = 1 was_cancelled = 0 error = 0 done_count_valid = 1 token.c:2310: rows_affected = 1 util.c:162:Changed query state from READING to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4054) token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c2c8, 0xbfd8c2c4, 0x6914) util.c:162:Changed query state from PENDING to READING token.c:512:processing result tokens. marker is 79(RETURNSTATUS) token.c:512:processing result tokens. marker is fe(DONEPROC) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4053) ct.c:2317:ct_res_info() ct.c:2342:ct_res_info(): Number of rows is -1 ct.c:1099:ct_results() ct.c:2317:ct_res_info() ct.c:2342:ct_res_info(): Number of rows is -1 ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c2c8, 0xbfd8c2c4, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:3045:ct_dynamic(711) ct.c:4560:_ct_locate_dynamic() looking for DBD1 ct.c:4563:_ct_locate_dynamic() matching with DBD1 ct.c:216:setting command state from READY to READY ct.c:844:ct_send() command_type = 160 query.c:1775:tds_submit_unprepare() DBD1 mem.c:603: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:781: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 - |&......| ct.c:216:setting command state from READY to SENT ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c658, 0xbfd8c654, 0x6914) util.c:162:Changed query state from PENDING to READING net.c:600:Received header 0000 04 01 00 16 00 37 01 00- |.....7..| net.c:654:Received packet 0000 04 01 00 16 00 37 01 00-79 00 00 00 00 fe 00 00 |.....7.. y.......| 0010 e0 00 00 00 00 00 - |......| token.c:512:processing result tokens. marker is 79(RETURNSTATUS) token.c:512:processing result tokens. marker is fe(DONEPROC) token.c:2279:tds_process_end: more_results = 0 was_cancelled = 0 error = 0 done_count_valid = 0 token.c:2295:tds_process_end() state set to TDS_IDLE util.c:162:Changed query state from READING to IDLE token.c:2310: rows_affected = 0 util.c:110:logic error: cannot change query state from IDLE to PENDING ct.c:1156:ct_results() process_result_tokens returned 1 (type 4053) ct.c:1099:ct_results() ct.c:1099:ct_results() token.c:497:tds_process_tokens(0x827bb00, 0xbfd8c658, 0xbfd8c654, 0x6914) token.c:500:tds_process_tokens() state is COMPLETED ct.c:1156:ct_results() process_result_tokens returned 2 (type 4052) ct.c:216:setting command state from SENT to READY ct.c:4595:ct_deallocate_dynamic() : command entry found in list ct.c:4608:ct_deallocate_dynamic() : relinking list ct.c:4615:ct_deallocate_dynamic() : relinked list ct.c:1796:ct_cmd_drop() ct.c:1827:ct_cmd_drop() : command entry found in list ct.c:1832:ct_cmd_drop() : relinking list ct.c:1839:ct_cmd_drop() : relinked list ct.c:1850:ct_close() mem.c:603:tds_free_all_results() util.c:162:Changed query state from IDLE to DEAD ct.c:1862:ct_con_drop()