Skip to content

Instantly share code, notes, and snippets.

@capsandiego

capsandiego/PHP-BUG-80869-PHP7-V2

Created March 16, 2021 12:24
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/18b2cbb5f6f3e518f508c9b16335b513 to your computer and use it in GitHub Desktop.
Save capsandiego/18b2cbb5f6f3e518f508c9b16335b513 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PHP-BUG-80869-PHP7-V2
log.c:168:Starting log file for FreeTDS 1.2
on 2021-03-16 08:23:22 with debug flags 0x4fff.
iconv.c:365:tds_iconv_open(0x564efadf3cb0, 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 3d 27 00 00 - |='..|
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 39 a2 22 eb 5b-c2 0f 96 72 ab 0a ef 79 |:..9.".[ ...r...y|
0020 a4 46 43 2b 49 4a f9 fc-c6 ca da f3 a9 5d 27 74 |.FC+IJ.. .....]'t|
0030 83 ca 81 20 be 6d 0c ce-35 e2 9a 85 59 73 91 98 |... .m.. 5...Ys..|
0040 e1 a8 4f 0e fb 88 41 c1-4e 0b 3d af 93 29 f3 17 |..O...A. N.=..)..|
0050 47 8f 71 16 00 5c 13 02-13 03 13 01 c0 2c c0 30 |G.q..\.. .....,.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 00 c8 17 cc 8e |..3.&.$. .. .....|
0130 fe 03 95 ac dc d7 c9 88-ef be a0 1e d4 99 06 e8 |........ ........|
0140 2a 56 28 09 84 15 17 f9-dc a6 5f |*V(..... .._|
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 a3 3a 0c-ea 33 30 03 aa 1f 3b 18 |Q..`P.:. .30...;.|
0020 67 fe 34 02 9e 90 0e c9-4a 8f eb 51 4e 1d eb 42 |g.4..... J..QN..B|
0030 2d 32 1d 20 10 3c 00 00-80 8c 74 0a f9 f4 29 09 |-2. .<.. ..t...).|
0040 3d 87 92 be 86 28 98 c9-40 1f ba 5c d5 15 12 22 |=....(.. @..\..."|
0050 44 ec ca 56 c0 30 00 00-09 00 17 00 00 ff 01 00 |D..V.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-4a 35 27 87 12 e0 9c 6c |...(... J5'....l|
0380 68 0c 2b 03 93 20 b6 91-50 19 7e 0d c6 30 52 46 |h.+.. .. P.~..0RF|
0390 ef d6 33 89 51 44 02 30-04 01 01 00 8a 40 07 9c |..3.QD.0 .....@..|
03a0 d6 ef 99 8d c8 39 02 0e-9c 68 d5 d1 06 de c8 94 |.....9.. .h......|
03b0 6f 57 b7 cf 7e 24 41 56-f9 cf a3 01 21 41 db e6 |oW..~$AV ....!A..|
03c0 d1 8e 0c 90 eb a9 ab 87-6c 8c 0f 27 3f 7e a2 54 |........ l..'?~.T|
03d0 0f de b6 65 8d ee 63 f3-c4 dc e2 c2 d1 65 6d 10 |...e..c. .....em.|
03e0 b4 77 1e 2e e6 28 90 8f-f0 66 fa 75 51 3f 02 c6 |.w...(.. .f.uQ?..|
03f0 49 b0 e7 f1 0e 0a 57 58-b1 3b 0f 6d d0 38 fc 61 |I.....WX .;.m.8.a|
0400 54 73 80 6b 93 23 db 5f-4d 72 56 6b cc 8a 10 ae |Ts.k.#._ MrVk....|
0410 f8 5c 24 c8 8d fb 36 37-89 1c 91 9b b1 ec ea 59 |.\$...67 .......Y|
0420 a1 10 3b df ad 94 cb 51-dc e8 72 b8 74 15 fa 81 |..;....Q ..r.t...|
0430 78 42 d7 d2 b0 c9 61 de-9b f9 2e df b4 15 c9 c4 |xB....a. ........|
0440 26 fe b6 cc 4c 81 b7 45-93 d1 8f a8 f7 7c 23 80 |&...L..E .....|#.|
0450 4d 18 66 5b 83 81 a3 19-d5 07 0a df ed 4a f9 b5 |M.f[.... .....J..|
0460 9b 8d 15 5c 02 52 0c 53-9d 31 bd d8 7b 22 f2 84 |...\.R.S .1..{"..|
0470 cd 67 7a c4 d0 9a 97 af-8e 55 51 55 05 56 61 50 |.gz..... .UQU.VaP|
0480 57 0c 21 1a 28 fa 54 b1-6e ef 72 f2 af 85 eb a4 |W.!.(.T. n.r.....|
0490 b1 27 2d 06 c1 ac 38 24-bc 1b f6 38 0e 00 00 00 |.'-...8$ ...8....|
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 68 79 43 80 f8 a2-27 2e ec e6 2f 4b 1a 2a |! hyC... '.../K.*|
0020 c5 f4 5c d8 96 80 4f 56-86 6e cf b0 36 36 fb e0 |..\...OV .n..66..|
0030 8f 3f 14 03 03 00 01 01-16 03 03 00 28 88 86 c1 |.?...... ....(...|
0040 8d 5c dc e8 0c a2 be 72-7f 87 fa 49 5d 30 89 91 |.\.....r ...I]0..|
0050 07 50 61 bb 1e 77 2d 20-87 9c 69 f5 ab a5 10 24 |.Pa..w- ..i....$|
0060 f2 f5 af 7d 48 - |...}H|
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 5c 36 25 ab 9e |..(..... ...\6%..|
0020 cc 3d bb 3f c2 7c 6b a1-84 d8 5d fe 5b 14 d8 4b |.=.?.|k. ..].[..K|
0030 da 78 a6 7e b6 eb b8 eb-28 41 93 |.x.~.... (A.|
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(0x564efadf2390, 167, 0x7fff8c96d180, 4, (nil))
odbc.c:5173:_SQLGetInfo(0x564efadf2390, 167, 0x7fff8c96d180, 4, (nil))
odbc.c:1812:SQLAllocStmt(0x564efadf2390, 0x564efae10a70)
odbc.c:1706:_SQLAllocStmt(0x564efadf2390, 0x564efae10a70)
odbc.c:4498:SQLGetStmtAttr(0x564efae25ce0, 10010, 0x7fff8c971ce8, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x564efae25ce0, 10011, 0x7fff8c971ce8, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x564efae25ce0, 10012, 0x7fff8c971ce8, 8, (nil))
odbc.c:4498:SQLGetStmtAttr(0x564efae25ce0, 10013, 0x7fff8c971ce8, 8, (nil))
odbc_export.h:851:SQLPrepare(0x564efae25ce0, 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(0x564efae25ce0)
prepare_query.c:208:parsing 0 parameters
odbc.c:3275:_SQLExecute(0x564efae25ce0)
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(0x564efadf4080, 0x7fff8c971b90, 0x7fff8c971b94, 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(0x564efadf4080, 0x7fff8c971b90, 0x7fff8c971b94, 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(0x564efae25ce0, 0x7fff8c971dd8), -1 rows
odbc.c:4622:SQLRowCount returns 0, row count -1
odbc.c:4530:SQLNumResultCols(0x564efae25ce0, 0x7fff8c971de0)
odbc_export.h:556:SQLDescribeCol(0x564efae25ce0, 1, 0x7fa416e733da, 127, 0x7fff8c971da6, 0x7fa416e733d8, 0x7fff8c971da8, (nil), (nil))
odbc.c:2070:_SQLColAttribute(0x564efae25ce0, 1, 6, (nil), 0, (nil), 0x7fff8c971db0)
odbc.c:2112:SQLColAttribute: fDescType is 6
odbc.c:4049:SQLFetchScroll(0x564efae25ce0, 1, 0)
odbc.c:3754:_SQLFetch(0x564efae25ce0, 1, 0)
token.c:554:tds_process_tokens(0x564efadf4080, 0x7fff8c971bb0, 0x7fff8c971bb4, 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(0x564efae25ce0, 1, 1, 0x7fa416e86000, 256, 0x7fa416e733d0)
convert_tds2sql.c:293:odbc_tds2sql: src is 99 dest = 1
odbc.c:4267:SQLCloseCursor(0x564efae25ce0)
odbc.c:4165:_SQLFreeStmt(0x564efae25ce0, 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(0x564efadf4080, 0x7fff8c9735f4, (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(0x564efadf4080, 0x7fff8c973570)
token.c:1647:tds_get_data_info(0x564efadf4080, 0x564efae123e0, 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, 0x564efae25ce0)
odbc.c:4165:_SQLFreeStmt(0x564efae25ce0, 1, 0)
query.c:1806:tds_submit_unprepare() i8nm0kwka1
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(0x564efadf4080, 0x7fff8c9736a0, 0x7fff8c9736a4, 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 i8nm0kwka1
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, 0x564efadf2390, 1)
odbc.c:4720:_SQLTransact((nil), 0x564efadf2390, 1)
odbc.c:4667:change_transaction(0x0x564efadf2390,0)
odbc.c:5928:SQLGetInfo(0x564efadf2390, 23, 0x564efaddec78, 2, 0x7fff8c9735ee)
odbc.c:5173:_SQLGetInfo(0x564efadf2390, 23, 0x564efaddec78, 2, 0x7fff8c9735ee)
odbc.c:5928:SQLGetInfo(0x564efadf2390, 24, 0x564efaddec7a, 2, 0x7fff8c9735ee)
odbc.c:5173:_SQLGetInfo(0x564efadf2390, 24, 0x564efaddec7a, 2, 0x7fff8c9735ee)
odbc.c:2334:SQLDisconnect(0x564efadf2390)
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, 0x564efadf2390)
odbc.c:4091:_SQLFreeConnect(0x564efadf2390)
bcp.c:673:_bcp_free_storage(0x564efadf2390)
odbc.c:4065:SQLFreeHandle(1, 0x564efadf37a0)
odbc.c:4138:_SQLFreeEnv(0x564efadf37a0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment