Update databases/sqlrelay to 1.0.0.

sqlrelay 1.0.0
- updated md5 pwdenc to use rudiments md5 class
- solved a long-standing hang that could occur if the database password
  expired while sqlrelay was running, and the sqlr-scaler attempted to
  start new connections
- added convertcase, convertcasedoublequotes, and removedoublequotes
  parameters to normalize translation module
- added ColumnCaseName parameter to ODBC driver
- fixed a subtle bug in the ODBC driver that caused the first row to be
  skipped if columns were not bound
- added -backtrace option for debugging
- fixed mysql connection module so it can use the statement API on
  Windows
- fixed semaphore reference-before-init bug in sqlrservercontroller
- added support for db, debug, columnnamecase, dontgetcolumninfo,
  nullsasnulls, and lazyconnect connect-string options to all drivers
  (though in some they are camel-case and others lower-case)
- in DB-abstraction-layer drivers, the debug, dontgetcolumninfo,
  nullsasnulls, lazyconnect, krb, and tls connect-string options now
  support any yes/no equivalent such as yes, Yes, y, Y, true, True, 1,
  (and similar for no)
- fixed a regression that could cause crashes in the C#/ADO driver when
  binding null or date values
- added all parameters to ODBC config screen
- removed calls to mysql_stmt_store_result/mysql_stmt_num_rows from
  mysql connection to improve performance. mysql connection doesn't know
  the total number of rows prior to full fetch now (which is consistent
  with most other databases).
- updated postgresql connection to use an unnamed cursor instead of
  naming it and having to deallocate it over an over
- tweaked skipWhitespaceAndComments and related methods to use
  charstring::isNullOrEmpty and character::isWhitespace
- replaced regular expression comparisons in sap/freetds connections
  with simpler charstring comparisons
- updated db2 connection to reuse the statement instead of recreating it
  with each prepare
- made column-lookup by name case sensitive to improve performance
- fixed nagle-disable and sizing of socket read/write buffers
- changed default maxcursors to 5
- fixed an uninitialized variable in the firebird connection
- python api's are installed in dist-packages subdirectory on systems
  that have that instead of site-packages
- added route-entire-session option to router modules

sqlrelay 0.67.0
- general documenation clean-up
- added missing all: target to man/Makefile
- mysql_info in drop-in library for mysql returns NULL instead of "" now
- mysql_errno in the drop-in library now returns the error number from
  the DB, instead of CR_UNKNOWN_ERROR, if no error map is provided, and
  the backend database is known to be mysql
- mysql_refresh in the drop-in library works with options other than
  REFRESH_GRANT now
- mysql_shutdown/kill in the drop-in library return 1 on failure now
  rather than 2000
- date/time and timestamp types are recognized as binary types now
- year/timestamp types are recognized as unsigned types now
- TINY/MEDIUM/LONG_TEXT types are recognized as blobs now
- mapping date/time to MYSQL_TYPE_DATE/TIME, rather than
  MYSQL_TYPE_DATETIME is the default in the drop-in library now and
  SQLR_MAP_DATETIME_TO_DATE has been removed
- mysql drop-in library sets column flags correctly now
- mysql drop-in library runs appropriate kill/shutdown queries now
- mysql connection uses non-stmt api for "show *" queries now
- mysql drop-in library runs "show processlist" for mysql_list_processes
- mysql drop-in library supports date/time/datetime input binds now
  instead of just treating them all as datetimes
- connection modules differentiate between date/time/datetime binds now
  instead of just treating them all as datetimes
- added result set row translation module framework
- updated firebird connection module to the fieldstruct.textbuffer
  instead of fieldbuffer for non-text to text translations
- added support for negative times in mysql connection module and
  drop-in library
- added translation-failure event
- general refactoring of server module API
- consolidated sqlr-scaler code
- fixed a 1-byte empty-blob memory leak in the client
- /etc/alternatives/java_sdk is preferred, if found, now

1 files changed, 51 insertions, 28 deletions

