Skip to content

Instantly share code, notes, and snippets.

@capsandiego
Created March 16, 2021 12:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save capsandiego/d51367c34d506d37aa6c62b46d71e1b3 to your computer and use it in GitHub Desktop.
Save capsandiego/d51367c34d506d37aa6c62b46d71e1b3 to your computer and use it in GitHub Desktop.
log.c:168:Starting log file for FreeTDS 1.2
on 2021-03-16 08:20:03 with debug flags 0x4fff.
iconv.c:365:tds_iconv_open(0x55af92ffca30, UTF-8)
iconv.c:196:local name for ISO-8859-1 is ISO-8859-1
iconv.c:196:local name for UTF-8 is UTF-8
iconv.c:196:local name for UCS-2LE is UCS-2LE
iconv.c:196:local name for UCS-2BE is UCS-2BE
iconv.c:387:setting up conversions for client charset "UTF-8"
iconv.c:389:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
iconv.c:428:tds_iconv_open: done
net.c:391:Connecting with protocol version 7.1
net.c:318:Connecting to 10.253.185.203 port 1433
net.c:340:tds_setup_socket: connect(2) returned "Operation now in progress"
net.c:528:tds_open_socket() succeeded
packet.c:852: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 37 23 00 00 - |7#..|
packet.c:410: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 0e 00 0c |........ ........|
0020 b9 00 00 00 00 - |.....|
login.c:1281:detected crypt flag 0
tls.c:1013:setting default openssl cipher to:HIGH:!SSLv2:!aNULL:-DH
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:852:Sending packet
0000 12 01 01 4b 00 00 00 00-16 03 01 01 3e 01 00 01 |...K.... ....>...|
0010 3a 03 03 a0 25 13 f5 ca-f3 63 6d 7f a0 af a1 49 |:...%... .cm....I|
0020 54 6d a2 7b b8 38 58 4d-87 29 d4 ab b7 e6 e1 96 |Tm.{.8XM .)......|
0030 6e c4 12 20 ec 59 aa 9a-54 90 e0 6d 37 34 95 95 |n.. .Y.. T..m74..|
0040 04 14 f5 ad f3 05 04 2f-5c 7f e7 c2 e0 88 71 40 |......./ \.....q@|
0050 7c ac f2 a3 00 5c 13 02-13 03 13 01 c0 2c c0 30 ||....\.. .....,.0|
0060 cc a9 cc a8 c0 af c0 ad-c0 5d c0 61 c0 2b c0 2f |........ .].a.+./|
0070 c0 ae c0 ac c0 5c c0 60-c0 24 c0 28 c0 73 c0 77 |.....\.` .$.(.s.w|
0080 c0 23 c0 27 c0 72 c0 76-c0 0a c0 14 c0 09 c0 13 |.#.'.r.v ........|
0090 00 9d c0 a1 c0 9d c0 51-00 9c c0 a0 c0 9c c0 50 |.......Q .......P|
00a0 00 3d 00 c0 00 3c 00 ba-00 35 00 84 00 2f 00 41 |.=...<.. .5.../.A|
00b0 00 ff 01 00 00 95 00 0b-00 04 03 00 01 02 00 0a |........ ........|
00c0 00 0c 00 0a 00 1d 00 17-00 1e 00 19 00 18 00 23 |........ .......#|
00d0 00 00 00 16 00 00 00 17-00 00 00 0d 00 30 00 2e |........ .....0..|
00e0 04 03 05 03 06 03 08 07-08 08 08 09 08 0a 08 0b |........ ........|
00f0 08 04 08 05 08 06 04 01-05 01 06 01 03 03 02 03 |........ ........|
0100 03 01 02 01 03 02 02 02-04 02 05 02 06 02 00 2b |........ .......+|
0110 00 09 08 03 04 03 03 03-02 03 01 00 2d 00 02 01 |........ ....-...|
0120 01 00 33 00 26 00 24 00-1d 00 20 71 f8 2f a5 fb |..3.&.$. .. q./..|
0130 02 43 07 96 63 a2 0c 50-73 3b d4 22 51 33 7a b7 |.C..c..P s;."Q3z.|
0140 cb 14 cf 17 44 8b 91 3a-c2 68 56 |....D..: .hV|
packet.c:410:Received packet
0000 12 01 04 a0 00 00 00 00-16 03 03 04 93 02 00 00 |........ ........|
0010 51 03 03 60 50 a2 73 65-f8 78 0b e2 c7 a0 0b 3c |Q..`P.se .x.....<|
0020 aa fb 3c 7f e0 e2 72 e9-1b 57 14 4d 80 16 82 fc |..<...r. .W.M....|
0030 39 2f b5 20 df 3a 00 00-a9 e0 11 11 fc e2 cb b3 |9/. .:.. ........|
0040 84 dd 5f 8e 69 e6 98 62-67 43 c3 f4 25 74 29 29 |.._.i..b gC..%t))|
0050 95 83 ef 7d c0 30 00 00-09 00 17 00 00 ff 01 00 |...}.0.. ........|
0060 01 00 0b 00 03 0a 00 03-07 00 03 04 30 82 03 00 |........ ....0...|
0070 30 82 01 e8 a0 03 02 01-02 02 10 21 3b d1 df ef |0....... ...!;...|
0080 10 1a 9c 48 37 73 d9 06-65 17 bd 30 0d 06 09 2a |...H7s.. e..0...*|
0090 86 48 86 f7 0d 01 01 0b-05 00 30 3b 31 39 30 37 |.H...... ..0;1907|
00a0 06 03 55 04 03 1e 30 00-53 00 53 00 4c 00 5f 00 |..U...0. S.S.L._.|
00b0 53 00 65 00 6c 00 66 00-5f 00 53 00 69 00 67 00 |S.e.l.f. _.S.i.g.|
00c0 6e 00 65 00 64 00 5f 00-46 00 61 00 6c 00 6c 00 |n.e.d._. F.a.l.l.|
00d0 62 00 61 00 63 00 6b 30-20 17 0d 32 31 30 33 31 |b.a.c.k0 ..21031|
00e0 34 30 31 34 34 32 35 5a-18 0f 32 30 35 31 30 33 |4014425Z ..205103|
00f0 31 34 30 31 34 34 32 35-5a 30 3b 31 39 30 37 06 |14014425 Z0;1907.|
0100 03 55 04 03 1e 30 00 53-00 53 00 4c 00 5f 00 53 |.U...0.S .S.L._.S|
0110 00 65 00 6c 00 66 00 5f-00 53 00 69 00 67 00 6e |.e.l.f._ .S.i.g.n|
0120 00 65 00 64 00 5f 00 46-00 61 00 6c 00 6c 00 62 |.e.d._.F .a.l.l.b|
0130 00 61 00 63 00 6b 30 82-01 22 30 0d 06 09 2a 86 |.a.c.k0. ."0...*.|
0140 48 86 f7 0d 01 01 01 05-00 03 82 01 0f 00 30 82 |H....... ......0.|
0150 01 0a 02 82 01 01 00 a4-ef 3d b7 22 22 18 f1 67 |........ .=.""..g|
0160 b2 4f 43 dd 07 4a 2d 17-20 94 4c a4 b5 c3 85 32 |.OC..J-. .L....2|
0170 2b 69 10 f8 20 9b 8a 8a-62 1a 01 83 59 e7 ac a1 |+i.. ... b...Y...|
0180 f4 d3 e7 aa f1 19 8f fc-b1 8f 8c 02 da 71 7a 36 |........ .....qz6|
0190 f7 c3 2d f6 31 50 90 36-af e0 67 47 50 aa c8 2c |..-.1P.6 ..gGP..,|
01a0 bb 4b 3a 75 0f c6 a7 43-fd d2 24 93 83 94 a7 ba |.K:u...C ..$.....|
01b0 95 4a 33 04 89 de 6e a1-aa 12 48 a9 54 14 1f fd |.J3...n. ..H.T...|
01c0 ff 7b c3 07 6c 61 c0 5a-ff e5 8d 02 c2 ba d5 d2 |.{..la.Z ........|
01d0 9a 09 64 a6 9a 35 c7 50-a6 04 d3 a6 cc 4c 78 62 |..d..5.P .....Lxb|
01e0 1b cd 0c 50 23 f4 b7 8e-e5 1a a3 1a 07 1d 14 74 |...P#... .......t|
01f0 37 41 b6 7b 9f 2d f2 74-0a d8 eb 3b eb 74 9e e0 |7A.{.-.t ...;.t..|
0200 ec 60 06 4d 8d 30 70 79-0a c3 ac 55 0d 17 a8 7d |.`.M.0py ...U...}|
0210 20 ff 20 05 a3 53 85 3c-ba b0 13 52 86 26 bf d6 | . ..S.< ...R.&..|
0220 4e 59 87 a3 03 c2 dc d7-39 d0 43 c5 25 a7 3c 59 |NY...... 9.C.%.<Y|
0230 06 2c ce 29 be 6c 5f 72-d2 35 4e aa 70 d2 0e 1b |.,.).l_r .5N.p...|
0240 cd b9 c4 c1 e4 cd 08 b1-9f 02 62 bf ed de 0b 8a |........ ..b.....|
0250 71 73 e0 cc a3 c3 95 02-03 01 00 01 30 0d 06 09 |qs...... ....0...|
0260 2a 86 48 86 f7 0d 01 01-0b 05 00 03 82 01 01 00 |*.H..... ........|
0270 21 1a 00 b5 68 73 f8 8f-a8 9c 72 ec 2b 5c 51 ef |!...hs.. ..r.+\Q.|
0280 b2 07 79 08 2f 4d 7d 80-31 8a 17 d8 6b de fe ec |..y./M}. 1...k...|
0290 1c f3 3f 3d 92 d0 0b 81-6d a5 30 b0 66 19 92 b3 |..?=.... m.0.f...|
02a0 c9 e3 e9 bc 84 4a 82 12-8d 98 d3 12 47 c6 ff a4 |.....J.. ....G...|
02b0 86 f2 f6 85 90 27 e9 a1-de b4 38 80 2b 23 75 e0 |.....'.. ..8.+#u.|
02c0 2a ea 90 97 1d 32 1d bd-45 3a c5 de d9 ce fb ce |*....2.. E:......|
02d0 d9 c8 20 81 fd b8 39 06-58 84 0b 1b 8d f1 97 7c |.. ...9. X......||
02e0 73 04 27 3a 4d 06 fe 07-15 4e 67 80 b8 fd be 9f |s.':M... .Ng.....|
02f0 41 5b e9 8c 1d 1a 5e 6c-b0 d6 cd 1e 43 cf 2c c4 |A[....^l ....C.,.|
0300 79 d4 fa c3 c5 3d 64 09-c9 0a 51 c9 42 e1 be 01 |y....=d. ..Q.B...|
0310 6e 37 b5 c5 b4 46 c3 10-d2 e6 3e f3 61 66 4d f8 |n7...F.. ..>.afM.|
0320 54 1d 09 a9 50 a6 42 f6-ab 24 92 d4 5f d1 9d 41 |T...P.B. .$.._..A|
0330 9f 65 e0 cc d2 50 2b 0b-b6 91 d0 9a 19 0b c4 94 |.e...P+. ........|
0340 74 56 1c 48 ae 25 a2 a3-be a6 a9 1c fa 20 53 15 |tV.H.%.. ..... S.|
0350 7b 31 36 71 1a a1 05 6b-0f 91 6f c6 a2 0f 52 b7 |{16q...k ..o...R.|
0360 10 2e c4 77 0f be 9a dd-c7 e1 a5 19 d8 15 5a 40 |...w.... ......Z@|
0370 0c 00 01 28 03 00 1d 20-67 c3 6d 16 27 6e 2c c5 |...(... g.m.'n,.|
0380 2d 7d d0 91 c0 65 33 dd-be 61 02 1d ae 28 a7 8f |-}...e3. .a...(..|
0390 ce 81 b0 90 f5 cb ba 77-04 01 01 00 15 ee 70 16 |.......w ......p.|
03a0 8b 57 ca 3b 60 0e e5 80-e1 ad 5f e1 7b b1 99 a7 |.W.;`... .._.{...|
03b0 73 96 d2 6f 12 bf e8 0c-d0 c9 6b 27 3f 84 e8 8e |s..o.... ..k'?...|
03c0 5e 2f 5d c0 64 73 77 b3-dd 2c c3 c5 7b 3f de 22 |^/].dsw. .,..{?."|
03d0 78 20 17 ea 1d ba d5 1b-33 c9 b7 d1 24 14 a2 07 |x ...... 3...$...|
03e0 84 3b 10 39 1d 8d d6 5d-e2 6c b1 26 e3 30 d3 ec |.;.9...] .l.&.0..|
03f0 07 c8 6e 47 6b 38 2f a8-cf ba 8a 18 ce 81 dc 96 |..nGk8/. ........|
0400 90 ca 1a 5e 7b d6 b5 ac-de 98 17 56 c2 9c 84 28 |...^{... ...V...(|
0410 95 2f 1c cc 40 9b 40 77-9c e7 de 7e 18 b2 9d b5 |./..@.@w ...~....|
0420 35 ca c3 c3 8f cf 6d 55-56 8b bc 51 fa 61 72 bd |5.....mU V..Q.ar.|
0430 23 14 d4 30 31 2d b2 14-b4 a7 42 dc 8f 95 b7 5b |#..01-.. ..B....[|
0440 74 b2 aa f9 8d a6 95 c9-7e d6 a1 69 fa 27 52 68 |t....... ~..i.'Rh|
0450 f9 15 fc 90 e3 f8 f8 fc-3e c0 18 bc 29 52 ed 56 |........ >...)R.V|
0460 17 e9 76 7a 94 4b d4 cb-a1 27 df a4 36 8b df 26 |..vz.K.. .'..6..&|
0470 f8 95 6f 9d ba 50 be 04-a1 c0 48 d8 e7 3c a2 80 |..o..P.. ..H..<..|
0480 1d 40 df 40 89 f2 48 50-62 62 57 39 6e de 35 53 |.@.@..HP bbW9n.5S|
0490 71 87 cf 60 27 b8 27 14-62 ff 8d 85 0e 00 00 00 |q..`'.'. b.......|
tls.c:117:in tds_pull_func_login
tls.c:147:in tds_push_func_login
tls.c:117:in tds_pull_func_login
packet.c:852:Sending packet
0000 12 01 00 65 00 00 00 00-16 03 03 00 25 10 00 00 |...e.... ....%...|
0010 21 20 81 8c 8a ec 8a db-42 bf 28 b0 41 68 57 cf |! ...... B.(.AhW.|
0020 50 7b dd 7f 5b 4f e4 a2-13 d6 b2 29 1e 8a e2 f0 |P{..[O.. ...)....|
0030 08 4f 14 03 03 00 01 01-16 03 03 00 28 7e e9 dd |.O...... ....(~..|
0040 1b 60 9d 6d e4 12 a0 3c-be b2 8b 15 bc 57 3e f0 |.`.m...< .....W>.|
0050 2a 5d b4 4c 2e e9 b3 41-6e 11 1f 48 39 91 09 98 |*].L...A n..H9...|
0060 3d 07 40 8e c5 - |=.@..|
packet.c:410:Received packet
0000 12 01 00 3b 00 00 00 00-14 03 03 00 01 01 16 03 |...;.... ........|
0010 03 00 28 00 00 00 00 00-00 00 00 32 9b 0a 76 9c |..(..... ...2..v.|
0020 0a 97 60 72 33 1e 39 24-35 a3 ec 0a 0a 76 43 73 |..`r3.9$ 5....vCs|
0030 8a 74 35 33 8c a9 cd 30-8b a2 af |.t53...0 ...|
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:117:in tds_pull_func_login
tls.c:1049:handshake succeeded!!
login.c:1005:quietly sending TDS 7+ login packet
token.c:417:tds_process_login_tokens()
packet.c:410:Received packet
0000 04 01 01 b5 00 40 01 00-e3 2b 00 01 0e 43 00 44 |.....@.. .+...C.D|
0010 00 57 00 5f 00 48 00 61-00 72 00 6d 00 6f 00 6e |.W._.H.a .r.m.o.n|
0020 00 69 00 7a 00 65 00 64-00 06 6d 00 61 00 73 00 |.i.z.e.d ..m.a.s.|
0030 74 00 65 00 72 00 ab 84-00 45 16 00 00 02 00 2d |t.e.r... .E.....-|
0040 00 43 00 68 00 61 00 6e-00 67 00 65 00 64 00 20 |.C.h.a.n .g.e.d. |
0050 00 64 00 61 00 74 00 61-00 62 00 61 00 73 00 65 |.d.a.t.a .b.a.s.e|
0060 00 20 00 63 00 6f 00 6e-00 74 00 65 00 78 00 74 |. .c.o.n .t.e.x.t|
0070 00 20 00 74 00 6f 00 20-00 27 00 43 00 44 00 57 |. .t.o. .'.C.D.W|
0080 00 5f 00 48 00 61 00 72-00 6d 00 6f 00 6e 00 69 |._.H.a.r .m.o.n.i|
0090 00 7a 00 65 00 64 00 27-00 2e 00 0f 41 00 57 00 |.z.e.d.' ....A.W.|
00a0 53 00 55 00 31 00 2d 00-31 00 30 00 57 00 43 00 |S.U.1.-. 1.0.W.C.|
00b0 57 00 44 00 30 00 34 00-50 00 00 01 00 e3 08 00 |W.D.0.4. P.......|
00c0 07 05 09 04 d0 00 34 00-e3 17 00 02 0a 75 00 73 |......4. .....u.s|
00d0 00 5f 00 65 00 6e 00 67-00 6c 00 69 00 73 00 68 |._.e.n.g .l.i.s.h|
00e0 00 00 ab 78 00 47 16 00-00 01 00 27 00 43 00 68 |...x.G.. ...'.C.h|
00f0 00 61 00 6e 00 67 00 65-00 64 00 20 00 6c 00 61 |.a.n.g.e .d. .l.a|
0100 00 6e 00 67 00 75 00 61-00 67 00 65 00 20 00 73 |.n.g.u.a .g.e. .s|
0110 00 65 00 74 00 74 00 69-00 6e 00 67 00 20 00 74 |.e.t.t.i .n.g. .t|
0120 00 6f 00 20 00 75 00 73-00 5f 00 65 00 6e 00 67 |.o. .u.s ._.e.n.g|
0130 00 6c 00 69 00 73 00 68-00 2e 00 0f 41 00 57 00 |.l.i.s.h ....A.W.|
0140 53 00 55 00 31 00 2d 00-31 00 30 00 57 00 43 00 |S.U.1.-. 1.0.W.C.|
0150 57 00 44 00 30 00 34 00-50 00 00 01 00 ad 36 00 |W.D.0.4. P.....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 0e 00 0c b9 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:421:looking for login token, got e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:421:looking for login token, got ab(INFO)
token.c:130:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5701 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2369:msgno 5701 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:421:looking for login token, got e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2226:tds_process_env_chg(): 5 bytes of collation data received
token.c:2227:tds->conn->collation was
0000 00 00 00 00 00 - |.....|
iconv.c:825:setting server single-byte charset to "CP1252"
token.c:2236:tds->conn->collation now
0000 09 04 d0 00 34 - |....4|
token.c:421:looking for login token, got e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:421:looking for login token, got ab(INFO)
token.c:130:tds_process_default_tokens() marker is ab(INFO)
mem.c:656:tds_free_all_results()
token.c:2398:tds_process_info() reading message 5703 from server
token.c:2493:tds_process_info() calling client msg handler
odbc.c:2369:msgno 5703 20003
token.c:2510:tds_process_info() returning TDS_SUCCESS
token.c:421:looking for login token, got ad(LOGINACK)
token.c:347:server reports TDS version 71.0.0.1
token.c:349:Product name for 0x71000001 is 2000 SP1
token.c:383:Product version 8E000CB9
token.c:421:looking for login token, got e3(ENVCHANGE)
token.c:130:tds_process_default_tokens() marker is e3(ENVCHANGE)
token.c:2285:changing block size from 4096 to 4096
token.c:421:looking for login token, got fd(DONE)
token.c:130:tds_process_default_tokens() marker is fd(DONE)
token.c:2096:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2115: rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
token.c:444:tds_process_login_tokens() returning TDS_SUCCESS
odbc.c:5006:SQLGetFunctions: fFunction is 999
odbc.c:5928:SQLGetInfo(0x55af92ffb110, 167, 0x7ffd0787a120, 4, (nil))
odbc.c:5173:_SQLGetInfo(0x55af92ffb110, 167, 0x7ffd0787a120, 4, (nil))
odbc.c:1812:SQLAllocStmt(0x55af92ffb110, 0x55af9301bf50)
odbc.c:1706:_SQLAllocStmt(0x55af92ffb110, 0x55af9301bf50)
odbc.c:4498:SQLGetStmtAttr(0x55af930171d0, 10010, 0x7ffd0787ec78, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x55af930171d0, 10011, 0x7ffd0787ec78, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x55af930171d0, 10012, 0x7ffd0787ec78, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x55af930171d0, 10013, 0x7ffd0787ec78, 8, (nil))
odbc_export.h:851:SQLPrepare(0x55af930171d0, select top 1
-- CAST(ship_to_customer_name AS NVARCHAR(MAX)) as name1
CONVERT(NVARCHAR(MAX), CONVERT(NVARCHAR(MAX), ship_to_customer_name)) as Name2
from CDW_Harmonized.dbo.BACKLOG
where ship_to_country = 'China'
and ship_to_customer_name <> 'THERMO FISHER SCIENTIFIC CHINA'
and ship_to_customer_id = '0001152458', -3)
odbc.c:3578:SQLExecute(0x55af930171d0)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x55af930171d0)
odbc.c:3292:_SQLExecute() starting with state 0
mem.c:656:tds_free_all_results()
util.c:179:Changed query state from IDLE to WRITING
packet.c:852:Sending packet
0000 03 01 02 b3 00 00 01 00-ff ff 0d 00 00 00 00 01 |........ ........|
0010 26 04 00 00 00 63 00 00-00 00 09 04 d0 00 34 ff |&....c.. ......4.|
0020 ff ff ff 00 00 63 80 02-00 00 09 04 d0 00 34 80 |.....c.. ......4.|
0030 02 00 00 73 00 65 00 6c-00 65 00 63 00 74 00 20 |...s.e.l .e.c.t. |
0040 00 74 00 6f 00 70 00 20-00 31 00 20 00 0d 00 0a |.t.o.p. .1. ....|
0050 00 2d 00 2d 00 20 00 43-00 41 00 53 00 54 00 28 |.-.-. .C .A.S.T.(|
0060 00 73 00 68 00 69 00 70-00 5f 00 74 00 6f 00 5f |.s.h.i.p ._.t.o._|
0070 00 63 00 75 00 73 00 74-00 6f 00 6d 00 65 00 72 |.c.u.s.t .o.m.e.r|
0080 00 5f 00 6e 00 61 00 6d-00 65 00 20 00 41 00 53 |._.n.a.m .e. .A.S|
0090 00 20 00 4e 00 56 00 41-00 52 00 43 00 48 00 41 |. .N.V.A .R.C.H.A|
00a0 00 52 00 28 00 4d 00 41-00 58 00 29 00 29 00 20 |.R.(.M.A .X.).). |
00b0 00 61 00 73 00 20 00 6e-00 61 00 6d 00 65 00 31 |.a.s. .n .a.m.e.1|
00c0 00 0d 00 0a 00 43 00 4f-00 4e 00 56 00 45 00 52 |.....C.O .N.V.E.R|
00d0 00 54 00 28 00 4e 00 56-00 41 00 52 00 43 00 48 |.T.(.N.V .A.R.C.H|
00e0 00 41 00 52 00 28 00 4d-00 41 00 58 00 29 00 2c |.A.R.(.M .A.X.).,|
00f0 00 20 00 43 00 4f 00 4e-00 56 00 45 00 52 00 54 |. .C.O.N .V.E.R.T|
0100 00 28 00 4e 00 56 00 41-00 52 00 43 00 48 00 41 |.(.N.V.A .R.C.H.A|
0110 00 52 00 28 00 4d 00 41-00 58 00 29 00 2c 00 20 |.R.(.M.A .X.).,. |
0120 00 73 00 68 00 69 00 70-00 5f 00 74 00 6f 00 5f |.s.h.i.p ._.t.o._|
0130 00 63 00 75 00 73 00 74-00 6f 00 6d 00 65 00 72 |.c.u.s.t .o.m.e.r|
0140 00 5f 00 6e 00 61 00 6d-00 65 00 29 00 29 00 20 |._.n.a.m .e.).). |
0150 00 61 00 73 00 20 00 4e-00 61 00 6d 00 65 00 32 |.a.s. .N .a.m.e.2|
0160 00 0d 00 0a 00 66 00 72-00 6f 00 6d 00 20 00 43 |.....f.r .o.m. .C|
0170 00 44 00 57 00 5f 00 48-00 61 00 72 00 6d 00 6f |.D.W._.H .a.r.m.o|
0180 00 6e 00 69 00 7a 00 65-00 64 00 2e 00 64 00 62 |.n.i.z.e .d...d.b|
0190 00 6f 00 2e 00 42 00 41-00 43 00 4b 00 4c 00 4f |.o...B.A .C.K.L.O|
01a0 00 47 00 0d 00 0a 00 77-00 68 00 65 00 72 00 65 |.G.....w .h.e.r.e|
01b0 00 20 00 73 00 68 00 69-00 70 00 5f 00 74 00 6f |. .s.h.i .p._.t.o|
01c0 00 5f 00 63 00 6f 00 75-00 6e 00 74 00 72 00 79 |._.c.o.u .n.t.r.y|
01d0 00 20 00 3d 00 20 00 27-00 43 00 68 00 69 00 6e |. .=. .' .C.h.i.n|
01e0 00 61 00 27 00 0d 00 0a-00 61 00 6e 00 64 00 20 |.a.'.... .a.n.d. |
01f0 00 73 00 68 00 69 00 70-00 5f 00 74 00 6f 00 5f |.s.h.i.p ._.t.o._|
0200 00 63 00 75 00 73 00 74-00 6f 00 6d 00 65 00 72 |.c.u.s.t .o.m.e.r|
0210 00 5f 00 6e 00 61 00 6d-00 65 00 20 00 3c 00 3e |._.n.a.m .e. .<.>|
0220 00 20 00 27 00 54 00 48-00 45 00 52 00 4d 00 4f |. .'.T.H .E.R.M.O|
0230 00 20 00 46 00 49 00 53-00 48 00 45 00 52 00 20 |. .F.I.S .H.E.R. |
0240 00 53 00 43 00 49 00 45-00 4e 00 54 00 49 00 46 |.S.C.I.E .N.T.I.F|
0250 00 49 00 43 00 20 00 43-00 48 00 49 00 4e 00 41 |.I.C. .C .H.I.N.A|
0260 00 27 00 0d 00 0a 00 61-00 6e 00 64 00 20 00 73 |.'.....a .n.d. .s|
0270 00 68 00 69 00 70 00 5f-00 74 00 6f 00 5f 00 63 |.h.i.p._ .t.o._.c|
0280 00 75 00 73 00 74 00 6f-00 6d 00 65 00 72 00 5f |.u.s.t.o .m.e.r._|
0290 00 69 00 64 00 20 00 3d-00 20 00 27 00 30 00 30 |.i.d. .= . .'.0.0|
02a0 00 30 00 31 00 31 00 35-00 32 00 34 00 35 00 38 |.0.1.1.5 .2.4.5.8|
02b0 00 27 00 - |.'.|
util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x55af92ffce00, 0x7ffd0787eb20, 0x7ffd0787eb24, 0x6914)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 93 00 40 01 00-81 01 00 00 00 21 00 63 |.....@.. .....!.c|
0010 fe ff ff 7f 09 04 d0 00-34 00 00 05 4e 00 61 00 |........ 4...N.a.|
0020 6d 00 65 00 32 00 d1 10-64 75 6d 6d 79 20 74 65 |m.e.2... dummy te|
0030 78 74 70 74 72 00 00 00-64 75 6d 6d 79 54 53 00 |xtptr... dummyTS.|
0040 28 00 00 00 b3 6c 17 53-99 99 b3 6c cf 7e 4e 6d |(....l.S ...l.~Nm|
0050 00 5f d1 53 3a 53 d0 8f-b3 6c 27 59 53 90 1c 4e |._.S:S.. .l'YS..N|
0060 a7 4f 89 5b 5f 66 57 88-17 53 a7 4f ff 11 00 c1 |.O.[_fW. .S.O....|
0070 00 01 00 00 00 79 00 00-00 00 ac 0d 00 00 01 00 |.....y.. ........|
0080 00 00 00 26 04 04 01 00-00 00 fe 00 00 e0 00 00 |...&.... ........|
0090 00 00 00 - |...|
token.c:569:processing result tokens. marker is 81(TDS7_RESULT)
token.c:1574:processing TDS7 result metadata.
mem.c:656:tds_free_all_results()
token.c:1599:set current_results (1 column) to tds->res_info
token.c:1606:setting up 1 columns
token.c:1543:tds7_get_data_info:
colname = Name2
type = 35 (text)
server's type = 99 (UCS-2 text)
column_varint_size = 4
column_size = 2147483646 (2147483646 on server)
token.c:1615: name size/wsize type/wtype utype
token.c:1616: -------------------- --------------- --------------- -------
token.c:1621: Name2 2147483646/2147483646 35/99 0
util.c:179:Changed query state from READING to PENDING
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617: result_type=4049, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4049
odbc.c:3438:_SQLExecute: odbc_process_tokens returned result_type 4049
token.c:554:tds_process_tokens(0x55af92ffce00, 0x7ffd0787eb20, 0x7ffd0787eb24, 0x6914)
util.c:179:Changed query state from PENDING to READING
token.c:569:processing result tokens. marker is d1(ROW)
token.c:675:tds_process_tokens::SET_RETURN stopping on current token
util.c:179:Changed query state from READING to PENDING
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4040
odbc.c:3438:_SQLExecute: odbc_process_tokens returned result_type 4040
odbc.c:3601:SQLExecute returns SQL_SUCCESS
odbc.c:4611:_SQLRowCount(0x55af930171d0, 0x7ffd0787ed68), -1 rows
odbc.c:4622:SQLRowCount returns 0, row count -1
odbc.c:4530:SQLNumResultCols(0x55af930171d0, 0x7ffd0787ed70)
odbc_export.h:556:SQLDescribeCol(0x55af930171d0, 1, 0x7ffaa1c7d3da, 127, 0x7ffd0787ed16, 0x7ffaa1c7d3d8, 0x7ffd0787ed18, (nil), (nil))
odbc.c:2070:_SQLColAttribute(0x55af930171d0, 1, 6, (nil), 0, (nil), 0x7ffd0787ed20)
odbc.c:2112:SQLColAttribute: fDescType is 6
odbc.c:4049:SQLFetchScroll(0x55af930171d0, 1, 0)
odbc.c:3754:_SQLFetch(0x55af930171d0, 1, 0)
token.c:554:tds_process_tokens(0x55af92ffce00, 0x7ffd0787eb30, 0x7ffd0787eb34, 0x6508)
util.c:179:Changed query state from PENDING to READING
token.c:569:processing result tokens. marker is d1(ROW)
token.c:1951:tds_process_row(): reading column 0
data.c:719:tds_get_data: type 35, varint size 4
data.c:763:tds_get_data(): wire column size is 40
util.c:179:Changed query state from READING to PENDING
odbc.c:3616:odbc_process_tokens: tds_process_tokens returned 0
odbc.c:3617: result_type=4040, TDS_DONE_COUNT=0, TDS_DONE_ERROR=0
odbc.c:3689:odbc_process_tokens: returning result_type 4040
odbc.c:4914:SQLGetData(0x55af930171d0, 1, 1, 0x7ffaa1c8c100, 256, 0x7ffaa1c7d3d0)
convert_tds2sql.c:293:odbc_tds2sql: src is 99 dest = 1
odbc.c:4267:SQLCloseCursor(0x55af930171d0)
odbc.c:4165:_SQLFreeStmt(0x55af930171d0, 0, 0)
query.c:2031:tds_send_cancel: not in_cancel and not idle
query.c:2078:tds_send_cancel: sending cancel packet
packet.c:852:Sending packet
0000 06 01 00 08 00 00 01 00- |........|
token.c:554:tds_process_tokens(0x55af92ffce00, 0x7ffd07880664, (nil), 0x0)
util.c:179:Changed query state from PENDING to READING
token.c:569:processing result tokens. marker is ff(DONEINPROC)
token.c:2096:tds_process_end: more_results = 1
was_cancelled = 0
error = 0
done_count_valid = 1
token.c:2115: rows_affected = 1
token.c:569:processing result tokens. marker is 79(RETURNSTATUS)
token.c:569:processing result tokens. marker is ac(PARAM)
token.c:618:processing parameters for op 13
token.c:620:calling tds_process_param_result
token.c:1304:tds_process_param_result(0x55af92ffce00, 0x7ffd078805e0)
token.c:1647:tds_get_data_info(0x55af92ffce00, 0x55af9301a9c0, 1) [for parameter]
token.c:1709:processing result. type = 38(integer-null), varint_size 1
token.c:1714:processing result. column_size 4
data.c:719:tds_get_data: type 38, varint size 1
data.c:763:tds_get_data(): wire column size is 4
log.c:443:type integer-null has value 1
token.c:626:1 hidden return parameters
token.c:569:processing result tokens. marker is fe(DONEPROC)
token.c:2096:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2115: rows_affected = 0
packet.c:410:Received packet
0000 04 01 00 11 00 40 01 00-fd 20 00 fd 00 00 00 00 |.....@.. . ......|
0010 00 - |.|
token.c:569:processing result tokens. marker is fd(DONE)
token.c:2096:tds_process_end: more_results = 0
was_cancelled = 1
error = 0
done_count_valid = 0
token.c:2115: rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
util.c:179:Changed query state from READING to IDLE
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:179:Changed query state from IDLE to IDLE
odbc.c:4065:SQLFreeHandle(3, 0x55af930171d0)
odbc.c:4165:_SQLFreeStmt(0x55af930171d0, 1, 0)
query.c:1806:tds_submit_unprepare() svvtd2t8a1
mem.c:656:tds_free_all_results()
util.c:179:Changed query state from IDLE to WRITING
packet.c:852: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 - |&......|
util.c:179:Changed query state from WRITING to PENDING
token.c:554:tds_process_tokens(0x55af92ffce00, 0x7ffd07880710, 0x7ffd07880714, 0x100)
util.c:179:Changed query state from PENDING to READING
packet.c:410:Received packet
0000 04 01 00 16 00 40 01 00-79 00 00 00 00 fe 00 00 |.....@.. y.......|
0010 e0 00 00 00 00 00 - |......|
token.c:569:processing result tokens. marker is 79(RETURNSTATUS)
token.c:569:processing result tokens. marker is fe(DONEPROC)
token.c:2096:tds_process_end: more_results = 0
was_cancelled = 0
error = 0
done_count_valid = 0
token.c:2115: rows_affected = 0
token.c:2118:tds_process_end() state set to TDS_IDLE
util.c:179:Changed query state from READING to IDLE
mem.c:225:tds_dynamic_deallocated() : freeing dynamic_id svvtd2t8a1
util.c:83:logic error: cannot change query state from IDLE to PENDING
util.c:179:Changed query state from IDLE to IDLE
odbc.c:4742:SQLEndTran(2, 0x55af92ffb110, 1)
odbc.c:4720:_SQLTransact((nil), 0x55af92ffb110, 1)
odbc.c:4667:change_transaction(0x0x55af92ffb110,0)
odbc.c:5928:SQLGetInfo(0x55af92ffb110, 23, 0x55af92fe77e8, 2, 0x7ffd0788066e)
odbc.c:5173:_SQLGetInfo(0x55af92ffb110, 23, 0x55af92fe77e8, 2, 0x7ffd0788066e)
odbc.c:5928:SQLGetInfo(0x55af92ffb110, 24, 0x55af92fe77ea, 2, 0x7ffd0788066e)
odbc.c:5173:_SQLGetInfo(0x55af92ffb110, 24, 0x55af92fe77ea, 2, 0x7ffd0788066e)
odbc.c:2334:SQLDisconnect(0x55af92ffb110)
query.c:3757:tds_disconnect()
util.c:179:Changed query state from IDLE to DEAD
mem.c:656:tds_free_all_results()
odbc.c:4065:SQLFreeHandle(2, 0x55af92ffb110)
odbc.c:4091:_SQLFreeConnect(0x55af92ffb110)
bcp.c:673:_bcp_free_storage(0x55af92ffb110)
odbc.c:4065:SQLFreeHandle(1, 0x55af92ffc520)
odbc.c:4138:_SQLFreeEnv(0x55af92ffc520)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment