forked from perl5-dbi/DBD-mysql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Changes
1920 lines (1544 loc) · 85.3 KB
/
Changes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
2018-10-25 Daniël van Eeden, Patrick Galbraith,
DBI/DBD community (4.050)
* Fix SQL syntax for statements that have "...limit = ?" #288
* Make tests pass on MySQL 4.1 #286
* Travis-CI: Install Test::Deep #281
* Fix undefined ssl_verify_set on MySQL 5.0 and before #283
* Fix compilation on MySQL 4.1 #283
* Move Travis to dbdeployer (#284) #284
* Fix compiling on 8.0.0 and 8.0.1 #285
* Fix compatibility with MariaDB 10.3 #291
2018-10-25 Daniël van Eeden, Patrick Galbraith,
DBI/DBD community (4.049)
* Fix MariaDB issue #262
* Various fixes for travis builds
* Fix to issue 187: Don't declare enum_type as static
* Fix regex for removing database from DSN again
* Allow to call $sth->mysql_async_ready and $sth->mysql_async_result more times without discarding result state 201
2018-09-15 Daniël van Eeden, Patrick Galbraith, Michiel Beijen,
DBI/DBD community (4.048)
* Fix corrupted META.json so cpan installations work as expected.
https://github.com/perl5-dbi/DBD-mysql/issues/263
2018-09-08 Daniël van Eeden, Patrick Galbraith, DBI/DBD community (4.047)
* Add options needed for public key based security.
* Allow several spaces after LIMIT clause.
* Basic GTID tracking.
* Fix GCC 8.1 warnings
* Fix warning: unused variable ‘buffer_len’
* Fix warning about bind->is_null assignment with incompatible pointer type
* Get rid of warning about unused variable ssl_verify_set
* Fix space/tab issue which leads to misleading indentation
* Change spaces/tabs to get rid of GCC8 warning
2018-03-09 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.046_01)
* Updated documentation re. multithreading (Daniël van Eeden)
* Remove #IFDEFs for code detecting ancient DBI versions. The minimum
DBI version we require is version 1.609 from 2009!
* ChopBlanks should not trim binary fields (urcheon)
* Skipped test which failed on OpenBSD because Proc::ProcessTable does not
come with a 'size' attribute on this platform (glasswalk3r, pali)
* Improved test suite with regards to MySQL 8.0
* Improved macOS installation notes.
* Use Devel::CheckLib 1.09 or newer, fixes
https://github.com/perl5-dbi/DBD-mysql/issues/109
* Specify bigint as test dependency
* Add recommends and suggests tests dependencies (pali)
* Check only for libs via Devel::CheckLib in Makefile.PL (pali)
* Remove param --with-mysql from Makefile.PL documentation (pali)
* Check if specified Makefile.PL settings are working (pali)
Fixes https://rt.cpan.org/Ticket/Display.html?id=119902
* Remember mysql_config value for Makefile.PL (pali)
* Locate MySQL libs using Devel::CheckLib (pali)
* Added a fix for 30insertfetch failure when using server-side prepared
statements. The stmt was being freed for DML statements before
the handle attribute was read, mysql_info was reading back nulls
2018-02-08 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.046)
* Version bump because of issue with META file in 4.045 release.
2018-02-06 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.045)
* Use API function for reconnect; fixes compilation on MariaDB 10.2.6+.
Fix provided by Pali.
* Fixed broken link to MySQL download page, provided by Mohammad S Anwar.
* Spelling fixes, provided by Ville Skyttä.
2018-01-22 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.044)
* Reapply https://github.com/perl5-dbi/DBD-mysql/pull/114
"Improve SSL settings, reflect changes for BACKRONYM and
Riddle vulnerabilities, enforce SSL encryption when mysql_ssl=1 is set"
Thank you to Pali Rohar, Daniël van Eeden, Booking.com, et al:w
* Fix parsing configure libs from mysql_config --libs output in Makefile.PL
Libraries in mysql_config --libs output can be specified by library name
with the -l prefix or by absolute path to library name without any prefix.
Parameters must start with a hyphen, so treat all options without leading
hyphen in mysql_config --libs output as libraries with full path.
Partially fixes bug https://rt.cpan.org/Public/Bug/Display.html?id=100898
Fix by Pali Rohár.
* Return INTs with ZEROFILL as strings. Reported by Knarf, fix by Pali Rohár.
https://rt.cpan.org/Public/Bug/Display.html?id=118977
* Correct require on relative path for perl 5.26. Fix by Grinnz.
https://github.com/perl5-dbi/DBD-mysql/pull/136
2017-06-29 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.043)
YOUR ATTENTION PLEASE, THIS IS A REVERT TO 4.041
This version is the same as 4.041 with all its bugs and
limitations. In version 4.042 there were some changes to Unicode handling
that turned out to be causing issues with existing implementations.
While it is possible to argue that the old behaviour was wrong and buggy,
lots of applications and scripts were depending on this behaviour so it
is NOT a good idea to change this.
There were lots of commits since 4.041, we'll add those back bit by bit
in a future release, excluding the ones which cause problems.
2017-??-?? Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.042_01)
* Use Devel::CheckLib 1.09 or newer, fixes
https://github.com/perl5-dbi/DBD-mysql/issues/109
* Improve CI testing on AppVeyor: caching, path to cpan, configure deps (pali)
* Specify bigint as test dependency.
2017-03-08 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.042)
* Full release to include development releases 4.041_2 and 4.041_1.
2017-02-28 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041_2)
* Statement handle now also has mysql_sock attribute, just as database handle.
(by Pali)
* Fix type conversions for magic types. Issue reported by Dmitriy Yatsenko and
Giovanni Bechis, fix by Pali.
https://lists.amavis.org/pipermail/amavis-users/2016-December/004674.html
https://github.com/perl5-dbi/DBD-mysql/issues/78
* Fix UTF8-encoding of table names, field names, warnings and error messages.
Reported by Tanabe Yoshinori, fix by Pali.
https://rt.cpan.org/Public/Bug/Display.html?id=120141
* Fix mysql_auto_reconnect when using mysql_server_prepare (pali). Reported by
Vladimir Marek.
https://github.com/perl5-dbi/DBD-mysql/pull/95
* Improve regex for removing database from dsn (pali)
https://rt.cpan.org/Public/Bug/Display.html?id=118837
* Locate MySQL libs using Devel::CheckLib (pali)
* Support async on Windows (pali)
* Fix test suite on range of older and newer MySQL and MariaDB versions
(https://github.com/perl5-dbi/DBD-mysql/pull/87)
* Fix compilation on MySQL 4.1 (pali)
* Do not leak dangling pointer to mysql result (pali)
* Fix logic when assigning to variable bind_comment_placeholders (pali)
* mysql_fd() still returned file descriptor after closing connection.
Reported by Larry Leszczynski, fixed by Pali Rohár.
(https://rt.cpan.org/Public/Bug/Display.html?id=110983)
* Fix parsing configure libs from mysql_config --libs output in Makefile.PL
Libraries in mysql_config --libs output can be specified by library name
with the -l prefix or by absolute path to library name without any prefix.
Parameters must start with a hyphen, so treat all options without leading
hyphen in mysql_config --libs output as libraries with full path.
Partially fixes bug https://rt.cpan.org/Public/Bug/Display.html?id=100898
Fix by Pali Rohár.
* Fix support for magic scalars (pali)
(https://github.com/perl5-dbi/DBD-mysql/pull/76)
2016-12-12 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041_1)
* Unicode fixes: when using mysql_enable_utf8 or mysql_enable_utf8mb4,
previous versions of DBD::mysql did not properly encode input statements
to UTF-8 and retrieved columns were always UTF-8 decoded regardless of the
column charset.
Fix by Pali Rohár.
Reported and feedback on fix by Marc Lehmann
(https://rt.cpan.org/Public/Bug/Display.html?id=87428)
Also, the UTF-8 flag was not set for decoded data:
(https://rt.cpan.org/Public/Bug/Display.html?id=53130)
* Return INTs with ZEROFILL as strings. Reported by Knarf, fix by Pali Rohár.
(https://rt.cpan.org/Public/Bug/Display.html?id=118977)
2016-11-28 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.041)
* Fix use-after-free for repeated fetchrow_arrayref calls when
mysql_server_prepare=1
Function dbd_st_fetch() via Renew() can reallocate output buffer for
mysql_stmt_fetch() call. But it does not update pointer to that buffer in
imp_sth->stmt structure initialized by mysql_stmt_bind_result() function.
That leads to use-after-free in any mysql function which access
imp_sth->stmt structure (e.g. mysql_stmt_fetch()).
This patch fix this problem and properly updates pointer in imp_sth->stmt
structure after Renew() call.
This is a medium level security issue to which the Debian security team
assigned identifier CVE-2016-1251. Discovered and fixed by Pali Rohár.
* auto_reconnect now also matches CR_SERVER_LOST, previously this only
matched CR_SERVER_GONE.
Fixes http://bugs.mysql.com/bug.php?id=27613
Fix suggested by Wouter de Jong.
* Fix compilation fixes (Pali Rohár).
2016-11-19 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.040)
* Since 4.038 we had problems compiling on big-endian architectures, such
as MIPS, s390 and Sparc. Thanks to Salvatore Bonaccorso @ Debian project
(https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=844538)
and Vladimir Marek (https://rt.cpan.org/Public/Bug/Display.html?id=118835)
for reporting the issues. Fix by Pali Rohár.
Fix integer types when server side prepare statements are enabled
Fixed problems:
* SQL_BIGINT was incorrectly handled as 32bit MYSQL_TYPE_LONG type instead
64bit MYSQL_TYPE_LONGLONG which led to integer overflow/underflow
* 32bit MYSQL_TYPE_LONG was used for perl's IV storage when IV was 64bit
and 64bit MYSQL_TYPE_LONGLONG was used when IV was 32bit
* All unsigned types were handled as signed, so all high positive values
were treated as negative
* Numeric conversions in perl which led to overflow/underflow was ignored
even when mysql strict mode was enabled
* Test t/41int_min_max.t was running only for normal non-prepared statements
* Test t/40server_prepare.t used incorrect SQL type for big (64bit) integers
2016-11-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.039)
* Fix for security issue Out-of-bounds read by DBD::mysql CVE-2016-1249 (pali)
2016-10-30 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.038_01)
* Fix compilation of embedded server (pali)
(https://github.com/perl5-dbi/DBD-mysql/pull/68)
* Fix compilation against libmariadbclient. First version by
H.Merijn Brand, improved by Bernt Johnsen @ Oracle.
* For efficiency use newSVpvn() instead newSVpv() where possible (pali)
* Correctly coerce fetched scalar values when mysql_server_prepare is
not used (pali)
* Add support for fetching columns of BIT type with
mysql_server_prepare = 1 (pali)
Fixes https://rt.cpan.org/Public/Bug/Display.html?id=88006
* Use correct format in printf instead of casting variable types (pali)
* Include errno.h for MYSQL_ASYNC because it uses errno variable (pali)
* Travis: also test on perl 5.22 and 5.24.
2016-10-19 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.038)
* Version 4.037_1 had fixes for MySQL 8.0 provided
Bernt Johnsen @ Oracle that were not in the Changelogs
(https://github.com/perl5-dbi/DBD-mysql/pull/56)
* Fixes for compiling against newer libmysqlclient on Windows (kmx)
* Fix unit test for 40server_prepare_crash on Windows (pali)
* Perl's IV in scalar can store 64bit integer when perl was compiled
with 64 bit support (default on 64bit linux with gcc). Use this
feature and stores MYSQL_TYPE_LONGLONG as integers instead of strings
when possible. (pali, https://github.com/perl5-dbi/DBD-mysql/pull/57)
2016-10-14 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.037_01)
* Newest versions of libmysqlclient and the MariaDB C connector no longer
export the __WIN__ macro. If this macro is not present we would not
compile in the poll.h-based async-support. Changed to use the _WIN32
macro instead. Thanks to Sergei Golubchik for suggesting the fix.
* Fix from Pali Rohár for use-after-free in prepared statements,
changes to bind logic, and added test 40server_prepare_crash.
2016-10-03 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.037)
* Security release to patch possible buffer overflow in unsafe sprintf with
variable length. Reported and fixed by Pali Rohár. This vulnerability
is present in all releases at least back to versions 3.0 of the
driver, which were released in 2005.
The CVE identifier for this vulnerability is CVE-2016-1246.
2016-08-23 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.036)
Stable version, to include all changes since 4.035.
2016-08-19 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.035_03)
* By mistake, when DBD::mysql was compiled against libmariadb, it
did not compile in SSL support.
Reported by Jitka Plesnikova @ Red Hat
(https://rt.cpan.org/Public/Bug/Display.html?id=116959)
(https://bugzilla.redhat.com/show_bug.cgi?id=1366773)
* If the database test server was not on localhost and the test database was
not yet created, we would not correctly create the test database.
Reported by Vladimir Marek.
(https://rt.cpan.org/Ticket/Display.html?id=112072)
2016-08-11 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.035_02)
* Test 56connattr.t failed when run when performance schema is enabled, but
tests were run as a user with limited permissions.
Reported by Jérôme Étévé.
(https://rt.cpan.org/Public/Bug/Display.html?id=115980)
* In 4.033_03 we added a patch from Petr Písař @ Red Hat for a problem on
64-bit big-endian systems. The patch was applied but the unit test was not,
also, there was no entry in the change log.
Unit test provided by Vladimir Marek.
t/40server_prepare.t test failed on s390x platform. Server-prepared
values of types int, smallint, and tinyint are passed to application
as 32-bit integer. The same buffer was interpreted as long integer
by DBD::MySQL. This caused misaligned read/write and bogus
interpretation of the values.
(https://rt.cpan.org/Public/Bug/Display.html?id=57266)
* Remove dropdb, createdb, reload and shutdown admin functions from perldoc.
These are deprecated by the C API.
Use 'CREATE DATABASE..', 'DROP DATABASE...' and other SQL commands instead.
* Test rt75353-innodb-lock-timeout.t fails on MySQL Server 5.1 and earlier
because innodb_lock_wait_timeout is not modifyable per session.
* Test rt25389-bin-case.t does not work on MySQL Server < 5.1, reported by
GAAS.
2016-08-01 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.035_01)
* Apparently, on t/31insertid.t, there is one test that fails when compiled
against libmysqlclient 5.7 or up; issuing a SELECT statement on the same
database handle that previously executed an INSERT clears
$dbh->{mysql_insertid}, while previously this was retained.
(https://rt.cpan.org/Ticket/Display.html?id=108000)
* Removed appveyor.yml and mysql.mtest from CPAN releases.
* Converted README.pod to README.md because of installation failures on
FreeBSD, reported by Don Randolph.
(https://rt.cpan.org/Public/Bug/Display.html?id=114177)
2016-07-09 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.035)
* Add DBI back to configure_requires, fix by miyagawa.
2016-07-06 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.034)
* Full version, to include all changes since 4.033.
2016-07-04 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.033_03)
* Check for errors after calling mysql_affected_rows(), by Pali.
(https://rt.cpan.org/Public/Bug/Display.html?id=75353)
* Fix reference to MySQL manual, chapter Character Set Support, suggested
by Slaven Rezić (https://rt.cpan.org/Public/Bug/Display.html?id=114148)
* Improve documentation on current database, suggested by Vladimir Marek.
(https://rt.cpan.org/Ticket/Display.html?id=112587)
2015-12-18 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.033_02)
* Compile against libssl by default. This allows to connect against remote
MySQL servers using SSL. Previously this was only achieved with an explicit
switch provided to Makefile.PL - if for some reason you can't or don't want
to link against libssl, you can use the new --nossl switch to Makefile.PL.
* Made tests more robust after CPAN Testers failures.
2015-12-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.033_01)
* Raise minimum DBI version to 1.609 (from 2009!) in order to make
tests pass on RHEL5.
* Add explicit documentation for how to enable SSL at build time,
provided by genio.
* Improve test suite to make it more robust using mixed versions of client and
server.
* Fix use after free error in my_login, provided by hannob.
* Add explicit instructions stating brackets are required around ipv6-addresses
in connection strings, provided by Kenny Gryp.
2015-10-26 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.033)
* Full-release to include 03.
2015-10-25 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.032_03)
* Use mysql_get_option to read net_buffer_length and mysql_get_parameter
where available, needed for MySQL 5.7.9. Patch from berntm @ Oracle.
https://github.com/perl5-dbi/DBD-mysql/pull/42
* Fix mysql_conn_attrs test when run against MySQL 5.1 server.
* Fix for memory leak to $sth->{ParamValues} , RT83051
https://rt.cpan.org/Public/Bug/Display.html?id=83051
* Fixes for running test suite on MySQL 5.7.
* Fix running test suite with InnoDB disabled, reported by bor.
2015-07-20 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.032)
* Full-release to include 02 and 01.
2015-06-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.032_02)
* Added support for utf8mb4 by Daniël van Eeden and Eric Herman (Booking.com)
* Added patch for connection attributes in MySQL 5.6.6+, by Daniël van Eeden
and Eric Herman (Booking.com).
2015-04-16 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.032_01)
* Fixed test rt88006-bit-prepare on MyISAM storage
(Reported both in RT102657 and by Scimon on github)
* Fix for https://rt.cpan.org/Public/Bug/Display.html?id=102717 "Fritz" Friedrich Haubensak (hsk AT fli-leibniz DOT de)
Vielen Danken!
* Corrected name ofINSTALL.pm in POD David Farrell <davidnmfarrell AT gmail DOT com>
Corrected name of INSTALL.pm in POD
2015-03-05 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.031)
* Added LICENSE
* Reworked installation documentation in POD.
* Allow use of bracketed IPv6 addresses in connection string (RT70640),
fix by Tim Mullin @ cPanel).
* Locate mysql_config in path on MSWin32 (RT94838, reported by CHORNY).
* Environment variable DBD_MYSQL_CONFIG actually works now.
* Makefile.PL now correcly handles MariaDB's mysql_config.
* Correct attribution to David Dick #86030: PATCH: adding statistics_info support
* Test suite can now be run in parallel. Fixes RT98994 reported by DOHERTY.
* Fixes for MySQL 5.6+ and for prepared statement handling (stevenh on github).
* Fix for RT100792, New test t/05dbcreate.t fails if user has no permissions.
* Fix for bit test (RT68374, BJDEAN@cpan.org) CaptTofu added 40bit.t to test.
2015-03-02 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.030_02)
* Reworked installation documentation in POD.
* Allow use of bracketed IPv6 addresses in connection string (RT70640),
fix by Tim Mullin @ cPanel).
* Locate mysql_config in path on MSWin32 (RT94838, reported by CHORNY).
* Environment variable DBD_MYSQL_CONFIG actually works now.
* Makefile.PL now correcly handles MariaDB's mysql_config.
2015-01-27 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.030_01)
* Correct attribution to David Dick #86030: PATCH: adding statistics_info support
* Test suite can now be run in parallel. Fixes RT98994 reported by DOHERTY.
* Fixes for MySQL 5.6+ and for prepared statement handling (stevenh on github).
* Fix for RT100792, New test t/05dbcreate.t fails if user has no permissions.
* Fix for bit test (RT68374, BJDEAN@cpan.org) CaptTofu added 40bit.t to test.
2014-12-08 Patrick Galbraith (aka CaptTofu) and community (4.029)
* Added fix to tests to create test database if not exists (contstant failure on Travis) (CaptTofu)
* Support the fraction of (Oracle) MySQL Fabric that is supported by the most recent Connector/C (Steffen Mueller smueller<at>cpan<dot>org
* Statistics Info Milan ¿orm <sorm<at>is4u<dot>cz> for work on statistics_info
* Fix for RT 97625, use after free(), Reini Urban rurban<at>cpan<dot>org
2014-08-01 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.028)
* Fixed bug in mysql.xs where dbh was being used as error code
* RT #97570: fix wrong salloc free in mysql_st_internal_execute - (Reini Urban, cPanel)
* Fix RT #97625 use-after-free in mysql_dr_error, and #86153 - (Reini Urban, cPanel)
* find mysql.h for MariaDB on Win32 (Graham Ollis)
* Update mysql.pm to work with ipv6 and ipv4 addresses (katyavoid)
2014-03-19 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.027)
* Added more OS X notes and fixed compiler warnings
* Skip tests if test database is not present-RT92330 (zefram <zefram at fysh dot org>
* metacpan.org and search.cpan.org didn't display module POD, caused by fix for RT90101. Reported by Oleg, RT92350.
2014-01-15 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.026)
* t/29warnings.t fails on MySQL Server 5.1.something - Reported by RT91202, Gisle Aas. Now is handled depending on version.
* README.pod misses proper NAME heading - RT90101 - Damyan Ivanov, Debian Perl Group
* Added fix and test for RT91715
* Added feature from Jacob Gelbman (cPanel) mysql_skip_secure_auth
2013-11-05 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.025)
* Set with parentheses and column_info - RT50304 - reported and fixed by Kevin Bosak.
* Fix method redefinition warnings in threads on Perl >= 5.16 - Dagfinn Ilmari Mannsåker
* use strict and warnings everywhere.
* Minimum perl version is now 5.8.1, just as for DBI.
* Improved database version check so tests run correctly on MariaDB 10.
* Fix manifest - RT89106, reported by Joe Grasse.
* set auto_increment_offset explicitly to make tests pass if they are set on server - RT83487, reported by Ian Barton.
* Assume 'localhost' when testport is set but no testhost in Makefile.PL - RT83496, reported by Philip Stoev.
* Corrected documentation for mysql_init_command option - Alexey Molchanov <alexey.molchanov@portaone.com>
* Skip stored procedure tests if user is unpriviliged - RT83348 - Chris Weyl <cweyl@alumni.drew.edu>
* Fix example in POD doc for NUM_OF_FIELDS - RT36730, reported by tapoutmma.
* Fix for memory leak (RT86153) when connecting with incorrect password
* Bail if connect fails early on (RT31823)
2013-09-17 Michiel Beijen, Patrick Galbraith, DBI/DBD community (4.024)
* Fix memory leak if mysql_server_prepare is enabled - RT76462 - Masahiro Chiba
* Small dist improvements: Michiel Beijen <michiel.beijen@otrs.com>
* Undefined $DBI::errstr on execute fail on Windows: Michiel Beijen <michiel.beijen@otrs.com>
* Better diagnostics for 80procs.t Fixes RT#71199: Alexandr Ciornii <alexchorny@gmail.com>
* Fix #64013: INSTALL.pod is shown with 'man install': Juergen Weigert <jw@suse.com>
* Added 'testport' to keys in Makefile.PL Fixes RT#83492: Michiel Beijen <michiel.beijen@otrs.com>
* Fixed test 70takeimp warning. Michiel Beijen <michiel.beijen@otrs.com>
* Made test t/87async.t not stop on Win32. Michiel Beijen <michiel.beijen@otrs.com>
* Update github location. Update support information. Michiel Beijen <michiel.beijen@otrs.com>
* POD Fixes Patch from RT77043 by Gunnar Wolf, Debian Perl Group. Michiel Beijen <michiel.beijen@otrs.com>
2013-04-12 Patrick Galbraith et open source community <patg at patg dot net> (4.023)
Fix memory leak if mysql_server_prepare is enabled.
* Fix primary_key_info result ordering - https://github.com/CaptTofu/DBD-mysql/pull/39 - Dagfinn Ilmari Mannsåker
* allow compilation with msvc - https://github.com/CaptTofu/DBD-mysql/pull/37 - Walde Christian
* just to set MYSQL_OPT_WRITE_TIMEOUT and MYSQL_OPT_READ_TIMEOUT by dsn - https://github.com/CaptTofu/DBD-mysql/pull/36 - Naosuke Yokoe
* just remove unnecessary "my" - https://github.com/CaptTofu/DBD-mysql/pull/34 - Shoichi Kaji
* eval $ExtUtils::MakeMaker::VERSION requires for old ExtUtils::MakeMaker - https://github.com/CaptTofu/DBD-mysql/pull/32 - Daisuke Murase
* Updated documentation to reflect that bugs will be reported at rt.cpan.org
* Updated version
* Chased tail finding issue with -1 being converted to max unsigned int in PS mode
* Various typos and other unicode fixes dsteinbrunner <dsteinbrunner@gmail.com>
* Fixed permissions on files.
* Clarified documentation and bumped version for next release
2012-08-28 Patrick Galbraith et open source community <patg at patg dot net> (4.022)
* Fixes for Win32 from Rom Hoelz (https://github.com/hoelzro)
* Pulling back in work for 4.021 that didn't get pushed and much other work from Chip Salzenberg (https://github.com/chipdude)
* Column info order fix from Tokuhiro Matsuno (https://github.com/tokuhirom)
* Fix AutoCommit comparison logic to avoid spurious commands to mysql from Matthew Horsfall (https://github.com/wolfsage)
* server_preapre can't bind placeholder on comment. from Misahiro Chiba (https://github.com/nihen)
* server_prepare; data is null, allocate big memory bug. from Misahiro Chiba (https://github.com/nihen)
2012-04-15 Patrick Galbraith (work of others) <patg at patg dot net> (4.021)
* Fix to enable PERL_NO_GET_CONTEXT to spee up DBD on thread Perls
(Dave Mitchell <davem at iabyn dot com>) Thank you!
* Fix to is_prefix not being exported by mysql Aran Deltax <bluefeet at gmail dot com> Thank you!
* Eliminate DBIS usage Dagfinn Ilmari Mannsåker <ilmari at ilmari dot org> Thank you!
* Enhanced / Fixed server side prepared statement checks (Steven Hartland) Thank you!
* Fix missprint in doc of DBD::mysql of mysql_bind_type_guessing (Perlover http://blog.perloever.com) Thank you!
* Misprint in lib/DBD/mysql.pm (Perlover) Thank you!
2011-08-15 Patrick Galbraith <patg at patg dot net> (4.020)
* Numerous (!! Thank you!!) fixes for prepared statements: Masahiro Chiba <nihen at megabbs
dot com>
- Chop blanks fixed
- UTF8 improvements
- fixed memory allocation for BLOBs
- auto-reconnect
* Fix in leak test, which failed sometime due to first assignment $prev_size over
paging (Masahiro Chiba)
* Catalog test allows use of schemas other than 'test' (Masahiro Chiba)
* Documentation fix for auto_reconnect (Karen Etheridge <ether at cpan dot
org>)
* Win32 and general installation fixes (Alexandr Ciornii, http://chorny.net)
2011-05-08 Patrick Galbraith <patg at patg dot net> Rob Hoelz <rhoelz at inoc dot com> (4.019)
* Asynchronous support added by Rob Hoelz - Thanks!
* Amiri Barksdale - Enable environment variables for installation options, add
docs to POD - Thanks!
* Pedro Melo - fix to change sv_undef to PL_sv_undef from 4.018 - Thanks!
2010-10-11 Patrick Galbraith <patg at patg dot net> (4.018)
* Added client and server info patch from Robert M. Jansen
* Added documentation and tests for new features
* More code cleanup
2010-08-11 Patrick Galbraith <patg at patg dot net> (4.017)
* BUG #60085, Andreas Koenig's patch for DBI changes
* Updated documents
2010-07-10 Patrick Galbraith <patg at patg dot net> (4.016)
* Disabled mysql_bind_type_guessing due to one performance issue
querying on an indexed character column unquoted will mean the index
is not used
* Fixed int types that should be bools
2010-07-09 Patrick Galbraith <patg at patg dot net> (4.015)
* BUG #56664 fixed t/40blobs.t skip_all logic (W. Phillip Moore)
* BUG #57253 Fixed iteration past end of string (crash). (Chris Butler)
* Added a new parameter for old behavior- mysql_bind_comment_placeholders which
will make it possible to have placeholders bound for those who really
want that behavior.
* Fixed bind_type_guessing - always on now
2010-04-14 Patrick Galbraith <patg at patg dot net> (4.014)
* BUG #30033 Fixed handling of comments to allow comments that contain characters
that might otherwise cause placeholder detection to not work properly
* BUG #53844, Fix for memory leak in stats. (Gregory Burmistrov)
* BUG #49719, Fix for handling of NULLs in prepared statements (Gert Pache)
* BUG #55627, Fix for testing failure due to strict mode (Yves)
* BUG #51784, Fix for mysqladmin on Windows in Makefile (Zeeshan Muhammad)
* BUG #41630, Typo in Makefile
* Had to define true and false in dbdimp.h. Didn't work out of the box on Linux
2009-09-16 Patrick Galbraith <patg at patg dot net> (4.013)
* #49484: PATCH add support for MYSQL_INIT_COMMAND - Peter John Edwards
* #48242: 'mysql_bind_type_guessing' doesn't work correctly
with minus sign - Thanks Serguei Trouchelle!
* #45616: t/40blobs.t cannot pass without database access -
ServerError() not declared - Thanks ysth http://ysth.livejournal.com/
2009-06-18 Patrick Galbraith <patg at patg dot net> (4.012)
* Patch to bind_type_guessing from Craigslist,
Thanks to Chris! Happiness is no quoted numbers.
Fixed ChopBlanks to work with bind_type_guessing
* Patch for win32 strawberry build
Thanks to Curtis Jewell! Windows needs love
* Patch for auto-reconnect to set active flag
Thanks to Doug Fischer!
* Fixed bug 32464 http://bugs.mysql.com/bug.php?id=32464.
See https://rt.cpan.org/Ticket/Display.html?id=46308
Add connection flag mysql_no_autocommit_cmd which users of
MySQL Proxy can use to prevent 'set autocommit=#' from being
issued by the driver. 'perldoc DBD::mysql' to see how to use
this new flag
* Added bind-type-guessing options to Makefile.PL so the entire
test suite can be run with bind_type_guessing set.
2009-04-13 Patrick Galbraith <patg at patg dot net> (4.011)
* Renamed unsafe_bind_type_guessing, fixed some of the logic. This
can be used to deal with bug 43822
(https://rt.cpan.org/Ticket/Display.html?id=43822)
* Patch from Daniel Frett (daniel Dot frett At ccci Dot org) to fix
issue of binding sever side integer parameters (server-side prepare
statements) resulting in corrupt data, bug 42723
(https://rt.cpan.org/Ticket/Display.html?id=42723)
* Updated documentation, cruft cleanup (as always)
2008-10-24 Patrick Galbraith <patg at patg dot net> (4.010)
* Fix to dbd_bind_ph() for uninitialized value 'buffer_length'
thanks for bug report and patch from Askniel.com (thanks!)
2008-10-21 Patrick Galbraith <patg at patg dot net> (4.009)
* Fix to re-enable TAKE_IMP_DATA_VERSION. Still have to ensure DBI version 1.607 or higher
* Fix to escaped single quotes throwing off bind param detection. Patch from Zhurs (zhurs@yandex.ru) Spasibo!
2008-8-15 Patrick Galbraith <patg at patg dot net> (4.008)
* Multi statement patch, thanks to Chris Heath!
* Disabled TAKE_IMP_DATA_VERSION because segfault with DBI < 1.607
* #29528: bind_param(..., SQL_FLOAT) ignores exponents - fixed, Thanks to
Tokuhiro Matsuno!
* Cleanups to make mysqlEmb work under Cygwin - Thanks to Chris Rodgers
<http://rodgers.org.uk/> !
* Modified and disabled tests for MySQL version < 4.1 for unsupported features
2008-5-11 Patrick Galbraith <patg at patg dot net> (4.007)
* Took out mysql_server_init call where not needed
* Complete re-write of test suit to use Test::More - tons of cleanups!
* Makefile.PL changes to use current user in 'make test' if not defined
2007-12-26 Patrick Galbraith <patg at patg dot net> (4.006)
* Cleanups on OS X compile
* Fixes to syntax errors on AIX
* Removed test code that was leaving trace files around
2007-3-22 Patrick Galbraith <patg at patg dot net> (4.005)
* Fixed mysql_warning issue < 4.1 (reminers, patches, help from ROAM, (issue 25713)
* makerealclean patch from ROAM (issue #25714)
* sqlstate cleanup patch from ROAM
* Replaced all references to dbis to use imp_xxh per DBI best practices
* Fix to dbd_st_destroy - added back previously removed 'free everything' code which
had been moved to dbd_st_finish, causing a crash upon freeing of bind values
after all rows resulting from one execution of a query have been fetched. This meant
that next attempt to execute the prepared statement would segfault. This
work thanks to Rainer Weikusat!
* Removed all 'FindNewTable' calls in all tests. Just use 't1' for all tests to
simplify things. Plus, this is how MySQL internall tests.
* Better 'skip test' logic in some tests that were still running when they shouldn't
have been.
2007-3-22 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.004)
* Work around a bug in old 3.23 servers by specifying NOT NULL for fields used
as a primary key in tests. (Bug #20325, reported by Julian Ladisch)
* Add support for mysql_warning_count statement handle attribute. (Bug #25457,
patch from Philip Stoev)
* Add support for mysql_multi_statements connection option. (RT #12322, based
on patch from Doug Morris)
* Had to bump to 4.003 do to print statement in mysql.pm that made it
into the dist. Even though you can delete a file on CPAN, you cannot
re-upload it if it's the same name. Mea Culpa.
* UTF8-Flag not set with flag mysql_enable_utf8 and column collation utf8_bin patch,
Joost Diepenmaat, (RT #24738)
* Fixed do_error definition (Scott Hildreth, Tim Bunce)
* Conversion of test suite to Test::More
2007-3-5 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.003)
* Fix inclusion of non-primary keys in primary_key_info. (Bug #26786,
reported and patch by Dave Rolsky)
2007-3-1 Patrick Galbraith <patg at patg dot net> Jim Winstead <jimw@mysql.com> (4.002)
* Fix re-exec of Makefile.PL when forcing $ENV{LANG} to 'C'. (RT #25233,
reported by Slaven Rezic)
* Rewrote table_info method to support all arguments (previously it would
only ever return all of the tables in the current database, no matter what
was specified)
* Fixed $DBD::mysql::VERSION to be a string instead of a float, which caused
problems for certain locales
* Fixed bug #23974. $dbh->column_info now returns handle with no rows upon
table not existing. Much thanks to Tim Bunce for help fixing the problem
in mysql.pm vs. dbdimp.c
* Removed #ifdefs for do error (sqlstate being passed as last arg depending on
version)
* Fixed insertid test to work with auto_increment_increment replication setup.
* Patch from Tim Bunce fixing do() not set $dbh->{Statement} attribute,
which prevented DBD::Profile from giving correct results for calls to do()
and causing ShowErrorStatement to possibly report the wrong statement in the
error message
* Patch from Tim Bunce clearing out the sth attribute cache when switching
between result, sets which prevented the adjustedment of NUM_OF_FIELDS
* Cleanup of several unused variables
* Added support for wildcards in last argument of column_info().
* Add mysql_is_auto_increment to results of column_info(). (Bug #26603,
original patch from Dave Rolsky)
* Return the correct table type for both tables and views from the table_info()
method. (Bug #26603, original patch from Dave Rolsky)
* Add implementation of foreign_key_info() (Bug #26604, original patch from
Dave Rolsky, and final implementation based on Connector/J code)
2007-1-8 Jim Winstead <jimw@mysql.com> Patrick Galbraith <patg at patg dot net> (4.001)
* Fix handling of unsigned integer values in result sets when using
server-side prepared statements (they were not retrieved at all).
* Fix handling of signed integer values when using server-side prepared
statements (they were being forced to unsigned values).
* Do not tell Perl that the contents of binary fields are UTF-8.
[rt.cpan.org #22123], original patch by Joost Diepenmaat
* Fix double-free of bound parameters when freeing statements. (Bug #20559)
* Make sure to handle "magical" values in a couple of places. (Bug #20104)
* Update the hints about what to do when zlib is found missing while
linking. (Bug #13803, reported by Philip Stoev)
* Explicitly initialize the MySQL client library to avoid possible race
conditions in a multithreaded application. (Bug #21792)
* Fix warning when no connection attributes are passed to the connect
method (Bug #17323, reported by Phil Randal)
* Removed redundant warnings when commit or rollback is called while
AutoCommit is enabled. [rt.cpan.org #15802], reported by Tyler MacDonald
* Report correct type for decimal columns from MySQL 5.0 and later
[rt.cpan.org #18294], reported by Ray Zimmerman
* Fix t/40bindparam.t to work when ANSI_QUOTES SQL_MODE is set.
[rt.cpan.org #21521], reported by David Wheeler
* Return a statement handle with an error when column_info is called on
a table that does not exist. (Bug #23974, patch by Philip Stoev)
* Fix handling of table names with characters that did not match /\w/ in
the column_info method. (Bug #22005, reported by Philip Stoev)
* Fix handling of negative integers bound to a column marked as SQL_INTEGER.
[rt.cpan.org #18976], patch from Mike Schilli.
* Add support for the primary_key_info method. [rt.cpan.org #8541]
* Fixed Bundle::DBD::mysql to only include modules required for using
DBD::mysql, not the old Mysql package. [rt.cpan.org #24096]
* Updated Makefile.PL to not include files in .svn directories
* Fixed various compile warnings in mysql.xs (ISO C)
* Cleaned up stored procedure examples, made strict
* Fixed bug that blew away subsequent result sets if you fetched all rows, only in
result sets that had more than one row
* Added test for bug #14979 http://rt.cpan.org/Ticket/Display.html?id=14979, which still
fails
* Tested with ALL mysql versions, fixed 40types, 40bind_param tests to work with 4.0, 4.1
* Fixed dbdimp.c to not test for MYSQL_DATA_TRUNCATED unless >= mysql 5.0
2006-12-22 Patrick Galbraith <patg at patg dot net>, Alexey Stroganov (4.00)
* Added Alexey Stroganov's patch which fixes varying number of columns in
multiple result sets. Added new test cases to 80procs.t based of his
test script (bug #21028) (Thanks Alexey!). Also fixed 80procs.t to allow
'CALL' to be prepared
* Added Philip Stoev's patch for DATA_TYPE date and time columns (bug #23988)
(Thanks Philip!)
* Reworked (for working with 4.0, which doesn't support sqlstate) Philip Stoev's
patch for sqlstate, bug #23935 (Thanks Philip!)
* New Versioning! 4.00 now. This dev tree will now become trunk
* Cleaned up much code that failed between versions (!!!)
* Turned off prepared statements by default
* Tested this with 5.1, 5.0, 4.1, 4.0. Works with ALL these versions!
2006-10-10 Patrick Galbraith <patg at patg dot net>, Alexey Stroganov (3.0009_1)
* Added fbind and bind alloc to dbd_st_describe. This was causing a crash
when using with mod_perl
2006-10-10 Patrick Galbraith <patg at patg dot net> (3.0008_1)
* Added patch for SSL Verify Certificate (Thanks Eric Chen!)
* Added multiple fixes to dbd_st_prepare which fixed variable overwrite
and unset increment counter. Also improved loop which checks statements
for presence of "LIMIT" by using a pointer as opposed to char array
increment variable. These errors were showing up in OpenBSD and other
Unixen (which I think all BSD-based) (Thanks to Kyle George!)
* Added fix to Makefile.PL to obtain correct build flags on VMS
(Thanks to Eric Milkie!)
* Fixed casting of num_params to unsigned int in calls to NewZ in mysql.xs
2006-10-07 Patrick Galbraith <patg at patg dot net>, Jim Winstead <jimw@mysql.com>
(3.0007_2)
* Added UTF8 patch from Dominic Mitchell (Thanks!)
* Fixed declaration of "row" in mysql_st_internal_execute which caused compile
errors on some platforms
* Fix documentation for _ListDBs to remove incorrect information about
limitations of data_sources(). (RT #20843, patch by Ann Barcomb)
* Fix typo in example (missing quote). (RT #15086)
* Mention in POD that 'localhost' always means to connect via UNIX socket,
and 127.0.0.1 must be used for TCP/IP to localhost (RT #14942, reported by
Alessandro Ranellucci)
* Fix typos in Makefile.PL (RT#16178, reported by Gavin Shelley)
2006-09-08 Jim Winstead <jimw@mysql.com>, Patrick Galbraith <patg@mysql.com>
(3.0007_1) (3.0006/3.0006_1 is the same as 3.0005/3.0005_1)
* Make sure to call dbd_st_finish when all rows from a statement handle
have been fetched. (Bug #20153, Bug #21607, RT #20464, RT #21241)
* Patch from Steve Hay to fix bind_param to deal properly with insertion
of a NULL into an INT or DOUBLE column using server-side prepare.
Converted Steve's dbi.pl script to expose this problem to 40bindparam2
test.
* Fix to mysql_st_internal_execute to keep from passing undefined dbh
handle member (bind_type_guessing) to parse_param causing crash on
OpenBSD. Reported on rt.cpan.org (#20868) by Kyle Georg, as well as
info from Sam Smith and Federico Giannici
* Cleaned up tests to make sure test table is dropped at end of test.
2006-06-10 Patrick Galbraith <patg@mysql.com) (3.0005)
* Fix dbd_st_finish in 3.0004 didn't clean up bind buffers resulting in
a memory leak. See eg/prepare_memory_usage.pl to see how this manifests
itself. Thanks to Jason Snell for giving me a good script to reproduce
this!
* Fix to parse_params, mysql.xs dbh->do, and bind_param to deal with
passing substr to "do" for placeholder value. Thanks Martin Waite for
the patch to parse_params (extended to mysql.xs "do" and bind_param for
server-side prepared statements.
2006-05-17 Patrick Galbraith <patg@mysql.com) (3.0004_1)
* Fix dbd_st_finish which closed the handle prematurely (Martin Evans)
* Compile issues (Martin Evans)
* Small change to get utf8 data returned. One still has to:
$dbh->do("set character set utf8");
$dbh->do("set names utf8");
to get utf8 back and even then you only get it back if the
column is defined as utf8 in mysql.
* Fix to dbd_bind_ph to deal with numbers (ints, floats) correctly
(Alexey Stroganov)
* Test changes - bind_param 41 and 42
* Turned off 70takeimp test
2006-04-29 Patrick Galbraith <patg@mysql.com) (3.0003_1)
* Removed old Msql-Mysql Driver emulation code - finally!!!
* Removed aweful string testing code (that I wrote) for unsported
statements and now use mysql_stmt_prepare, if statement not
supported, toggle to mysql_emulated_prepare
* Fixed bug where failed stmt execution caused later statements
to fail with mysql_stmt_reset
* Added tests for unsupported statements
* Added test for test of failed statement with subsequent executes
(thanks to Martin Evans!)
* Added typo fix (Martin Evans)
* Added support for ParamValues and associated test (Martin Evans)
* Removed old emulated driver tests (HOORAY!)
* Cleaned up debug printing code
* Fixed syntax for create table ENGINE=InnoDB instead of type=innobase
* Cleaned up tests
2006-01-31 Patrick Galbraith <patg@mysql.com> (3.0002_5)
* Fixed bugs 15546 (selectcol_arrayref failing on SHOW TABLES)
and 15665, 'USE dbname' failing when driver is not in emulated
prepare mode
2005-10-26 Patrick Galbraith <patg@mysql.com> (3.0002_4)
* Added Guy Harrison's patch for multiple result sets
* Fixed bugs with declarations in middle of functions
* Cleaned up code, rewrote several loops using pointers
instead of iterators
* Rewrote 'SHOW', 'ALTER', 'CALL', 'CREATE' toggling code that turns
off server prepared statements (these calls are not supported)
* Updated documentation
2005-09-28 Patrick Galbraith <patg@mysql.com> (3.0002_3)
* Added code to mysql_st_internal_execute that determines whether the
SV *h is a sth or dbh, and then imports imp_dbh appropriately
2005-09-26 Patrick Galbraith <patg@mysql.com> (3.0002_2)
* Fixed bug in dbd_st_execute where imp_sth was being
imported unecessarily, when only imp_dbh is needed. This caused a
core dump in some cases. Thanks to Andy Maas at Proofpoint for his
execellent detective work!
* Small changes to Makefile.PL to make sure --ps-protocol works as
advertised.
* Updated install.html with current info about prepared statements and FC
RPM/YUM packages.
2005-08-04 Patrick Galbraith <patg@mysql.com> (3.0002_1)
* Prepared statement support is default now. To turn it off
a parameter 'mysql_emulated_prepare' must be turned ON
* Better error handling in mysql_internal_execute_ps (renamed
from mysql_internal_execute41). Also free the result if error -
that could have been a memory bug
* Added a simply 'do' to t/35prepare.test to see if you can turn
off prepared statements in the 'do' call.
* Cleaned up a LOT of cruft. Added more 'caveat' blurbage to old
Mysql.pm lib, which will not work with prepared statements
2005-07-06 Parick Galbraith <patg@mysql.com> (3.0001_3)
* Fix to ensure MYSQL_BIND is only defined when mysql
client version is >= 4.1.3. Thanks to Tom Parkison
2005-07-06 Patrick Galbraith <patg@mysql.com> (3.0001_2)
* Fixed runtime bug (when inserting or updating quotes or double quotes)
(Thanks to Brad Choate, Six Apart Ltd.)
2005-07-04 Patrick Galbraith <patg@mysql.com> (3.0001_1)
* Changed uint argument in safe_sv_fetch to int due to
uint not being available on windows unless you include
my_globals.h in dbdimp.h, which also breaks on unixen!
* Removed // comments from mysql.xs (thanks Bodo Bergman!)
2005-07-03 Patrick Galbraith <patg@mysql.com> (3.0000_0)
* Special Thanks to Steve Hay for his patch to fix windows
* Fixed Makefile.PM for windows compiles
* Removed long long type from dbdimp.h
* Changed strncasecmp to strncmp (still need a better long-term solution)
in dbdimp.c
* Modified Makefile.PM to make prepared statements on by default
2005-04-26 Patrick Galbraith <patg@mysql.com> (2.9015_3)
* Added patch from Stas Beckman for new DBI feature take_imp_data, needed
for DBI::Pool
* Fix to Statement.pm for old API call for numfields that caused
warnings on 40numrows and akmisc tests
* Fix to bind_ph to throw an error if trying to bind a non-numeric
value as numeric
* Better fix for dealing with error condition in $sth->rows()
* Fix to bind_param to throw error when trying to bind a non-numeric as
numeric
2005-04-04 Patrick Galbraith <patg@mysql.com> (2.9015_2)
* Merged all code changes from 2.900x tree from the last 9
months
- unsafe bind type guessing patch from Dragonchild
- Removed mysql.mtest
- Fixed sth->rows to return my_ulongloong and also handle
error from client API
- Fix to make autocommit work was already part of this version
- Auto-reconnect bug fixed in 2.9006 included
* Added simple test to 35limit test to check if using malicious code in
LIMIT ?, ? placeholders works, which it doesn't.
* Fix that sets mysql_server_prepare to 0 if SQL statement is 'SHOW ...'
which is not supported by prepared statement API currently
2004-10-28 Rudolf Lippan <rlippan@remotelinux.com> (2.9015_1)
* Merged Makefile.PL from 2.9005_3
* Bumped version number to 2.9015 for release of Dev Branch. Which
will become 2.9020 when tested and merged into HEAD.
* fixed typo/compiler warning in bind_param_guessing
'*testchar' should have been 'testchar'.
2004-10-20 Patrick Galbraith patg@mysql.com (Dev-2_9 - 2.9005)
* merged changes from 2.9005_1
* fix to blob in dbd_st_fetch (Alexey Stroganov ranger@mysql.com)
In case of BLOB/TEXT fields we allocate only 8192 bytes in dbd_describe()
for data. Here we know real size of field so we should increase buffer
size and refetch column value
2004-07-25 Patrick Galbraith patg@mysql.com (2.9004)
* Prepared statement support
* Use of mysql_stmt_* API (>= 4.1.3)
* mysql_shutdown fix
* MySQL Embedded Server support (Alexey Stroganov)
* Fixed link failure on MacOSX
* Cleaned up tests
* Fixed various compile warnings
2003-10-26 Rudy Lippan <rlippan@remotelinux.com> (2.9003)
* Applied patch from Aaron and Chuck that added basic testing of the
table_info/column_info functions [Aaron Ross <aross@plusthree.com>]
* Applied patch removing Jochen Wiedmann's contanct information and
also removing the restriction on CD ROM distribution.
[Jochen Wiedmen <joe@ispsoft.de>]
* The check for the innodb table type was broken so the transaction
tests were skipped even though the database supported transactions.
* :sql_types were not being inported in column info, so SQL_VARCAR was
thowing an error. Also, the :sql_types were not being pulled into
DBD::mysq::db package
* Patch for dbdadmin.t so that it respects username and password
[Alexey Stroganov <ranger@mysql.com>]
* Fix for memory leak in bind_param() introduced in 2.9002
(2.9002 changed bind_param so that changing the value of a scalar
after binding would not affect what was passed to execute eg:
$sth->bind_param(1,$foo);
$foo = 'bar'
$sth->execute() -- $foo would contain 'bar')
[reported by <shildreth@emsphone.com>]
* don't define dbd_discon_all so that mysql uses DBI's This fixes a
bug whereby DBD::mysql was dropping perl's destruct level.
* patch to myld so that it uses strict and fixes scoping problem
with $contents [Jochen Wiedmann <joe@ispsoft.de>]
* Modified Makefile.PL so that it gives a usage message
if any unknown options are passed in.
* patch to INSTALL.pod on how to link DBD::mysql against
a static libmysqlclient [Jochen Wiedmann <joe@ispsoft.de>]
2003-06-22 Rudy Lippan <rlippan@remotelinux.com> (2.9002)
* moved pod into mysql.pm from mysql.pod
* Changed the default behaviour of mysql_found_rows, so now
'UPDATE table set field=?' will return the number of rows matched
and not the number of rows physically changed. You can get the old
behaviour back by adding "mysql_found_rows=0" to the dsn passed
to connect.
* Updated type_info_all() to be more inline with
what DBD::ODBC returns.
* Added attribute 'mysql_auto_reconnect' that allows the auto reconnect
behaviour to be toggled. :
** NOTE** The behaviour of auto reconnect has changed. If
either the MOD_PERL or the GATEWAY_INTERFACE environment variable is
set, auto_reconnect will default to ON; otherwise auto_reconnect
will default to off. Earlier versions of this driver would always
try to reconnect to the database on error; however, this is dangerous
because table locks could be lost without the application knowing.
* Fixed a segfault with failed reconnects that were trapped in an
eval. The next tine DBD::mysql tried to reconnect, the process
would segfault.
* Added statistics attribute, 'mysql_dbd_stats' which returns
a hash ref that contains 2 keys 'auto_reconnects_ok' and
'auto_reconnects_failed'.
* Fixed bug where strings that were used in numeric
context were not getting quoted on execute(). Now all
parameters are bound as varchar by default.
**NOTE** this is a change in behaviour that MAY cause problems
with some SQL statements. If quoted integers, for example,
cause any problems, use bind_param(<column_id>, undef, SQL_INTEGER)
to force a column to be bound as an integer.
* Added get_info() method. See 'perldoc DBI' for more info
* Added column_info(). See 'perldoc DBI' for more info [Tim Bunce]
2003-03-03 Jochen Wiedmann <joe@ispsoft.de> (2.1026)
* Fixed the handling of case insensitive file
names. Jan Dubois, <jand@ActiveState.com>
* lib/Mysql.pm (listdbs): Added support for user
name and password.
2003-01-21 Jochen Wiedmann <joe@ispsoft.de> (2.1025)
* lib/DBD/mysql.pm: added support for optional
DBI->data_sources() \%attributes parameter.
Georg Rehfeld, <georg.rehfeld@gmx.de>
* lib/DBD/mysql.pod: documented optional
DBI->data_sources() \%attributes parameter.
Georg Rehfeld, <georg.rehfeld@gmx.de>
* t/dbdadmin.t: changed to use optional
DBI->data_sources() \%attributes parameter.
Georg Rehfeld, <georg.rehfeld@gmx.de>
2003-01-20 Jochen Wiedmann <joe@ispsoft.de> (2.1024)
* dbdimp.c: Fixed missing support for double quotes
in ParseParam. JUERD@cpan.org
* Test suite: Multiple patches for Windows/CygWin (case
insensitive file names and the like). Georg Rehfeld,
<georg.rehfeld@gmx.de>
* lib/DBD/mysql/INSTALL.pod: Added description on how
to install with Windows/CygWin. Georg Rehfeld,
<georg.rehfeld@gmx.de>
2003-01-18 Jochen Wiedmann <joe@ispsoft.de> (2.1023)
* Remove compiler warnings