diff --git a/databases/sqlrelay/PLIST b/databases/sqlrelay/PLIST
index 0fd4436cb34..358d8ef1c1c 100644
--- a/databases/sqlrelay/PLIST
+++ b/databases/sqlrelay/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2016/10/21 14:16:34 fhajny Exp $
+@comment $NetBSD: PLIST,v 1.19 2017/01/16 13:13:13 fhajny Exp $
 bin/sqlr-cachemanager
 bin/sqlr-connection
 bin/sqlr-export
@@ -13,40 +13,72 @@ bin/sqlrclient-config
 bin/sqlrclientwrapper-config
 bin/sqlrserver-config
 bin/sqlrsh
+include/sqlrelay/private/sqlrauth.h
+include/sqlrelay/private/sqlrauths.h
 include/sqlrelay/private/sqlrclientincludes.h
 include/sqlrelay/private/sqlrclientwrapper.h
 include/sqlrelay/private/sqlrclientwrapperincludes.h
 include/sqlrelay/private/sqlrconnection.h
 include/sqlrelay/private/sqlrcursor.h
+include/sqlrelay/private/sqlrfilter.h
+include/sqlrelay/private/sqlrfilters.h
+include/sqlrelay/private/sqlrgsscredentials.h
 include/sqlrelay/private/sqlrlistener.h
+include/sqlrelay/private/sqlrlogger.h
+include/sqlrelay/private/sqlrloggers.h
+include/sqlrelay/private/sqlrnotification.h
+include/sqlrelay/private/sqlrnotifications.h
+include/sqlrelay/private/sqlrparser.h
+include/sqlrelay/private/sqlrprotocol.h
+include/sqlrelay/private/sqlrprotocols.h
+include/sqlrelay/private/sqlrpwdenc.h
+include/sqlrelay/private/sqlrpwdencs.h
+include/sqlrelay/private/sqlrqueries.h
+include/sqlrelay/private/sqlrquery.h
+include/sqlrelay/private/sqlrquerycursor.h
+include/sqlrelay/private/sqlrresultsetrowtranslation.h
+include/sqlrelay/private/sqlrresultsetrowtranslations.h
+include/sqlrelay/private/sqlrresultsettranslation.h
+include/sqlrelay/private/sqlrresultsettranslations.h
+include/sqlrelay/private/sqlrrouter.h
+include/sqlrelay/private/sqlrrouters.h
+include/sqlrelay/private/sqlrschedule.h
+include/sqlrelay/private/sqlrschedulerule.h
+include/sqlrelay/private/sqlrschedules.h
 include/sqlrelay/private/sqlrserverconnection.h
 include/sqlrelay/private/sqlrservercontroller.h
 include/sqlrelay/private/sqlrservercursor.h
 include/sqlrelay/private/sqlrserverincludes.h
-include/sqlrelay/private/sqlrshmdata.h
+include/sqlrelay/private/sqlrshm.h
+include/sqlrelay/private/sqlrtlscredentials.h
+include/sqlrelay/private/sqlrtranslation.h
+include/sqlrelay/private/sqlrtranslations.h
+include/sqlrelay/private/sqlrtrigger.h
+include/sqlrelay/private/sqlrtriggers.h
+include/sqlrelay/private/sqlruserpasswordcredentials.h
 include/sqlrelay/private/sqlrutilincludes.h
 include/sqlrelay/sqlrclient.h
 include/sqlrelay/sqlrclientwrapper.h
 include/sqlrelay/sqlrserver.h
 include/sqlrelay/sqlrutil.h
 lib/libmysql3sqlrelay.so
-lib/libmysql3sqlrelay.so.2
-lib/libmysql3sqlrelay.so.2.0.0
+lib/libmysql3sqlrelay.so.4
+lib/libmysql3sqlrelay.so.4.0.0
 lib/libmysql40sqlrelay.so
-lib/libmysql40sqlrelay.so.2
-lib/libmysql40sqlrelay.so.2.0.0
+lib/libmysql40sqlrelay.so.4
+lib/libmysql40sqlrelay.so.4.0.0
 lib/libmysql41sqlrelay.so
