Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

Whats new:>>

Cassandra 3.x support was added. New data types, metadata browser.
MongoDB 3.x authentication support was added.
PostgreSQL: SSL support, foreign tables support, database switch, metadata managers improved.
MySQL: SSL support was added.
Oracle: table DDL generator improved.
Many minor UI fixes and improvements.

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

The main program update ( the Main ):

Upd: Run optimization approach, in order to avoid waiting database returns a message too long, leading to the main program can not respond to the problem (5924)
Add: Added cancel the execution of the command ( the Cancel Executing Command ) function can be forced to cancel the execution of commands without waiting for completion of execution (5924)
Unlike the already supported cancel the execution process (Cancel executing process)
More shortcuts ( the Cancel the Execution : In addition to the original Escape, another increase Alt + Break)
Upd: Status column depending on the status of implementation, updating the display of different background colors
Upd: Cumulative contain other minor updates, fixes and optimization
Upd: Update Files Additional .NET Database ( 32bit / 64bit ) (2016/03/16)
Misc: the with Compatible the SQL Server 2016 RC1 (2016/03/18)

Automatically and perception:

Upd: auto-complete optimization and perception Space automatically exclude unnecessary processing
Upd: increasing insertion AND, OR, keywords, automatically open field sensing process

Table and view a list of tables:

Fix: Fixed RowCount field scheduling problem
Fix: Fixed some database objects can not get RowCount VIEW problems

Row editing and browsing:

Upd: rows manually edit filter conditions ( Manual the Filter ): 1. increase button background color status display, 2. Clear the empty string
Upd: optimization significantly enhance the data column shows the processing speed of more than 30%

Data Definition Language:

Fix: (Oracle) is generated when the correction data table definition is not included via CREATE UNIQUE INDEX generated index definition
Fix: structural description and data sheet (Oracle) where the index is not the same amendment, the definition of the problem can not generate the index

Database Migration:

Fix: Fixed multi-column index generated when the field is displayed in order of priority issues
Fix: Fixed after completion of the project the new connection can not be displayed immediately [auto-generated command line to the clipboard] function button issues
Fix: Fixed Oracle index generation processing
Fix: Improved index was renamed after the problem menu changes are not synchronized Index Name

Upd: command line processing ( the Command-Line ):

Upd: When using parameters -m open database migration feature will run independently, can be left directly after closing will not open the main program
Upd: increase QuotedString recognition processing, in order to avoid duplication of the specified
Fix: Fixed database to SQL Server / SQLAzure / SybaseASE, you can not specify schema + table (Schema.Table) Issues
Upd: correct object parameter abbreviated -dest (formerly -desc still use [?])

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

