--- - branch: MAIN date: Thu May 22 12:50:48 UTC 2014 files: - new: '1.1' old: '0' path: pkgsrc/databases/p5-sqlrelay/Makefile pathrev: pkgsrc/databases/p5-sqlrelay/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/p5-sqlrelay/PLIST pathrev: pkgsrc/databases/p5-sqlrelay/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/php-sqlrelay/Makefile pathrev: pkgsrc/databases/php-sqlrelay/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/php-sqlrelay/PLIST pathrev: pkgsrc/databases/php-sqlrelay/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/py-sqlrelay/Makefile pathrev: pkgsrc/databases/py-sqlrelay/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/py-sqlrelay/PLIST pathrev: pkgsrc/databases/py-sqlrelay/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/ruby-sqlrelay/Makefile pathrev: pkgsrc/databases/ruby-sqlrelay/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/ruby-sqlrelay/PLIST pathrev: pkgsrc/databases/ruby-sqlrelay/PLIST@1.1 type: added - new: '1.36' old: '1.35' path: pkgsrc/databases/sqlrelay/Makefile pathrev: pkgsrc/databases/sqlrelay/Makefile@1.36 type: modified - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/Makefile.common pathrev: pkgsrc/databases/sqlrelay/Makefile.common@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/buildlink3.mk pathrev: pkgsrc/databases/sqlrelay/buildlink3.mk@1.1 type: added - new: '1.10' old: '1.9' path: pkgsrc/databases/sqlrelay/PLIST pathrev: pkgsrc/databases/sqlrelay/PLIST@1.10 type: modified - new: '1.8' old: '1.7' path: pkgsrc/databases/sqlrelay/distinfo pathrev: pkgsrc/databases/sqlrelay/distinfo@1.8 type: modified - new: '0' old: '1.7' path: pkgsrc/databases/sqlrelay/options.mk pathrev: pkgsrc/databases/sqlrelay/options.mk@0 type: deleted - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-freetds/Makefile pathrev: pkgsrc/databases/sqlrelay-freetds/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-freetds/PLIST pathrev: pkgsrc/databases/sqlrelay-freetds/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-mysql/Makefile pathrev: pkgsrc/databases/sqlrelay-mysql/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-mysql/PLIST pathrev: pkgsrc/databases/sqlrelay-mysql/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-odbc/Makefile pathrev: pkgsrc/databases/sqlrelay-odbc/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-odbc/PLIST pathrev: pkgsrc/databases/sqlrelay-odbc/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-pgsql/Makefile pathrev: pkgsrc/databases/sqlrelay-pgsql/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-pgsql/PLIST pathrev: pkgsrc/databases/sqlrelay-pgsql/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-sqlite/Makefile pathrev: pkgsrc/databases/sqlrelay-sqlite/Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay-sqlite/PLIST pathrev: pkgsrc/databases/sqlrelay-sqlite/PLIST@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/files/smf/manifest.xml pathrev: pkgsrc/databases/sqlrelay/files/smf/manifest.xml@1.1 type: added - new: '0' old: '1.3' path: pkgsrc/databases/sqlrelay/patches/patch-ac pathrev: pkgsrc/databases/sqlrelay/patches/patch-ac@0 type: deleted - new: '1.2' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-ad pathrev: pkgsrc/databases/sqlrelay/patches/patch-ad@1.2 type: modified - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/patches/patch-configure pathrev: pkgsrc/databases/sqlrelay/patches/patch-configure@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/patches/patch-etc_Makefile pathrev: pkgsrc/databases/sqlrelay/patches/patch-etc_Makefile@1.1 type: added - new: '1.1' old: '0' path: pkgsrc/databases/sqlrelay/patches/patch-init_rc.sqlrelay.in pathrev: pkgsrc/databases/sqlrelay/patches/patch-init_rc.sqlrelay.in@1.1 type: added - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-init__netbsd__rc.d__sqlrelay.in pathrev: pkgsrc/databases/sqlrelay/patches/patch-init__netbsd__rc.d__sqlrelay.in@0 type: deleted - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-src__listener__sqlrlistener.h pathrev: pkgsrc/databases/sqlrelay/patches/patch-src__listener__sqlrlistener.h@0 type: deleted - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-src_connection_sqlrcursor.h pathrev: pkgsrc/databases/sqlrelay/patches/patch-src_connection_sqlrcursor.h@0 type: deleted - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-src_connection_sqlrcursor_queryparse.C pathrev: pkgsrc/databases/sqlrelay/patches/patch-src_connection_sqlrcursor_queryparse.C@0 type: deleted - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-src_connections_oracle8_oracle8connection.C pathrev: pkgsrc/databases/sqlrelay/patches/patch-src_connections_oracle8_oracle8connection.C@0 type: deleted - new: '0' old: '1.1' path: pkgsrc/databases/sqlrelay/patches/patch-src_connections_router_routerconnection.C pathrev: pkgsrc/databases/sqlrelay/patches/patch-src_connections_router_routerconnection.C@0 type: deleted id: 20140522T125048Z.f2298bd764a4e119c75f4da1071c2dfb98a13a73 log: | Update sqlrelay to 0.55. A full refactor and split-up into separate packages for the various APIs and backends. Changelog since 0.43 follows. 0.55 - fixed a sql translation bug related to exists clauses added deployment projects for windows tweaked make.batch install target to install 32-bit files under C:\Program Files (x86) added a timeout parameter to db2 and odbc connect strings fixed a bug that could cause a connection's ttl to fail because a semaphore was left signalled when another connection's ttl expired updated handoff="proxy" code to work with sessionhandler="thread" replaced waitpid call in sqlrscaler with rudiments equivalent got the server-side stuff to compile on windows added configurable fetch buffer sizes to sybase, freetds and db2 connections re-distribute themselves periodically if the database is behind a load balancer now fixed a bug that caused sqlrsh to incorrectly interpret internal commands with leading whitespace when run from a script or on the command line fixed a bug that caused cursors not to be completely cleaned up after when dynamic scaling is used fixed a bug that caused the response timeout to be handled improperly added response timeout command to sqlrsh added support for clobs/blobs with firebird fixed a blob-related bug with sqlite added support for blob input binds with db2 added support for clob/blob output binds with db2 improved clob/blob fetching with db2 inputBindClob/Blob methods work with all db's now added -Wno-unknown-pragmas flag (if it it supported) to java build for solaris 8 updated default item buffer sizes to 32768 for sybase, freetds, db2 and odbc applied Gerhard Lausser's patch to improve Oracle instantclient detection 0.54 - fixed bugs that caused problems when unopened result sets were closed added protocol identification phase to client/server protocol split client protocol handling out into its own class and abstracted it updated oracle code not to relogin when dropping tables unless a temp table with an "on commit preserve rows" was run updated server to run table-drop and session-end queries after the session-end commit/rollback, as some queries on some platforms ( ncluding drop-table on oracle) cause an implicit commit and the rollback needs to be run first replaced gettimeofday calls with calls to datetime::getSystemDateAndTime fixed a bug in slow query logger that caused it to display the wrong query time a few mingw32 tweaks fixed a few PDO driver bugs related to affected row counts and last insert id implemented PDO exceptions implemented support for PDO::ATTR_EMULATE_PREPARES by using substitution variables added foundrows and ignorespace options to mysql connect string fixed a bug where affectedRows() would return -1 for MySQL selects instead of the same value as rowCount() updated sqlr-connection code not to get db host name and ip address at startup unless logging is enabled to work around issues where people fail to put the db host name in dns fixed a subtle bind format translation bug that caused errors when translating from oracle-style binds to mysql-style if the varaibles were out of order with the placeholders in the query fixed bugs in the mysql and postgresql connection code that assumed that the bind variables were bound in order, independent of their names resolved a paradox involved in detecting whether the current mysql query needs to have its bind variables faked or not added support for client-side debug-to-file added debug-to-file support to command line clients tweaked server processes to use process::spawn instead of system() and process::fork()/process::exec() added another error string to detect down mysql database added support for a multi-threaded listener fixed a bug that could cause a crash when logging connection-level errors added back x64-detection so sybase and db2 libraries will be detected properly added support for forward-only cursors to the PDO driver fixed a bug that could cause one (and only one) dynamically spawned connection daemon to ignore its ttl added support for get/set result set buffer size to the PDO driver updated configure test for xsubpp updated configure test for tcl to support multi-arch updated configure test for python to support multi-arch added custom PDO driver attributes to access db type, version, host name, ip address and bind format added custom PDO driver attribute to get/set current database added custom PDO driver attribute to set whether or not to get column info when fetching the result set updated db2 to re-login when it sees error -30081 0.53.1 - updated the configuration and tuning docs a bit fixed a Makefile bug that caused "make clean" to be interrupted extern "C"-wrapped sys/times.h for OSR500 0.53 - added support for sqlite statement api and native binds fixed some leaks related to using sys::getHostName() added multiarch detection added PHP PDO driver fixed a bind variable translation bug where output binds followed by := would not be detected dropped zope support (for now) dropped PHP Pear DB support refactored init script - one script should work on all platforms now updated init script installation - should work on virtually all unixes added OS X launchd configuration updated the sqlr-listener to clean up files related to ipc, sockets and marking whether the db is up or down on exit sqlr-start no longer starts the cache manager added a second init script for the cache manager plugins are statically linked into libsqlrserver if the platform doesn't support shared libraries (or if --disable-shared is specified at configure time) the perl API should build with old versions of perl (5.00X) on older platforms (redhat 4.2, 5.2, 6.2, etc.) now updated postgresql bind docs added dateyyyyddmm parameter added yyyyddmm parameter to translatedates translation added SQLR_MYSQL_DATE_YYYYDDMM envrionment variable to mysql drop-in library added SQLR_ODBC_DATE_YYYYDDMM envrionment variable to odbc driver 0.52 - sqlrsh has long reported the wrong version, fixed that added csv support to sqlr-export and a -format xml|csv option replaced snprintf calls with charstring::printf calls added a test for sys/vnode.h to work around an issue with perl on SCO OSR6 added workarounds for old versions of sqlite without sqlite3_malloc and sqlite3_free with char * argument fixed error with sqlserver where "describe