-lib/libmysql41sqlrelay.so.2
-lib/libmysql41sqlrelay.so.2.0.0
+lib/libmysql41sqlrelay.so.4
+lib/libmysql41sqlrelay.so.4.0.0
 lib/libmysql50sqlrelay.so
-lib/libmysql50sqlrelay.so.2
-lib/libmysql50sqlrelay.so.2.0.0
+lib/libmysql50sqlrelay.so.4
+lib/libmysql50sqlrelay.so.4.0.0
 lib/libmysql51sqlrelay.so
-lib/libmysql51sqlrelay.so.2
-lib/libmysql51sqlrelay.so.2.0.0
+lib/libmysql51sqlrelay.so.4
+lib/libmysql51sqlrelay.so.4.0.0
 lib/libpqsqlrelay.so
-lib/libpqsqlrelay.so.2
-lib/libpqsqlrelay.so.2.0.0
+lib/libpqsqlrelay.so.4
+lib/libpqsqlrelay.so.4.0.0
 lib/libsqlrclient.la
 lib/libsqlrclientwrapper.la
 lib/libsqlrserver.la
@@ -75,6 +107,7 @@ libexec/sqlrelay/sqlrpwdenc_rot.${SOEXT}
 libexec/sqlrelay/sqlrquery_sqlrcmdcstat.${SOEXT}
 libexec/sqlrelay/sqlrquery_sqlrcmdgstat.${SOEXT}
 libexec/sqlrelay/sqlrresultsettranslation_reformatdatetime.${SOEXT}
+libexec/sqlrelay/sqlrresultsettranslation_test.${SOEXT}
 libexec/sqlrelay/sqlrrouter_clientiplist.${SOEXT}
 libexec/sqlrelay/sqlrrouter_regex.${SOEXT}
 libexec/sqlrelay/sqlrrouter_userlist.${SOEXT}
@@ -96,8 +129,11 @@ share/doc/sqlrelay/admin/configreference.html
 share/doc/sqlrelay/admin/installing.html
 share/doc/sqlrelay/admin/oraclentier.html
 share/doc/sqlrelay/admin/prerequisites.html
-share/doc/sqlrelay/admin/router.html
 share/doc/sqlrelay/admin/running.html
+share/doc/sqlrelay/admin/sqlr-connection-oracletest-querylog.2899.html
+share/doc/sqlrelay/admin/sqlr-connection.1871.html
+share/doc/sqlrelay/admin/sqlr-listener.1869.html
+share/doc/sqlrelay/admin/sqlr-listener.1886.html
 share/doc/sqlrelay/admin/tuning.html
 share/doc/sqlrelay/api/ado.net/html/annotated.html
 share/doc/sqlrelay/api/ado.net/html/arrowdown.png
@@ -681,19 +717,6 @@ share/doc/sqlrelay/images/toomanyconnections.png
 share/doc/sqlrelay/images/unixodbc.png
 share/doc/sqlrelay/index.html
 share/doc/sqlrelay/js/rotate.js
-share/doc/sqlrelay/modules/auths.html
-share/doc/sqlrelay/modules/filters.html
-share/doc/sqlrelay/modules/loggers.html
-share/doc/sqlrelay/modules/notifications.html
-share/doc/sqlrelay/modules/pwdencs.html
-share/doc/sqlrelay/modules/resultsettranslations.html
-share/doc/sqlrelay/modules/routers.html
-share/doc/sqlrelay/modules/schedules.html
-share/doc/sqlrelay/modules/sqlr-connection-oracletest-querylog.2899.html
-share/doc/sqlrelay/modules/sqlr-connection.1871.html
-share/doc/sqlrelay/modules/sqlr-listener.1869.html
-share/doc/sqlrelay/modules/sqlr-listener.1886.html
-share/doc/sqlrelay/modules/translations.html
 share/doc/sqlrelay/programming/ado.net.html
 share/doc/sqlrelay/programming/binds.html
 share/doc/sqlrelay/programming/c++.html