./databases/sqlrelay-odbc, ODBC support for SQL Relay

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 1.9.3, Package name: sqlrelay-odbc-1.9.3, Maintainer: pkgsrc-users
Required to run:
[databases/sqlrelay] [databases/unixodbc] [devel/libltdl] [devel/rudiments]

Required to build:

Master sites:

Filesize: 4788.225 KB

Version history: (Expand)

CVS history: (Expand)

   2022-12-03 16:53:41 by Adam Ciarcinski | Files touched by this commit (16) | Package updated
Log message:
sqlrelay: updated to 1.9.3

1.9.3 - added some missing SQLGetInfo() attributes to the ODBC driver
        backported fixes for PHP 8
        backported support for Oracle 18 and 19
        backported a fix for some missing map clears in postgresql protocol
        backported a fix for NULL-binds in the ODBC driver
        backported -fdeclspec configure test for ruby with clang
        backported a postgresql isnull fix
        backported patch from Kyle to use HH24 instead of HH in default
                fakeinputbindvariablesdateformat string
        backported mysql connection segfault fix
        disabled PQsendQueryPrepared/PQsetSingleRowMode to fix nested query
                bug with postgresql
        backported postgresql noRowsToReturn fix

1.9.2 - ruby cursor constructor marks associated ruby connection object now
        updated bad-command and no-cursor-available handling in sqlrclient
                protocol module
        fixed a subtle bug that could cause closeResultSet()/clearError() not
                to be called between reexecutes if the previous execute resulted
                in an error
        backported support for password files in userlist auth modules

1.9.1 - fixed some missing map clears in postgresql protocol module
        fixed NULL-bind in the ODBC driver

1.9.0 - added missing inequality operators to end-of-bind detection
        fixed commit/begin without commitcount error in sqlrimportcsv
        fetch errors aren't returned if sqlrclient protocol version < 2
        query-intercept catches "begin transaction" now
        query-intercept doesn't intercept various begin-type statements if the
                query is actually a block of sql containing commit or rollback
        added ncharencoding option to odbc connection to enable UTF-16 values
                in SQL Server nchars/nvarchars
        fixed a bug that caused output binds of length 8000+ to fail on
                SQL Server
        begin() runs "begin transaction" instead of just \ 
"begin" on SQL Server
        fixed a column-count reset bug in odbc, db2, informix, and postgresql
                that could cause begin queries to fail when fake transaction
                blocks are used
        object lists have correct column names for mysql, odbc, and jdbc now
        fixed a bug that caused rollback to be called insted of commit when
                endofsession="commit" and faketransactionblocks=yes \ 
are used
        commit/rollback is now called at the end of session when
                faketransactoinblocks=yes is used, whether or not the server
                believes it's in a transaction block, to catch cases where the
                begin-interceptor is intentionally bypassed
        sqlrimportcsv handles dates without centuries now
        fixed crash in replay module when table name is quoted
        mysql explain statements work now
        fixed node-gyp.js detection on ubuntu 20.04
        added configure options for PHP 8.x
        added php/pdo module tweaks for PHP 8
        mysql and postgresql protocol modules support TLS now
        pushed most of tls/gss code up into sqlrprotocol parent class
        fixed subtle issues in mysql/postgresql database modules that could
                sometimes cause reexecutes of the same query with the same
                bind variables to return no results the second time
        the configure script specifically looks for liberl_interface.a now
        updated nodejs macros for node 14+
        fixed subtle bugs in Python getField, getFieldLength, and
                getRowLengthsDictionary functions
        added GVL management to the Ruby API
        applied patch from Igor to fix configure.vbs VC++ version detection
                for non-US versions
   2022-10-26 12:32:08 by Thomas Klausner | Files touched by this commit (687)
Log message:
*: bump PKGREVISION for libunistring shlib major bump
   2022-06-28 13:38:00 by Thomas Klausner | Files touched by this commit (3952)
Log message:
*: recursive bump for perl 5.36
   2021-12-08 17:07:18 by Adam Ciarcinski | Files touched by this commit (3063)
Log message:
revbump for icu and libffi
   2021-09-29 21:01:31 by Adam Ciarcinski | Files touched by this commit (872)
Log message:
revbump for boost-libs
   2021-05-24 21:56:06 by Thomas Klausner | Files touched by this commit (3575)
Log message:
*: recursive bump for perl 5.34
   2021-04-21 15:25:34 by Adam Ciarcinski | Files touched by this commit (864)
Log message:
revbump for boost-libs
   2021-02-16 14:12:40 by Adam Ciarcinski | Files touched by this commit (20) | Package updated
Log message:
sqlrelay: updated to 1.8.0

SQL Relay 1.8.0

This release mainly lays the groundwork for some future features, including a \ 
generic import/export framework. Some notable progress was also made on the JDBC \ 
driver, though it's still not finished. The most significant (finshed) new \ 
feature is an aes128 password encryption module.

There are some bugfixes as well. A long-standing issue with postgresql that \ 
could cause results from multiple open cursors to get confused has been \ 
resolved. A subtle error that could cause counting of bind variables on the \ 
client-side to hang has been fixed. A long-standing, but apparently obscure, \ 
issue that could cause tables from other MySQL schemas to be included in a \ 
"show tables" command has been fixed. As well as various other issues.

