Age | Commit message (Collapse) | Author | Files | Lines |
|
|
|
The previous commit replaced the distfile with a new one with the same
name. In pkgsrc, we have rules for that; apply them.
|
|
Bumped PKGREVISION in case anyone already built the wrong one.
|
|
|
|
Mark as ready for python-3.x now that py-postgresql is.
Bump PKGREVISION.
|
|
The biggest change here is Python 3.x compatibility. Other changes are too
numerous to list. See http://www.pygresql.org/ for all the changes.
|
|
|
|
reset maintainer (ok by joerg@)
Recent changes:
Date Dev Ver Change details
---------- --- ------ --------------
2016-01-04 AV 1.22.0 Resolved an issue related to check options selection in
the view properties dialog with the check option.
[Reported by: Sebastian Albert, Patched by: Neel Patel]
2015-12-08 AV 1.22.0 Merged the libssh2 to the latest version.
[Akshay Joshi]
2015-11-19 DP 1.22.0 Properly detect serial columns as such when
identifiers have been truncated.
2015-10-23 AV 1.22.0 Fixes an issue related to the column inheritance
information properly, when one (or, more) common columns
are inherited from multiple tables.
[Reported by: Liu Yuanyuan, Patched by: Akshay Joshi]
2015-10-12 AV 1.22.0 Ensure the correct syntax used for moving the objects
from one tablespace to another. [Sanket Mehta]
2015-10-07 DP 1.22.0 Ensure the correct line endings are used when copying
from the SQL Pane [Nikolai Zhubr]
2015-09-25 AV 1.22.0 Toolbar icons, and menu items for Commit and Rollback
actions. [John Obaterspok]
2015-09-24 DP 1.22.0 Display the connection details for the current browser
object in the status bar [Adam Scott]
2015-09-21 AV 1.22.0 Fixed an issue related to different menus enabling in
the Query Tool on Ubunutu unity.
[Reported by: Vahdet Mert]
2015-09-21 AV 1.22.0 Reset the position (x, y) for dialog(s), and frame(s) to
0 (if found negative), while saving its position and
size. [Reported By: Mark, Patch: Sanket Mehta,
Reworked, and Reviewed: Ashesh]
2015-09-21 AV 1.22.0 Fixes an issue identifying the return type to TABLE in
some cases, using pg_get_function_result(..) for the
same instead of format_type(..)
[Reported By: Guillermo E. Villanueva,
PATCH:Sanket Mehta]
2015-09-21 AV 1.22.0 Honour PGPASSFILE environment variable for saving,
retrieving the password instead of always works with
pgpass.conf (on windows)/.pgpass (on non-windows)
[PATCH: Prasad Somwanshi, Reworked by: Sanket Mehta,
Reviewed by: Ashesh Vashi, Sanket Mehta]
2015-09-14 AV 1.22.0 Fix a segfault occurs while detecting transaction
section requirement, when autocommit has been disabled.
[Reported by John Obaterspok, Patch by Sanket Mehta]
2015-09-14 AV 1.22.0 Format execution time in a more readable manner
[John Obaterspok]
2015-07-27 AV 1.22.0 Improve sorting in Data editor
[J. F. Oster, Reviewed by Sanket Mehta]
2015-07-27 AV 1.22.0 Allow to format the selecte SQL using external tools
in Query Editor [J. F. Oster]
2015-05-22 AV 1.22.0 Allow to set auto-commit mode to on/off in the query
editor [Sanket Mehta]
|
|
Set up a separate user, previous PGUSER/PGGROUP integration didn't
make sense.
2016-02-26 - PgBouncer 1.7.2 - "Finally Airborne"
- Fix crash on stale pidfile removal. Problem introduced in 1.7.1.
- Disable cleanup - it breaks takeover and is not useful for
production loads. Problem introduced in 1.7.1.
- After takeover, wait until pidfile is gone before booting. Slow
shutdown due to memory cleanup exposed existing race. (#113)
- Make build reproducible by dropping DBGVER handling. (#112)
- Antimake: Sort file list from $(wildcard), newer gmake does not
sort it anymore. (#111)
- Show libssl version in log.
- deb: Turn on full hardening.
2016-02-18 - PgBouncer 1.7.1 - "Forward To Five Friends Or Else"
- WARNING: Since version 1.7, server_reset_query is not executed
when database is in transaction-pooling mode. Seems this was not
highlighted enough in 1.7 announcement. If your apps depend on
that happening, use server_reset_query_always to restore previous
behaviour.
- TLS: Rename sslmode "disabled" to "disable" as that is what
PostgreSQL uses.
- TLS: client_tls_sslmode=verify-ca/-full now reject connections
without client certificate. (#104)
- TLS: client_tls_sslmode=allow/require do validate client
certificate if sent. Previously they left cert validation
unconfigured so connections with client cert failed. (#105)
- Fix memleak when freeing database.
- Fix potential memleak in tls_handshake().
- Fix EOF handling in tls_handshake().
- Fix too small memset in asn1_time_parse compat.
- Fix non-TLS (--without-openssl) build. (#101)
- Fix various issues with Windows build. (#100)
- TLS: Use SSL_MODE_RELEASE_BUFFERS to decrease memory usage of
inactive connections.
- Clean allocated memory on exit. Helps to run memory-leak
checkers.
- Improve server_reset_query documentation. (#110)
- Add TLS options to sample config.
2015-12-18 - PgBouncer 1.7 - "Colors Vary After Resurrection"
- Support TLS connections. OpenSSL/LibreSSL is used as backend
implementation.
- Support authentication via TLS client certificate.
- Support "peer" authentication on Unix sockets.
- Support Host Based Access control file, like pg_hba.conf in
Postgres. This allows to configure TLS for network connections
and "peer" authentication for local connections.
- Set query_wait_timeout to 120s by default. Current default (0)
causes infinite queueing, which is not useful. That means if
client has pending query and has not been assigned to server
connection, the client connection will be dropped.
- Disable server_reset_query_always by default. Now reset query is
used only in pools that are in session mode.
- Increase pkt_buf to 4096 bytes. Improves performance with TLS.
The behaviour is probably load-specific, but it should be safe
to do as since v1.2 the packet buffers are split from connections
and used lazily from pool.
- Support pipelining count expected ReadyForQuery packets. This
avoids releasing server too early. Fixes #52.
- Improved sbuf_loopcnt logic - socket is guarateed to be
reprocessed even if there are no event from socket. Required for
TLS as it has it's own buffering.
- Adapt system tests to work with modern BSD and MacOS. (Eric
Radman)
- Remove crypt auth. It's obsolete and not supported by PostgreSQL
since 8.4.
- Fix plain "--with-cares" configure option - without argument it
was broken.
|
|
These should never have made it in. Bump resp. PKGREVISIONs.
|
|
|
|
This package is well beyond obsolete, and is no longer maintained
upstream. It only existed because postgis2 (now at 2.2, 2 major
releases later) was added instead of just updating this one.
|
|
|
|
3.2.4
- mongorestore --noIndexRestore inhibits empty collection creation
3.2.3
- mongoexport chokes on data with quotes
3.2.1
- Add bypassDocumentValidation option to mongorestore and mongoimport
- Missing "from" text in mongorestore status message
3.2.0
- Add bypassDocumentValidation option to mongorestore and mongoimport
- Missing "from" text in mongorestore status message
3.0.8
- bsondump does not keep attribut order
- mongodump issue with temporary map/reduce collections
- Error restoring database "insertion error: EOF"
|
|
- Fixed issue with setting optime when running with journaling
disabled
- Have read concern majority reflect journaled state on
the primary
- Fixed issue where specifying replication.enableMajorityReadConcern
implied true regardless of the actual boolean value
- Fixed issue causing segfault when running aggregation that
includes $lookup
|
|
|
|
Features
- Pass name of server auth class to AuthProvider
- Surface schema agreed flag for DDL statements
- Automatically convert float and int to Decimal on serialization
- Eventlet Reactor IO improvement
- Make pure Python ProtocolHandler available even when Cython is
present
- Optional Cython deserializer for bytes as bytearray
- Add Session.default_serial_consistency_level
- cqlengine: Expose prior state information via cqlengine
LWTException
- cqlengine: Collection datatype "contains" operators support
(Cassandra 2.1)
- cqlengine: Add DISTINCT query operator
- cqlengine: Tuple cqlengine api
- cqlengine: Add support for UPDATE/DELETE ... IF EXISTS statements
- cqlengine: Allow nested container types
- cqlengine: Add ability to set query's fetch_size and limit
- cqlengine: Internalize default keyspace from successive set_session
- cqlengine: Warn when Model.create() on Counters
Bug Fixes
- Bus error (alignment issues) when running cython on some ARM
platforms
- Overflow when decoding large collections (cython)
- Timer heap comparison issue with Python 3
- Cython deserializer date overflow at 2^31 - 1
- Decode error encountered when cython deserializing large map
results
- Don't require Cython for build if compiler or Python header
not present
- Unorderable types in task scheduling with Python 3
- cqlengine: Fix crash when updating a UDT column with a None value
- cqlengine: Race condition in ..connection.execute with lazy_connect
- cqlengine: doesn't support case sensitive column family names
- cqlengine: UserDefinedType mandatory in create or update
- cqlengine: db_field breaks UserType
- cqlengine: UDT badly quoted
- cqlengine: Use of db_field on primary key prevents querying except
while tracing.
- cqlengine: DateType.deserialize being called with one argument
vs two
- cqlengine: Querying without setting up connection now throws
AttributeError and not CQLEngineException
- cqlengine: BatchQuery multiple time executing execute statements.
- cqlengine: Better error for management functions when no connection
set
- cqlengine: Handle None values for UDT attributes in cqlengine
- cqlengine: Fix inserting None for model save
- cqlengine: EQ doesn't map to a QueryOperator (setup race condition)
- cqlengine: class.MultipleObjectsReturned has DoesNotExist as base
class
- cqlengine: Typo in cqlengine UserType __len__ breaks attribute
assignment
Other
- cqlengine: a major improvement on queryset has been introduced.
It is a lot more efficient to iterate large datasets: the rows
are now fetched on demand using the driver pagination.
- cqlengine: the queryset len() and count() behaviors have changed.
It now executes a "SELECT COUNT(*)" of the query rather than
returning the size of the internal result_cache (loaded rows).
On large queryset, you might want to avoid using them due to
the performance cost. Note that trying to access objects using
list index/slicing with negative indices also requires a count
to be executed.
|
|
|
|
pgpool-II is a middleware that works between PostgreSQL servers
and a PostgreSQL database client. It talks PostgreSQL's backend
and frontend protocol, and relays a connection between them.
|
|
v2.2.17 released 2016-03-07
* General compatibility with MySQL 5.7 tools, docs and test suite
* pt-mysql-summary displays incorrect info about Fast Server Restarts
for Percona Server 5.6
* pt-online-schema-change cannot set sql_mode using --set-vars
* pt-online-schema-change added --null-to-non-null option to allow
NULLable columns to be converted to NOT NULL
* pt-online-schema-change doesn't apply underscores to foreign
keys individually
* pt-online-schema Invalid recursion method: t=dsns
* pt-online-schema-change fails when using --no-drop-old-table
after 10 times
* pt-query-digest : Redundant argument in sprintf
* pt-query-digest doc bug with --since and too many colons
* pt-query-digest: Make documentation of --attribute-value-limit
option more clear
* pt-show-grants fails against MySQL-5.7.6
* pt-show-grants doesn't sort column-level privileges
* pt-slave-restart fails on MariaDB 10.0.13 (gtid_mode confusion)
* pt-stalk: new var binlog_error_action causes bug in collect module
* pt-table-checksum has high likelyhood to skip a table when row count
is around chunk-size * chunk-size-limit
* pt-table-checksum redundant argument in printf
v2.2.16 released 2015-11-09
* pt-archiver dies with "MySQL server has gone away" when
innodb_kill_idle_transaction set to low value and bulk
insert/delete process takes too long time
* pt-kill option --filter does not work
* pt-online-schema-change should reconnect to slaves
* pt-online-schema-change, MySQL 5.6, and InnoDB optimizer stats
can cause downtime
* pt-stalk find -warn option is not portable
* Document that pt-table-checksum has high likelihood to skip a table
when row count is around chunk-size * chunk-size-limit
v2.2.15 released 2015-08-28
* pt-archiver checked lag too frequently
* pt-archiver clarified function of --check-interval [DOC]
* pt-archiver now accepts checking lag on multiple slaves
* pt-archiver now checks for PXC flow control via --max-flow-ctl option
* pt-archiver options --no-delete and --purge were not mutually
exclusive
* pt-archiver mysql timed out when innodb_kill_idle_transaction set
to low value and check-slave-lag used
* pt-duplicate-key-checker doesn't support triple quote in column name
* pt-kill enable support for RDS
* pt-mysql-summary lacked an --ask-pass option
* pt-online-schema-change added --sleep option
* pt-online-schema-change core dump on erroneous alter directive
* pt-online-schema-change now checks for PXC flow control via
--max-flow-ctl option
* pt-online-schema-change unstable signal handling
* pt-online-schema-change now controls constraint name length
* pt-online-schema-change --chunk-size-limit=0 inhibited checksumming
of single nibble tables
* pt-sift failed when fetching missing tools
* pt-stalk monitors tokudb status
* pt-table-checksum doesn't reconnect to slaves when timed out
on very long lags
* passsword parameter must escape commas - all tools [DOC]
* changes needed to build packages from git tree
* write-user-docs script stopped working after switching to github
* testing bugs related to newer perl versions
|
|
7.4.10
- A serious regression was inadvertently introduced in MySQL Cluster NDB
7.4.8 whereby local checkpoints and thus restarts often took much longer
than expected.
See more at:
http://dev.mysql.com/doc/relnotes/mysql-cluster/7.4/en/mysql-cluster-news-7-4-10.html
7.4.9
- Important Change: Previously, the NDB scheduler always optimized for
speed against throughput in a predetermined manner (this was hard coded);
this balance can now be set using the SchedulerResponsiveness data node
configuration parameter.
- Added the tc_time_track_stats table to the ndbinfo information database.
- Cluster Replication: Normally, RESET SLAVE causes all entries to be
deleted from the mysql.ndb_apply_status table. This release adds
the ndb_clear_apply_status system variable, which makes it possible
to override this behavior.
See more at:
http://dev.mysql.com/doc/relnotes/mysql-cluster/7.4/en/mysql-cluster-news-7-4-9.html
7.4.8
- Changes have been made in the minimum values for a number of parameters
applying to data buffers for backups and LCPs. These parameters, listed
here, can no longer be set so as to make the system impossible to run:
- BackupDataBufferSize: minimum increased from 0 to 2M.
- BackupLogBufferSize: minimum increased from 0 to 2M.
- BackupWriteSize: minimum increased from 2K to 32K.
- BackupMaxWriteSize: minimum increased from 2K to 256K.
In addition, the BackupMemory data node parameter is now deprecated and
subject to removal in a future version of MySQL Cluster. Use
BackupDataBufferSize and BackupLogBufferSize instead.
- When a backup was unsuccessful due to insufficient resourcesa subsequent
retry worked only for those parts of the backup that worked in the same
thread, since delayed signals are only supported in the same thread.
Delayed signals are no longer sent to other threads in such cases.
- An instance of an internal list object used in searching for queued
scans was not actually destroyed before calls to functions that could
manipulate the base object used to create it.
- ACC scans were queued in the category of range scans, which could lead
to starting an ACC scan when DBACC had no free slots for scans. We fix
this by implementing a separate queue for ACC scans.
- Cluster Replication: Added the create_old_temporals server system
variable to compliment the system variables avoid_temporal_upgrade and
show_old_temporals introduced in MySQL 5.6.24 and available in MySQL
Cluster beginning with NDB 7.3.9 and NDB 7.4.6.
- When the --database option has not been specified for ndb_show_tables,
and no tables are found in the TEST_DB database, an appropriate warning
message is now issued.
- Bug fixes.
See more at
http://dev.mysql.com/doc/relnotes/mysql-cluster/7.4/en/mysql-cluster-news-7-4-8.html
|
|
3.7.0 (09/14/2015)
==================
Enhancements:
Feature request #521 Alias name in SQL History search dialog.
Upgraded to latest RSyntax version (2.5.6).
The new version has a clipboard history which is accessible
through ctrl shift v.
A little drawback of the new version is that background colors
are not supported in syntax styles.
Feature request #485 Execute multiple SQL statements on one
click without selection
The new feature executes all SQLs in the editor.
If there are multiple SQLs in the editor the statement
separator has to be used.
The feature is accessible through a new tool bar button,
tools popup and the alt shift ENTER key combination
Feature request #484 Query output preferences --> Allow table
and text output simultaneously
Note: SQL result output as table or editable table now
includes text output in an extra tab.
That's why there should be only few cases where
choosing text output in Session Properties makes sense
anymore.
Feature request #479 Add option for tab names to contain only
Alias name
The option can be found at menu File --> Global Preferences -->
Tab General --> Bottom of section Appearance
Feature request #487 Show AS label as column header (if present)
If a SQL result contains at least one column whose column name
is not equal to its column label a button is shown at the header
of the tab named "Result".
By this button one can toggle display between column names
and labels.
Note: To configure the default display see menu File ->
Global Preferences -> Tab Data Type Controls -> Top of panel.
WIKI table Plugin: Added support for JIRA/Confluence Markup Style
Thanks to Thomas Hackel for the merge request.
Feature request #501 Overview/Charts Tab: Distinct Counts
- Distinct counts for an Overview as a whole are now displayed
right next to the column name
- Distinct counts of Intervals are available as tool tips
as well as a new details window which is accessible through
the right mouse menu
Sybase dialect support when using jtds
Thanks to Sumit Agarwal for the merge request.
On Mac OS X the SQuirreL now uses the acorn icon instead of the
default java coffee cup icon.
Thanks to Martin W. Kirst for the merge request.
New command line parameter:
Short form: -detectEDT
Long form: --detect-long-running-swing-edt-events
The parameter has no arguments.
The parameter enables SQuirreL to detect long running Swing
Event Dispatch Thread events.
When the dispatch thread is blocked for longer than two seconds
a warning containing a thread dump is written to the logs.
Upgraded to the latest RSyntax version (2.5.3).
Syntax Plugin: Made background color for white spaces affect
the whole SQL editors background, see menu File --> New Session
Properties --> tab Syntax
Note: If you combine this feature with the Metal-Charcoal Look
and Feel you can make SQuirreL appear in "fashionable" black.
Thanks to Duane Redfern for the patch.
When adjusting table column widths a maximum width may now be
defined.
See menu File --> Global Preferences --> Tab General -->
right column
Speeded up reading and writing Alias properties. As result
opening and closing a connections will be much faster for big,
complicated databases.
Thanks to Jaroslaw Jarmolowicz for the patch
Starting and stopping SQuirreL is much faster for big,
complicated databases
Thanks to Jaroslaw Jarmolowicz for the patch
Postgres Plugin:
- For postgres query plans explain was used which is less
accurate than explain analyze so it was changed to use it
instead.
- Previous implementation had limitation of producing query
plans only for SELECT queries. It was changed so query plan can
work for every type of query.
- Query plan executions are wrapped in transaction so they don't
change database state.
Thanks to Jaroslaw Jarmolowicz for the patch
Bug fixes.
|
|
|
|
GA 1.1.7 -
- Add JSON support
- Allow building without server flags (Bug#21391025)
- Correct relative() not seeking after changing position.(Bug#21152054)
|
|
=== 4.32.0 (2016-03-01)
* Use mutex for synchronizing access to association reflection cache on MRI (jeremyevans)
* Add Dataset#delete_from on MySQL, allowing deletions from multiple tables in a single query (jeremyevans) (#1146)
* Add no_auto_literal_strings extension, which makes SQL injection vulnerabilities less likely (jeremyevans)
* Add Model.default_association_options, for setting option defaults for all future associations (jeremyevans)
* Support :association_pks_nil association option in association_pks setter for determining how to handle nil (jeremyevans)
* Make association_pks setter handle empty array correctly when :delay_pks is set (jeremyevans)
* Add a setter method for one_through_one associations (jeremyevans)
* Include :remarks entry in JDBC schema parsing output, containing comments on the column (olleolleolle) (#1143)
* Support :eager_reload and :eager options to associations in tactical_eager_loading plugin (jeremyevans)
* Make tactical_eager_loading not eager load if passing proc or block to association method (jeremyevans)
* Make eager_each plugin handle eager loading for Dataset#first and similar methods (jeremyevans)
|
|
0.4.3
New Features
* Add method Client#ssl_cipher to expose mysql_get_ssl_cipher
* Add method Result#free to immediately free a result set
* Add connection flag automatic_close: true/false to determine whether to
work around connections being closed by garbage collection in a child
after a fork. Default is true, which restores behavior prior to 0.3.16.
Bugfixes
* Fix to hold the GVL between mysql_stmt_execute and mysql_stmt_store_result
to prevent commands hitting the wire out of sync (e.g. if a GC run occurs
in the middle)
* Fix BigDecimal arguments to Prepared Statements were ignored
* Fix rake re-definition warning
Changes
* Add Ruby 2.3 to the Travis CI matrix
* Allow nil for timeouts instead of casting to 0 when creating a Client
instance
* Add connection flag automatic_close: true/false to determine whether to
work around connections being closed by garbage collection in a child
after a fork. Default is true, which restores behavior prior to 0.3.16.
|
|
|
|
Improvements to the Makefiles and build scripts used by VisualStudio.
Fix an FTS5 issue in which the 'optimize' command could cause index corruption.
Fix a buffer overread that might occur if FTS5 is used to query a corrupt database file.
Increase the maximum "scope" value for the spellfix1 extension from 6 to 30.
|
|
|
|
|
|
* Change LICENSE since 3.1.0
Changelog:
* Support SQLite 3.9.2
* Support Qt5
* Many improvements and bugfixes
|
|
|
|
No chnage except version.
|
|
Version 1.6.0 - 29 Feb 2016
- Support for streaming replication connection through the
streaming_conninfo server option
- Support for the streaming_archiver option that allows Barman to
receive WAL files through PostgreSQL's native streaming protocol.
When set to 'on', it relies on pg_receivexlog to receive WAL data,
reducing Recovery Point Objective. Currently, WAL streaming is an
additional feature (standard log archiving is still required)
- Implement the receive-wal command that, when streaming_archiver is
on, wraps pg_receivexlog for WAL streaming. Add --stop option to
stop receiving WAL files via streaming protocol. Add --reset option
to reset the streaming status and restart from the current xlog
in Postgres.
- Automatic management (startup and stop) of receive-wal command via
cron command
- Support for the path_prefix configuration option
- Introduction of the archiver option (currently fixed to on) which
enables continuous WAL archiving for a specific server, through log
shipping via PostgreSQL's archive_command
- Support for streaming_wals_directory and errors_directory options
- Management of WAL duplicates in archive-wal command and integration
with check command
- Verify if pg_receivexlog is running in check command when
streaming_archiver is enabled
- Verify if failed backups are present in check command
- Accept compressed WAL files in incoming directory
- Add support for the pigz compressor (thanks to Stefano Zacchiroli
zack@upsilon.cc)
- Implement pygzip and pybzip2 compressors (based on an initial idea
of Christoph Moench-Tegeder christoph@2ndquadrant.de)
- Creation of an implicit restore point at the end of a backup
- Current size of the PostgreSQL data files in barman status
- Permit archive_mode=always for PostgreSQL 9.5 servers (thanks to
Christoph Moench-Tegeder christoph@2ndquadrant.de)
- Complete refactoring of the code responsible for connecting to
PostgreSQL
- Improve messaging of cron command regarding sub-processes
- Native support for Python >= 3.3
- Changes of behaviour:
- Stop trashing WAL files during archive-wal (commit:e3a1d16)
- Bug fixes:
- Atomic WAL file archiving (#9 and #12)
- Propagate "-c" option to any Barman subprocess (#19)
- Fix management of backup ID during backup deletion (#22)
- Improve archive-wal robustness and log messages (#24)
- Improve error handling in case of missing parameters
Version 1.5.1 - 16 Nov 2015
- Add support for the 'archive-wal' command which performs WAL
maintenance operations on a given server
- Add support for "per-server" concurrency of the 'cron' command
- Improved management of xlog.db errors
- Add support for mixed compression types in WAL files (SF.net#61)
- Bug fixes:
- Avoid retention policy checks during the recovery
- Avoid 'wal_level' check on PostgreSQL version < 9.0 (#3)
- Fix backup size calculation (#5)
|
|
Upstream changes:
1.73 Thu Mar 3 20:34:46 PST 2016
Some mionor typos in the document fixed. No code change.
Thanks to Lucas Kanashiro
|
|
|
|
|
|
not clear all bits. (Can happen on Linux --
https://bugs.launchpad.net/ubuntu/+source/coreutils/+bug/67583)
|
|
Build 119 (2016-01-31)
Enhancements
* It's now possible to display the column's data type in the
header of the result table
* When importing all files from a directory, WbImport now
provided pre-defined variables with the filename
* It's now possible to configure auto-saving of external files
independently from auto-saving the workspace.
* A new command WbMessage to display a simple message is available.
* It's not possible to search text in all open editors
(Tools -> Search all tabs)
* For some DBMS, the DbTree and DbExplorer now show the
dependencies between objects
* For DB2/iSeries table and column comments can now be retrieved
from the system catalogs instead of using the JDBC driver.
* For Postgres it is now possible to manually control transactions
using BEGIN .. COMMIT when the connection is set to autocommit
* The list of tables in the DbTree is now sorted to work around
bugs in JDBC driver that do not properly sort the list of tables
* For DBMS that support it, two new modes have been added
to WbImport: -upsert and -insertIgnore using native "UPSERT"
functionality if available
* For Firebird the SQL source of external tables is now generated
correctly.
* An new command WbGenerateImpTable is available to infer
the structure of a table from an import file
* The command line parameter -vardef has been deprecated and
replaced with -variable and -varFile
* It's now possible to provide tags for each connection profile.
The quickfilter will then use the defined tags for filtering
the displayed profiles.
* Connection parameters specified on the command line now have
precedence over the properties defined through a Liquibase
defaults file (specified through -lbDefaults)
* It's now possible to enable the use of Oracle's DBMS_METADATA
for source code retrieval for different types of objects
* The tooltip shown for result tabs can now be configured
(Options -> Data display)
* For the internal SQL formatter, it's now possible to
configure the case in which data type names are written
* A new action to run all SQL statements up to the cursor
position is available
* The error dialog that is displayed when running a script can
now be configured to also include the error message or the
statement that failed
* Improved display of packages in the DbTree for Oracle and
Firebird
Bug fixes
* Showing rowcounts in the DbTree did not work for DB2
* "Generate Delete Script" for a selection of rows in
the result did not display the generated script.
* When reloading the whole DbTree while a node was selected,
would show elements (e.g. tables) twice
* CREATE TABLE statements were not formatted correctly
if the name consisted of quoted and unquoted parts
(e.g. unquoted schema and quoted table name)
* The error dialog when running running multiple statements
was not displayed on Linux if the option "Include error message"
was selected in the "SQL Execution" options
* Improved the performance when retrieving table definitions
and table source for Oracle
* For Postgres, rules defined on a table where shown twice
in the generated DDL script
* Retrieving additional column information in the DbExplorer
failed on SQL Server if a non-standard database collation
was used
* The DDL for constraints or comments where identifiers
required quoting was not correct
* The formatter would not process statements correctly where
a sub select using function calls in the WHERE clause was
used in a JOIN condition
* When using "Remove Comments" for a connection profile,
the error position inside a statement was not shown correctly
for some DBMS
* For Oracle, when using "Trim CHAR data" and editing tables
where the primary key column was defined as CHAR, updating
the result did not work.
* Toggle comment did not toggle correctly when some lines were
already commented and some not
* The messages shown when using conditional execution with
WbInclude did not properly include the variable name or value
* For Oracle the tablespace of materialized views was not shown
in the generated SQL (Fix contributed by Franz Mayer)
* It was not possible to work with SAVEPOINTs correctly
* Table definitions for tables with VARCHAR columns were not
displayed for Oracle
* Disabling the check for read-only columns did not work
for all JDBC drivers
* WbCopy now stops with an error if -targetTable is specified
and -sourceTable is used to specify multiple tables
* For DB2 the names of PK constraints where not properly
qualified with a schema if needed
* Sometimes using "Execute current" would not correctly
identify the current statement and run the first statement
from the editor
* WbImport using -insert,update did not work for multi-column
primary keys when not all PK columns where part of the input
file
* When a variable value contained the prefix and the suffix of
the variable pattern, using such a variable would result
in SQL Workbench/J locking up
* Reloading a trigger source in the DbExplorer's trigger panel
did not work
* For Oracle the source of a trigger that had a trailing space
in the name was not retrieved
* For Oracle the position of errors in regular (non-PL/SQL)
DDL statements was not shown
* When starting SQL Workbench on a headless system, using
"java -jar" using the -script parameter did not work
any longer
* For SQL Server 2000, retrieving the source of a view did not
work
* For SQL Server, generating "dummy DML" for tables with "bit"
columns did not work
* For MySQL the option "on update" for a default value was not
shown in the generated SQL source for a table
Build 118 (2015-08-16)
Enhancements
* Added support to include computed columns for MySQL 5.7
in the generated CREATE TABLE source
* The source and target connection for WbCopy, WbSchemaDiff
and WbDataDiff can now be specified on the command line when
starting the application. In that case it's not necessary to
provide them to the respective commands
* A new action to run all SQL statements in the editor starting
from the cursor position is available
* It's now possible to use OS environment variable or Java
properties in the username of a connection profile.
* For Postgres, "COPY .. FROM stdin" with the data after the
statement is now supported
* It's now possible to define external tools to format SQL
* For decimal values WbExport now supports the parameters
-fixedDigits and -maxDigits.
* It's now possible to enable editing (and running)
the generated SQL source code in the DbExplorer directly.
* For Oracle, messages from dbms_output are now always shown
if a procedure is started using EXECUTE regardless of
the setting of "set serveroutput"
* Added some basic support for SAP HANA.
* For Excel imports, the option -stringDates=true retrieves
Dates as formatted strings and converts them using
the date/timestamp format specified in the WbImport command
rathr then reading a converted value from the Excel file.
* For Excel exports, the start location where the data should
be written to in the excel file can now be specified using
the -offset parameter
* The application to be used for displaying the logfile can now
be configured.
* WbSchemaReport has a new (boolean) option -writeFullSource
to write a valid CREATE VIEW statement to the XML output
in case the DBMS does not store the complete SQL
* Results can now automatically be refreshed either through
an annotation or through the context menu of the result tab
* The macros in a group can now be sorted alphabetically
* The quoting of the null values for text exports can now
be enabled through the option -quoteNulls
* The quoting of the header for text exports can now be enabled
through the option -quoteHeader
* The statement at the cursor position can now be copied directly
into the clipboard (Code Tools -> Copy current statement)
* For Oracle, the partitions of a materialized view are now
shown in the source code
* WbImport and WbCopy (including the DataPumper) can now be
used to insert data into a view
* For tables without a primary key, unique indexes that contain
nullable columns are no longer considered when generating
DML statements
* For Vertica tables and views from the schema "v_internal" are
now show in the DbExplorer (contributed by Tatiana Saltykova)
* It's now possible to define the terminator string for
"Copy Code Snippet" through the config property
"workbench.clipcreate.codeend"
* Macros and macro groups can now be excluded from
the popup window
Bug fixes
* The menu to select data from referenced/referencing tables
in a result set was disabled when switching to the DbExplorer
and back to the SQL panel
* -syncDelete with WbCopy did not work if alternate key columns
were specified using -keyColumns
* Fixed retrieval of stored procedures for DB2 on AS/400
(thanks to Francesco)
* Fixed detection of update columns for multi-table result sets
when the name of the PK columns is not uniuqe in the result set
* For Firebird the source code for procedures with multiple out
parameters was not generated correctly.
* For PostgreSQL, SQL statements to create the comment for
functions with OUT parameters were not generated correctly.
* When running a single command in batch mode, the error status
was not returned correctly to the operating system
* WbExport no longer uses the GUI defaults for decimal digits.
The default is now to always export all digits, unless
the new -maxDigits parameter is used
* For MySQL, when multiple tables with the same name in different
databases had triggers defined, all triggers where visible
for each table in the DbExplorer
* When importing multiple files using -usePgCopy and one file
generated an error, the previous import was not committed
* WbConnect would prompt for a password for profiles with
an empty password even if "Save password" was enabled
* No parameter prompt was shown for INOUT parameters when
running procedures using WbCall
* Implemented a workaround for an Informix driver bug where
index information for the wrong table was returned
* Double quotes in column values were not escaped properly
when creating a JSON export
* When switching between views and tables in the DbExplorer
the foreign key tabs were no longer shown for SQL Server
* Compile errors for Oracle's PL/SQL where not always shown
correctly
* Parameters for SQL Workbench commands with nested single
and double quotes that included SQL comments were not
evaluated properly
* Fixed restoring of the window position when using multiple
monitors
* Generating the SQL source for computed columns did not work
for SQL Server 2000
* The SQL source for inherited tables in Postgres was not
generated correctly.
* The SQL source for sequences for SQL Server was not generated
correctly.
* "Create DDL script" in the DbExplorer would generate
the source code for sequnces twice
* Nano (or micro) seconds from timestamp values where not
displayed correctly
* When opening a file, it is now checked if the selected
encoding matches the one from the file
* Each time when reloading a result that uses the @WbMacro
annotation, the macro sub-menu would be added to the context
menu again
* For Informix, default clauses for columns were not generated
properly in the DbExplorer
* For Informix, index definitions were not always displayed
correctly
* Overloaded functions and procedures where not handled
correctly by WbSchemaDiff
* For Postgres the wrong DROP FUNCTION statement was generated
if a function contained OUT parameter
* Scripts that contained statements including character
literals with a backslash were not always parsed correctly.
* When WbImport did not find any matching columns, the error
message did not include the (faulty) source file
* Fixed the display of the profile tree with large fonts
* The DataPumper did not work if source and destination had
a different number of columns
* The generated WbCopy command in the DataPumper was not
correct when a query was used as the source
* XLSX export did not work if the output file was specified
without an extension
* Fixed some issues with restoring the window position on
multi-monitor systems
* Fixed some issues where the alternate delimiter was
incrrectly used when running scripts through WbInclude
* When importing multiple Excel files with WbImport using
the -sourceDir argument, only the first file was imported
* The abbreviated WbInclude using @ only worked with Oracle
* The minutes for columns of type "timestamp with time zone"
where not always displayed correctly in Oracle
* Oracle's autotrace did not work in console mode
* Using pgpass for Postgres connections did not work in console
or batch mode
* WbProcSource would not show the code for a packaged procedure
in Oracle
* Fixed some problems in the SQL formatter that would lead
to invalid SQL syntax
* XSLT transformations failed when the output filename didn't
include a directory
* Disabling "Filter while typing" in the DbExplorer was not
possible
* -targetConnection and -referenceConnection for WbSchemaDiff
and WbDataDiff were broken
|
|
shared-mime-info 1.6 (2016-02-23)
* Add XAR archive mime-type
* Add GeoJSON mime-type
* Add GPX mime-type
* Add xdg-app mime-type
* Add *.xht glob and magic for XHTML files
* Bump priority of archive mime-types with long magics,
to avoid false positives when detecting files inside
the archive itself
|
|
|
|
|
|
* InnoDB: A new InnoDB configuration option, innodb_tmpdir, allows you to configure a separate temporary file directory for online ALTER TABLE operations. This option was introduced to help avoid tmpdir overflows that could occur as a result of large temporary files created during online ALTER TABLE operations. innodb_tmpdir is a SESSION variable and can be configured dynamically using a SET statement.
* yaSSL was upgraded to version 2.3.9. This upgrade corrects an issue in which yaSSL handled only cases of zero or one leading zeros for the key agreement instead of potentially any number, which in rare cases could cause connections to fail when using DHE cipher suites.
* The Valgrind function signature in mysql-test/valgrind.supp was upgraded for Valgrind 3.11.
* Bugs Fixed
|
|
* yaSSL was upgraded to version 2.3.9. This upgrade corrects an issue in which yaSSL handled only cases of zero or one leading zeros for the key agreement instead of potentially any number, which in rare cases could cause connections to fail when using DHE cipher suites.
* The Valgrind function signature in mysql-test/valgrind.supp was upgraded for Valgrind 3.11.
* Bugs Fixed
|
|
Add missing BUILD_DEPENDS
Upstream changes:
2.032000 2015-11-07 10:34:14-08:00 America/Los_Angeles
- Add ::ResultClass::Tee
|
|
Upstream changes:
0.12 24 Nov 2015
- fix https://rt.cpan.org/Ticket/Display.html?id=109596 for newer DBIC API.
|
|
Upstream changes:
0.07045 2016-01-22
- Regenerate tarball without author-mode test dependencies
0.07044 2016-01-22
- Fix Pg date/time types with zero fractional second digits
- Add support for nested hashref form of col_accessor_map
|
|
Upstream changes:
0.082821 2016-02-11 17:58 (UTC)
* Fixes
- Fix t/52leaks.t failures on compilerless systems (RT#104429)
- Fix t/storage/quote_names.t failures on systems with specified Oracle
test credentials while missing the optional Math::Base36
- Fix test failures when DBICTEST_SYBASE_DSN is set (unnoticed change
in error message wording during 0.082800 and a bogus test)
- Remove largely obsolete test of SQLite view deployment (RT#111916)
* Misc
- Work around rare test deadlock under heavy parallelism (RT#108390)
|
|
|
|
|