Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect execution of prepared statements with datetime #958

Closed
renecannao opened this issue Mar 16, 2017 · 0 comments
Closed

Incorrect execution of prepared statements with datetime #958

renecannao opened this issue Mar 16, 2017 · 0 comments
Assignees
Milestone

Comments

@renecannao
Copy link
Contributor

Issue reported on the forum .
Reproduced, and below is an extract from tcpdump:

17:36:21.663312 IP 127.0.0.1.41312 > 127.0.0.1.6033: Flags [P.], seq 70:132, ack 90, win 342, options [nop,nop,TS val 327763599 ecr 327763599], length 62
        0x0000:  4508 0072 22d3 4000 4006 19a9 7f00 0001  E..r".@.@.......
        0x0010:  7f00 0001 a160 1791 25a3 6488 cac3 2e1d  .....`..%.d.....
        0x0020:  8018 0156 fe66 0000 0101 080a 1389 468f  ...V.f........F.
        0x0030:  1389 468f 3a00 0000 1649 4e53 4552 5420  ..F.:....INSERT.
        0x0040:  494e 544f 206d 616e 795f 6461 7465 284e  INTO.many_date(N
        0x0050:  6f74 652c 4578 5f64 6174 6529 2056 414c  ote,Ex_date).VAL
        0x0060:  5545 5328 2766 726f 6d20 5275 6279 272c  UES('from.Ruby',
        0x0070:  3f29                                     ?)
17:36:21.666948 IP 127.0.0.1.59642 > 127.0.0.1.3306: Flags [P.], seq 244:306, ack 133, win 342, options [nop,nop,TS val 327763600 ecr 327763599], length 62
        0x0000:  4508 0072 34a3 4000 4006 07d9 7f00 0001  E..r4.@.@.......
        0x0010:  7f00 0001 e8fa 0cea 7fca 7306 ebe3 0168  ..........s....h
        0x0020:  8018 0156 fe66 0000 0101 080a 1389 4690  ...V.f........F.
        0x0030:  1389 468f 3a00 0000 1649 4e53 4552 5420  ..F.:....INSERT.
        0x0040:  494e 544f 206d 616e 795f 6461 7465 284e  INTO.many_date(N
        0x0050:  6f74 652c 4578 5f64 6174 6529 2056 414c  ote,Ex_date).VAL
        0x0060:  5545 5328 2766 726f 6d20 5275 6279 272c  UES('from.Ruby',
        0x0070:  3f29                                     ?)
17:36:21.667083 IP 127.0.0.1.3306 > 127.0.0.1.59642: Flags [P.], seq 133:185, ack 306, win 350, options [nop,nop,TS val 327763600 ecr 327763600], length 52
        0x0000:  4508 0068 4670 4000 4006 f615 7f00 0001  E..hFp@.@.......
        0x0010:  7f00 0001 0cea e8fa ebe3 0168 7fca 7344  ...........h..sD
        0x0020:  8018 015e fe5c 0000 0101 080a 1389 4690  ...^.\........F.
        0x0030:  1389 4690 0c00 0001 0001 0000 0000 0001  ..F.............
        0x0040:  0000 0000 1700 0002 0364 6566 0000 0001  .........def....
        0x0050:  3f00 0c3f 0000 0000 00fd 8000 0000 0005  ?..?............
        0x0060:  0000 03fe 0000 0200                      ........
17:36:21.667154 IP 127.0.0.1.6033 > 127.0.0.1.41312: Flags [P.], seq 90:142, ack 132, win 342, options [nop,nop,TS val 327763600 ecr 327763599], length 52
        0x0000:  4500 0068 6b4c 4000 4006 d141 7f00 0001  E..hkL@[email protected]....
        0x0010:  7f00 0001 1791 a160 cac3 2e1d 25a3 64c6  .......`....%.d.
        0x0020:  8018 0156 fe5c 0000 0101 080a 1389 4690  ...V.\........F.
        0x0030:  1389 468f 0c00 0001 0001 0000 0000 0001  ..F.............
        0x0040:  0000 0000 1700 0002 0364 6566 0000 0001  .........def....
        0x0050:  3f00 0c3f 0000 0000 00fd 8000 0000 0005  ?..?............
        0x0060:  0000 03fe 0000 0200                      ........
17:36:21.667337 IP 127.0.0.1.41312 > 127.0.0.1.6033: Flags [P.], seq 132:158, ack 142, win 342, options [nop,nop,TS val 327763600 ecr 327763600], length 26
        0x0000:  4508 004e 22d4 4000 4006 19cc 7f00 0001  E..N".@.@.......
        0x0010:  7f00 0001 a160 1791 25a3 64c6 cac3 2e51  .....`..%.d....Q
        0x0020:  8018 0156 fe42 0000 0101 080a 1389 4690  ...V.B........F.
        0x0030:  1389 4690 1600 0000 1701 0000 0000 0100  ..F.............
        0x0040:  0000 0001 0c00 07e1 0703 1011 2415       ............$.
17:36:21.667369 IP 127.0.0.1.59642 > 127.0.0.1.3306: Flags [P.], seq 306:329, ack 185, win 342, options [nop,nop,TS val 327763600 ecr 327763600], length 23
        0x0000:  4508 004b 34a4 4000 4006 07ff 7f00 0001  E..K4.@.@.......
        0x0010:  7f00 0001 e8fa 0cea 7fca 7344 ebe3 019c  ..........sD....
        0x0020:  8018 0156 fe3f 0000 0101 080a 1389 4690  ...V.?........F.
        0x0030:  1389 4690 1300 0000 1701 0000 0000 0100  ..F.............
        0x0040:  0000 0001 0c00 04e1 0711 00              ...........
@renecannao renecannao added this to the v1.3.5 milestone Mar 16, 2017
@renecannao renecannao self-assigned this Mar 16, 2017
@renecannao renecannao added the bug label Mar 16, 2017
renecannao added a commit that referenced this issue Mar 17, 2017
All date and time fields used in prepared statements were incorrectly parsed
renecannao added a commit that referenced this issue Mar 17, 2017
All date and time fields used in prepared statements were incorrectly parsed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant