forked from mysql/mysql-connector-odbc
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ChangeLog
1558 lines (1305 loc) · 62.7 KB
/
ChangeLog
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
8.0.16
Security Notes:
Functionality added or changed:
Bugs fixed:
* Prepared statements (server) return no results, client statements work
(Bug# 29282638/93895)
* Memory leak in SQLSetPos with SQL_DELETE (Bug# 29434462)
Built using MySQL 8.0.16
8.0.15
This release contains no functional changes and is published to align
version number with the MySQL Server 8.0.15 release.
Built using MySQL 8.0.15
8.0.14
Security Notes:
Functionality added or changed:
* New connection option for ODBC driver to enable LOAD DATA LOCAL INFILE
(WL# 12394)
* Connectors: Expose metadata about source and binaries in unified way
(WL# 12373)
* Build Con/ODBC with MSVC 2017 (WL# 12640)
Built using MySQL 8.0.14
8.0.13
Security Notes:
Functionality added or changed:
* Add support for dynamic libmysql linking to ODBC Driver 8.0 (WL# 12369)
* RE: Release ODBC 8.0 on Solaris platform. (WL# 12386)
Bugs fixed:
* MySQL ODBC causes write access violation when using RECORDSET.MOVE
(Bug# 28098219/91060)
* ODBC 8.0.12 32-bit, Microsoft Access and Tables with MEDIUMTEXT or
LONGTEXT (Bug# 28670725/91856)
* Obsolete options in ODBC Driver (Bug# 28407520)
* SQLGetInfo() returns zero length for SQL_MAX_SCHEMA_NAME_LEN
(Bug# 28385722/91760)
Built using MySQL 8.0.13
8.0.12
Security Notes:
* Fix issues found by Fortify (WL #11829)
Functionality added or changed:
* Improve coverage for ODBC code (WL #11994)
Bugs fixed:
* SQLColAttribute/SQL_DESC_TYPE_NAME text instead of longtext for
longtext col (Bug# 11761407/53900)
Built using MySQL 8.0.12
8.0.11
Security Notes:
Functionality added or changed:
* Make sure ODBC works with new 8.0 auth. mechanism. (WL #11659)
* Prepare ODBC 8.0 Source tree. (WL #11099)
Bugs fixed:
Built using MySQL 8.0.11
5.3.10
Security Notes:
Functionality added or changed:
* Build ODBC Connector with libmysqlclient linked dynamically (WL #11105)
Bugs fixed:
* ODBC Driver issue with SELECT for UPDATE (Bug# 26646688/87457)
* Contribution: Compilation fixes for MySQL 5.5 (Bug# 26633971/87413)
* Contribution: Fix truncated "SSL Certificate Authority" label
(Bug# 26579169/87325)
* OpenRecordset leaking memory client side on Windows ODBC Client
(Bug# 27155880/86473)
* MySQL Connector/ODBC 5.2.5 - Command Timeout does not work
(Bug# 26474362/69416)
* Calling MySQLDrivercConnect with a NULL pcbConnStrOut causes a crash
(Bug# 27101767/88371)
Built using MySQL 5.7.20
5.3.9
Security Notes:
Functionality added or changed:
* Added two new CMake build options. STATIC_MSVCRT to switch /MT and /MD
compiler options in Windows. WITH_NODEFAULTLIB to specify the
/NODEFAULTLIB linker option. (WL# 10890)
Bugs fixed:
* Segmentation fault in SQLFetch() when used with dynamic cursor
(Bug# 18805392)
* SQLExecute() after SQLFreeStmt(SQL_RESET_PARAMS) results
in assert failure (Bug# 19148246)
* SQLForeignKeys() crashing when SQL_MODE='ANSI_QUOTES'
(Bug# 18641824)
* SQLForeignKeys() returns empty result with NO_I_S=0
(Bug# 26388694)
Built using MySQL 5.7.19
----
5.3.8
Security Notes:
* Connector/ODBC 5.3.8 Commercial upgrades the linked OpenSSL
library to version 1.0.2k which has been publicly reported
as not vulnerable to CVE-2017-3732
(http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3732)
(Bug #25615448, CVE-2017-3732)
Functionality added or changed:
* Added a new connection option NO_DATE_OVERFLOW to control returning
of errors when the TIMESTAMP structure used for DATE column contains
non-zero time part (Bug# 25386024)
Bugs fixed:
* SQL_ATTR_MAX_ROWS applies to all result sets on the statement,
and not connection (Bug# 17259397/69554)
* SQLTABLES patch (Bug 13914518) has to be extended for NO_I_S case
(Bug# 14005343)
* Connector/ODBC does not send correct error message when 2006 error occurs
(Bug #25671389)
* Error in Windows Setup Wizard Custom Setup Dialog
(Bug# 25247807/84190)
* Contents in embedded help for myodbc-installer are outdated
(Bug# 18896110/72852)
* SQLGetData() with invalid column number crashes (Bug# 18636600)
* Assert failure in SQLSetDescField() API (Bug# 18641633)
* Metadata functions crash when the catalog/table/column name is long
(Bug #18796005)
* Prefetch causes syntax errors in select queries with parameters
(Bug# 17386788)
Built using MySQL 5.7.18
----
5.3.7
Security Notes:
* Connector/ODBC 5.3.7 Commercial upgrades the linked OpenSSL
library to version 1.0.2j which has been publicly reported
as not vulnerable to CVE-2016-6304
(http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2016-6304)
(Bug #24753385, CVE-2016-6304)
Functionality added or changed:
* Added new options to control TLS versions for connecting:
NO_TLS_1_0, NO_TLS_1_1, NO_TLS_1_2. By Default all TLS versions are enabled
and options allow to disable using of a particular TLS version.
(Bug# 23496903/81640)
* Added a new option SSLMODE to set the SSL mode before connection is made.
The option value can be set to any of the follwing: DISABLED, PREFERRED,
REQUIRED, VERIFY_CA, VERIFY_IDENTITY. This option will override
the deprecated SSLVERIFY and SSL_ENFORCE.
(Bug# 23497043/81641)
Bugs fixed:
* Assertion in ODBC Driver when calling mysql_stmt_close() on a broken
connection (Bug# 25109356/83858)
* Connector ODBC does not build with newer CMake (Bug# 22746557)
* Installation fails in OSX El Capitan (23123503/81113)
Built using MySQL 5.7.17.
----
5.3.6
Functionality added or changed:
* Keywords specific to MySQL server 5.7 (WL#7992)
* Implement SQL_ATTR_QUERY_TIMEOUT statement attribute (WL#7991)
* Added DEFAULT_AUTH and PLUGIN_DIR options in connection parameters.
* Added DISABLE_SSL_DEFAULT connection parameter to disable
connecting through SSL by default.
* Added SSL_ENFORCE connection parameter to enforce SSL connection.
Bugs fixed:
* ODBC Driver not parsing comments correctly (Bug# 16613308/53891)
* Calling SQLGetDiagField with DIAGIDENTIFIER SQL_DIAG_ROW_COUNT always
returns 0 (Bug #11750296/40771)
* ADO hangs when using MySQL ODBC 5.3 ANSI Driver with French characters
(Bug# 20526062)
* Connector/ODBC fails to build when using libmysqlclient 5.7
(Bug# 20685833/76261)
* malloc/free mismatch in MySqlGetPrivateProvileStringW
(Bug# 21074676/76984)
----
5.3.5
Security Notes:
* Connector/ODBC 5.3.5 Commercial upgrades the linked OpenSSL
library to version 1.0.1m which has been publicly reported
as not vulnerable to CVE-2015-0286
(http://www.cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2015-0286).
Since the only change in Connector/ODBC 5.3.5 is the inclusion
of OpenSSL libraries publicly reported as unaffected by
CVE-2015-0286, and since Oracle-produced MySQL Community
builds use YaSSL libraries which have been reported as not
affected by CVE-2015-0286, Oracle will not produce builds for
Connector/ODBC Community for version 5.3.5. This means the
Community edition of Connector/ODBC will skip version 5.3.5.
(Bug #20747740, CVE-2015-0286)
----
5.3.4
Functionality added or changed:
* New ODBC connection option to specify the location of RSA public key
(WL #7911)
Bugs fixed:
* SSL CA Path cannot be selected in Linux GUI (Bug #18813389/72716)
----
5.3.3
Functionality added or changed:
Bugs fixed:
* Seg Fault in SQLForeignKeys() when column name contains special characters
(Bug #18286118)
* Add NULL handle checks in ODBC API functions (WL #7807)
----
5.3.2
Functionality added or changed:
* Support of ODBCINSTGetProperties in MyODBC Driver (WL #7577)
* Add DFLT_BIGINT_BIND_STR option to Connector/ODBC GUI (Windows and Linux)
(WL#7579)
Bugs fixed:
* Connect crash if the catalog name given to SQLSetConnectAttr is invalid
(Bug #17587913)
* Driver returns wrong length for output parameter streams
(Bug #17814768/70946)
* Assert failure in case of prepared statments and SQLDESCRIBECOL() called
with column number given larger then actual parameter marker in query.
(Bug #17311065)
* SQLFOREIGNKEYS WITH FLAG_NO_INFORMATION_SCHEMA OPTION RETURNS BAD RESULTS
(Bug #16920750)
* SQLFetch() crashing when execute using UnixODBC 2.3.2 (Bug #17857204)
* Segmentation fault in SQLSpecialColumns if table name is invalid
(Bug# 17854697)
* Invalid order of free() functions can cause crash (Bug# 17992912)
* Crash in ODBC Driver with CHARSET=WRONGCHARSET (Bug# 17999659)
* Driver and myodbc-installer crash with long option names (>100) and
values (>255) (Bug# 17966018)
* ODBCManageDataSourcesQ4 cannot run MyODBC GUI setup to edit an existing
DSN (Bug# 18046123)
* SQLGetData returning error being called after SQLParamData (Bug #17842966)
* Valgrind: jump or move depends on uninitialised value error from
myodbc-installer (Bug# 18046120)
* Memory leak in sqlexecute() when connection is killed from another thread
(Bug#17587617)
* Data corruption in SQLBulkOperations because of buffer overrun.
(Bug #17714172)
* Segfault in SQLBulkOperations() for SQL_UPDATE_BY_BOOKMARK when select
returns 0 records. (Bug# 17714358)
* MS Access crashed when sorting a column (Bug# 17071780/69550)
* Empty query giving segmentation fault in myodbc_casecmp (Bug# 17085344)
* Uninitialized variable free_value can set wrong error in SQLDescribeCol
(Bug# 17588101)
* ODBC 5.2.5 DMG installer fails on OSX 10.8.5 (Bug #17512040/70422)
* Bulk insert on time column with hour value > 99 gives error (Bug#17613161)
* Concurrent execution of SQLEndTran() with SQL_HANDLE_ENV results in
SEG FAULT (Bug #18166331)
* Workaround to GTK bug in GtkComboBox and GtkComboBoxEntry (WL #7637)
* ODBC Driver GUI in Windows has wrong order of controls selection
(Bug# 18240696)
* Wrong installation library directory on some 64bit system other than x86_64.
(Bug# 68848)
* SQLNumResultCols() with NULL parameter results in Segmentation Fault
(Bug# 18165197)
* SQLBULKOPERATIONS(SQL_FETCH_BOOKMARK) RETURNS SQL_NO_DATA ERROR
(Bug# 18287216)
* Segmentation Fault in SQLExecute() while executing test file "my_types"
(Bug# 18303978)
* Segmentation fault in SQLParamOptions() in Solaris platform (Bug# 18325878)
* Segmentation fault in SQLForeignKeys() when number of columns in the table
is more (Bug# 18286366)
* Valgrind memory leak in SQLForeignKeys when NO_I_S=1 (Bug# 18286007)
* Valgrind memory leak in when SQLPrepare used with SQLParamData/SQLPutData for
NO_I_S=1 (Bug#18295317)
* The password is getting saved when creating FileDSN using SQLDriverConnect
(Bug# 18310873)
* Passing NULL pointer to SQLSetDescField, SQLGetDiagField and SQLGetDiagRec
results in a crash (Bug# 18431088)
* Rename internal functions named as mysql_xxxx inside ODBC sources
(WL #7789)
Built using MySQL 5.6.17.
----
5.3.1(20-Nov-2013)
Functionality added or changed:
* Support of SQL_ATTR_RESET_CONNECTION connection attribute (WL #7274)
Bugs fixed:
* Memory leak using 5.2.6 ODBC Connector (Bug #17653461/70662)
* MySQL ODBC driver incorrectly quotes TableName when calling SQLPrimaryKeys
(Bug# 16952531/69448)
* Bad memory access when get out params (Bug #17640929/70642)
* Setting Unix Socket using ODBCManageDataSourcesQ4 sets NAMED_PIPE=1
(Bug# 17586452)
* Segmentation Fault in SQLBulkOperations() (Bug #17714290)
* Segmentation fault when SQLColumns table or column argument are provided
more then 256 and 129 respectively (Bug #17358838)
* Memory leak in SQLSetStmtAttr() as statement deallocation was missing
(Bug #17441507)
* Memory leak is happening in SQLProcedureColumns when returning empty results.
(Bug #17298721)
* Memory leak in SQLConnect() called after SQLSetConnectAttr() (Bug #17586844)
Built using MySQL 5.6.14.
----
5.3.0(19-Oct-2013)
Functionality added or changed:
* Support for File Data Sources. (WL #6583, Bug #11746219/24581)
* Bookmark support added in myodbc (WL #7039)
* Seg Fault in SQLForeignKeys() when column name contains special characters
(Bug #18286118)
* Add NULL handle checks in ODBC API functions (WL #7807)
----
5.2.6(25-Sep-2013)
Functionality added or changed:
* Added new variable in cmake config files ODBCCP32_LIB for odbccpp32.lib path,
and MYSQLCLIENT_LIB_NAME for linking mysqlclient statically or dynamically by
specifying mysqlclient library (libmysql.*, mysqlclient.*, libmysqlclient_r.*,
libmysqlclient.*) to be used. Mysql CPP linkage for mysql version >= 5.6.4
(WL #6738)
* Added a new test module for crash bugs (my_crash.c)
* Added GUI dialog for Linux
* Support of ODBC 3.8 standard - driver self identification, input/output
stream parameters (WL #6584)
Bugs fixed:
* With utf8 byte string for mysql server version < 5.5.3, insert fails
with error message "Server does not support 4-byte encoded UTF8
characters." (Bug #14838690)
* Driver use the char ';' as separator in attributes string instead
of the '\0' (Bug #15940689/66548)
* DSN connection parameters override those specified in the connection
string (Bug #11760574/52996)
* Non-compliant behavior of SQLMoreResults (Bug #16101282/67920)
* MSSQL linked server connected to MySQL 5.1.9 driver causes hard crash
(Bug #16604346/63386)
* MySQL ODBC drivers incorrectly returns TIME columns, where value > '99:59:59'
(Bug #16176981/67793)
* Conversion of Time field data to Timestamp type may produce incorrect result
(Bug #17016839/69545)
* Need to add a lock to access connections member in ENV structure
(Bug #17240611/69864)
* Visual Studio 2010 crashes when reading rows from any table in Server
Explorer (Bug #17304031/69950)
* Corrected MYSQL_NUM_VERSION calculation error in FindMysql.cmake.
MYSQL_LIB_DIR, MYSQL_INCLUDE_DIR, MYSQL_LINK_FLAGS and MYSQL_CXXFLAGS will
be obtained from mysql_config only when they are not provided using cmake
options.
* Memory leak in SQLPrepare with queries that use parameters
(Bug #17400483/70113)
* Valgrind error, simple loop fix (Bug #17397596/64105)
* Wrong pointer type can cause crash in convert_c_type2str()
(Bug #17421620/69733)
* Memory leak in SQLMoreResults() as deallocation of result_bind buffer
required before calling mysql_stmt_free_result() (Bug# 17441296)
* FileDSN is created evein if the connection credentials are wrong
(Bug #17508006)
* Error with iodbc in SQLAllocHandle with handle type SQL_HANDLE_DBC
as odbc_ver is unset.
Built using MySQL 5.6.14.
----
5.2.5(04-Apr-2013)
Functionality added or changed:
* MSI package installs both ANSI and Unicode drivers. (WL#6793)
Bugs fixed:
* query_print will cause core dump in 32-bit application
(Bug #16367440/68201)
* Microsoft Access Crashes when Bit field updates (Bug# 16287859/68243)
* Datetime and timestamp second fractions need removing the trailing
zeros (Bug# 16294197/65418)
* Binding string to decimal parameter always uses system locale setting
(Bug# 11766369/59469)
* Added CLEARTEXT authentication connection option ENABLE_CLEARTEXT_PLUGIN.
(Bug#16445091)
* Crash in SQLSetConnectAttr(SQL_ATTR_CURRENT_CATALOG) (Bug# 16526604/63844)
Built using MySQL 5.6.11.
----
5.2.4 (16-Jan-2013)
Functionality added or changed:
* Support of expired passwords. Added conenction string option CAN_HANDLE_EXP_PWD.
(WL#6786)
* Add new reserved words from MySQL 5.6 in SQLGetInfo (WL#6704)
Bugs fixed:
* While retrieving data from a field, BLOB to CHAR conversion is done only for
fields having BLOB_FLAG, BINARY_FLAG and binary character set(63) (Bug #11746572)
Built using MySQL 5.6.10.
----
5.2.3 (19-Dec-2012)
Bugs fixed:
* Memory leak in 5.2.2(w) ODBC driver causes Prepared_stmt_count to grow
(Bug# 67340/14812778)
* Version 5.1 exports symbols SQLInstallDriverEx and SQLInstallDriverExW
(Bug# 11766724/59900)
* Corrected calculation for length indicator descriptor field (Bug# 11766437)
* is_minimum_version() function does not work correctly (Bug# 15926340)
* Problem with BIT columns in MS Access (Bug# 15997361/67702)
Built using MySQL 5.5.27.
----
5.2.2 (10-Sep-2012)
Bugs fixed:
* Server disconnects on the execution of a query following execution of a SP
returning resultset(s) and OUT parameters. (Bug# 14512187)
* Crash while executing after binding BLOB datatype as INOUT parameter
(Bug# 14501952)
* SP having 2 BLOB OUT parameters crashes at execution (Bug# 14563386)
* ASSERT for INOUT parameter of BIT(N>3) type (Bug#14560916)
* Using ADO, driver returns wrong type and value for bit(>1) parameter
(Bug# 14555713)
* Blobs used in as INOUT parameters have inconsistent behaviour in ADO
(Bug# 14580316)
* my_isspace calls cause ODBC driver crashes (Bug# 14363601)
* SQLNativeSql did not null-terminate output string after copying
(Bug# 14559721)
* Incorrect length value passed to SQLSetConnectAttr could cause
driver crash. (Bug# 14620420)
Built using MySQL 5.5.27.
----
5.2.1 (09-Aug-2012)
Functionality added or changed:
* Driver prepares statements on server
* Support of INOUT and OUT parameters(WL#6116)
* Increased the timeout in tests from 30 to 60 seconds to avoid failures in
slow tests that involve catalog functions and Information_Schema queries.
Bugs fixed:
* Long table names crash OBDC driver. (Bug# 14085211/65200)
* Close proximity issue when handling OS signlals in myodbc (Bug# 14303803)
* "String data right truncated" error is not always correct (Bug# 14285620)
Built using MySQL 5.5.27.
----
5.2.0(15-Jun-2012)
Functionality added or changed:
* Driver available in Unicode and ANSI versions(WL#5850)
* Driver by default uses server side prepared statements
* Connection string option NO_SSPS prevents using of server side prepared
statements. It is configurable via GUI dialog.
Built using MySQL 5.5.25.
----
5.1.11(28-Apr-2012)
Functionality added or changed:
* MyODBC queries log is written to %TEMP%\myodbc.sql, or to C:\myodbc.sql if
TEMP is not defined.
* Added pre-fetch functionality and PREFETCH connection string option
implemented through LIMIT to avoid reading the entire resultset for full
table SELECT queries. (WL#6211)
Bugs fixed:
* Fractional parts of second is ignored in SQLGetData. (Bug #12767740/60646)
* ODBC prepared statements ignore fractional part of temporal data types.
(Bug #12767761/60648)
* Memory leak on Windows on each connection attepmt. (Bug #11766029/59059)
* SQLTables() function does not return the catalog correctly if the wildcard
or SQL_ALL_CATALOGS is used. (Bug #13914518)
Built using MySQL 5.5.18.
----
5.1.10(02-Feb-2012)
Functionality added or changed:
Bugs fixed:
* In some cases TIMESTAMP field could be described as SQL_NO_NULLS.
(Bug #13532987)
* SQLFetch has to return error if indicator pointer is NULL for NULL value.
(Bug #13542600)
* A failure on one stmt causes another stmt to fail. (Bug #13097201/#62657)
Built using MySQL 5.5.18.
----
5.1.9 (04-Oct-2011)
Functionality added or changed:
* Support of windows authentication.
Bugs fixed:
* SQLFetch() did not return SQL_ERROR if connection was dropped due to a
timeout. (Bug #39878)
* MS Access with VARCHAR NOT NULL columns. (Bug #31067)
* sqlwcharchr might read one SQLWCHAR after end of string. (Bug #61586)
* Column parameter binding makes SQLExecute not to return SQL_ERROR on
disconnect. (Bug #59772)
* If pre-execution failed some catalog functions called right after that
would return only one row. (Bug #12824839)
* MyODBC driver does not call mysql_thread_end() when the thread ends causing
error messages such as this: Error in my_thread_global_end(): 1 threads
didn't exit. (Bug #57727)
* When NO_BINARY_RESULT was set driver failed to perform the expected data
conversion. (Bug#11765110/58038)
Built using MySQL 5.5.16.
----
5.1.8 (08-Nov-2010)
Functionality added or changed:
Bugs fixed:
* MySQL ODBC Connector on Windows 2008 64bit. (Bug #56233)
* SQLNumResultCols() causes the driver to return only first row in the
resultset. (Bug #56677)
* Connector/ODBC 5.1 series requires uninstall prior to installing a new
version. (Bug #54314)
* SQLDescribeCol and SQLColAttribute cannot be called before SQLExecute.
(Bug #56717)
* Errors would not be reported in bulk upload. (Bug #56804)
* MSI installer does not set InstallLocation value in registry. (Bug #56978)
* SQLProcedureColumns doesn't work with certain data/parameters combinations.
(Bug #57182)
* SQLRowCount return wrong result row count for SQLTables and some other
catalog functions. (Bug #57182)
Built using MySQL 5.1.46sp1.
----
5.1.7 (24-Aug-2010)
Functionality added or changed:
* Options in the GUI are groupped on named tabs.
* Added connection option INTERACTIVE that tells driver that client is
ineractive and interactive_timeout has to be used. (Bug #48603)
* Added parameters arrays support. (Bug #48310)
* SQLTables uses now INFORMATION_SCHEMA. Added connection option to use old code.
(Bug #43644)
* Added GUI options for MIN_DATE_TO_ZERO and ZERO_DATE_TO_MIN connection
options. (Bug #30539)
* Function SQLProcedureColumns() implemented. (Bug #50400)
* Added NO_I_S connection option.
Bugs fixed:
* If NO_BACKSLASH_ESCAPES mode is used on a server, escaping binary data
can lead to server query parsing errors. (Bug #49029)
* Error if unsupported client character set is encountered(for wchar data).
(Bug #36996)
* Binding bit field to a numeric types doesn't work. (Bug #32821)
* Conversion flags are not complete. (Bug #43855)
* SQL_ATTR_MAX_ROWS make some SELECT statement invalid. (Bug #49726)
* Certain column attributes aren't correct for date columns. (Bug #44576)
* SQLPrepare causes Prefetch of table. (Bug #46411)
* If there are foreign key constraints with same name for tables with same
names in 2 schemas, SQLForeignKeys can return rows for both
schemas in query about one of those tables. (Bug #49660)
* SQLForeignKeys included in results rows for foreign keys pointing to unique fields
(Bug #51422)
* SQLPrimaryKeys returns mangled strings. (Bug #36441)
* Spaces in connection string aren't removed (Bug #45378)
* SQLColumns returns wrong transfer octet length. (Bug #53235)
* Retrieving of current catalog at the moment when connection is not ready for
that(broken, not all pending results processed) leads to application crash.
(Bug #46910)
* SQLForeignKeys unacceptable performance getting imported FK. (Bug #39562)
* SQLTablePrivileges requires SELECT privilege on mysql database. (Bug #50195)
* Column octet length includes terminating null byte. (Bug #54206)
* Wrong type returned by SQLColAttribute(SQL_DESC_PRECISION...) in 64-bit
systems. (Bug #55024)
----
5.1.6 (09-Nov-2009)
Functionality added or changed:
* Providing an empty string as the catalog argument to SQLTables()
will return an empty result set. A catalog must have a name.
* Remove use of "old" SQLLEN/SQLULEN types aliases. They are not
supported in unixODBC 2.2.13 and later 64-bit builds. Removed
SQLROWCOUNT, SQLROWSETSIZE, SQLTRANSID, SQLROWOFFSET.
* Connection parameters can be specified individually instead of
using OPTIONS bitflags. (See connection parameters documentation)
* Edit controls for INITSTMT and CHARSET DSN options are added to the native
Windows GUI. (Bug #40932)
* Length/Indicator pointer is now stored and used internally as pointer to
SQLLEN and not to SQLINTEGER. Using SQLINTEGER pointers as
StrLen_or_IndPtr parameter of SQLBindParameter/SQLBindCol may cause crash
on 64bit platforms.
* Query log is not overwritten, but appended instead. (Bug #44965)
* Fixed tab order in Windows datasource config dialog. (Bug #42905)
Bugs fixed:
* Add support for data-at-execution with positioned insert/update
(Bug #37649)
* Output string length from SQLDriverConnect() includes NULL-term
(Bug #38949)
* SQLGetInfo() returns 0 for SQL_CATALOG_USAGE info (Bug #39560)
* SQLDriverConnect() may truncate output string erroneously
(Bug #37278)
* SQLTables() doesn't properly handle empty strings to list catalogs
and tables. (Bug #39561)
* Calling SQLDriverConnect() with no output buffer will crash if not
prompting. (Bug #40316)
* SQLTables() doesn't return the catalog name if the table is given
and the catalog argument is NULL. (Bug #39957)
* Driver crashes when attempting to retrieve data in a character set
not compiled into libmysql. (Bug #39831)
* SQLGetTypeInfo() doesn't return any rows SQL_TIMESTAMP on an ODBC v2
connection. (Bug #30626)
* Positioned update with SQL_C_NUMERIC loses prec/scale values
(Bug #39961)
* ADO adUseServer cursor is lost after updating adLongVarWChar field
(Bug #26950)
* Calling SQLDescribeCol() with a NULL buffer and non-zero buffer
length causes a crash. (Bug #41942)
* NULL parameters don't work correctly with ADO. (Bug #41256)
* Unable to retrieve null DECIMAL fields in ADO. (Bug #41081)
* Fix positioned update using data-at-execution, bind offsets and
row-wise binding. (Bug #36071)
* SQLConfigDataSource may fail with: Cannot find driver (Bug #41796)
* FLAG_NO_BIGINT still returns bigint for SQLDescribeCol()
(Bug #17679)
* Random access violation exceptions (0xC0000005) in ASP scripts in the
SQLSetConnectAttrW. (Bug #44971)
* Binding SQL_C_BIT to an integer column didn't work. (Bug #39644)
* Inserting a new record using SQLSetPos if the table is from different than
current catalog. (Bug #41946)
Includes changes from Connector/ODBC 3.51.27.
Built using MySQL 5.1.34sp1.
----
5.1.5 (18-Aug-2008)
Functionality added or changed:
* Added FLAG_NO_BINARY_RESULT connection option to always handle
binary function results as character data. (Bug #29402)
Bugs fixed:
* Some catalog functions used fixed-sized buffers for handling
arguments that could be overrun, and misinterpreted some arguments
as patterns when they should be treated as identifiers. (Bug #36275)
* SQLDriverConnect() returned SQL_ERROR when the user cancelled
the dialog box instead of SQL_NO_DATA. (Bug #36293)
* System DSN lookup (using ODBC_BOTH_DSN) fails on Windows XP.
(Bug #36203)
* SQLProcedures() followed by SQLFreeStmt() crashes (Bug #36069)
* ADO adUseServer cursor is lost after updating adLongVarWChar field
(Bug #26950)
* SQL_TYPE_TIMESTAMP and SQL_TYPE_TIME parameters were incorrectly
included when parameters were expanded. (Bug #37342)
* DSN-less connection prompting cannot look up driver entry
(Bug #37254)
Includes changes from Connector/ODBC 3.51.26.
Built using MySQL 5.0.60sp1.
----
5.1.4 (15-Apr-2008)
Bugs fixed:
* SQLGetDiagRec() sometimes returned SQL_SUCCESS but no error
message. (Bug #33910)
* Driver installer (myodbc-installer.exe) fails to create a new DSN
(Bug #35776)
* Get wrong result with decimal(8,2) field type (Bug #35920)
Includes changes from Connector/ODBC 3.51.25.
Built using MySQL 5.0.56sp1.
----
5.1.3 (26-Mar-2008)
Functionality added or changed:
* Added SSLVERIFY connection option to verify server certificate. By default
certificate is not verified now. (Bug #34648)
* Database list height is autoadjusted in Windows GUI. (Bug #33918)
* Added new connection string option DFLT_BIGINT_BIND_STR
Bugs fixed:
* Recordset-based update fails if blob field is queried. (Bug #19065)
* Descriptor records were not cleared correctly when calling
SQLFreeStmt(SQL_UNBIND). (Bug #34271)
* The driver incorrectly reported that the SQL standard CAST() and
CONVERT() functions were supported. (Bug #33808)
* Unresolved symbols "min" and "max" in libmyodbc3.so w/gcc 4.2.
(Bug #34256)
* Notorious #DELETED problem when linking tables in Access and BIGINT PK
(Bug #24535)
* MyODBC 51/Access unable to use DBEngine.RegisterDatabase to create a DSN
(Bug #33825)
* Unable to use surrogate pairs into with unicode column. (Bug #34672)
* SQLGetData w/SQL_C_WCHAR gives incorrect data. (Bug #34429)
Includes changes from Connector/ODBC 3.51.24.
Built using MySQL 5.0.52.
----
5.1.2 (12-Feb-2008)
Functionality added or changed:
* SQLForeignKeys uses INFORMATION_SCHEMA when it is available on the server,
which allows more complete information to be returned.
* Disabled MYSQL_OPT_SSL_VERIFY_SERVER_CERT when using an SSL connection.
* Explicit descriptors are implemented. (Bug #32064)
* Changed SQL_ATTR_PARAMSET_SIZE to return an error until support for it
is implemented.
Bugs fixed:
* Tried to use the already-entered database when connecting to get list of
databases in Windows setup library. (Bug #33615)
* SQLForeignKeys returned an empty string for the schema columns instead of
a NULL. (Bug #19923)
* SQLGetInfo() reported characters for SQL_SPECIAL_CHARACTERS that were
not encoded correctly. (Bug #33130)
* Adding or updating a row using SQLSetPos() on a result set with aliased
columns would fail. (Bug #6157)
* Changing the DSN name when editing a DSN left behind the DSN
under the old name in addition to creating the new entry. Fixed for
native Windows GUI. (Bug #31165, fixed for Qt GUI in 3.51.23)
* Numeric values (such as OPTIONS or PORT) were not read correctly
from a connection string if they were not the last parameter. (Bug #33822)
* The SSLCIPHER option was saved incorrectly on Windows. (Bug #33897)
* The cursor position was incorrect after rows were deleted from a
static cursor. (Bug #33388)
* Dynamic cursors on statements with parameters were not supported.
(Bug #11846)
* FLAG_COLUMN_SIZE_S32 did not limit the octet length or display size
reported for fields, causing problems with Microsoft Visual
FoxPro. (Bug #30890)
* Retrieving SQL_C_WCHAR data with SQLGetData() could crash due to
incorrect handling of the buffer length. (Bug #32684)
Includes changes from Connector/ODBC 3.51.23.
Built using MySQL 5.0.52.
----
5.1.1 (12-Dec-2007)
Functionality added or changed:
* Added MSI installer for Windows 64-bit. (Bug #31510)
* Implemented support for SQLCancel(). (Bug #15601)
* Added wrappers for missing ODBC driver manager installer functions.
This makes it possible to use the driver with unixODBC 2.2.11, which
is the version shipped with Debian and Ubuntu. (Bug #32685)
* Disallow 'SET NAMES' in initial statement and in executed statements.
* Replaced the internal library which handles creation and loading
of DSN information. The new library, which was originally a part of
Connector/ODBC 5.0, supports Unicode option values.
* Implemented native Windows setup library.
* Removed monitor (myodbc3m) and dsn-editor (myodbc3c).
* Replaced myodbc3i (now myodbc-installer) with Connector/ODBC 5.0
version.
* Added support for SQL_NUMERIC_STRUCT (Bug #3028, #24920).
* Removed non-threadsafe configuration of the driver. The driver is
now always built against the threadsafe version of libmysql.
Bugs fixed:
* SQL statements were limited to 64k. (Bug #30983)
* Diagnostics were not correctly cleared on connection and
environment handles.
* SQLCopyDesc() did not correctly copy all records.
* Freeing a statement resulted in a memory leak due to descriptor
records not being freed. (Bug #31115)
* SQL_ODBC_SQL_CONFORMANCE was not handled by SQLGetInfo().
* NULL pointers passed to SQLGetInfo() could result in a crash.
* Passwords with ';' were not handled correctly. (Bug #16178)
* Binding of columns between calling prepare and execute caused premature
statement execution. (Bug #29239)
* ADO could not open a recordset that has a DECIMAL field (Bug #31720)
* SQLError() incorrectly cleared the error information, making it
unavailable from subsequent calls to SQLGetDiagRec().
* ADO was unable to open record set using dynamic cursor. (Bug #32014)
* SQLSetConnectAttr() did not clear previous errors, possibly confusing
SQLError().
* SQLDescribeColW returned UTF-8 column as SQL_VARCHAR instead of
SQL_WVARCHAR. (Bug #32161)
* Fixed SQL_ATTR_PARAM_BIND_OFFSET, and fixed row offsets to work
with updatable cursors.
* SQLSetPos w/SQL_DELETE advances dynamic cursor incorrectly. (Bug #29765)
* Recordset Update() fails in 5.1 ODBC connector when using adUseClient
cursor. (Bug #26985)
* MyODBC 5/ ADO Not possible to update a client side cursor. (Bug #27961)
* Intermixing of SQLGetData() using SQL_C_CHAR and SQL_C_WCHAR on the same
field value was incorrect. (Bug #28617)
* SQLNativeSql() didn't properly handle the output length pointer.
(Bug #10128 & Bug #31049)
Includes changes from Connector/ODBC 3.51.21 and 3.51.22.
Built using MySQL 5.0.52.
----
5.1.0 (8-Sep-2007)
Functionality added or changed:
* Added support for SQL_C_WCHAR.
* Added support for Unicode functions (SQLConnectW, etc).
* Added descriptor support (SQLGetDescField, SQLGetDescRec, etc).
----
3.51.27 (20-Nov-2008)
Bugs fixed:
* Cannot use SSL (Bug #29955)
* Enable auto reconnect doesn't work (Bug #37179)
* Add read and write timeouts on the connection (Bug #40407)
----
3.51.26 (7-Jul-2008)
Bugs fixed:
* Access Violation in myodbc3.dll (Bug #30770)
* Truncation of "SHOW CREATE TABLE" result (Bug #24131)
* Added a new connection option FLAG_NO_BINARY_RESULT. Fixed
field type charset 63 problem. (Bug #29402)
----
3.51.25 (11-Apr-2008)
Bugs fixed:
* SQL_DESC_FIXED_PREC_SCALE was possibly being reported as true, but it's
never supported. (Bug #35581)
* ADO failed to retrieve the length of LONGBLOB columns. (Bug #12805)
----
3.51.24 (14-Mar-2008)
Bugs fixed:
* ConfigDSN() returned FALSE when the dialog was cancelled by the user.
* Static cursor was unable to be used through ADO when dynamic cursors
were enabled. (Bug #27351)
* Driver would crash when requesting the current catalog before connecting.
(Bug #16653)
* Catalog data was truncated due to NAME_LEN only allocating a single byte
for characters. (Bug #32864)
* SSL connections could not be established properly. Added the server
certificate verification flag. (Bug #29955)
* Added deprecated SQLSetParam function. (Bug #29871)
* Recordset-based update fails if blob field is queried. (Bug #19065)
* Allows dirty reading with SQL_TXN_READ_COMMITTED isolation through ODBC
(Bug #31959)
* Don't cache results and SQLExtendedFetch work badly together.
(Bug #32420)
* SQLFetch or SQLFetchScroll returns negative data length using SQL_C_WCHAR.
(Bug #31220)
* An SQLSTATE of HY000 was returned when a stored procedure was not found,
instead of 42000. This caused problems with ADO's adCmdUnknown option.
(Bug #27158)
* Identifiers were quoted incorrectly by SQLColumns(). (Bug #32989)
* Worked around bug in iODBC installer library that made it impossible
to create a system DSN, particularly on Mac OS X, where the installer
created the /Library/ODBC/*.ini files with insufficient permissions.
(Bug #31495)
* Unresolved symbols "min" and "max" in libmyodbc3.so w/gcc 4.2.
(Bug #34256)
* Fixed some incorrect information returned by SQLGetTypeInfo().
(Bug #30918)
* Values bound using the SQL_C_CHAR value type but with numeric
parameter type were not correctly escaped. (Bug #34575)
* The driver reported that it does not support SQLProcedureColumns(),
which causes problems for ADO. (Bug #33298)
----
3.51.23 (9-Jan-2008)
Bugs fixed:
* Allowed connections to be enlisted in distributed transactions, even
though the driver doesn't support them. (Bug #32727)
* Cleaning up environment handles in multithread environments could result
in a five (or more) second delay. (Bug #32366)
* SQLAllocStmt() and SQLFreeStmt() did not synchronize access to the
list of statements associated with a connection. (Bug #32857)
* SQLGetInfo() returned the wrong value for SQL_DATABASE_NAME when no
database was selected. (Bug #3780)
* Changing the DSN name when editing a DSN left behind the DSN
under the old name in addition to creating the new entry. (Bug #31165)
----
3.51.22 (13-Nov-2007)
Functionality added or changed:
* Removed workaround for bug #10491 in the server, which has now been
fixed in MySQL Server 5.0.48 and 5.1.21.
* Added FLAG_COLUMN_SIZE_S32 to limit the reported column size to a
signed 32-bit integer. This option is automatically enabled for ADO
applications, in order to work around a bug in ADO. (Bug #13776)
Bugs fixed:
* SQLGetInfo() reported that UNION was not supported. (Bug #32253)
* The non-portable "English" locale was used for handling of decimal
and floating-point values instead of "C". (Bug #32294)
* Unsigned integer values greater than the maximum value of a signed
integer were handled incorrectly. (Bug #32171)
* The wrong result was returned by SQLGetData() when the data was an
empty string and a zero-sized buffer was specified. (Bug #30958)
----
3.51.21 (5-Oct-2007)
Bugs fixed:
* The wrong value was returned for SQL_DESC_LITERAL_PREFIX and
SQL_DESC_LITERAL_SUFFIX for date-time fields. (Bug #31009)
* The wrong SQLSTATE was reported when the connection to the server
was lost. (Bug #3456)
* SQLDescribeCol() incorrectly reported whether auto-increment and
some timestamp fields were nullable. (Bug #26108)
* SQLGetTypeInfo() reported the wrong column size for the SQL_TYPE_TIME
type. (Bug #30939)
* Empty selection for database and character set comboboxes in setup
were set to " " instead of an empty string. (Bug #30568)
* Fixed incorrect input requirement in the setup dialog. (Bug #30499)
* Added SQLSetParam function and fixed handling of buffer length in
SQLBindParameter. (Bug #29871)
* Fixed SQLSetPos that generated incorrect INSERT statement for result
columns without bound data buffers. (Bug #31246)
----
3.51.20 (7-Sep-2007)
Bugs fixed:
* The FLAG_NO_PROMPT option was not handled by SQLDriverConnect().
(Bug #30840)
* Removed checkbox in setup dialog for FLAG_FIELD_LENGTH ("Don't
Optimize Column Width"), which was removed from the driver in 3.51.18.
* The wrong column size was returned for binary data. (Bug #30547)
* The specified length of the username and authentication parameters to