Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2021-02-16 14:12:40
Message id: 20210216131240.97E5FFA95@cvs.NetBSD.org

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 \ 
attribute
*_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 \ 
delimiters
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

Files:
RevisionActionfile
1.32modifypkgsrc/databases/p5-sqlrelay/Makefile
1.29modifypkgsrc/databases/php-sqlrelay/Makefile
1.28modifypkgsrc/databases/py-sqlrelay/Makefile
1.25modifypkgsrc/databases/ruby-sqlrelay/Makefile
1.70modifypkgsrc/databases/sqlrelay/Makefile
1.22modifypkgsrc/databases/sqlrelay/Makefile.common
1.20modifypkgsrc/databases/sqlrelay/PLIST
1.26modifypkgsrc/databases/sqlrelay/distinfo
1.30modifypkgsrc/databases/sqlrelay-freetds/Makefile
1.25modifypkgsrc/databases/sqlrelay-mysql/Makefile
1.28modifypkgsrc/databases/sqlrelay-nodejs/Makefile
1.29modifypkgsrc/databases/sqlrelay-odbc/Makefile
1.26modifypkgsrc/databases/sqlrelay-pgsql/Makefile
1.40modifypkgsrc/databases/sqlrelay-sqlite/Makefile
1.4modifypkgsrc/databases/sqlrelay/patches/patch-config.mk.in
1.8modifypkgsrc/databases/sqlrelay/patches/patch-configure
1.4modifypkgsrc/databases/sqlrelay/patches/patch-etc_Makefile
1.2modifypkgsrc/databases/sqlrelay/patches/patch-src_api_nodejs_Makefile
1.1addpkgsrc/databases/sqlrelay/patches/patch-Makefile
1.4removepkgsrc/databases/sqlrelay/patches/patch-ad