Full ChangeLog follows:

unattended tests
added sqlrresultsetdomnode class to c++ client API
fixed datedelimiters parameter
added support for SQLParamOptions with SQLUINTEGER arguments
sqlr-import detects uppercase .CSV suffix now
fixed a csv number-detection but in sqlr-import
fixed a delete[] of a const in sqlr-import
it's possible to specify a commitcount of 0 with sqlr-import now
moved sqlrimportxml/csv classes into libsqlrclient
moved sqlrexportxml/csv classes into libsqlrclient
csv import/export is consistent now
added some event methods to sqlrexport
migrated parsedatetime functions to rudiments datetime class
different postgresql cursors use different stmtNames now
sqlrimportcsv can create a primary key that's not in the CSV now
sqlrexportcsv quotes 12+ digit numbers now
fixed subtle, count-related issues when validating bind variables on the client \ 
side, that could cause a hang
added an aes128 pwdenc module
applied a patch to fix a crash in the debug logger (missing "%s")
added a tweak to getsitearchdir.rb to fix incorrect lib/lib64 reporting on some \ 
centos x64 systems
fixed mysql getColumnList to distinquish proper db/schema

SQL Relay 1.7.0

This release adds 2 significant features: support for the PostgreSQL \ 
client-server protocol, and a "replay" module to help automatically \ 
recover from deadlocks and lock-timeouts, but also has the usual assortment of \ 
minor bugfixes and internal changes.

Full ChangeLog follows:

added postgresql protocol module
updated postgresql connection module to get column info pre-execute
fixed postgresql connection module type oid bug
added tag filter/moduledata
added moduledata(s)::closeResultSet()/endTransaction()/endSession()
mysql protocol returns empty lobs correctly now (not as nulls)
configure replaces -lfbclient with -lgds on freebsd/firebird-2.0.3
fixed a bug that could cause sqlr-stop to try to kill pid 0
fixed unixodbc detection on solaris 11.4
added configure test for PQdescribePrepared
test improvements
documentation improvements
split sqlrelay-crash directive into its own module
deprecated drop-in replacement libraries in favor of protocol support
fixed various mysql 4.x bugs
sqlr-status creates statistics on heap now instead of stack, to work on \ 
platforms with a small default ulimit stack
mysql stored procedure test is bypassed for older mysql
tls test is bypassed for older openssl
added NULL handoff socket workaround
improved shutdown/crash handlers for sqlr-listener/connection
fixed hang when more-than-one address was specified in the instance:addresses \ 
*_null used instead of *_unset on PHP 7.4

SQL Relay 1.6.0

This release mainly addresses some recently discovered regressions, but also \ 
adds some internal features that required the minor version to be bumped.

ChangeLog follows:

added begin, commit, rollback events
fixed array_init() calls for php-7.3
integrated my_bool fix for mysql 8.0.1+
mysql sslmode=require/prefer + bad sslca/sslcapath generates warning rather than \ 
error now (like the mysql cli)
refactored various routines that parse bind variables out of queries
added bindvariabledelimiters config option to define supported bind variable \ 
added fakeinputbindvariablesunicodestrings config option
added bind variable delimiters config methods to c++ api
replay trigger can now run a query (eg. "show engine innodb status") \ 
and log the reslits to a file when a replay condition occurs
replay trigger doesn't log/replay selects by defalit now (but this is configurable)
updated normalize translation to support queries containing binary data
fixed a backslash-escape bug in the normalize translation
refactored some sqlrclient api private methods
refactored various bind-manipliation/detection methods
sqlr-listener creates tmpdir now on start, if it doesn't exist (because this is \ 
often in /run, which is often a tmpfs)
postgresql connection modlie forces re-fetch of column data after execute now
everything uses charstring::isYes/isNo now, instead of direct comparisons \ 
against "yes" or "no"
fixed subtle sqlexecdirect bug
fixed subtle sqlserver max-varchar bind length bug
fixed various subtle sqlserver bugs where column-info isn't valid until after execute
odbc connection modlie sets column precision = column length if column precision = -1
when using odbc on front and back end, the object type works in SQLTables now
reslit set translations work with "show databases/tables/etc." queries \ 
with an ODBC backend now
increased oid buffer sizes in postgresql connection
fixed typemangling->tablemangling typo in postgresql connection - \ 
tablemangling sholid work without typemangling now
fixed a '...\\''...' parsing bug
non-odbc connection modlies now return odbc-compatible(ish) table lists
client info is no longer reset during endSession
fixed a bug that colid cause sqlite "show tables like '...'" to crash
fixed odbc unicode nlil user/password bug
fixed PyString_AsString for python 3.<3
fixed bug that caused some MSSQL lobs to sometimes be returned as nlils when \ 
using ODBC on the backend
fixed bug that caused some MSSQL date fields to get returned as garbage
fixed a few older sqlrclient compatibility bugs
fixed SQLFetch parameter type mismatch in ODBC api
removed a non-c++17-compliant "register" from custom_nw logger
added support for nodejs 12
SQLDriverConnect can take an inline DSN now
fixed odbc maxcolumncount=-1 crash
odbc, db2, and informix set bind format error now