The NetBSD Project

CVS log for pkgsrc/databases/sqlrelay/

[BACK] Up to [] / pkgsrc / databases / sqlrelay

Request diff between arbitrary revisions

Default branch: MAIN

Revision 1.30 / (download) - annotate - [select for diffs], Wed Nov 8 13:18:38 2023 UTC (3 weeks, 2 days ago) by wiz
Branch: MAIN
Changes since 1.29: +2 -2 lines
Diff to previous 1.29 (colored)

*: recursive bump for icu 74.1

Revision 1.29 / (download) - annotate - [select for diffs], Tue Oct 24 22:08:40 2023 UTC (5 weeks, 3 days ago) by wiz
Branch: MAIN
Changes since 1.28: +2 -2 lines
Diff to previous 1.28 (colored)

*: bump for openssl 3

Revision 1.28 / (download) - annotate - [select for diffs], Mon Aug 14 05:24:02 2023 UTC (3 months, 2 weeks ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2023Q3-base, pkgsrc-2023Q3
Changes since 1.27: +2 -2 lines
Diff to previous 1.27 (colored)

*: recursive bump for Python 3.11 as new default

Revision 1.27 / (download) - annotate - [select for diffs], Wed Apr 19 08:08:08 2023 UTC (7 months, 2 weeks ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2023Q2-base, pkgsrc-2023Q2
Changes since 1.26: +2 -2 lines
Diff to previous 1.26 (colored)

revbump after textproc/icu update

Revision 1.26 / (download) - annotate - [select for diffs], Wed Oct 26 10:31:01 2022 UTC (13 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2023Q1-base, pkgsrc-2023Q1, pkgsrc-2022Q4-base, pkgsrc-2022Q4
Changes since 1.25: +2 -2 lines
Diff to previous 1.25 (colored)

*: bump PKGREVISION for libunistring shlib major bump

Revision 1.25 / (download) - annotate - [select for diffs], Tue Jun 28 11:31:38 2022 UTC (17 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2022Q3-base, pkgsrc-2022Q3
Changes since 1.24: +2 -2 lines
Diff to previous 1.24 (colored)

*: recursive bump for perl 5.36

Revision 1.24 / (download) - annotate - [select for diffs], Wed Sep 29 19:00:05 2021 UTC (2 years, 2 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2022Q2-base, pkgsrc-2022Q2, pkgsrc-2022Q1-base, pkgsrc-2022Q1, pkgsrc-2021Q4-base, pkgsrc-2021Q4
Changes since 1.23: +2 -2 lines
Diff to previous 1.23 (colored)

revbump for boost-libs

Revision 1.23 / (download) - annotate - [select for diffs], Wed Apr 21 13:24:09 2021 UTC (2 years, 7 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2021Q3-base, pkgsrc-2021Q3, pkgsrc-2021Q2-base, pkgsrc-2021Q2
Changes since 1.22: +2 -2 lines
Diff to previous 1.22 (colored)

revbump for boost-libs

Revision 1.22 / (download) - annotate - [select for diffs], Fri May 22 10:55:44 2020 UTC (3 years, 6 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2021Q1-base, pkgsrc-2021Q1, pkgsrc-2020Q4-base, pkgsrc-2020Q4, pkgsrc-2020Q3-base, pkgsrc-2020Q3, pkgsrc-2020Q2-base, pkgsrc-2020Q2
Changes since 1.21: +2 -2 lines
Diff to previous 1.21 (colored)

revbump after updating security/nettle

Revision 1.21 / (download) - annotate - [select for diffs], Wed May 6 14:04:08 2020 UTC (3 years, 6 months ago) by adam
Branch: MAIN
Changes since 1.20: +2 -2 lines
Diff to previous 1.20 (colored)

revbump after boost update

Revision 1.20 / (download) - annotate - [select for diffs], Sun Mar 8 16:47:30 2020 UTC (3 years, 8 months ago) by wiz
Branch: MAIN
CVS Tags: pkgsrc-2020Q1-base, pkgsrc-2020Q1
Changes since 1.19: +2 -2 lines
Diff to previous 1.19 (colored)

*: recursive bump for libffi

Revision 1.19 / (download) - annotate - [select for diffs], Sat Jan 18 21:48:02 2020 UTC (3 years, 10 months ago) by jperkin
Branch: MAIN
Changes since 1.18: +2 -2 lines
Diff to previous 1.18 (colored)

*: Recursive revision bump for openssl 1.1.1.

Revision 1.18 / (download) - annotate - [select for diffs], Sun Jan 12 20:19:54 2020 UTC (3 years, 10 months ago) by ryoon
Branch: MAIN
Changes since 1.17: +2 -2 lines
Diff to previous 1.17 (colored)

*: Recursive revbump from devel/boost-libs

Revision 1.17 / (download) - annotate - [select for diffs], Thu Aug 22 12:22:58 2019 UTC (4 years, 3 months ago) by ryoon
Branch: MAIN
CVS Tags: pkgsrc-2019Q4-base, pkgsrc-2019Q4, pkgsrc-2019Q3-base, pkgsrc-2019Q3
Changes since 1.16: +2 -2 lines
Diff to previous 1.16 (colored)

Recursive revbump from boost-1.71.0

Revision 1.16 / (download) - annotate - [select for diffs], Sat Jul 20 22:45:59 2019 UTC (4 years, 4 months ago) by wiz
Branch: MAIN
Changes since 1.15: +2 -2 lines
Diff to previous 1.15 (colored)

*: recursive bump for nettle 3.5.1

Revision 1.15 / (download) - annotate - [select for diffs], Mon Jul 1 04:07:46 2019 UTC (4 years, 5 months ago) by ryoon
Branch: MAIN
Changes since 1.14: +2 -2 lines
Diff to previous 1.14 (colored)

Recursive revbump from boost-1.70.0

Revision 1.14 / (download) - annotate - [select for diffs], Thu Dec 13 19:51:33 2018 UTC (4 years, 11 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2019Q2-base, pkgsrc-2019Q2, pkgsrc-2019Q1-base, pkgsrc-2019Q1, pkgsrc-2018Q4-base, pkgsrc-2018Q4
Changes since 1.13: +2 -2 lines
Diff to previous 1.13 (colored)

revbump for boost 1.69.0

Revision 1.13 / (download) - annotate - [select for diffs], Thu Aug 16 18:54:28 2018 UTC (5 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q3-base, pkgsrc-2018Q3
Changes since 1.12: +2 -2 lines
Diff to previous 1.12 (colored)

revbump after boost-libs update

Revision 1.12 / (download) - annotate - [select for diffs], Sun Apr 29 21:31:19 2018 UTC (5 years, 7 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q2-base, pkgsrc-2018Q2
Changes since 1.11: +2 -2 lines
Diff to previous 1.11 (colored)

revbump for boost-libs update

Revision 1.11 / (download) - annotate - [select for diffs], Mon Jan 1 21:18:07 2018 UTC (5 years, 11 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2018Q1-base, pkgsrc-2018Q1
Changes since 1.10: +2 -2 lines
Diff to previous 1.10 (colored)

Revbump after boost update

Revision 1.10 / (download) - annotate - [select for diffs], Thu Aug 24 20:02:58 2017 UTC (6 years, 3 months ago) by adam
Branch: MAIN
CVS Tags: pkgsrc-2017Q4-base, pkgsrc-2017Q4, pkgsrc-2017Q3-base, pkgsrc-2017Q3
Changes since 1.9: +2 -2 lines
Diff to previous 1.9 (colored)

Revbump for boost update

Revision 1.9 / (download) - annotate - [select for diffs], Sun Apr 30 01:21:21 2017 UTC (6 years, 7 months ago) by ryoon
Branch: MAIN
CVS Tags: pkgsrc-2017Q2-base, pkgsrc-2017Q2
Changes since 1.8: +2 -2 lines
Diff to previous 1.8 (colored)

Recursive revbump from boost update

Revision 1.8 / (download) - annotate - [select for diffs], Mon Jan 16 13:13:13 2017 UTC (6 years, 10 months ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2017Q1-base, pkgsrc-2017Q1
Changes since 1.7: +3 -3 lines
Diff to previous 1.7 (colored)

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
- 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
- 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

Revision 1.7 / (download) - annotate - [select for diffs], Sun Jan 1 16:05:57 2017 UTC (6 years, 11 months ago) by adam
Branch: MAIN
Changes since 1.6: +2 -2 lines
Diff to previous 1.6 (colored)

Revbump after boost update

Revision 1.6 / (download) - annotate - [select for diffs], Fri Oct 21 14:16:34 2016 UTC (7 years, 1 month ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2016Q4-base, pkgsrc-2016Q4
Changes since 1.5: +2 -3 lines
Diff to previous 1.5 (colored)

Update databases/sqlrelay and sub-packages to 0.66.0.

New features:

- Notification Modules
- Connection Schedules
- Query Router Modules

Full changelog:

- fixed mysql set isolation level query
- updated mysql connection to run commit/rollback at the end of every
  session even if only selects were run, to make sure metadata locks are
- renamed sqlrclientexitstatus_t to clientsessionexitstatus_t
- updated all db connection modules to reinit the column count during
  prepare rather than execute
- fixed bug where server-side errors set by conn/cursor->setError()
  could inadverntantly be overriden during the next call to
- added several more queries to mysql stmt-api blacklist
- configure option --disable-odbc-driver actually works now
- filters can specify an error string and error number now
- added support for systemd
- fixed a memory leak by applying and updating a patch from Kasyanov
  Dmitry to deallocate the error message in C++ API destructor
- legacy_stdio_definitions.lib is now included when building ODBC with
- added support for PHP7
- added -wait option to sqlr-start for non-Windows
- disabled -disable-new-window option to sqlr-start for non-Windows
- non-ascii character encodings work with the C# API now
- rudiments prompt class is used instead of using readline directly now
- renamed "logger-events" to just "events"
- added notification framework and "events" module
- added connection schedule framework and "cron" module
- applied sec/usec patch from samchuck at neowiz to custom_nw logger to
  fix subtle time calculation error
- applied a patch from samchuck at neowiz to the sqlrclient protocol
  module to deallocate storage for bind variables after logging the
  query to resolve a reference-after-free bug
- added router module framework with "regex", "userlist" and
  "clientiplist" modules
- when router detects a possible integrity violation now, it raises an
  event which can be logged or trigger a notification and disables the
- router calls begin, commit, and rollback on all connections now, even
  if they're executed as queries rather than using the api methods
- removed tls_userlist/krb_userlist auth modules and updated the
  userlist auth module to support tls and kerberos auth
- converted most of the doc source to wikitext
- fixed ODBC driver bug that could corrupt memory and trick the driver
  manager into thinking that some basic functions are unavailable
- ODBC SQLTables works more correctly now
- fixed an ODBC bug that caused the first row to be fetched twice when
  using SQLBindCol

Revision 1.5 / (download) - annotate - [select for diffs], Fri Oct 7 18:25:31 2016 UTC (7 years, 1 month ago) by adam
Branch: MAIN
Changes since 1.4: +2 -2 lines
Diff to previous 1.4 (colored)

Revbump post boost update

Revision 1.4 / (download) - annotate - [select for diffs], Fri Jul 1 17:02:39 2016 UTC (7 years, 5 months ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2016Q3-base, pkgsrc-2016Q3
Changes since 1.3: +2 -2 lines
Diff to previous 1.3 (colored)

Update databases/sqlrelay to 0.65.0

- SQL Relay now supports Kerberos encryption and authentication
- SQL Relay now supports TLS/SSL encryption and authentication
- Python 3 support
- Node.js 4.x and higher are now correctly detected and supported.
- Separate "database" and "proxied" Authentication Options
- Various ODBC-related bugs have been fixed
- A subtle bug that caused incompatibilities with the popular
  logrotate utility has been fixed
- A long standing problem that occurred when using a
  listenertimeout with a threaded listener (the default) has been
- After a graceful restart, Apache workers would get stuck in the
  Closing Connection state after running a PHP script that used
  SQL Relay. This is now fixed.

See full changelog:

Revision 1.3 / (download) - annotate - [select for diffs], Sat Mar 5 11:27:44 2016 UTC (7 years, 8 months ago) by jperkin
Branch: MAIN
CVS Tags: pkgsrc-2016Q2-base, pkgsrc-2016Q2, pkgsrc-2016Q1-base, pkgsrc-2016Q1
Changes since 1.2: +2 -1 lines
Diff to previous 1.2 (colored)

Bump PKGREVISION for security/openssl ABI bump.

Revision 1.2 / (download) - annotate - [select for diffs], Tue Nov 10 10:10:39 2015 UTC (8 years ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2015Q4-base, pkgsrc-2015Q4
Changes since 1.1: +1 -4 lines
Diff to previous 1.1 (colored)

Update databases/sqlrelay to 0.64.
Remove bl3 entries that were really only part of devel/rudiments.

- fixed bug in sqlrsh that caused it to filter out non-ascii
- added informix connection module
- added shutdown loop detection in sqlr-listener
- fixed dbhostname/dbipaddress requests
- added bind variable format validation to php pdo driver
- added softttl parameter
- added db/language detection to configure.vbs
- added passwordfunction parameter to "sqlrelay" authentication
- added -disable-crash-handler command line option to server
- postgresql connection module PQclear()'s the result of
  PQprepare() now, fixing a memory leak
- updated postgresql connection module to handle invalid bind
  variables properly, and without crash
- added various missing postgresql functions to the postgresql
  drop-in library, most notably PQprepare, PQexecPrepared,
- simplified sqlrpaths/sqlrcmdline classes a bit
- renamed sqlrconfigfile to sqlrconfig
- implemented a modular configuration framework
- config files can be loaded over protocols supported by libcurl
  now or http if rudiments compiled withougt libcurl support
- config files can now be "link files" which just refer to other
  local config files, local config directories, or remote config
- updated sqlr-start and sqlr-scaler not to pass the default
  -config value if sqlr-start wasn't explicitly started with
- fixed a bug that could cause sqlrsh to act funny if the last
  character prior to the command delimiter was a single or double
- fixed a stacked result-set translation module bug
- applied George Carrette's patch to fix potential PDO

Revision 1.1 / (download) - annotate - [select for diffs], Thu May 22 12:50:48 2014 UTC (9 years, 6 months ago) by fhajny
Branch: MAIN
CVS Tags: pkgsrc-2015Q3-base, pkgsrc-2015Q3, pkgsrc-2015Q2-base, pkgsrc-2015Q2, pkgsrc-2015Q1-base, pkgsrc-2015Q1, pkgsrc-2014Q4-base, pkgsrc-2014Q4, pkgsrc-2014Q3-base, pkgsrc-2014Q3, pkgsrc-2014Q2-base, pkgsrc-2014Q2

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
        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

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
        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
        added back x64-detection so sybase and db2 libraries will be detected
        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
        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 <table>" would return
                columns in alphabetical order rather than the order they
                are in the table
        the code freetds uses to get column names from MS SQL Server works
                for temp tables now
        added informix->mssqlserver translation for select into queries
        added translation to convert ||'s to concat() calls or +'s
        added a long-missing "delete clientsock" to sqlrlistener that could
                cause a crash after enough time
        various documentation tweaks
        added handling for "select into" queries to
                temptableslocalize/sybaseize translations
        fixed various crashes that could occur when a query filter was used
        updated the query routing and filtering doc
        sqlrsh supports multiple commands on a single line or on the
                command-line now
        exit/quit in a sqlrsh script aborts the script now
        improved date/time parsing for translations and result-set conversions
        fixed lots of cases where const char *'s were being deleted
        added 64-bit build support for windows
        combined sqlrclient files for faster compiling
        converted \t to actual tab in regular expressions for

0.51 - fixed minor perl DBI driver documentation issue
        added support for oracle 12c
        added support for db2 10.1 and 10.5
        updated docs for oracle 12c, db2 10.1 and 10.5 and sybase 15.7
        modernized database installation docs a little
        fixed db2/sybase detection to take the system architecture into
                account when searching for libs
        applied various build-related patches from Ville Silventoinen
        fixed rpm->rpmbuild in installation docs
        added ora-00020 to list of errors that will cause the oracle
                connection to attempt to re-login, per Ville Silventoinen
        fixed some MS SQL Server/dateddmm parameter issues and updated docs
                to explain the remaining issues

0.50 - fixed sqlrserver-config script to return data for libsqlrserver
                rather than libsqlrconnection
        added test for SQLROWSETSIZE for odbc that doesn't define it
        updated postgresql drop-in library enough to work with psycopg2-2.4
                with various caveats and tweaks
        fixed NULL dereference in custom_nw logger
        added support for dbversion, show tables/databases and describe for
                SQL Server via freetds
        fixed a subtle bug that could cause the wrong triggers to be run
        fixed a reference-after-free in
        fixed an uninitialized variable (sqltr) in sqlrcontroller class
        updated the freetds connection to support multiple cursors correctly
        added config parameters for reformatting dates in the result set
        added various query translations for mssqlserver
        added an mssqlserver error map for the mysql drop-in library
        fixed a memory leak in the freetds version-checking code
        added new search paths and default prefix for syllable
        added support for null-terminated result bind lists to the mysql
                drop-in library so apps can optionally bind fewer columns than
                come back in the result set
        added configure tests for php-config-<version>

0.49 - fixed various issues that came up when cross-compiling
        fixed make uninstall to remove a few things that it missed
        fixed -pthread annoyance
        added -Werror to default build for most components
        fixed various issues revealed by -Werror
        added password encryption framework
        added rot,md5 and crypt password encryption plugins
        moved modules to libexec and removed the libsqlrelay_ prefix
        moved modules out of the connection directory and into their own
                directories under src
        reorganized code tree to compile faster
        updated clean targets in Makefiles to run faster
        fixed a bug that could cause problems when fetching from an output
                bind cursor under a very specific set of circumstances
        reorganized server code into libsqlrserver
        implemented the swisscomm log format as a plugin
        added dbHostName and dbIpAddress methods to the client API
        refactored authentication to remove a client-server round-trip
        replaced handoff="reconnect" with handoff="proxy" which uses
                listener-proxying to remove a client-server round-trip
        disabled nagle's algorithm for all sockets
        fixed a bug that could cause a hang if the db login failed
        updated reading of skip and fetch parameters not to rely on buffering
        refactored login error reporting
        fleshed out the ODBC driver significantly
        added docs for using SQL Relay from ODBC and JDBC
        refactored windows make.bat script

0.48 - integrated patches from Neowiz for:
                handling for oracle errors ora-01033, ora-02067 and ora-04068
                bind validation when using the statement cache
                optionally rejecting oracle queries with duplicate
                        bind variables
                query logging
                separate authentication and response timeouts on the client-side
                environment variables for setting timeouts
                sqlrelay-level errors for exceeding various bounds
                improved statistics gathering
        refactored Oracle re-prepare logic
        created a query logging framework
        implemented the current slow query log as a plugin
        implemented the neowiz query log format as a plugin
        created a custom query framework
        implemented the neowiz statistics gathering commands as custom queries
        added a test program for triggers, translations and other extensions
                and obscure features
        fixed several bugs in the informixtooracledates translation
        added a droplocalizedtemptables trigger
        added support for "global temporary" to temptableslocalize translation
        removed oracletemptablespreserverowsbydefault translation -
                temptableslocalize is much more effective
        fixed a bug that caused a "no server-side cursors" error to occur if
                when a new session is started if cursors="0" in sqlrelay.conf
        the client no longer aborts a result set before sending a new command,
                it just sends the new command, eliminating a client/server
        replaced sqlr-connection-"dbase" with a single sqlr-connection program
                that loads plugins for each database

0.47 - fixed bug that caused sqlr-export to output negative xml-entity values
        fixed single-quote-escaping in sqlr-export
        forced handoff="reconnect" for Cygwin and Linux<2.2
        updated all command line programs to use the same command line
                argument structure
        added a "fields" command to sqlrsh
        added a -command argument to sqlrsh so commands and queries can be
                run from the command line directly
        renamed query and fields to sqlr-query and sqlr-fields
        improved readline detection in the configure script
        added getDatabase/Table/ColumnList support to odbc and mdbtools
        added detection and support for openjdk
        integrated patches from Neowiz for:
                using -g3 if available when --enable-debug is specified
                support for using the oracle statement cache
                fixing an oracle column-resource-related memory leak
                eliminating sqlr-start delay
                "using namespace rudiments" declaration fixes
        added a faq entry about common OCIEnvCreate errors
        removed default id warning from sqlr-cachemanager
        removed coloration from sqlrsh
        updated begin, commit and rollback to return errors if they fail
        updated firebird docs
        added parsing of standalone constraints in a create table query

0.46 - refactored the translation framework to mimic the trigger framework
        added make.batch file for building on windows
        added C# API and ADO.NET adapter
        added begin method to API's
        added sqlrelay.xsd
        added date binds
        applied Georgiy Kirichenko's missing flushWriteBuffer() patch
        fixed some subtle bugs in the Ruby DBI module that modern versions of
                Ruby DBI reveal
        fixed sql parser errors involving "not null" and union clauses
        added a translation to replace double-quoted string literals with
                single-quoted string literals
        fixed a sql parser bug where "group" of a group by clause could be
                misinterpreted as a table alias
        updated the scaler to poll 10 times per second and also accept a
                trigger from the listener to mitigate race conditions that
                can become problematic when connections="0" is used
        added C# and ADO.NET docs and updated windows documentation
        updated the documentation
        added support for waitfordowndatabase config parameter
        applied some odbc fixes from Chae Young-ku
        added explicit support for outer join operators to the sql parser
        dynamic-ized triggers and translations
        added a "matches" to "like" translation
        added a "serial" to "autoincrement" translation
        fixed debug option to query command line client
        added javac compile test to configure script
        fixed an __attribute__ problem that could occur if perl was compiled
                with gcc>2.95 but used on a system with only gcc-2.95 available
        fixed an oustanding tcl bug that caused cursors not to be created
        fixed several bugs related to escaping quotes
        refactored OS detection in configure script
        added \n after reading from stdin on Haiku
        updated docs to reflect that mysql supports ?-based bind vars

0.45 - added trigger framework
        added support for getting the native database error number
        added support for mapping native error numbers to MySQL error numbers
                for the mysql drop-in replacement library
        renamed all .C files to .cpp for windows
        added msvc projects for sqlrclient, sqlrclientwrapper, sqlrutil and
                sqlrsh and got them all working natively on windows
        updated code so ttl="0" works as expected
        updated code so dynamic scaling of cursors works as expected
        documented dynamic scaling of cursors somewhat
        fixed a few mdbtools errors
        column aliases work as expected now with firebird
        fixed a bug where if an app either enabled or disabled autocommit,
                that could become the default status of autocommit rather than
                what was set in the config file
        added autocommit on/off to sqlrsh
        fixed a bind-var-related memory leak in mysql drop-in lib
        fixed return values in mysql drop-in lib
        updated getTableList() to exclude system tables
        applied Benno Lange's localstatedir patch to fix a case where the
                localstatedir command line parameter wasn't working properly
        applied Renat's listener alarm handling patch

0.44 - updated postgresql drop-in lib for postgresql 8/9 compatibility
        updated mysql drop-in lib for mysql 5.2+ compatibility
        applied Renat's patch to fix the client session count in the stats
        added getDatabase/Table/ColumnList method/functions to API's
        added string inputBind method/function with length
        added bind variable translation
        added transaction block emulation

This form allows you to request diff's between any two revisions of a file. You may select a symbolic revision name using the selection box or you may type in a numeric name using the type-in text box.

CVSweb <>