rows method with SyBase driver always returns -1
Alan Mosca <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CA+WPPLPptRRA0XEtSfTyx37YC5-1dtwXcTZ9t4u8=OCMAALT4A@mail.gmail.com> |
Hello,
I am using the SyBase driver to connect to Sql Server 08 and after an
insert or an update the rows method always returns -1. I have attached a
TDSDUMP, and following is some sample code. Is this a bug or am I doing
something wrong?
Thank you!
--
Alan
#!/usr/bin/perl
my ($user, $pass, $server) = ('user', 'pass', 'server');
use DBI;
require DBD::Sybase;
# New TDS protocol
$ENV{TDSVER} = '8.0';
my $dbh = DBI->connect("dbi:Sybase:$server", $user, $pass,
{ RaiseError => 1,
PrintError => 0,
ShowErrorStatement => 1,
AutoCommit => 1,
FetchHashKeyName => 'NAME_lc',
syb_no_child_con => 1
})
or die "Could not make connection to database: $DBI::errstr";
###ON TEMP DATABASE
$dbh->do("create table #tbTemp (col1 int)");
$dbh->do("insert into #tbTemp values (1)");
#this prints -1
print $dbh->rows . "\n";
$dbh->do("update #tbTemp set col1 = 2 where col1 = 1");
#this prints -1
print $dbh->rows. "\n";
$dbh->do("drop table #tbTemp");
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
tds_dump.log
(application/octet-stream, 47 KB)
log.c:196:Starting log file for FreeTDS 0.91
on 2013-03-07 17:31:18 with debug flags 0x4fff.
iconv.c:330:tds_iconv_open(0x186a9e0, 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:349:setting up conversions for client charset "UTF-8"
iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
iconv.c:394:tds_iconv_open: done
net.c:205:Connecting to 149.85.127.34 port 1433 (TDS version 7.1)
net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:310:tds_open_socket() succeeded
util.c:156:Changed query state from DEAD to IDLE
net.c:743:Sending packet
0000 12 01 00 34 00 00 00 00-00 00 15 00 06 01 00 1b |...4.... ........|
0010 00 01 02 00 1c 00 0c 03-00 28 00 04 ff 08 00 01 |........ .(......|
0020 55 00 00 00 4d 53 53 51-4c 53 65 72 76 65 72 00 |U...MSSQ LServer.|
0030 1f 61 00 00 - |.a..|
net.c:557:Received header
0000 04 01 00 25 00 00 01 00- |...%....|
net.c:611:Received packet
0000 04 01 00 25 00 00 01 00-00 00 15 00 06 01 00 1b |...%.... ........|
0010 00 01 02 00 1c 00 01 03-00 1d 00 00 ff 0a 32 09 |........ ......2.|
0020 c4 00 00 00 00 - |.....|
login.c:1057:detected flag 0
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Allocating epoch #0
net.c:1259:GNUTLS: level 2:
ASSERT: gnutls_constate.c:695
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Allocating epoch #1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: RSA_AES_256_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: RSA_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: RSA_3DES_EDE_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: RSA_ARCFOUR_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: RSA_ARCFOUR_MD5
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_DSS_AES_256_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_DSS_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_DSS_3DES_EDE_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_DSS_ARCFOUR_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_RSA_AES_256_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_RSA_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Keeping ciphersuite: DHE_RSA_3DES_EDE_CBC_SHA1
net.c:1259:GNUTLS: level 2:
EXT[0x18a1550]: Sending extension SAFE RENEGOTIATION (1 bytes)
net.c:1259:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.2) DSA-SHA256
net.c:1259:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (4.1) RSA-SHA256
net.c:1259:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.1) RSA-SHA1
net.c:1259:GNUTLS: level 2:
EXT[SIGA]: sent signature algo (2.2) DSA-SHA1
net.c:1259:GNUTLS: level 2:
EXT[0x18a1550]: Sending extension SIGNATURE ALGORITHMS (10 bytes)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: CLIENT HELLO was sent [88 bytes]
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 88 bytes of Data
net.c:1259:GNUTLS: level 7:
HWRITE: enqueued 88. Total 88 bytes.
net.c:1259:GNUTLS: level 7:
HWRITE FLUSH: 88 bytes in buffer.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sending Packet[0] Handshake(22) with length: 88
net.c:1259:GNUTLS: level 7:
WRITE: enqueued 93 bytes for 0x186a9e0. Total 93 bytes.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sent Packet[1] Handshake(22) with length: 93
net.c:1259:GNUTLS: level 7:
HWRITE: wrote 88 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 7:
WRITE FLUSH: 93 bytes in buffer.
net.c:1242:in tds_push_func
net.c:1259:GNUTLS: level 7:
WRITE: wrote 93 bytes, 0 bytes left.
net.c:1201:in tds_pull_func
net.c:743:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 00 00 58 01 00 00 |...e.... ....X...|
0010 54 03 03 51 38 ce e6 bd-78 c0 95 fc ba 7a 3a d6 |T..Q8... x....z:.|
0020 57 91 ce 31 83 c1 e8 45-98 3d 2f d6 bd 38 d1 9b |W..1...E .=/..8..|
0030 79 f3 47 00 00 18 00 35-00 2f 00 0a 00 05 00 04 |y.G....5 ./......|
0040 00 38 00 32 00 13 00 66-00 39 00 33 00 16 01 00 |.8.2...f .9.3....|
0050 00 13 ff 01 00 01 00 00-0d 00 0a 00 08 04 02 04 |........ ........|
0060 01 02 01 02 02 - |.....|
net.c:1214:have 0
net.c:1218:before read
net.c:557:Received header
0000 12 01 02 69 00 00 00 00- |...i....|
net.c:611:Received packet
0000 12 01 02 69 00 00 00 00-16 03 01 02 5c 02 00 00 |...i.... ....\...|
0010 4d 03 01 51 38 ce e6 3b-fc 4c 16 19 d7 25 94 76 |M..Q8..; .L...%.v|
0020 a7 f7 cc 7e 95 5b 30 fa-39 a9 52 40 02 9b ab d6 |...~.[0. 9.R@....|
0030 f4 7e ca 20 20 32 00 00-44 f2 2a 41 aa 8e 98 7e |.~. 2.. D.*A...~|
0040 18 07 10 da 7b 0a 8c 1d-34 7c fb 78 b9 26 76 19 |....{... 4|.x.&v.|
0050 3a 19 05 2d 00 2f 00 00-05 ff 01 00 01 00 0b 00 |:..-./.. ........|
0060 02 03 00 02 00 00 01 fd-30 82 01 f9 30 82 01 62 |........ 0...0..b|
0070 a0 03 02 01 02 02 10 1f-dd 51 c3 a8 51 f1 9b 45 |........ .Q..Q..E|
0080 0d 14 40 ff b6 46 47 30-0d 06 09 2a 86 48 86 f7 |[email protected] ...*.H..|
0090 0d 01 01 05 05 00 30 3b-31 39 30 37 06 03 55 04 |......0; 1907..U.|
00a0 03 1e 30 00 53 00 53 00-4c 00 5f 00 53 00 65 00 |..0.S.S. L._.S.e.|
00b0 6c 00 66 00 5f 00 53 00-69 00 67 00 6e 00 65 00 |l.f._.S. i.g.n.e.|
00c0 64 00 5f 00 46 00 61 00-6c 00 6c 00 62 00 61 00 |d._.F.a. l.l.b.a.|
00d0 63 00 6b 30 1e 17 0d 31-33 30 32 31 37 30 30 35 |c.k0...1 30217005|
00e0 35 33 34 5a 17 0d 34 33-30 32 31 37 30 30 35 35 |534Z..43 02170055|
00f0 33 34 5a 30 3b 31 39 30-37 06 03 55 04 03 1e 30 |34Z0;190 7..U...0|
0100 00 53 00 53 00 4c 00 5f-00 53 00 65 00 6c 00 66 |.S.S.L._ .S.e.l.f|
0110 00 5f 00 53 00 69 00 67-00 6e 00 65 00 64 00 5f |._.S.i.g .n.e.d._|
0120 00 46 00 61 00 6c 00 6c-00 62 00 61 00 63 00 6b |.F.a.l.l .b.a.c.k|
0130 30 81 9f 30 0d 06 09 2a-86 48 86 f7 0d 01 01 01 |0..0...* .H......|
0140 05 00 03 81 8d 00 30 81-89 02 81 81 00 d9 f3 11 |......0. ........|
0150 aa 1d 82 71 7d 02 fa 0b-83 f9 6b 08 60 7f 90 c7 |...q}... ..k.`...|
0160 ad 51 b9 35 31 77 00 f6-31 99 0f 1e 1f a0 f4 1a |.Q.51w.. 1.......|
0170 c2 f0 4e 36 5f 85 ef f5-89 f3 db d9 26 e9 58 7a |..N6_... ....&.Xz|
0180 03 be 53 86 77 5f d2 54-f7 63 88 22 1f 1f 96 1d |..S.w_.T .c."....|
0190 24 83 63 ee 1e 6b b7 00-78 33 c4 14 b4 0e 38 6a |$.c..k.. x3....8j|
01a0 2f e1 ef 43 a5 04 f6 8c-eb 07 ff 17 b4 fc a9 28 |/..C.... .......(|
01b0 df 12 92 c5 1c e2 35 c2-82 d4 60 6a b9 a4 66 01 |......5. ..`j..f.|
01c0 52 29 e9 6e ef 6b 79 03-87 be a0 f4 cb 02 03 01 |R).n.ky. ........|
01d0 00 01 30 0d 06 09 2a 86-48 86 f7 0d 01 01 05 05 |..0...*. H.......|
01e0 00 03 81 81 00 69 7f 4e-d7 8e 39 25 3b 8a 57 c6 |.....i.N ..9%;.W.|
01f0 fc c2 40 d6 58 e0 39 00-de 4d c0 14 c2 97 52 ca |[email protected]. .M....R.|
0200 7c 25 ca eb 2b 69 d2 2b-e8 a9 f5 5b 1d 8c 23 88 ||%..+i.+ ...[..#.|
0210 64 c6 35 95 64 df ff 86-42 c4 e5 3c e3 7d 9e da |d.5.d... B..<.}..|
0220 a6 13 ba 38 fe c1 4e cf-1e 61 95 13 cd a7 a2 20 |...8..N. .a..... |
0230 3f 85 76 81 89 2f 7d 0a-6c c9 c6 83 86 49 1f 26 |?.v../}. l....I.&|
0240 04 71 ce e9 d9 83 17 71-2f a3 01 8b fe 22 fc 0a |.q.....q /...."..|
0250 c6 64 06 3c 63 c7 f5 7c-92 e6 e0 a3 86 9a e3 af |.d.<c..| ........|
0260 69 21 5a 0f cd 0e 00 00-00 |i!Z..... .|
net.c:1221:after read
net.c:1214:have 609
net.c:1225:read 5 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Expected Packet[0] Handshake(22) with length: 1
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Received Packet[0] Handshake(22) with length: 604
net.c:1201:in tds_pull_func
net.c:1214:have 604
net.c:1225:read 604 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 604 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 604 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 604 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 609 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Decrypted Packet[0] Handshake(22) with length: 604
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 604 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: SERVER HELLO was received [81 bytes]
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 77 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 77 bytes of Data
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Server's version: 3.1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: SessionID length: 32
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: SessionID: 2032000044f22a41aa8e987e180710da7b0a8c1d347cfb78b92676193a19052d
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Selected cipher suite: RSA_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 2:
EXT[0x18a1550]: Parsing extension 'SAFE RENEGOTIATION/65281' (1 bytes)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Safe renegotiation succeeded
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: CERTIFICATE was received [519 bytes]
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 515 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 169 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 515 bytes of Data
net.c:1259:GNUTLS: level 2:
ASSERT: ext_signature.c:393
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: SERVER HELLO DONE was received [4 bytes]
net.c:1259:GNUTLS: level 2:
ASSERT: gnutls_handshake.c:1369
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 519 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: CLIENT KEY EXCHANGE was sent [134 bytes]
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 4 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 7:
HWRITE: enqueued 134. Total 134 bytes.
net.c:1259:GNUTLS: level 7:
HWRITE FLUSH: 134 bytes in buffer.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sending Packet[1] Handshake(22) with length: 134
net.c:1259:GNUTLS: level 7:
WRITE: enqueued 139 bytes for 0x186a9e0. Total 139 bytes.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sent Packet[2] Handshake(22) with length: 139
net.c:1259:GNUTLS: level 7:
HWRITE: wrote 134 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 7:
WRITE FLUSH: 139 bytes in buffer.
net.c:1242:in tds_push_func
net.c:1259:GNUTLS: level 7:
WRITE: wrote 139 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 3:
REC[0x18a1550]: Sent ChangeCipherSpec
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sending Packet[2] Change Cipher Spec(20) with length: 1
net.c:1259:GNUTLS: level 7:
WRITE: enqueued 6 bytes for 0x186a9e0. Total 6 bytes.
net.c:1259:GNUTLS: level 7:
WRITE FLUSH: 6 bytes in buffer.
net.c:1242:in tds_push_func
net.c:1259:GNUTLS: level 7:
WRITE: wrote 6 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sent Packet[3] Change Cipher Spec(20) with length: 6
net.c:1259:GNUTLS: level 9:
INT: PREMASTER SECRET[48]: 030307e5904ff404911c4ffce4d2c2a7dced6c79c2955d68f47d12a0c75843a2b88faa19dda3d6d206c29ae0314584a7
net.c:1259:GNUTLS: level 9:
INT: CLIENT RANDOM[32]: 5138cee6bd78c095fcba7a3ad65791ce3183c1e845983d2fd6bd38d19b79f347
net.c:1259:GNUTLS: level 9:
INT: SERVER RANDOM[32]: 5138cee63bfc4c1619d7259476a7f7cc7e955b30fa39a95240029babd6f47eca
net.c:1259:GNUTLS: level 9:
INT: MASTER SECRET: 47a6a882383fd9914226f9d93d628ea865f07619774f747c8ff21e19fab732d08775f883d5fe5db99e01e1167b88120b
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Initializing epoch #1
net.c:1259:GNUTLS: level 9:
INT: KEY BLOCK[104]: d1aaad927884cbeebb29da7a75d5d94fe2edfa7738b69753edab4c28577a8415
net.c:1259:GNUTLS: level 9:
INT: CLIENT WRITE KEY [16]: 1df41ef831421ae0a43c5703938aa138
net.c:1259:GNUTLS: level 9:
INT: SERVER WRITE KEY [16]: b92ac93fdadd443602e7e7fad126c58a
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Epoch #1 ready
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Initializing internal [write] cipher sessions
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Start of epoch cleanup
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: End of epoch cleanup
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: recording tls-unique CB (send)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: FINISHED was sent [16 bytes]
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 7:
HWRITE: enqueued 16. Total 16 bytes.
net.c:1259:GNUTLS: level 7:
HWRITE FLUSH: 16 bytes in buffer.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sending Packet[0] Handshake(22) with length: 16
net.c:1259:GNUTLS: level 7:
WRITE: enqueued 53 bytes for 0x186a9e0. Total 53 bytes.
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Sent Packet[1] Handshake(22) with length: 53
net.c:1259:GNUTLS: level 7:
HWRITE: wrote 16 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 7:
WRITE FLUSH: 53 bytes in buffer.
net.c:1242:in tds_push_func
net.c:1259:GNUTLS: level 7:
WRITE: wrote 53 bytes, 0 bytes left.
net.c:1259:GNUTLS: level 2:
ASSERT: ext_session_ticket.c:710
net.c:1201:in tds_pull_func
net.c:743:Sending packet
0000 12 01 00 ce 00 00 00 00-16 03 01 00 86 10 00 00 |........ ........|
0010 82 00 80 d9 df ad 06 27-96 6f ca 6d 9e c4 1a 20 |.......' .o.m... |
0020 a9 06 97 fb 30 b7 6b 72-3c f5 85 54 16 d6 97 7e |....0.kr <..T...~|
0030 61 ea 71 6a cf dd dd a1-6b b0 83 3a fe 7a 5c 9f |a.qj.... k..:.z\.|
0040 78 1a 27 46 09 48 84 d1-9a 89 45 44 6d e8 1e 2f |x.'F.H.. ..EDm../|
0050 56 05 81 37 c6 26 41 57-df 93 cf ae 26 d1 97 d8 |V..7.&AW ....&...|
0060 b1 76 4c 70 08 86 4d 5f-f5 4b 91 34 6b 3e 51 c4 |.vLp..M_ .K.4k>Q.|
0070 d9 ec 1a 35 7a 33 b6 47-15 b4 ea d9 72 2b 18 47 |...5z3.G ....r+.G|
0080 26 b2 d0 c9 37 ea 28 bf-09 66 4a f1 7b ee ea f3 |&...7.(. .fJ.{...|
0090 ad f9 ea 14 03 01 00 01-01 16 03 01 00 30 64 73 |........ .....0ds|
00a0 27 a6 9a 16 11 01 80 24-00 68 da a3 ac 04 d1 d2 |'......$ .h......|
00b0 7e 30 28 ec 9b 63 e5 9c-fd 5c 3f 8a 6b 22 7d f0 |~0(..c.. .\?.k"}.|
00c0 da 33 d5 ca 0b d0 31 1d-d3 d8 47 d7 0d 3b |.3....1. ..G..;|
net.c:1214:have 0
net.c:1218:before read
net.c:557:Received header
0000 12 01 00 43 00 00 00 00- |...C....|
net.c:611:Received packet
0000 12 01 00 43 00 00 00 00-14 03 01 00 01 01 16 03 |...C.... ........|
0010 01 00 30 5e 23 93 9c 86-ca 18 59 ad 82 7a b2 0a |..0^#... ..Y..z..|
0020 7f 88 65 ac 2e da 18 bc-9a 86 a5 b4 f7 6d b4 d3 |..e..... .....m..|
0030 9e 02 ae be 43 b8 39 78-e3 69 cb 02 b9 1f 8a 2f |....C.9x .i...../|
0040 6e 04 af - |n..|
net.c:1221:after read
net.c:1214:have 59
net.c:1225:read 5 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Expected Packet[1] Change Cipher Spec(20) with length: 1
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Received Packet[1] Change Cipher Spec(20) with length: 1
net.c:1201:in tds_pull_func
net.c:1214:have 54
net.c:1225:read 1 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 1 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 1 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 1 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 6 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: ChangeCipherSpec Packet was received
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: Cipher Suite: RSA_AES_128_CBC_SHA1
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Start of epoch cleanup
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Epoch #0 freed
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: End of epoch cleanup
net.c:1201:in tds_pull_func
net.c:1214:have 53
net.c:1225:read 5 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 5 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 0 bytes into buffer. Adding 5 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 5 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Expected Packet[0] Handshake(22) with length: 1
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Received Packet[0] Handshake(22) with length: 48
net.c:1201:in tds_pull_func
net.c:1214:have 48
net.c:1225:read 48 bytes
net.c:1259:GNUTLS: level 7:
READ: Got 48 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
READ: read 48 bytes from 0x186a9e0
net.c:1259:GNUTLS: level 7:
RB: Have 5 bytes into buffer. Adding 48 bytes.
net.c:1259:GNUTLS: level 7:
RB: Requested 53 bytes
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Decrypted Packet[0] Handshake(22) with length: 16
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 16 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 1 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 3 bytes of Data(22)
net.c:1259:GNUTLS: level 3:
HSK[0x18a1550]: FINISHED was received [16 bytes]
net.c:1259:GNUTLS: level 6:
BUF[REC][HD]: Read 12 bytes of Data(22)
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Peeked 0 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Emptied buffer
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 4 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Inserted 12 bytes of Data
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1372:handshake succeeded!!
login.c:782:quietly sending TDS 7+ login packet
net.c:1259:GNUTLS: level 6:
BUF[HSK]: Cleared Data from buffer
net.c:1259:GNUTLS: level 4:
REC[0x18a1550]: Epoch #1 freed
token.c:328:tds_process_login_tokens()
net.c:557:Received header
0000 04 01 01 91 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 01 91 00 52 01 00-e3 1b 00 01 06 6d 00 61 |.....R.. .....m.a|
0010 00 73 00 74 00 65 00 72-00 06 6d 00 61 00 73 00 |.s.t.e.r ..m.a.s.|
0020 74 00 65 00 72 00 ab 72-00 45 16 00 00 02 00 25 |t.e.r..r .E.....%|
0030 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0040 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a .b.a.s.e|
0050 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n .t.e.x.t|
0060 00 20 00 74 00 6f 00 20-00 27 00 6d 00 61 00 73 |. .t.o. .'.m.a.s|
0070 00 74 00 65 00 72 00 27-00 2e 00 0e 57 00 43 00 |.t.e.r.' ....W.C.|
0080 4c 00 2d 00 53 00 51 00-4c 00 2d 00 50 00 52 00 |L.-.S.Q. L.-.P.R.|
0090 4f 00 44 00 30 00 31 00-00 01 00 e3 08 00 07 05 |O.D.0.1. ........|
00a0 09 04 d0 00 00 00 e3 17-00 02 0a 75 00 73 00 5f |........ ...u.s._|
00b0 00 65 00 6e 00 67 00 6c-00 69 00 73 00 68 00 00 |.e.n.g.l .i.s.h..|
00c0 ab 76 00 47 16 00 00 01-00 27 00 43 00 68 00 61 |.v.G.... .'.C.h.a|
00d0 00 6e 00 67 00 65 00 64-00 20 00 6c 00 61 00 6e |.n.g.e.d . .l.a.n|
00e0 00 67 00 75 00 61 00 67-00 65 00 20 00 73 00 65 |.g.u.a.g .e. .s.e|
00f0 00 74 00 74 00 69 00 6e-00 67 00 20 00 74 00 6f |.t.t.i.n .g. .t.o|
0100 00 20 00 75 00 73 00 5f-00 65 00 6e 00 67 00 6c |. .u.s._ .e.n.g.l|
0110 00 69 00 73 00 68 00 2e-00 0e 57 00 43 00 4c 00 |.i.s.h.. ..W.C.L.|
0120 2d 00 53 00 51 00 4c 00-2d 00 50 00 52 00 4f 00 |-.S.Q.L. -.P.R.O.|
0130 44 00 30 00 31 00 00 01-00 ad 36 00 01 71 00 00 |D.0.1... ..6..q..|
0140 01 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.|
0150 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.|
0160 65 00 72 00 76 00 65 00-72 00 00 00 00 00 0a 32 |e.r.v.e. r......2|
0170 09 c4 e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.......4 .0.9.6..|
0180 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ........|
0190 00 - |.|
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5701 from server
token.c:2659:tds_process_msg() calling client msg handler
ctutil.c:153:_ct_handle_server_message(0x18668f0, 0x186a9e0, 0x7fffa3dcc670)
ct.c:352:ct_con_props(0x170cce0, 33, 9108, 0x7fffa3dcb888, 8, (nil))
ct.c:354:ct_con_props() action = CS_GET property = 9108
ct.c:510:fetching userdata 0x185d480
token.c:2672:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2419:tds_process_env_chg(): 5 bytes of collation data received
token.c:2420:tds->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:988:setting server single-byte charset to "CP1252"
token.c:2430:tds->collation now
0000 09 04 d0 00 00 - |.....|
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:337:looking for login token, got ab(INFO)
token.c:122:tds_process_default_tokens() marker is ab(INFO)
token.c:2588:tds_process_msg() reading message 5703 from server
token.c:2659:tds_process_msg() calling client msg handler
ctutil.c:153:_ct_handle_server_message(0x18668f0, 0x186a9e0, 0x7fffa3dcc670)
ct.c:352:ct_con_props(0x170cce0, 33, 9108, 0x7fffa3dcb888, 8, (nil))
ct.c:354:ct_con_props() action = CS_GET property = 9108
ct.c:510:fetching userdata 0x185d480
token.c:2672:tds_process_msg() returning TDS_SUCCEED
token.c:337:looking for login token, got ad(LOGINACK)
token.c:373:server reports TDS version 71.0.0.1
token.c:375:Product name for 0x71000001 is 2000 SP1
token.c:337:looking for login token, got e3(ENVCHANGE)
token.c:122:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2477:changing block size from 4096 to 4096
token.c:337:looking for login token, got fd(DONE)
token.c:122:tds_process_default_tokens() marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
token.c:2370: rows_affected = 0
token.c:438:tds_process_login_tokens() returning TDS_SUCCEED
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:168:tds_put_string wrote 38 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743: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:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc788, 0x7fffa3dcc78c, 0x100)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 00 00 be 00 00 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc788, 0x7fffa3dcc78c, 0x100)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:650:leaving ct_connect() returning 1
ct.c:3382:ct_options(0x170cce0, 34, 5025, 0x7fffa3dccc44, -99999, (nil))
ct.c:3414:ct_options: CS_SET, option = 5025
ct.c:3612: tds_submit_optioncmd will be action(CS_SET) option(25) arg(0) arglen(1)
query.c:3328:tds_submit_optioncmd()
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 29 bytes of "SET IMPLICIT_TRANSACTIONS OFF"
write.c:168:tds_put_string wrote 58 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743: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:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcca68, 0x7fffa3dcca6c, 0x100)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 00 00 ba 00 00 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcca68, 0x7fffa3dcca6c, 0x100)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:667:ct_cmd_alloc(0x170cce0, 0x7fffa3dccbf8)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:684:ct_cmd_alloc() : allocating command list to head
ct.c:705:ct_command(0x186ad50, 148, 0x7fffa3dccc50, -9, -99999)
ct.c:844:_ct_initialise_cmd(0x186ad50)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:4042:rpc_clear((nil))
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from IDLE)
ct.c:866:ct_send(0x186ad50)
ct.c:868:ct_send() command_type = 148
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 16 bytes of "select @@version"
write.c:168:tds_put_string wrote 32 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743: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:237:ct_describe_cmd_state(2)
ct.c:237:ct_describe_cmd_state(3)
ct.c:225:setting command state to SENT (from READY)
ct.c:989:ct_send() succeeded
ct.c:1122:ct_results(0x186ad50, 0x7fffa3dccc34)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dccbd8, 0x7fffa3dccbdc, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 01 ac 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 01 ac 00 52 01 00-81 01 00 00 00 21 00 e7 |.....R.. .....!..|
0010 58 02 09 04 d0 00 00 00-d1 88 01 4d 00 69 00 63 |X....... ...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 38 00 20 00 52 |.r. .2.0 .0.8. .R|
0050 00 32 00 20 00 28 00 53-00 50 00 31 00 29 00 20 |.2. .(.S .P.1.). |
0060 00 2d 00 20 00 31 00 30-00 2e 00 35 00 30 00 2e |.-. .1.0 ...5.0..|
0070 00 32 00 35 00 30 00 30-00 2e 00 30 00 20 00 28 |.2.5.0.0 ...0. .(|
0080 00 58 00 36 00 34 00 29-00 20 00 0a 00 09 00 4a |.X.6.4.) . .....J|
0090 00 75 00 6e 00 20 00 31-00 37 00 20 00 32 00 30 |.u.n. .1 .7. .2.0|
00a0 00 31 00 31 00 20 00 30-00 30 00 3a 00 35 00 34 |.1.1. .0 .0.:.5.4|
00b0 00 3a 00 30 00 33 00 20-00 0a 00 09 00 43 00 6f |.:.0.3. .....C.o|
00c0 00 70 00 79 00 72 00 69-00 67 00 68 00 74 00 20 |.p.y.r.i .g.h.t. |
00d0 00 28 00 63 00 29 00 20-00 4d 00 69 00 63 00 72 |.(.c.). .M.i.c.r|
00e0 00 6f 00 73 00 6f 00 66-00 74 00 20 00 43 00 6f |.o.s.o.f .t. .C.o|
00f0 00 72 00 70 00 6f 00 72-00 61 00 74 00 69 00 6f |.r.p.o.r .a.t.i.o|
0100 00 6e 00 0a 00 09 00 53-00 74 00 61 00 6e 00 64 |.n.....S .t.a.n.d|
0110 00 61 00 72 00 64 00 20-00 45 00 64 00 69 00 74 |.a.r.d. .E.d.i.t|
0120 00 69 00 6f 00 6e 00 20-00 28 00 36 00 34 00 2d |.i.o.n. .(.6.4.-|
0130 00 62 00 69 00 74 00 29-00 20 00 6f 00 6e 00 20 |.b.i.t.) . .o.n. |
0140 00 57 00 69 00 6e 00 64-00 6f 00 77 00 73 00 20 |.W.i.n.d .o.w.s. |
0150 00 4e 00 54 00 20 00 36-00 2e 00 31 00 20 00 3c |.N.T. .6 ...1. .<|
0160 00 58 00 36 00 34 00 3e-00 20 00 28 00 42 00 75 |.X.6.4.> . .(.B.u|
0170 00 69 00 6c 00 64 00 20-00 37 00 36 00 30 00 30 |.i.l.d. .7.6.0.0|
0180 00 3a 00 20 00 29 00 20-00 28 00 48 00 79 00 70 |.:. .). .(.H.y.p|
0190 00 65 00 72 00 76 00 69-00 73 00 6f 00 72 00 29 |.e.r.v.i .s.o.r.)|
01a0 00 0a 00 fd 10 00 c1 00-01 00 00 00 |........ ....|
token.c:555:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1515:processing TDS7 result metadata.
mem.c:615:tds_free_all_results()
token.c:1540:set current_results (1 column) to tds->res_info
token.c:1547:setting up 1 columns
token.c:3418:adjust_character_column_size:
Server charset: UCS-2LE
Server column_size: 600
Client charset: UTF-8
Client column_size: 1200
token.c:1486:tds7_get_data_info:
colname = (0 bytes)
type = 39 (varchar)
server's type = 231 (x UCS-2 varchar)
column_varint_size = 2
column_size = 1200 (600 on server)
token.c:1556: name size/wsize type/wtype utype
token.c:1557: -------------------- --------------- --------------- -------
token.c:1567: 1200/600 39/231 0
util.c:156:Changed query state from READING to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4049)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dccbd8, 0x7fffa3dccbdc, 0x6914)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:666:tds_process_tokens::SET_RETURN stopping on current token
util.c:156:Changed query state from READING to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4040)
ct.c:2282:ct_describe(0x186ad50, 1, 0x7fffa3dccc90)
ct.c:1907:_ct_get_client_type(type 39, user 0, size 1200)
ct.c:2303:ct_describe() datafmt->datatype = 0 server type 39
ct.c:1457:ct_bind(0x186ad50, 1, 0x7fffa3dccc90, 0x7fffa3dccd40, 0x7fffa3dccc38, 0x7fffa3dccc32)
ct.c:1459:ct_bind() datafmt count = 1 column_number = 1
ct.c:1518:ct_fetch(0x186ad50, -99999, -99999, -99999, 0x7fffa3dccc3c)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dccbdc, (nil), 0x1608)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is d1(ROW)
token.c:2304:tds_process_row(): reading column 0
token.c:2049:tds_get_data: type 39, varint size 2
token.c:2109:tds_get_data(): wire column size is 392
util.c:156:Changed query state from READING to PENDING
ct.c:1583:inside ct_fetch() process_row_tokens returned 1
ct.c:1729:_ct_bind_data(0x160f1f0, 0x18a2030, 0x18a2030, 0)
ct.c:1736:_ct_bind_data(): column 0 is type 39 and has length 196
ct.c:1907:_ct_get_client_type(type 39, user 0, size 1200)
cs.c:523:cs_convert(0x160f1f0, 0x7fffa3dcca00, 0x18a2520, 0x7fffa3dccab0, 0x7fffa3dccd40, 0x7fffa3dccc38)
ct.c:2018:_ct_get_server_type(0)
ct.c:2018:_ct_get_server_type(0)
cs.c:569:converting type 47 (196 bytes) to type = 47 (255 bytes)
cs.c:583:cs_convert() srctype == desttype
cs.c:619:cs_convert() desttype = character
cs.c:66:cs_prretcode(1)
cs.c:703:cs_convert() returning CS_SUCCEED
ct.c:1518:ct_fetch(0x186ad50, -99999, -99999, -99999, 0x7fffa3dccc3c)
ct.c:1122:ct_results(0x186ad50, 0x7fffa3dccc34)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dccbd8, 0x7fffa3dccbdc, 0x6914)
util.c:156:Changed query state from PENDING to READING
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 1
util.c:104:logic error: cannot change query state from IDLE to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1285:ct_results() results state = 2
ct.c:1286:ct_results() command type = 148
ct.c:1287:ct_results() dynamic cmd = 0
ct.c:1122:ct_results(0x186ad50, 0x7fffa3dccc34)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dccbd8, 0x7fffa3dccbdc, 0x6914)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:1179:ct_results() process_result_tokens returned 2 (type 4052)
ct.c:237:ct_describe_cmd_state(3)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from SENT)
ct.c:1799:ct_cmd_drop(0x186ad50)
ct.c:1813:_ct_cmd_drop(0x186ad50, 1)
ct.c:1845:ct_cmd_drop() : command entry found in list
ct.c:1850:ct_cmd_drop() : relinking list
ct.c:1857:ct_cmd_drop() : relinked list
ct.c:667:ct_cmd_alloc(0x170cce0, 0x7fffa3dcc628)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:684:ct_cmd_alloc() : allocating command list to head
ct.c:705:ct_command(0x18a4820, 148, 0x18a47b0, -9, -99999)
ct.c:844:_ct_initialise_cmd(0x18a4820)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:4042:rpc_clear((nil))
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from IDLE)
ct.c:866:ct_send(0x18a4820)
ct.c:868:ct_send() command_type = 148
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 31 bytes of "create table #tbTemp (col1 int)"
write.c:168:tds_put_string wrote 62 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743:Sending packet
0000 01 01 00 46 00 00 01 00-63 00 72 00 65 00 61 00 |...F.... c.r.e.a.|
0010 74 00 65 00 20 00 74 00-61 00 62 00 6c 00 65 00 |t.e. .t. a.b.l.e.|
0020 20 00 23 00 74 00 62 00-54 00 65 00 6d 00 70 00 | .#.t.b. T.e.m.p.|
0030 20 00 28 00 63 00 6f 00-6c 00 31 00 20 00 69 00 | .(.c.o. l.1. .i.|
0040 6e 00 74 00 29 00 - |n.t.).|
ct.c:237:ct_describe_cmd_state(2)
ct.c:237:ct_describe_cmd_state(3)
ct.c:225:setting command state to SENT (from READY)
ct.c:989:ct_send() succeeded
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 00 00 c6 00 00 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1285:ct_results() results state = 0
ct.c:1286:ct_results() command type = 148
ct.c:1287:ct_results() dynamic cmd = 0
ct.c:2346:ct_res_info(0x18a4820, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is -1
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
ct.c:2346:ct_res_info(0x18a4820, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is -1
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:1179:ct_results() process_result_tokens returned 2 (type 4052)
ct.c:237:ct_describe_cmd_state(3)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from SENT)
ct.c:1799:ct_cmd_drop(0x18a4820)
ct.c:1813:_ct_cmd_drop(0x18a4820, 1)
ct.c:1845:ct_cmd_drop() : command entry found in list
ct.c:1850:ct_cmd_drop() : relinking list
ct.c:1857:ct_cmd_drop() : relinked list
ct.c:667:ct_cmd_alloc(0x170cce0, 0x7fffa3dcc628)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:684:ct_cmd_alloc() : allocating command list to head
ct.c:705:ct_command(0x18a4820, 148, 0x18a47b0, -9, -99999)
ct.c:844:_ct_initialise_cmd(0x18a4820)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:4042:rpc_clear((nil))
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from IDLE)
ct.c:866:ct_send(0x18a4820)
ct.c:868:ct_send() command_type = 148
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 30 bytes of "insert into #tbTemp values (1)"
write.c:168:tds_put_string wrote 60 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743:Sending packet
0000 01 01 00 44 00 00 01 00-69 00 6e 00 73 00 65 00 |...D.... i.n.s.e.|
0010 72 00 74 00 20 00 69 00-6e 00 74 00 6f 00 20 00 |r.t. .i. n.t.o. .|
0020 23 00 74 00 62 00 54 00-65 00 6d 00 70 00 20 00 |#.t.b.T. e.m.p. .|
0030 76 00 61 00 6c 00 75 00-65 00 73 00 20 00 28 00 |v.a.l.u. e.s. .(.|
0040 31 00 29 00 - |1.).|
ct.c:237:ct_describe_cmd_state(2)
ct.c:237:ct_describe_cmd_state(3)
ct.c:225:setting command state to SENT (from READY)
ct.c:989:ct_send() succeeded
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 10 00 c3 00 01 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 1
util.c:104:logic error: cannot change query state from IDLE to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1285:ct_results() results state = 0
ct.c:1286:ct_results() command type = 148
ct.c:1287:ct_results() dynamic cmd = 0
ct.c:2346:ct_res_info(0x18a4820, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is 1
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
ct.c:2346:ct_res_info(0x18a4820, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is 1
ct.c:1122:ct_results(0x18a4820, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:1179:ct_results() process_result_tokens returned 2 (type 4052)
ct.c:237:ct_describe_cmd_state(3)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from SENT)
ct.c:1799:ct_cmd_drop(0x18a4820)
ct.c:1813:_ct_cmd_drop(0x18a4820, 1)
ct.c:1845:ct_cmd_drop() : command entry found in list
ct.c:1850:ct_cmd_drop() : relinking list
ct.c:1857:ct_cmd_drop() : relinked list
ct.c:667:ct_cmd_alloc(0x170cce0, 0x7fffa3dcc628)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:684:ct_cmd_alloc() : allocating command list to head
ct.c:705:ct_command(0x18a20c0, 148, 0x18a2030, -9, -99999)
ct.c:844:_ct_initialise_cmd(0x18a20c0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:4042:rpc_clear((nil))
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from IDLE)
ct.c:866:ct_send(0x18a20c0)
ct.c:868:ct_send() command_type = 148
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 42 bytes of "update #tbTemp set col1 = 2 where col1 = 1"
write.c:168:tds_put_string wrote 84 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743:Sending packet
0000 01 01 00 5c 00 00 01 00-75 00 70 00 64 00 61 00 |...\.... u.p.d.a.|
0010 74 00 65 00 20 00 23 00-74 00 62 00 54 00 65 00 |t.e. .#. t.b.T.e.|
0020 6d 00 70 00 20 00 73 00-65 00 74 00 20 00 63 00 |m.p. .s. e.t. .c.|
0030 6f 00 6c 00 31 00 20 00-3d 00 20 00 32 00 20 00 |o.l.1. . =. .2. .|
0040 77 00 68 00 65 00 72 00-65 00 20 00 63 00 6f 00 |w.h.e.r. e. .c.o.|
0050 6c 00 31 00 20 00 3d 00-20 00 31 00 |l.1. .=. .1.|
ct.c:237:ct_describe_cmd_state(2)
ct.c:237:ct_describe_cmd_state(3)
ct.c:225:setting command state to SENT (from READY)
ct.c:989:ct_send() succeeded
ct.c:1122:ct_results(0x18a20c0, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 10 00 c5 00 01 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 1
util.c:104:logic error: cannot change query state from IDLE to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1285:ct_results() results state = 0
ct.c:1286:ct_results() command type = 148
ct.c:1287:ct_results() dynamic cmd = 0
ct.c:2346:ct_res_info(0x18a20c0, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is 1
ct.c:1122:ct_results(0x18a20c0, 0x7fffa3dcc600)
ct.c:2346:ct_res_info(0x18a20c0, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is 1
ct.c:1122:ct_results(0x18a20c0, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:1179:ct_results() process_result_tokens returned 2 (type 4052)
ct.c:237:ct_describe_cmd_state(3)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from SENT)
ct.c:1799:ct_cmd_drop(0x18a20c0)
ct.c:1813:_ct_cmd_drop(0x18a20c0, 1)
ct.c:1845:ct_cmd_drop() : command entry found in list
ct.c:1850:ct_cmd_drop() : relinking list
ct.c:1857:ct_cmd_drop() : relinked list
ct.c:667:ct_cmd_alloc(0x170cce0, 0x7fffa3dcc628)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:684:ct_cmd_alloc() : allocating command list to head
ct.c:705:ct_command(0x18a2030, 148, 0x186ae70, -9, -99999)
ct.c:844:_ct_initialise_cmd(0x18a2030)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:4042:rpc_clear((nil))
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(0)
ct.c:225:setting command state to IDLE (from IDLE)
ct.c:237:ct_describe_cmd_state(0)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from IDLE)
ct.c:866:ct_send(0x18a2030)
ct.c:868:ct_send() command_type = 148
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to QUERYING
write.c:140:tds_put_string converting 18 bytes of "drop table #tbTemp"
write.c:168:tds_put_string wrote 36 bytes
util.c:156:Changed query state from QUERYING to PENDING
net.c:743:Sending packet
0000 01 01 00 2c 00 00 01 00-64 00 72 00 6f 00 70 00 |...,.... d.r.o.p.|
0010 20 00 74 00 61 00 62 00-6c 00 65 00 20 00 23 00 | .t.a.b. l.e. .#.|
0020 74 00 62 00 54 00 65 00-6d 00 70 00 |t.b.T.e. m.p.|
ct.c:237:ct_describe_cmd_state(2)
ct.c:237:ct_describe_cmd_state(3)
ct.c:225:setting command state to SENT (from READY)
ct.c:989:ct_send() succeeded
ct.c:1122:ct_results(0x18a2030, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
util.c:156:Changed query state from PENDING to READING
net.c:557:Received header
0000 04 01 00 11 00 52 01 00- |.....R..|
net.c:611:Received packet
0000 04 01 00 11 00 52 01 00-fd 00 00 c7 00 00 00 00 |.....R.. ........|
0010 00 - |.|
token.c:555:processing result tokens. marker is fd(DONE)
token.c:2339:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2355:tds_process_end() state set to TDS_IDLE
util.c:156:Changed query state from READING to IDLE
token.c:2370: rows_affected = 0
util.c:104:logic error: cannot change query state from IDLE to PENDING
ct.c:1179:ct_results() process_result_tokens returned 1 (type 4052)
ct.c:1285:ct_results() results state = 0
ct.c:1286:ct_results() command type = 148
ct.c:1287:ct_results() dynamic cmd = 0
ct.c:2346:ct_res_info(0x18a2030, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is -1
ct.c:1122:ct_results(0x18a2030, 0x7fffa3dcc600)
ct.c:2346:ct_res_info(0x18a2030, 800, 0x18a41b8, -99999, (nil))
ct.c:2371:ct_res_info(): Number of rows is -1
ct.c:1122:ct_results(0x18a2030, 0x7fffa3dcc600)
token.c:540:tds_process_tokens(0x186a9e0, 0x7fffa3dcc568, 0x7fffa3dcc56c, 0x6914)
token.c:543:tds_process_tokens() state is COMPLETED
ct.c:1179:ct_results() process_result_tokens returned 2 (type 4052)
ct.c:237:ct_describe_cmd_state(3)
ct.c:237:ct_describe_cmd_state(2)
ct.c:225:setting command state to READY (from SENT)
ct.c:1799:ct_cmd_drop(0x18a2030)
ct.c:1813:_ct_cmd_drop(0x18a2030, 1)
ct.c:1845:ct_cmd_drop() : command entry found in list
ct.c:1850:ct_cmd_drop() : relinking list
ct.c:1857:ct_cmd_drop() : relinked list
ct.c:1868:ct_close(0x170cce0, 301)
mem.c:615:tds_free_all_results()
util.c:156:Changed query state from IDLE to DEAD
ct.c:1880:ct_con_drop(0x170cce0)