+ issue #11456 Disabled storage engines
+ issue #11479 Allow setting routine wise privileges
- issue        Hide Insert tab for non-updatable views
+ issue #11490 UI for defining partitioning in create table window
+ issue #11438 Support JSON data type
+ issue        Editing partitions in table Structure
- issue        Tracking does not make sense for information_schema
- issue #11550 Regression in Find and replace
+ issue #11619 TokuDB Tables Show Size as "unknown"
+ issue #11654 Use a slider for Internal relations
+ issue #11641 Ability to disable the navigationhiding Feature
- issue #11647 Restrict configuration NavigationTreeDbSeparator to strings
- issue #11667 Disable the tooltip in the navigation panel's filter box
+ issue        Copy results to clipboard
+ issue #11504 Reactivate cut&paste possibility in print view
- issue #11702 Extraneous message after edit + grid-edit
- issue #11668 Table header is empty with browsing an empty table
+ issue #11701 Allow changing parameter order of routines
- issue #11708 Remove no password warning
+ issue #11711 Clarify the meaning of "Stand-in structure for view" in SQL export
- issue        HTML line break shown after a MySQL connection error message
- issue #11728 CSV import skip row count after
- issue        Fixed displaying of SQL query on table operations
- issue #6321  Display binary strings as text if they are valid UTF-8
+ issue #11743 Display routine specific privileges
+ issue #11538 Copy multiple tables to database
+ issue        Support Cloudflare Flexible SSL
- issue        Handle empty TABLE_COMMENT
+ issue #11833 Drop support for old Internet Explorer versions
+ issue #11796 Use modals for displaying forms in db structure page
+ issue #11789 Show MySQL error messages in user language
+ issue        Add 'ssl_verify' configuration directive for self-signed certificates with mysqlnd and PHP >= 5.6
+ issue #11874 Show more used PHP extensions
- issue #11874 Report when version check and error reporting are disabled
- issue #11849 Fix PDF schema export
- issue #11412 Remove ForceSSL configuration directive
- issue        Remove support for Mozilla Prism
- issue #11412 Remove PmaAbsoluteUri configuration directive
- issue #11914 Fix autoloading of phpseclib
- issue #11880 Fixed rendering of missing extension error
- issue #11923 Errors on Structure tab when user only has select access on certain columns
- issue #11972 Missing documentation for $cfg['Servers'][$i]['favorite'] and $cfg['NumFavoriteTables']
- issue #11907 Avoid displaying UPDATE query twice
- issue #11850 Fixed CSV import
- issue        Fix SQL syntax highlighting in database search page
- issue #12056 Fix error when we can not generate random string
- issue #12055 Fixed PHP syntax error in templates
- issue #12054 Fixed processing of queries with escaped quotes
- issue #12041 Fixed exporting tables with fields DEFAULT and COMMENT
- issue #12073 Hide edit and delete buttons when the results are not related to a table
- issue #12083 Fixed parsing of field definition
- issue #12081 Fixed rendering of table stats
- issue #11705 Fixed problems with PHP on Windows on table structure
- issue #12085 Like search strings being escaped incorrectly
- issue #12092 Rename exported databases/tables doesn't seem to work
- issue #12099 Undefined index: controllink
- issue #12094 PHP Fatal error: Call to undefined function __()
- issue #12098 Fix login after logout with http authentication
- issue #12074 Fixed possible invalid SQL export
- issue #12026 Fixed parsing of UNION SELECT with brackets
- issue #12109 Fixed parsing of CREATE TABLE [AS] SELECT
- issue #12105 Multi-server drap-and-drop import always fails
- issue #12116 Fulltext indexes are not copied when using copy database function

[close]

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Exportizer is a free database export tool. It allows you to export data to a file, clipboard, or printer. Exportizer works via BDE or ADO. It can convert DB, DBF, text, CSV to text, CSV, XLS, RTF, XML, HTML, DBF, and INSERT statements. Many export options ensure full control over output. There is an ability to specify the source-to-target field mappings. Export operations can be performed either via the program interface or via command line with large number of parameters. You can easily generate needed command line directly from the GUI. It is possible to copy data to the clipboard or print it. There are several utility functions for data manipulating and bookmarking.

Features:

Opening tables from multi-table database files like XLS, XLSX, XLSM, XLSB, MDB, ACCDB, HTML, GDB, IB, FDB, UDL, and other multi-table databases like ODBC data sources etc.
Exporting data from all files, which are located in one folder, or all tables from a multi-table data source, at once (from interface or via command line).
Ability to specify custom increment number for Increment Field Value function.
Exporting data to Excel (XML-based) and DATABASE formats.
Using extra command line line options like /Silent, /LogFile, /CloseOnError etc.
Using extra export modes like Append and Empty+Insert.

Freeware

Whats new: >>

New export formats: PDF, SYLK, Excel (OLE), Word (OLE).
Ability to work with favorite export formats only.
Automatically checking for new program version.
Minor changes in data grid.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

Potentially Disruptive Change:

The SQLITE_DEFAULT_PAGE_SIZE is increased from 1024 to 4096. The SQLITE_DEFAULT_CACHE_SIZE is changed from 2000 to -2000 so the same amount of cache memory is used by default. See the application note on the version 3.12.0 page size change for further information.

Performance enhancements:

Enhancements to the Lemon parser generator so that it creates a smaller and faster SQL parser.
Only create master journal files if two or more attached databases are all modified, do not have PRAGMA synchronous set to OFF, and do not have the journal_mode set to OFF, MEMORY, or WAL.
Only create statement journal files when their size exceeds a threshold. Otherwise the journal is held in memory and no I/O occurs. The threshold can be configured at compile-time using SQLITE_STMTJRNL_SPILL or at start-time using sqlite3_config(SQLITE_CONFIG_STMTJRNL_SPILL).
The query planner is able to optimize IN operators on virtual tables even if the xBestIndex method does not set the sqlite3_index_constraint_usage.omit flag of the virtual table column to the left of the IN operator.
The query planner now does a better job of optimizing virtual table accesses in a 3-way or higher join where constraints on the virtual table are split across two or more other tables of the join.
More efficient handling of application-defined SQL functions, especially in cases where the application defines hundreds or thousands of custom functions.
The query planner considers the LIMIT clause when estimating the cost of ORDER BY.
The configure script (on unix) automatically detects pread() and pwrite() and sets compile-time options to use those OS interfaces if they are available.
Reduce the amount of memory needed to hold the schema.
Other miscellaneous micro-optimizations for improved performance and reduced memory usage.

