Created
March 16, 2021 12:21
-
-
Save capsandiego/d51367c34d506d37aa6c62b46d71e1b3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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