Up to [cvs.NetBSD.org] / pkgsrc / databases / myodbc
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
Update to myodbc-8.0.43. pkgsrc changes: appease pkglint package changes: unknown
myodbc: update to 8.0.31. Fixes build. Changes: Now for mysql80*. Otherwise, too many to list here, see https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0.html for details.
myodbc: Update to 5.3.14
5.3.14
Security Notes:
Functionality added or changed:
* Unit tests will allocate/deallocate STMT/DBC/ENV for each test
* Added processing of new UTF8MB4 collations
Bugs fixed:
* myodbc-installer does not show all DSN options (Bug #29753227/95290)
* MASTER: Crash noticed in SQLSetPos (Bug #29630465)
Built using MySQL 5.7.28
5.3.13
Security Notes:
* Connector/ODBC 5.3.13 Commercial upgrades the linked OpenSSL
library to version 1.0.2r which has been publicly reported
as not vulnerable to CVE-2019-1559
(Bug #29489006, CVE-2019-1559)
Functionality added or changed:
Bugs fixed:
* SQL_NO_DATA when fetching VARCHAR(500) with filter
(Bug# 29512548/94545)
Built using MySQL 5.7.26
5.3.12
Security Notes:
Functionality added or changed:
* New connection option for ODBC driver to enable LOAD DATA LOCAL INFILE
Bugs fixed:
* Dynamic linking is broken in MyODBC 5.3.11 (Bug# 28609434/92319)
* Crash in SQLBulkOperations when NO_SSPS is set to 0 (Bug #28289320)
Built using MySQL 5.7.25
5.3.11
Security Notes:
* Fix issues found by Fortify (WL #11829)
Functionality added or changed:
* Fixes in ODBC 5.3 from 8.0 code merge (WL #12199)
* Make sure ODBC 5.3 works with new 8.0 auth. mechanism. (WL #11962)
Bugs fixed:
* Source character set not supported by client error on SHOW TABLES command
(Bug# 28116892/90984)
* SQLColAttribute/SQL_DESC_TYPE_NAME text instead of longtext for
longtext col (Bug# 11761407/53900)
* Connector uses UTF8 charset instead of UTF8MB4 (Bug# 28204756)
* SQLMoreResults does not set statement errors correctly
(Bug# 11757423/49466)
* Master: Connection fails for cache256 user when GET_SERVER_PUBLIC_KEY=1
(Bug# 28359632)
Built using MySQL 5.7.23
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)
----
myodbc: remove gui option from PLIST
Update to MySQL Connector-ODBC 5.3.2.
pkgsrc change: add 56 to MYSQL_VERSIONS_ACCEPTED
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)
* Accessibility features in Connector/ODBC Linux GUI (WL #7635)
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)
----
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)
* 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.
Upgrade to version 5.2.2:
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
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
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 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)
----
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.
Changes 5.1.8: * Documentation in .CHM and .HLP format has been removed from the distribution. * For some procedure and parameter combinations SQLProcedureColumns() did not work correctly. For example, it could not return records for an existing procedure with correct parameters supplied. * Further, it returned incorrect data for column 7, TYPE_NAME. For example, it returned VARCHAR(20) instead of VARCHAR. * The MySQL Connector/ODBC MSI installer did not set the InstallLocation value in the Microsoft Windows registry. * In bulk upload mode, SQLExecute would return SQL_SUCCESS, even when the uploaded data contained errors, such as primary key duplication, and foreign key violation. * SQLDescribeCol and SQLColAttribute could not be called before SQLExecute, if the query was parameterized and not all parameters were bound. * Note, MSDN states that “For performance reasons, an application should not call SQLColAttribute/SQLDescribeCol before executing a statement.” However, it should still be possible to do so if performance reasons are not paramount. * When SQLNumResultCols() was called between SQLPrepare() and SQLExecute() the driver ran SET @@sql_select_limit=1, which limited the resultset to just one row. * After installing MySQL Connector/ODBC, the system DSN created could not be configured or deleted. An error dialog was displayed, showing the error message “Invalid attribute string”. * In this case the problem was due to the fact that the driver could not parse the NULL-separated connection string. * When used after a call to SQLTables(), SQLRowCount() did not return the correct value.
Update to MYSQL Connector/ODBC 5.1.6 so this will actually work
with a modern version of MySQL. Also, fix some DESTDIR issues.
5.1.6
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 lookup 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)
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)
Remove @dirrm entries from PLISTs
pullup ticket #2583 - requested by bouyer
myodbc: update package for bug fixes
revisions pulled up:
pkgsrc/databases/myodbc/Makefile 1.18
pkgsrc/databases/myodbc/PLIST 1.5
pkgsrc/databases/myodbc/distinfo 1.6
pkgsrc/databases/myodbc/patches/patch-aa r0
pkgsrc/databases/myodbc/patches/patch-ab r0
Module Name: pkgsrc
Committed By: bouyer
Date: Tue Nov 11 20:29:27 UTC 2008
Modified Files:
pkgsrc/databases/myodbc: Makefile PLIST distinfo
Removed Files:
pkgsrc/databases/myodbc/patches: patch-aa patch-ab
Log Message:
Update to mysql-connector-odbc-3.51.26r1127 (from 3.51.12). Most
important change: 3.51.12 doesn't work anymore with mysql-client-5.0.67nb1,
a function has been removed from the mysql-client library.
Other changes:
* lots of bug fixes
* 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)
* Added FLAG_MULTI_STATEMENTS to allow issuing queries that contain
multiple statements. Also added to the setup GUI. (Bug #7445)
* Removed support for the TRACE and TRACEFILE DSN options. The standard
ODBC logging should be used.
* Added support for SQL_ATTR_ROW_BIND_OFFSET_PTR in normal cursors.
(Bug #6741)
* Added SSL options to the GUI setup dialog.
* Added an option (CHARSET) for specifying the default character
set for a connection. This must be used instead of a "SET NAMES"
statement. Also available from the GUI setup dialog. (Related
to Bug #6667 and Bug #9498.)
* Dis-allow NULL ptr for null indicator when calling SQLGetData()
if value is null. Now returns SQL_ERROR w/state 22002.
* Fixed calling convention ptr and wrong free in myodbc3i, and fixed
the null terminating (was only one, not two) when writing DSN to string.
* Added support for using SSL. This is not yet exposed in the setup GUI,
but must be enabled through configuration files or the DSN. (Bug #12918)
* Added auto-reconnect option because automatic reconnect is now
disabled by default in libmysql
* Added auto is null option (Bug #10910)
* Added support for SQLMoreResults
* Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to
check for a dead connection.
* Remove ODBC escape syntax { and } that begin and terminate statements,
allowing {CALL (?)} for procedures that don't require OUT or INOUT
parameters
* Improved regression tests
* Added --with-separate-debug-driver ./configure option
Update to mysql-connector-odbc-3.51.26r1127 (from 3.51.12). Most
important change: 3.51.12 doesn't work anymore with mysql-client-5.0.67nb1,
a function has been removed from the mysql-client library.
Other changes:
* lots of bug fixes
* 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)
* Added FLAG_MULTI_STATEMENTS to allow issuing queries that contain
multiple statements. Also added to the setup GUI. (Bug #7445)
* Removed support for the TRACE and TRACEFILE DSN options. The standard
ODBC logging should be used.
* Added support for SQL_ATTR_ROW_BIND_OFFSET_PTR in normal cursors.
(Bug #6741)
* Added SSL options to the GUI setup dialog.
* Added an option (CHARSET) for specifying the default character
set for a connection. This must be used instead of a "SET NAMES"
statement. Also available from the GUI setup dialog. (Related
to Bug #6667 and Bug #9498.)
* Dis-allow NULL ptr for null indicator when calling SQLGetData()
if value is null. Now returns SQL_ERROR w/state 22002.
* Fixed calling convention ptr and wrong free in myodbc3i, and fixed
the null terminating (was only one, not two) when writing DSN to string.
* Added support for using SSL. This is not yet exposed in the setup GUI,
but must be enabled through configuration files or the DSN. (Bug #12918)
* Added auto-reconnect option because automatic reconnect is now
disabled by default in libmysql
* Added auto is null option (Bug #10910)
* Added support for SQLMoreResults
* Checking SQL_ATTR_CONNECTION_DEAD now always calls mysql_ping() to
check for a dead connection.
* Remove ODBC escape syntax { and } that begin and terminate statements,
allowing {CALL (?)} for procedures that don't require OUT or INOUT
parameters
* Improved regression tests
* Added --with-separate-debug-driver ./configure option
Convert to use PLIST_VARS instead of manually passing "@comment " through PLIST_SUBST to the plist module.
Update to 3.51.12 (latest stable version). There were zillions of changes... please see the Changelog file. Now it builds with both mysql-4.1.x and mysql-5.1.x. pkgsrc changes: Supported build options: * myodbc-gui: builds the QT widgets library. (disabled) * myodbc-iodbc: uses iodbc for the odbc functions. (enabled) * myodbc-unixodbc: uses unixodbc for the odbc functions. (disabled) Uses MASTER_SITE_MYSQL.
Mechanical changes to package PLISTs to make use of LIBTOOLIZE_PLIST. All library names listed by *.la files no longer need to be listed in the PLIST, e.g., instead of: lib/libfoo.a lib/libfoo.la lib/libfoo.so lib/libfoo.so.0 lib/libfoo.so.0.1 one simply needs: lib/libfoo.la and bsd.pkg.mk will automatically ensure that the additional library names are listed in the installed package +CONTENTS file. Also make LIBTOOLIZE_PLIST default to "yes".
Move pkg/ files into package's toplevel directory