New Features:

Added the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to sqlite3_db_config() which allows the two-argument version of the fts3_tokenizer() SQL function to be enabled or disabled at run-time.
Added the sqlite3rbu_bp_progress() interface to the RBU extension.
The PRAGMA defer_foreign_keys=ON statement now also disables RESTRICT actions on foreign key.
Added the sqlite3_system_errno() interface.
Added the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS compile-time options. The SQLITE_DEFAULT_SYNCHRONOUS compile-time option replaces the SQLITE_EXTRA_DURABLE option, which is no longer supported.
Enhanced the ".stats" command in the command-line shell to show more information about I/O performance obtained from /proc, when available.

Bug fixes:

Make sure the sqlite3_set_auxdata() values from multiple triggers within a single statement do not interfere with one another. Ticket dc9b1c91.
Fix the code generator for expressions of the form "x IN (SELECT...)" where the SELECT statement on the RHS is a correlated subquery. Ticket 5e3c886796e5512e.
Fix a harmless TSAN warning associated with the sqlite3_db_readonly() interface.

[close]

https://www.sqlite.org/

[SiLæncer]

Changelog

MySQL: support of DELIMITER command
PostgreSQL: metadata reading fixed
Cassandra: functions and aggregates support added; date/time and UDT bindings fixed
Connections keep-alive support
Keywords case auto-convert
Source code paste conversion
SQL formatter: fixes and improvements
SQL formatter: external formatter support
SQL preferences redesigned
Many minor fixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

- The main program update ( the Main ):

Add: (Firebird) support query access plan display ( Display of Query Access Plan ) (5934)
Add: support auto reconnect feature ( the Automatic Reconnection ): in the absence of any change in the database under the rewiring process (5934)
Upd: simplify all [Preview] editor, copy the contents of the processing: When [None selected] replicate content clicks, you can copy the entire contents to the clipboard omitted Select Processing (5934)
Upd: Perfection cancel the execution of the command ( the Cancel Executing Command ) many issues related to the processing (5934)
Fix: (PostgreSQL) instruction code generation (SCRIPT AS -> SELECT): No amendment FUNCTION parameter values ​​script generation problems (5934)
Upd: Cumulative contain other minor updates, fixes and optimization (5934)
- Query Design Tools ( Query Builder )
Add: increase SQL syntax verification (Verify SQL) (5934)
Add: increase (right outer | left outer | full outer) join link arrow shows the direction (5934)
Upd: Selected query criteria to the query generator ( the Selected to the Text Query Builder ): Improved JOIN case distinct problem (5934)
Fix: Fixed Using Quoted Identifiers have a problem with the main set of conflict (5934)

- Data Export ( the Data the Export ):

