Thema: Datenbanksoftware und Tools diverses ...

[SiLæncer]

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface. Includes:

    MySQL Server user management
    Database management (modify databases, tables, fields, indexes)
    Data browsing and modification (including search filters, blob editing)
    MySQL session management (can kill queries)
    SQL query execution, including SQL batch scripting (and MySQL function list)
    Import/export of data

Functional in Linux via WINE.

License: GPL

What's new: >>

see http://www.heidisql.com/forum.php?t=14319#p14407
or http://code.google.com/p/heidisql/source/list

http://www.heidisql.com/

[SiLæncer]

Database .NET is a simple, uniform and intuitive database management tool for multiple databases. It makes Local and Remote database administration easier without installing anything. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries.

An innovative, powerful and intuitive multiple database management tool, based on .NET Framework 4.0.

Freeware

Whats new: >>

Release Notes

SQL editor ( SQL Editor ):

Fix: Correction (5273) when the window is minimized and then restored, the information display area is displayed automatically scaled to minimize the cause of the problem (*) (5290)

The main program update ( Main ):

Upd: (SQL Server / SQLAzure / SQLCe / MySQL) implementation plan ( Execution Plan ): The main attribute changed to strip out the colorful display makes browsing more intuitive clear (5290)
Fix: (MySQL) implementation plan ( Execution Plan ): Correction JSON Array (> = 5.6) analytical processing (5290)
Upd: (SQLite) component version updated to System.Data.SQLite.dll 1.0.93.0 (3.8.5) (2014/06/23) (5290)
Upd: other contains the cumulative minor updates, fixes and optimization (5290)

Table Editor ( Table Designer ):

Upd: (PostgreSQL / Informix) table field type display case consistency (including script generation and fields displayed) (5287/5290)
Upd: (DB2) Update Provider Data Types DBCLOB, VARCHAR () FOR BIT DATA, VARGRAPHIC default field length (5290)
Fix: (DB2) Correction CHAR () FOR BIT DATA, VARCHAR () FOR BIT DATA length generation method (including script generation and fields displayed) (5290)
Upd: (Informix) Remove Provider invalid data type display list, multiset, row, set (5290)
Upd: (Informix) Update Provider Data Types lvarchar default field length (5290)
Fix: (Informix) Correction Provider Data Types INTERVAL -> interval year to month (including script generation and fields displayed) (5290)
Upd: Remove the database type float length of the display (including script generation and fields displayed) (5290)

Row editing and browsing ( Data Editor and Browser ):

Fix: Automatic filtering ( AutoFilter ): solve SQLAzure / SQLServer / SQLCe / Sybase environment under Win 8 types of text fields can not filter problems (5287)
Fix: fix batch SQL command processing: For data visualization ( Data Visualization ) and separated mode ( mode Splitter issues related treatment) (5287)
Issue (5287) (OData) Correction (5282) may lead to non-text field to Null data type and can not handle: Fix

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

- bug #4467 shell_exec() has been disabled for security reasons
- bug #4470 Error while submitting empty query
- bug #4463 Fatal error: Class 'PMA_DatabaseInterface' not found
- bug #4469 Fixed cookie based login for installations without mcrypt
- bug #4473 incorrect result count when having clause is used

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

- Object Browser ( Object Navigator ):
 Add: Table menu to increase import and export data processing ( Data Import and Data Export ): direct inward remittance processing, no Open Table (5301)
- SQL editor ( SQL Editor ):
 Add: Added custom batch SQL statement delimiter ( Custom delimiter  ) (Supports all database systems) (5301)
 Add: Added auto completion of braces ( Options -> Automatic Brace completion : () [] {} ""'' `` / ** /) (5301)
 Add: add a new row is inserted (Inserting a new line) function and shortcut keys (Shortcut Keys):
 Open the bottom line (Line Open Below: Ctrl + Shift + Enter), open the top of the line (Line Open Above: Ctrl + Enter) (5301)
- Auto-sensing processing ( AutoComplete * ):
 Upd: revise and improve the Insert Object quoted identifiers (Quoted Identifiers) before and after the identification process, including automatic shut down and avoid duplication insertion ... and other issues (5301)
 Upd: Updated Schemaname and Nickname object name length limit of 10 -> 20 (no perceptual processing beyond) (5301)