Add: Copy the selected row to the clipboard ( the Copy the Selected the Rows to a Clipboard : support for CSV / TSV / PSV / SQL format (5934)
Add: increase return results Export formats PSV (Pipe delimited) (* .psv ) to replace the original Text files (* .txt) format (5934)
Add: increase export Excel alternative manner, when the DataAccess not complete, automatically switch to Office API processing (5934)

- Row editing and browsing ( the Data Editor and Browser ):

Add: Browse row (Data Browser): new computing cell function is selected ( the Calculate the Selected Cells, : Shortcut Keys: the Alt + S) (5934)
Upd: Copy to clipboard (Copy to Clipboard) fixed Tab as the delimiter, convenient handling compatibility Excel (5934)

- Edit Index ( Index Designer ):

Upd: (Oracle) to increase the existing index browse original editorial content (with other databases) (5934)

- Data Definition Language ( the Data Definition! Language (the DDL) ):

Fix: (SQLCe) correction can not generate the Foreign Key field to the association that defines UNIQUE INDEX time (5934)

- Database Migration ( Database Migration ) (Pro):

Upd: optimizing data conversion processing speed (5934)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Changelog

# Changes

* Disable abbreviated keys for string sorting in non-C locales
- PostgreSQL 9.5 introduced logic for speeding up comparisons of string data types by using the standard C library function strxfrm() as a substitute for strcoll(). It now emerges that most versions of glibc (Linux's implementation of the C library) have buggy implementations of strxfrm() that, in some locales, can produce string comparison results that do not match strcoll(). Until this problem can be better characterized, disable the optimization in all non-C locales. (C locale is safe since it uses neither strcoll() nor strxfrm().) Unfortunately, this problem affects not only sorting but also entry ordering in B-tree indexes, which means that B-tree indexes on text, varchar, or char columns may now be corrupt if they sort according to an affected locale and were built or modified under PostgreSQL 9.5.0 or 9.5.1. Users should REINDEX indexes that might be affected. It is not possible at this time to give an exhaustive list of known-affected locales. C locale is known safe, and there is no evidence of trouble in English-based locales such as en_US, but some other popular locales such as de_DE are affected in most glibc versions.
* Maintain row-security status properly in cached plans
- In a session that performs queries as more than one role, the plan cache might incorrectly re-use a plan that was generated for another role ID, thus possibly applying the wrong set of policies when row-level security (RLS) is in use. (CVE-2016-2193)
* Add must-be-superuser checks to some new contrib/pageinspect functions
- Most functions in the pageinspect extension that inspect bytea values disallow calls by non-superusers, but brin_page_type() and brin_metapage_info() failed to do so. Passing contrived bytea values to them might crash the server or disclose a few bytes of server memory. Add the missing permissions checks to prevent misuse. (CVE-2016-3065)
* Fix incorrect handling of indexed ROW() comparisons
- Flaws in a minor optimization introduced in 9.5 caused incorrect results if the ROW() comparison matches the index ordering partially but not exactly (for example, differing column order, or the index contains both ASC and DESC columns). Pending a better solution, the optimization has been removed.
* Fix incorrect handling of NULL index entries in indexed ROW() comparisons
- An index search using a row comparison such as ROW(a, b) > ROW('x', 'y') would stop upon reaching a NULL entry in the b column, ignoring the fact that there might be non-NULL b values associated with later values of a.
* Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after
* Fix incorrect behavior when rechecking a just-modified row in a query that does SELECT FOR UPDATE/SHARE and contains some relations that need not be locked
- Rows from non-locked relations were incorrectly treated as containing all NULLs during the recheck, which could result in incorrectly deciding that the updated row no longer passes the WHERE condition, or in incorrectly outputting NULLs.
* Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names
* Fix nonsense result from two-argument form of jsonb_object() when called with empty arrays
* Fix misbehavior in jsonb_set() when converting a path array element into an integer for use as an array subscript
* Fix misformatting of negative time zone offsets by to_char()'s OF format code
* Fix possible incorrect logging of waits done by INSERT ... ON CONFLICT
- Log messages would sometimes claim that the wait was due to an exclusion constraint although no such constraint was responsible.
* Ignore recovery_min_apply_delay parameter until recovery has reached a consistent state
- Previously, standby servers would delay application of WAL records in response to recovery_min_apply_delay even while replaying the initial portion of WAL needed to make their database state valid. Since the standby is useless until it's reached a consistent database state, this was deemed unhelpful.
* Correctly handle cases where pg_subtrans is close to XID wraparound during server startup
* Fix assorted bugs in logical decoding (Andres Freund)
- Trouble cases included tuples larger than one page when replica identity is FULL, UPDATEs that change a primary key within a transaction large enough to be spooled to disk, incorrect reports of "subxact logged without previous toplevel record", and incorrect reporting of a transaction's commit time.
* Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery
* Fix memory leak in GIN index searches
* Fix corner-case crash due to trying to free localeconv() output strings more than once
* Fix parsing of affix files for ispell dictionaries
- The code could go wrong if the affix file contained any characters whose byte length changes during case-folding, for example I in Turkish UTF8 locales.
* Avoid use of sscanf() to parse ispell dictionary files
- This dodges a portability problem on FreeBSD-derived platforms (including OS X).
* Fix atomic-operations code used on PPC with IBM's xlc compiler
- This error led to rare failures of concurrent operations on that platform.
* Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013
- This is a workaround for a bug in Visual Studio 2013's runtime library, which Microsoft have stated they will not fix in that version.
* Fix psql's tab completion logic to handle multibyte characters properly
* Fix psql's tab completion for SECURITY LABEL
- Pressing TAB after SECURITY LABEL might cause a crash or offering of inappropriate keywords.
* Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line
- This eases testing of slower buildfarm members by allowing them to globally specify a longer-than-normal timeout for postmaster startup and shutdown.
* Fix incorrect test for Windows service status in pg_ctl
- The previous set of minor releases attempted to fix pg_ctl to properly determine whether to send log messages to Window's Event Log, but got the test backwards.
* Fix pgbench to correctly handle the combination of -C and -M prepared options
* In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory
- Blind application of the script in such cases would result in loss of the new data directory.
* In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays
* Make PL/Python cope with function names that aren't valid Python identifiers
* Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function
* Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl
* Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia

[close]

http://www.postgresql.org/

[SiLæncer]

ESEDatabaseView reads and displays the data stored inside Extensible Storage Engine (ESE) database (Also known as 'Jet Blue' or .edb file). It displays a list of all tables available in the opened database file, allows you to choose the desired table to view, and then when you choose a table, it displays all records found in the selected table.

ESEDatabaseView also allows you to easily choose one or more records, and then export them into comma-delimited/tab-delimited/html/xml file, or copy the records to the clipboard (Ctrl+C) and then paste them into Excel or other spreadsheet application.

License:    Freeware

Whats new: >>

You can now choose the desired encoding (ANSI, UTF-8, UTF-16) to save the csv/xml/text/html files (under the Options menu).

http://www.nirsoft.net/utils/ese_database_view.html

[SiLæncer]

Whats new:>>

Fix a boundary condition error introduced by version 3.12.0 that can result in a crash during heavy SAVEPOINT usage. Ticket 7f7f8026eda38.
Fix views so that they inherit column datatypes from the table that they are defined against, when possible.
Fix the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN.

https://www.sqlite.org/

[SiLæncer]

Whats new: >>

Minor changes in export to PostgreSQL.
Minor bug fixes.

http://www.vlsoftware.net/

[SiLæncer]

Changelog

MySQL: database export wizard improved (+ DEFINER remove feature)
Oracle: metadata read performance improved
PostgreSQL: metadata read fixed for version before 9.x
PostgreSQL: temp/toast schemas access added
MongoDB: document update/delete fixed
SQLite: datetime columns read/update fixed
GemfireXD: driver updated
SQL keywords were updated
Misc UI bugfixes

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Release Notes

# Bugs Fixed
* InnoDB; Partitioning: When OPTIMIZE TABLE rebuilt a partitioned InnoDB table, it placed the resulting partition tablespace files (*.ibd files) in the default data directory instead of the directory specified using the DATA DIRECTORY option.
* InnoDB: Running REPLACE operations on multiple connections resulted in a hang.
* InnoDB: MySQL stalled when syncing the InnoDB full-text index cache.
* InnoDB: A CREATE TABLE ... DATA DIRECTORY operation failed to create a table while innodb_flush_method was set to O_DIRECT.
* InnoDB: The innodb_open_files setting could exceed the open files limit.
* Replication: Issuing STOP SLAVE caused a spurious Error reading packet from server: Lost connection to MySQL server during query message to be written to the error log. With this fix, when connection to the master is lost, the abort_slave flag is checked and the error message is printed only if the flag is not set.
* Replication: In Slave_worker::write_info(), DBUG_ENTER() had “Master_info::write_info” as its argument instead of “Slave_worker::write_info”. This fix corrects the argument. Thanks to Stewart Smith for the patch.
* Replication: When a multi-threaded slave stopped with an error, the same error message was printed three times. Now, the SQL thread's kill acceptance status is saved, and only printed once.
* Replication: mysqlbinlog --verbose displayed BINARY and VARBINARY data as ordinary strings, causing any single quote (“'”) or backslash (“\”) among the data to be printed as such, which was confusing to the users and, in the case of a backslash, caused the next character to be skipped. This fix makes mysqlbinlog print the characters' hexadecimal values (“\x27” for single quote and “\x5c” for backslash) instead.
* Replication: The test case main.merge failed when the variables binlog_format was set to “ROW,” as the server tried to get information for table creation for a child table before it was opened. With this fix, the server skips getting information for the table in the situation.
* Replication: If a query on a master generated an error and partial results were written to the binary log, for example due to a DROP TABLE IF EXISTS statement applying to multiple tables that would break foreign key constraints, when a slave configured with replication filters encountered the query it could be incorrectly binary logged. This caused errors such as:
* Last_SQL_Error: Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */'
* There were two fixes required for this bug.
- If a DROP TABLE statement used to drop a single table fails, to avoid partial results causing this bug the query is not written to the binary log. If a DROP TABLE statement used to drop a list of tables fails, any partial results it generates are written to the binary log with an error.
- When a query that generates an error as expected was received by a slave but it was skipped due to replication filters, the slave was incorrectly checking the error. The fix ensures that this comparison of the expected error from the master with the actual error from the slave does not happen.
* Integer overflow could occur during client handshake processing, leading to a server exit.
* The System-V initialization script for RHEL6 or older failed to enable the mysqld service by default.
* When ExtractValue() found no match for the supplied expression, it returned NULL instead of an empty string as expected.
* This issue affected MySQL 5.6.28 and 5.6.29 only.
* Improper host name checking in X509 certificates could permit man-in-the-middle attacks.
* A boolean mode full-text search caused a segmentation fault.
* Concurrent selecting and flushing of a FEDERATED table while killing connections accessing it could result in a server exit.
* Executing GRANT PROXY statements after altering the definition of the mysql.user system table could result in a server exit.
* Certain error messages included part of the SQL statement that produced them, possibly exposing data.
* The Performance Schema assumed that tables named using a #sql prefix were temporary and could be ignored. But it is possible to create nontemporary tables using that prefix. The Performance Schema now uses table attributes other than the name to identify temporary tables.
* Character set conversion operations on NULL parameters to prepared statements could cause a server exit.
* Loose Index Scan was not chosen for queries that had an equality condition.
* A MySQL 5.6 server exited during startup if used with a 5.7 data directory due to the change in 5.7 of the mysql.plugin table from MyISAM to InnoDB. A safe shutdown now occurs in this circumstance.
* For INSERT and UPDATE operations that caused FOREIGN KEY constraint violations, errors were reported rather than warnings when the IGNORE keyword was used.
* For some queries, an Index Merge access plan was chosen over a range scan when the cost for the range scan was the same or less.
* Certain queries could raise an assertion when a internal string operation produced a NULL pointer rather than an empty string.
* EXPLAIN for SELECT ... FOR UPDATE statements acquired locks.
* Processlist state information was not updated correctly for LOAD DATA INFILE and could show a state different from executing.

[close]

http://www.mysql.com/

[SiLæncer]

Changelog

PostgreSQL: table data update fix (CRITICAL)
PostgreSQL: metadata read fix
MySQL: database export fix
Oracle: custom PLAN table creation
Windows installer now shipped with JRE 1.8

[close]

http://dbeaver.jkiss.org/

[SiLæncer]

Changelog

The main program update ( the Main ):

Add: Cancel execution command ( the Cancel Executing Command ): increase the batch command GO interrupt handling (5952)
Upd: increase GO batch command displays the progress of the implementation of SQL (5952)
Fix: fix the problem after the batch command GO, progress in the display to cancel the execution process (Cancel executing process) button is no longer displayed in the execution End (5952)
Upd: Tree Connection list (Connection List): Integration original [Menu] (Pinned / Unpinned) function on the list (5952)
Add: (SQLite) support Indexes On Expressions Expressions Index Processing (Effect contains multiple main functions) (5952)
Add: (SQLite) support REFERENCES TABLE only Cankaoziliao table no specified field processing (influence contains multiple main functions) (5952)
Upd: (MySQL> 5.0.2) When the database connection SQL MODE setting if it is loose ANSI mode, will automatically set STRICT_TRANS_TABLES strict mode (5952)
Upd: (Firebird) query access plan display ( Display of Query Access Plan ): increasing the execution time display (5952)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.100.0 (3.12.1) (2016/04/15) (5952)
Upd: HP Vertica element updated to Vertica.Data.dll 7.2.2 (2016/03/30) (5952)
Upd: Cumulative contain other minor updates, fixes and optimization (5952)
Misc: the with Compatible the SQL Server 2016 RC3 (2016/04/15)
Misc: the with Compatible the MySQL 5.7.12 (2016/04/11) / the MySQL 5.6.30 (2016/04/11) / the MySQL 5.5.49 (2016/04/11)

Dynamic variable value input ( the Specifying the Variables Dynamic ):

Upd: supports specifying NULL handling, support the removal of key handling (5952)
Upd: Remove unnecessary testing key handling (5952)

SQL editor ( the SQL Editor ):

Upd: Improved detection of file changes when the outside environment (Detect when file is changed outside the environment): If there is no movement in the current content, not ask directly update (5952)

Database Migration ( Database Migration ) (Pro):

Upd: the same index name is automatically renamed Processing (5952)

[close]

http://fishcodelib.com/Database.htm