- Row editor ( Data Editor ):
 Upd: data import processing ( Data Import ): Various improvements and increase import processing speed (5301)
 Upd: Improved Identity Column and Default Columns and other issues not included in quoted identifiers (Quoted Identifiers) when new data columns (5301)
- The main program update ( Main ):
 Add: Added panes ( Switching Panes ) function and shortcut keys (Shortcut Keys):
 The next pane (Next Pane: F6), on a pane (Previous Pane: Shift + F6), the results pane (Results Pane: Ctrl + R) (5301)
 Add: Add a label switching ( Switching Tabs ) switching shortcuts (Shortcut Keys):
 The next tab (Next Tab: Ctrl + Tab), a tab (Previous Tab: Ctrl + Shift + Tab) (5301)
 Add: Connection Manager ( Connection Manager / snippet Management ( Code Snippets Manager ): increase in the taskbar (Toolbar) treatment (5301)
 Upd: other contains the cumulative minor updates, fixes and optimization (5301)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

ClipTable lets you copy any desired data directly from your clipboard into an SQL Server table. You can easily get data from any sources, including: HTML Tables, Word, Excel, Text, PDF and many more.

Requirements: .NET Framework 4

Freeware

Latest Changes

- ClipTable is no longer in "beta". This is now a fully-functional trial version (until registered)
- Fixed Windows 8.1 compatibility
- Fixed Setup "cannot downgrade" message
- x64 version embedded (so, no more different downloads, one will run on both x86 and x64)
- File Drag&Drop support (drag your txt/csv/xml files into the import window)
- Analysis Re-Apply is about x60 times faster
- Added support for /ImportClipboard argument (internal yet public)
- Repository enhancements
- Rebuilt using new engine
- Multiple Repository enhancements, including nested groups, DL tools integration and more
- LocalDb support
- Amazon RedShift support (through PostgreSQL driver)

http://www.doccolabs.com/

[SiLæncer]

Release Notes

- The main program update ( Main ):
 Upd: rewrite transaction mode processing ( Transaction Mode ): no longer limiting access to transaction mode is enabled, the non-operating fully with the trading patterns (5308)
 Add: (Oracle) supports browsing [all] database schema ( Browsing all Databases ) (5308)
 Supports browsing [specify / all] database schema, including: SQL Server / MySQL / Teradata / Oracle
 Upd: Updated execute SQL script file ( Execute an SQL script File ): adding custom variables function (: servar), custom delimiters (DELIMITER) ... and other analytical processing (5308)
 Fix: Correction (5290) is not supported by Informix Provider (CreateFormat), cause problems when connecting exception loading (5308)
 Fix: Fixes and improvements in the non-FoxPro database query exceptions "File is in use." Related processing (5308)
 Upd: Updated Slovenian interface language Slovenian language (by Jadran Rudec) (5308)
 Upd: Updated Italian interface language Italian language (by Paolo Saudin) (5308)
 Upd: other contains the cumulative minor updates, fixes and optimization (5308)
- SQL editor ( SQL Editor ):
 Add: Support for SQL command mode to switch the current database or schema location ( or SQL to Change Database Schema  ) (5308)
 Upd: optimization automatically braces complete processing ( Options -> Automatic Brace completion : () [] {} ""'' `` / ** /): after more intelligently handle correspondence problem, reduce duplication of processing (5308)
 Upd: solve different database support for single-line comments differences, avoid misuse and not run as "- comment", "- comment", the users themselves without any modification (5308).
 Upd: When updating starts to open the final check labels ( Options-> Open Last Query tabs on startup ): When you open content from the specified file and when movement remains open to the next transaction state (5308)
 Add: increase Shortcuts: Comments (Comment: Ctrl + Shift + C), uncomment (Uncomment: Ctrl + Shift + U) (5308)
- Object Browser ( Object Navigator ):
 Add: With the Object Browser automatically switch the current schema (SCHEMA), you can specify where the object is located omitted when dealing with SCHEMA next time (support included NuoDB/DB2/PostgreSQL/Oracle/MySQL (All)) (5308)
 Upd: (Oracle) User-Defined Data Types change take user_types objects (5308)
- Row editor ( Data Editor ):
 Fix: Data table's primary key selector ( PrimaryKey Selector ): Correction table names with the exception of characters, you can not turn the issue (5308)
- Auto-sensing processing ( AutoComplete * ):
 Add: Support WITH common_table_expression field IntelliSense treatment (5308)
 Add: Built-in Functions added automatically and highlighted treatment (5308)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

- bug #4471 Undefined index warning with referenced column.
- bug #4027 $cfg['MaxExactCount'] is ignored when BROWSING is back
- bug #4482 Multi Column sorting (improved user experience)
- bug #4478 Server validation does not work while in setup/mysqli
- bug       Undefined variable when grid editing a foreign key column
- bug #4481 mult_submits.inc.php Undefined variable Error
- bug #4485 Sorting breaks the copy column feature
- bug #4440 Javascript error when renaming table
- bug #4483 'New window' link (selflink) disappears, causing Javascript error
- bug #4489 Incorrect detection of privileges for routine creation
- bug #4459 First few characters of database name aren't clickable when expanded
- bug #4486 [security] XSS injection due to unescaped table comment
- bug #4488 [security] XSS injection due to unescaped table name (triggers)
- bug #4492 [security] XSS in AJAX confirmation messages
- bug #4491 [security] Missing validation for accessing User groups feature

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

- SQL editor ( SQL Editor ):
 Upd: Improved execution of the current statement (Execute current statement: Ctrl + Enter) approach, the cursor position in the semicolon ( is still processing the current location after SQL commands instead of the next column (5315)
 Add: Added shortcut keys to display the results grid (Results to Grid): Ctrl + 1, text displays the results (Results to Text): Ctrl + 2, the results archive (Results to File): Ctrl + 3 (5315)
 Fix: Modify the shortcut key to open the top line (Line Open Above: change Ctrl + +), the original execution of the current statement (Execute current statement): unchanged Ctrl + Enter (5315)
- Code management ( Code Manager ):
 Add: When you open a file to via SQL editor, add the icon to display the label display for easy distinction (5315)
 Fix: Remove the SQL file correction function useless questions (5315)
 Fix: fix open to the SQL editor to delete the file when re-saving labels, title status updates are not synchronized problem (5315)
- Auto-sensing ( AutoComplete * ):
 Fix: Correction automatically associated perception process before and after the main table and the referenced table field order may lead to misplaced questions (5315)
- Table Editor ( Table Designer ):
 Fix: Under the new amendments to the table mode, unable to cope with the increased portion of the database field annotations (Column comments) problems (5315)
- Row editing and browsing ( Data Editor and Browser ):
 Upd: text displays the results ( Results to Text ): browsing with no wrap (No Wrap) display (5315)
 Fix: fix automatic scaling fields and rows content, or in the first tab does not automatically scale problems (5315)
- Script generation ( Data Definition Language ):
 Add: increase the Teradata database object scripts generated annotation information (Table / Column / Trigger / View / Macro / Procedure / Function comments) (5315)
- SQL History ( SQL History ):
 Upd: changed to a non-exclusive display for easy interaction with the main window handle (5315)
- The list of processes ( Process List ):
 Upd: Updated Oracle process list displays content, including all Schemas view and add more fields Message (5315)
- The main program update ( Main ):
 Upd: optimization (SQL History / SQL Profiler) built-in SQL formatting (5315)
 Upd: (MySQL) component version updated to MySql.Data.dll 6.9.2 (2014/07/18) (5315)
 Upd: other contains the cumulative minor updates, fixes and optimization (5315)
 Misc: Compatible with Firebird 2.5.3 (2014/07/17) / Firebird 2.1.6 (2014/06/23)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

Firebird is a fully featured and powerful RDBMS. It can handle databases from just a few KB to many Gigabytes with good performance and almost free of maintenance!

License: Open Source

Whats new: >>

Code: [Auswählen]


* New context variables have been added to the SYSTEM namespace to retrieve more information about the current connection and current transaction. The added variables: SYSTEM::CLIENT_PID and SYSTEM::CLIENT_PROCESS for the current connection, SYSTEM::LOCK_TIMEOUT and SYSTEM::READ_ONLY for the current transaction.
* Some limits have increased:
- The maximum number of connections on Windows for Superserver and Superclassic has been raised from 1024 to 2048 connections.
- The maximum number of input parameters for external functions (UDFs) has increased to 15.
* Error reporting improvements, including:
- More details are now reported for “object in use” errors.
- The relation name is now added to the text of validation constraint error messages, to help identify the error context.
- Error reporting for index and constraint violations has been extended to include the problematic key value.
* Physical backup (using ALTER DATABASE BEGIN/END BACKUP or the nBackup utility) was improved to speed up extension of the main database file when backup state changes from stalled to merge.
- Contention for the allocation table lock while a database is in the stalled physical backup state has been reduced.
- Faster file growth has been enabled on Linux systems that support fallocate().
- Attachments no longer block others when the allocation table is being read for the first time.
* Execution of a SET STATISTICS INDEX statement no longer blocks or slows down concurrent attachments.
* The scan for limbo transactions at the end of a sweep has been improved.
* Support for the UPDATE OR INSERT statement and the RETURNING clause have been implemented for Embedded SQL (ESQL).


http://www.firebirdsql.org/

[SiLæncer]

Whats new: >>

Siehe hier : http://www.postgresql.org/docs/9.3/static/release-9-3-5.html

http://www.postgresql.org/

[SiLæncer]

Release Notes

Code management ( Code Manager ):
Add: Added SQL file version control features ( SQL File Version Control ) (5323)
The main program update ( Main ):
Add: (PostgreSQL) supported data types and related treatment established by the Extension, such as ( hStore / ghstore Data type (> = 9.1) ) (5323)
Add: (PostgreSQL) to increase support data types (Data Types): pg_lsn (> = 9.4) , smallserial (> = 9.2) , tsquery / tsvector / txid_snapshot (> = 8.4) related to treatment (5323)
Upd: (PostgreSQL) to update user-defined data types ( User-Defined Data Types (Domains) ): exclude basetype = 0 display (5323)
Upd: (PostgreSQL) update FUNCTIONS Object Browser grammar, provide a more complete object display (5323)
Upd: (Firebird) component version updated to FirebirdSql.Data.FirebirdClient.dll 4.5.0 ( ) (2014/07/29) (5323)
Upd: (PostgreSQL) component version updated to Npgsql.dll 2.2.0b1 (2014/07/21) (5323)
Fix: fix file locking problems lead to changes portability mode setting (5323)
Upd: other contains the cumulative minor updates, fixes and optimization (5323)
Misc: Compatible with PostgreSQL 9.3.5 / 9.2.9 / 9.1.14 / 9.0.18 / 8.4.22 (2014/07/24)
Row editing and browsing ( Data Editor and Browser ):
Add: browse mode ( Browsing Mode ): Add vertical view mode (Vertical Mode), currently supports paging / horizontal / vertical view, three modes (Paging / Horizontal / Vertical Mode) (5323)
Fix: Automatic filtering ( AutoFilter ): Fixed some differences in the object database Quoted Identifiers (Quoted Identifiers) does not work due cause problems (5323)
SQL editor ( SQL Editor ):
Add: drag and drop to rearrange tab order ( Drag and drop to Reorder tabs ) (5323)
Query Builder ( Query Builder * ):
Fix: Improved the selected query to the Query processing ( Selected Text to Query Builder ): Correction of the same name specified table alias (Alias) problems (5323)
Connection Settings ( Connection Profile )
Fix: Click on the drop-down database automatically corrected example (Browse for more ...) stalled issues (5323)
Script generation ( Data Definition Language ):
Fix: (PostgreSQL) amendment (5290) led to the unnecessary display serial data types defined default value (5323)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

* Functionality Added or Changed
- Replication: The new system variable binlog_impossible_mode controls what happens if the server cannot write to the binary log, for example, due to a file error. For backward compatibility, the default for binlog_impossible_mode is IGNORE_ERROR, meaning the server logs the error, halts logging, and continues updates to the database. Setting this variable to ABORT_SERVER makes the server halt logging and shut down if it cannot write to the binary log.
- CMake support was updated to handle CMake version 3.
- New Debian7, Ubuntu12.04, and Ubuntu14.04 distribution support that was introduced with 5.6.17 now comes with the platform-specific packaging source placed under the packaging directory, in the deb-precise, deb-wheezy, and deb-trusty directories.
- Support for LinuxThreads has been removed from the source code. LinuxThreads was superseded by NPTL in Linux 2.6.
- By default, mysql_install_db creates a my.cnf file in the installation base directory using a template. This may be undesireable for some deployments. To enable this behavior to be suppressed, mysql_install_db now supports a --keep-my-cnf option to preserve any existing my.cnf file and not create a new my.cnf file.
- The mysqlhotcopy utility is now deprecated and will be removed in a future version of MySQL. Among the reasons for this: It works only for the MyISAM and ARCHIVE storage engines; it works on Unix but not Windows. Alternatives include mysqldump and MySQL Enterprise Backup.
- The timed_mutexes system variable has no effect and is deprecated.
* Bugs Fixed
- Important Change; Replication: A DROP TABLE statement may be divided into multiple statements before it is sent to the binary log if it contains regular (not temporary) tables and temporary tables, or if it contains temporary tables using both transactional and non-transactional storage engines. Now, when using GTIDs, DROP TABLE statements affecting these combinations of tables are no longer allowed unless the value of the gtid_next system variable is AUTOMATIC. This is because, with GTIDs enabled on the server, issuing a DROP TABLE in the cases just described while having only one GTID associated with each statement (the SQL thread does this following SET gtid_next='uuid:number') causes problems when there are not enough GTIDs for assignment to all the resulting statements following the division of the original DROP TABLE. A DROP TABLE statement might be split due to the behavior of the statement with respect to the current transaction varying, depending on table characteristics, as follows:
> DROP TABLE of a regular (not temporary) table is committed immediately
> DROP TABLE of a temporary table using a transactional storage engine is committed with the current transaction (following COMMIT)
> DROP TABLE of a temporary table that uses a nontransactional storage engine is committed immediately
- InnoDB: Opening a parent table that has thousands of child tables could result in a long semaphore wait condition.
- InnoDB: For single item full-text searches, deleted documents were included in inverse document frequency (IDF) calculations.
- InnoDB: On mysqld start, specifying multiple data files using the innodb_data_file_path option would return a Space id in fsp header error after data is written to the second file.
- InnoDB: A DELETE operation on a table with full-text search indexes raised an assertion.
- InnoDB: When calling the memcached flush_all command, InnoDB attempts to initialize a connection and a transaction. If the transaction is in TRX_STATE_NOT_STARTED state, InnoDB would fail to set CONN_DATA->CRSR_TRX to NULL, resulting in a serious error.
- InnoDB: When InnoDB is built as a shared library, attempting to load the InnoDB full-text search (FTS) INFORMATION_SCHEMA plugin would fail with a Can't open shared library 'ha_innodb.so' error.
- InnoDB: A regression introduced in MySQL 5.6.5 would cause full-text search index tables to be created in the system tablespace (space 0) even though innodb_file_per_table was enabled.
- InnoDB: The InnoDB memcached plugin would call plugin_del without acquiring the lock_plugin mutex. This bug fix also addresses a race condition in ib_cursor_delete_row.
- InnoDB: The fix for Bug added superfluous buf_flush_list() logic to InnoDB startup code.
- InnoDB: A race condition in fts_get_next_doc_id resulted in Duplicate FTS_DOC_ID and Cannot find index FTS_DOC_ID_INDEX in InnoDB index translation table errors.
- InnoDB: Due to differences in memory ordering on different processor types, some mutex and read-write lock flags were not read consistently.
- Partitioning: Selecting from a table having multiple columns in its primary key and partitioned by LIST COLUMNS(R), where R was the last (rightmost) column listed in the primary key definition, returned an incorrect result.
- Replication: mysqlbinlog --raw did not check for errors caused by failed writes, which could result in silent corruption of binary logs. Now in such cases it stops with an error.
- Replication: When a slave worker thread tried to execute a statement that was too large, the resulting error caused a crash. Now in such cases, the error is truncated to fit the size of the buffer.
- Replication: When using row-based replication, updating or deleting a row on the master that did not exist on the slave led to failure of the slave when it tried to process the change. This problem occurred with InnoDB tables lacking a primary key.
- Replication: Quotation marks were not always handled correctly by LOAD DATA INFILE when written into the binary log.
- Replication: Beginning in MySQL 5.6.20, when a user specified AUTO_INCREMENT value falls outside of the range between the current AUTO_INCREMENT value and the sum of the current and number of rows affected values it is replicated correctly. In previous versions, an error was generated by the slave even if the user specified AUTO_INCREMENT value fell outside of the range.
- Replication: A group of threads involved in acquiring locks could deadlock when the following events occurred:
> Dump thread reconnects from slave; on master, a new dump thread tries to kill zombie dump threads; having acquired the thread's LOCK_thd_data, it is about to acquire LOCK_log.
> Application thread executing show binary logs, having acquired LOCK_log and about to acquire LOCK_index.
> Application thread executing PURGE BINARY LOGS; having acquired LOCK_index, it is about to acquire LOCK_thread_count.
> Application thread executing SHOW PROCESSLIST (or SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST), having acquired LOCK_thread_count and about to acquire the zombie dump thread's LOCK_thd_data.
- Replication: On Windows, mysqldump failed if the error log file was deleted (missing) from the active MySQL server.
- Replication: Client applications should be able to set the BINLOG_DUMP_NON_BLOCK flag in the initial handshake packet (COM_BINLOG_DUMP). Clients connecting to a server issuing a COM_BINLOG_DUMP with the flag unset do not get an EOF when the server has sent the last event in the binary log, which causes the connection to block. This flag, which was removed in error in MySQL 5.6.5, is now restored in the current release.
- As part of this fix, a new --connection-server-id option is added to mysqlbinlog. This option can be used by the client to test a MySQL server for the presence of this issue.
- When a SELECT included a derived table in a join in its FROM list and the SELECT list included COUNT(DISTINCT), the COUNT() returned 1 even if the underlying result set was empty.
- Enabling optimizer trace could cause a server exit for queries with a subquery in a HAVING clause.
- SHA and MD5 functions failed for operations using the internal filename character set and could cause a server exit.
- Large arguments passed to mysqldump could lead to buffer overflow and program exit.
- Compiler flags were not passed to DTrace, causing problems for 32-bit builds cross-compiled on 64-bit platforms.
- ALTER TABLE on a partitioned table could result in the wrong storage engine being written into the table's .frm file and displayed in SHOW CREATE TABLE.
- With the max_heap_table_size system variable set to a large value (20GB), creation of a temporary table or a table using the MEMORY storage engine caused a server exit.
- For debug builds, a 0x00 character in a full-text query string that used the ujis_japanese_ci, utf8mb4_turkish_ci, or eucjpms_bin collation could raise an assertion.
- mysqladmin password masked the old password given on the command line, but not the new password.
- yaSSL code had an off-by-one error in certificate decoding that could cause buffer overflow.
- yaSSL code had an opendir() without a corresponding closedir().
- For full-text queries on InnoDB tables, attempts to access deleted document IDs could lead to a server exit.
- MyISAM temporary files could be used to mount a code-execution attack.
- For queries that selected from the Performance Schema events_statements_current table, adding an ORDER BY clause could produce incorrect results.
- If a query had both MIN()/MAX() and aggregate_function(DISTINCT) (for example, SUM(DISTINCT)) and was executed using Loose Index Scan, the result values of MIN()/MAX() were set improperly.
- For UNION statements, the rows-examined value was calculated incorrectly. This was manifest as too-large values for the ROWS_EXAMINED column of Performance Schema statement tables (such as events_statements_current).
- Clients could determine based on connection error message content whether an account existed.
- An assertion could be raised when creating a index on a prefix of a TINYBLOB or GEOMETRY column in an InnoDB column.
- Use of a nonmultibyte algorithm for skipping leading spaces in multibyte strings could cause a server exit.
- For a view defined on a UNION, the server could create an invalid view definition.
- Configuring with cmake -DWITHOUT_SERVER to build clients without the server failed for builds outside of the source tree.
- With big_tables enabled, queries that used COUNT(DISTINCT) on a simple join with a constant equality condition on a non-duplicate key returned incorrect results.
- Deadlock could occur if three threads simultaneously performed INSTALL PLUGIN, SHOW VARIABLES, and mysql_change_user().
- mysql_config_editor exited when given an empty argument to the --login-path option.
- MySQL did not compile with Bison 3. A workaround is to downgrade to Bison 2.
- Uninstalling and reinstalling semisynchronous replication plugins while semisynchronous replication was active caused replication failures. The plugins now check whether they can be uninstalled and produce an error if semisynchronous replication is active. To uninstall the master-side plugin, there must be no semisynchronous slaves. To uninstall the slave-side plugin, there must be no semisynchronous I/O threads running.
- If there was a predicate on a column referenced by MIN() or MAX() and that predicate was not present in all the disjunctions on key parts earlier in the compound index, Loose Index Scan returned an incorrect result.
- Client auto-reconnect did not work for clients linked against libmysqlclient, even with MYSQL_OPT_RECONNECT enabled.
- Upgrades using RPM packages could change the ownership of an installation directory.
- Proxy users were unable to execute statements if the proxied user password had expired.
- A new CMake option, SUNPRO_CXX_LIBRARY, enables linking against libCstd instead of stlport4 on Solaris 10 or later. This works only for client code because the server depends on C++98. Example usage: cmake -DWITHOUT_SERVER=1 -DSUNPRO_CXX_LIBRARY=Cstd
- File permissions and line endings of several test and configuration files were made more consistent to avoid warnings from package checkers.

[close]

http://www.mysql.com/

[SiLæncer]

Whats new: >>

- bug       Broken links on home page
- bug #4494 Overlap in navigation panel
- bug #4427 Action icons not in horizontal order
- bug #4493 s_attention.png is missing
- bug #4499 Uncaught TypeError: Cannot call method 'substr' of undefined
- bug #4498 PMA 4.2.x and HHVM
- bug #4500 mysql_doc_template is not defined

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

- Connection Settings ( Connection Profile )
 Add: Support the connection after the specified code function ( Execute scripts when Connected ) (5329):
 Support includes SQL Server / SQL Azure / Oracle / IBM DB2/Informix/MySQL/PostgreSQL/Sybase ASE / Teradata / NuoDB database, etc.
 Add: Support loading [specify multiple] database functionality ( Specifying Multiple Databases ): Support includes MySQL / SQL Server / Teradata / Oracle and other databases (5329)
- Object Browser ( Object Navigator ):
 Upd: (SQL Server) with the login user account permissions, lists only valid database (5329)
- Row editing and browsing ( Data Editor and Browser ):
 Add: Support hexadecimal string data display ( Displaying Hexadecimal String ) (including information content export process) (5329)
 Fix: Correction (DB2/NuoDB) row editing, the conditions filtering ( Filter Expression ) no effect problems (5329)
- SQL editor ( SQL Editor ):
 Add: Added Decrease Indent and Increase Indent function ( Decrease Indent and Increase Indent ) (5329)
- Code management ( Code Manager ):
 Upd: control file version of SQL ( SQL File Version Control ): Improved Checkout treatment: When the directory where the file does not exist with the completion of the auto-refresh problems (5329)
 Fix: Fix the query tags do not exist, a problem with the right menu to save exceptions (5329)
 Fix: After the fix file delete, edit tags can not resave already open question (5329)
 Upd: Improved When you delete the directory, the directory under the original open files cleared associated state (5329)
 Upd: If the current without any labels or tags for editing, searching or existing file, the new label will also add a file (5329)
- Script generation ( Data Definition Language ):
 Upd: (PostgreSQL) user-defined data types script generation ( User-Defined Data Types (Domains) ):
 1 Increase NULL / NOT NULL display, 2. Bug fixes <9.1 version can not handle (5329)
- The main program update ( Main ):
 Add: control focus highlight treated to a more intuitive way to display the location of the current focus (5329)
 Fix: Bug fixes some features not in the vertical (Portrait Orientation) normal screen display (5329)
 Fix: Correction (5308) led to a table editing and searching, the problem of intelligent menu to switch the state of the database can not be updated (5329)
 Upd: other contains the cumulative minor updates, fixes and optimization (5329)
 Misc: Compatible with MySQL 5.6.20 (2014/07/31) / MySQL 5.5.38 (2014/05/30)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

RecordEditor is a datafile editor, similar to File-Aid or Net-Cobols Cobol-Editor. It uses a record layout to format the data in the file in to a human readable format. Because it knows the format of fields, it can format binary fields as normal numbers rather than displaying hex equivalent as most hex editors do. The file can be editted in a table (spreadsheet-like format) or in a single record format with fields going down the page.

Freeware

Release Notes

- New Text view where fields are highlighted
- Allow block cell selections and added block cell coping/pasteing
- Major changes to Installers - Better Windows UAC handling, can install in Windows"User" account, Better handling of multiple user's on PC
- Can specify Charset on Csv and Fixed width export
- New Csv compare function
- Added file charset detection for Ebcdic files
- Added Edit-Layout button to tool bar
- Key assignment changes, Record-Copy Record-Cut, Record-Paste, Record-Insert and Record-Delete are now assigned to keys Alt-C, Alt-X, Alt-V, Alt-Insert and Alt-Delete. Control-C and Control-V are now for cell copying and pasting
- Automatic backup of File Layouts (Schema's) as Xml files (to directory <RecordEditorUserDirectory>Copybook/SchemaBu)
- Fixed problem in copying to Ebcdic Files (that use a new-line character) on Windows machines
- Fix problem new Xml export function
- Fix System and record-seperator problems in Xml export

[close]

http://record-editor.sourceforge.net/