Thema: Datenbanksoftware und Tools diverses ...

[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

Release Notes

- Row editing and browsing ( Data Editor and Browser ):
 Upd: optimization of long data content display processing: significantly improve the display speed while avoiding lead A generic error occurred in GDI + exception occurred (5336)
 Upd: hexadecimal string data display ( Displaying Hexadecimal String ): 1. significantly improve processing speed, (2) support greater length setting (0 ~ 2147483647, default: 30000) (5336)
- Instruction code generation ( Data Definition Language ):
 Add: Update SCRIPT AS -> Data (INSERTs) instruction code generation support hexadecimal string data output, support for database contains: (5336)
 (0x) SQL Server / SQL Azure / SQLCe / Access / Sybase ASE / NuoDB,
 (X '') SQLite / Firebird / MySQL, ('') Oracle, ('' xb) Teradata, (blob (X '')) DB2, (decode ('', 'hex')) PostgreSQL
 Fix: Correction (Access) tables IDENTITY (seed_value, increment_value) attribute generation: seed_value initial fixed at 1 (5336)
- SQL editor ( SQL Editor ):
 Upd: optimization automatically complete braces treatment ( Options -> Automatic brace Completion ): increase the right of the first character recognition processing, reducing unnecessary auto-complete (5336)
 Fix: Correction window and then maximize the reduction, if the original data when the display area is hidden when not properly scaled reopen cause problems (5336)
- SQL efficacy Analyzer ( SQL Profiler * )
 Upd: (SQL Server) converts Duration field unit display (microseconds-> millseconds with SQL Server Profiler) (5336)
- Data Import ( Data Import ):
 Upd: significantly improved loading speed while avoiding larger amounts of imported produce enough memory problems (5336)
- Data Export ( Data Export ):
 Upd: Improved Excel export process, to avoid the type of text field type of digital information in a digital way to store (5336)
- Code Management ( Code Manager ):
 Upd: control file version of SQL ( SQL File Version Control ): Improved exception handling issues (5336)
- Object Browser ( Object Navigator ):
 Fix: Correction (Teradata) data table belongs trigger (TRIGGERS) display is not completely correct the problem (5336)
- Master Program update ( Main ):
 Upd: (PostgreSQL) component version update to Npgsql.dll 2.2.0rc1 (2014/08/06) (5336)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5336)
 Upd: Update Database .NET Additional Files (  ) (2014/08/08)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

- Object Browser ( Object Navigator ):
 Add: Added advanced editing options ( [ADV] Advanced Edit Otions ): Support field specified column sorting, filtering conditions before <n> a row ... and other advanced editing options set (5343)
 Upd: simplify opening and editing tables feature items ( Open and Edit Table Data ): original [before <n> Rows] functions merged into subprojects [TOP] (5343)
 Add: [specify / multiple choice / all] database browsing mode ( Database browsing Modes ), support for more database contains: SQL Server / MySQL / Teradata / Oracle / SybaseASE (5343)
 Add: [excluded] Schema Browser treatment ( Excluded Schemas ), support for database contains: DB2 / Informix / PostgreSQL / NuoDB (5343)
 Upd: load [specify multiple] database functions ( Specifying Multiple Databases ): Specifies the name of the support case-insensitive treatment (5343)
 Fix: Fixed issue TRIGGERS object failed to show a table under the 2000 SQL Server (5343)
- Instruction code generation ( Data Definition Language ):
 Add: Support (SQL Server / SQL Azure) table computed column definition generates display ( Computed Column Definition ) (5343)
- Row editing and browsing ( Data Editor and Browser ):
 Upd: improvements and amendments (5336) redraw problems when dragging the horizontal scroll bar and Edit mode (bit) field type exception handling (5343)
 Upd: Data Grid browser (Cell Viewer): 1. automatic zooming according to browse the contents of the open window size, 2 to increase the content length window title display, 3 support BLOB browsing (5343)
- SQL editor ( SQL Editor ):
 Upd: optimization automatically complete braces treatment ( Options -> Automatic brace Completion ): significantly improve reaction speed and reduce unnecessary auto-complete processing (5343)
 Fix: Fixed an Fields perception ( IntelliSense * exception handling) source data table does not exist, while increasing processing speed ()
- Data Import ( Data Import ):
 Upd: shift to transaction-mode processing (Transaction Mode), significantly enhance the bulk [Import] processing speed while reducing support after the failure of treatment (5343)
- Master Program update ( Main ):
 Upd: Connection settings ( Connection Profile ): Cancel delimiter ( character as a password input limit (5343)
 Upd: Improved NuoDB database exception message processing (5343)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5343)

[close]

http://fishcodelib.com/Database.htm

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

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite 3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze and manipulate SQLite databases.

License:    Freeware for personal and educational use.

Whats new: >>

Update built-in DISQLite3 engine to SQLite 3.8.6.
Attached database: Double clicking a table node did not work. Fixed.
New MediaMonkey.dll extension which adds the IUNICODE collation sequence needed to open MediaMonkey databases.

http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index

[SiLæncer]

Release Notes

Ver 12.7 (2014/09/01) Stable Version
 - Master Program update ( Main ):
 Add: Support to restore database objects final location after the program starts (Restore last object location) (5357)
 Upd: Connection Manager ( Connection Manager ): Connection settings option supports all servo databases (5357)
 Upd: updating the database name length restrictions renamed (30 -> 100) (5357)
 Upd: open to a password-protected database files, increasing the illustration shows (5357) on the title
 Fix: After (SQL Server) error correction perform any SQL statement, then switch directly database may cause problems anomaly (5357)
 Upd: (IBM DB2 / Informix) component version update to IBM.Data.DB2.dll 9.7.4.4 (10.5.4.4) (2014/08/29) (5357)
 Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 4 (2014/08/29)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5357)
 - Data Table Editor ( Table Designer ):
 Add: Added field properties set ( Column Properties ) (5357)
 - Database Diagram ( Database Diagram * ):
 Upd: to follow the view of content generated automatically zoom display window size (5357)
  Might not work to open the browser issues (5357) Fixed display long table object: Fix
 - Auto-sensing ( AutoComplete * ):
 Add: When inserting SELECT / UPDATE / DELETE / INSERT automatically senses the built-in template table (table_name) (5357)
 Add: increase UPDATE <tab> SET <col> WHERE <col> tables and fields perception (5357)
 Upd: object properties sorted by display automatically senses table with a view (TABLES-> VIEWS) (5357)
 Upd: optimization of the presence or absence of the table detection methods to improve data processing speed table field sensing (5357)
 Upd: Improved data tables with Table Hints fields perception processing (5357)
 - Row Editing ( Data Editor ):
 Upd: Support delete Cell of NULL into an empty (Empty) treatment (5357)
 Upd: Data Grid Edit ( Cell Editor * ): Support hexadecimal string data display ( Displaying Hexadecimal String ) (5357)
 Fix: Form Editor ( Form Editor * ): Correction (5329) lead to the update row containing BLOB fields (5357)
 - Instruction code generation ( Data Definition Language ):
 Fix: Problem (SQLCe) correction IDENTITY (seed_value, increment_value) if increment_value non-default when acquired (including table editing and editing rows) (5357)
 - Database Object Search ( Search Objects ):
 Fix: Correction OData can not double-click on the search list view objects issues (5357)
 Upd: to enhance the database object search speed (5357)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>


- bug #4516 Odd export behavior
- bug #4519 Uncaught TypeError: Cannot read property 'success' of null
- bug #4520 sql.js: cannot read property
- bug #4521 Initially allowed chart types do not match selected data
- bug #4518 Export to SQL: CREATE TABLE option AUTO_INCREMENT ignored
- bug #4522 Duplicate column names while assigning index
- bug #4487 Export of partitioned table does not import
- bug server_privileges.js: cannot read property
- bug #4527 Importing ODS files with column names having trailing spaces fails
- bug #4413 Navigation Error in Nav Tree for Search Results Past the First Page
- bug functions.js: Cannot read property 'replace' of undefined

Download : Klick

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

Master Program update ( Main ):
Add: Support to restore database objects final location after the program starts (Restore last object location)
Upd: Connection Manager ( Connection Manager ): Connection settings option supports all servo databases
Upd: updating the database name length restrictions renamed (30 -> 100)
Upd: open to a password-protected database files, increasing the illustration shows on the title
Fix: After (SQL Server) error correction perform any SQL statement, then switch directly database may cause problems anomaly
Upd: (IBM DB2 / Informix) component version update to IBM.Data.DB2.dll 9.7.4.4 (10.5.4.4) (2014/08/29)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 4 (2014/08/29)
Upd: Other includes cumulative minor update, correction and optimization of processing
Data Table Editor ( Table Designer ):
Add: Added field properties set ( Column Properties )
Database Diagram ( Database Diagram):
Upd: to follow the view of content generated automatically zoom display window size
Might not work to open the browser issues Fixed display long table object: Fix
Auto-sensing ( AutoComplete ):
Add: When inserting SELECT / UPDATE / DELETE / INSERT automatically senses the built-in template table (table_name)
Add: increase UPDATE SET WHERE tables and fields perception
Upd: object properties sorted by display automatically senses table with a view (TABLES-> VIEWS)
Upd: optimization of the presence or absence of the table detection methods to improve data processing speed table field sensing
Upd: Improved data tables with Table Hints fields perception processing
Row Editing ( Data Editor ):
Upd: Support delete Cell of NULL into an empty (Empty) treatment
Upd: Data Grid Edit ( Cell Editor ): Support hexadecimal string data display ( Displaying Hexadecimal String )
Fix: Form Editor ( Form Editor): Correction (5329) lead to the update row containing BLOB fields
Instruction code generation ( Data Definition Language ):
Fix: Problem (SQLCe) correction IDENTITY (seed_value, increment_value) if increment_value non-default when acquired (including table editing and editing rows)
Database Object Search ( Search Objects ):
Fix: Correction OData can not double-click on the search list view objects issues
Upd: to enhance the database object search speed

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

- Object Browser ( Object Navigator ):
 Add: Added Advanced View option ( [ADV] Advanced Browsing Options ):
 Support field specified column sorting, filtering conditions before <n> a row ... and other advanced browser option is set (5364)
 Support TABLES and VIEWS Objects (5364)
 Upd: Updates Advanced editing options ( [ADV] Advanced Edit Options ):
 Before supports updating <n> a data column is set (5364)
 Updated when the focus is not editing area, you can directly click Enter rapid implementation (5364)
- Row editing and browsing ( Data Editor and Browser ):
 Upd: Browse mode Money and Currency data type of decimal places displayed automatically according to the operating system settings ( Based on the Regional Settings ) (5364)
 Fix: Correction (5336) resulting in Edit mode (DateTime / DateTimeOffset) and numerical output unformatted display right-aligned display (Right align numeric values) failures and other issues (5364)
 Upd: solve the edit mode (Access) in the absence of PK and contains a date field, in special circumstances row and sometimes you can not edit update in question (Access's bug) (5364)
- Instruction code generation ( Data Definition Language ):
 Upd: When (DB2) to delete the specified tables be deleted along with the object belongs TRIGGERS treatment (5364)
 Fix: (Informix) correction TRIGGERS script generation D / A content display issue priorities (5364)
- Query Builder ( Query Builder * ):
 Fix: Correction due renamed Reserved Words lead generation DISTINCT and unexpected disappearance TOP grammar issues (5364)
 Upd: selected query to the query generator processing ( Selected Text to Query Builder ): automatic generation of process improvement and optimization (5364)
- Batch script generation ( Generate Batch Scripts ):
 Add: Support to manually update the object generates sequential processing (Move Up and Move Down objects): object associated with the priority treatment (5364)
- Auto-sensing ( AutoComplete * ):
 Upd: Perception is just a field, and is entirely consistent when no longer displays a list (5364)
- Master Program update ( Main ):
 Upd: Improved exception handling exception when executing a SELECT statement's (5364)
 Upd: Improved multi-screen deal with related issues: 1 under the current screen window reset, 2 to avoid the dialog beyond the display range (5364)
 Upd: (SQLite) component version update to System.Data.SQLite.dll 1.0.94.0 (3.8.6) (2014/09/09) (5364)
 Upd: (MySQL) component version update to MySql.Data.dll 6.9.3 (2014/09/03) (5364)
 Upd: (PostgreSQL) component version update to Npgsql.dll 2.2.0 (2014/09/01) (5364)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5364)

[close]

http://fishcodelib.com/Database.htm

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

Improvements in Field Mappings section of Export dialog.
Minor changes in export procedures.

http://www.vlsoftware.net/

[SiLæncer]

Whats new: >>

- bug #4530 [security] DOM based XSS that results to a CSRF that creates a ROOT account in certain conditions

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

Master Program update ( Main ):
Add: (OData) query data transmission process, support progress display and interrupt handling
Add: (SQL Server) connection settings ( Connection Profile ): Database drop-down option increases link library file functions (with the attribute set AttachDbFilename)
Upd: Cache database (Database.db3): increase the integrity of the testing, and supports auto repair process (5372)
Fix: Cache database (Database.db3): Correction in the MySQL connection environment because \ character problems affecting the partial correlation function
Upd: (Firebird) component version update to FirebirdSql.Data.FirebirdClient.dll 4.5.1 ( )
Fix: When solving minimization program closes at the operating system Visual Effects, will lead to reducing the problem properly displayed
Upd: Other includes cumulative minor update, correction and optimization of processing
SQL editor ( SQL Editor ):
Upd: code folding handle ( Code Folding ): Improved newline characters when only \ n instead of \ r \ n, the lead generation and repeat the folding block can not generate other issues
Upd: automatically complete braces treatment ( Automatic brace Completion ): Avoid fast input repetitive processing
Auto-sensing ( AutoComplete *):
Wrap treatment without the use of keys Enter to insert [selected item] : Upd
Upd: Improved Quoted Strings for [about the same] field sensing process
Row Editing ( Data Editor ):
Fix: When saving the edited solve exception occurs when rows, if more direct click close the program will lead to other problems
Code Management ( Code Manager ):
Fix: Correction (5323) led to a non-default SQL can not directly save the open issues

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Whats new: >>

- bug ajax.js responseHandler: cannot read property of null
- bug sql.js: str is undefined
- bug #4524 Allow for direct selection of "0" on the "user overview" page
- bug #4529 Undefined index: pos
- bug #4523 tbl_change.js: insert as new row submit type on multiple selected records does not set all AUTO_INCREMENTs to 0 value
- bug ajax.js responseHandler: another "cannot read property"
- bug tbl_structure.js "cannot read property"

http://www.phpmyadmin.net/

[SiLæncer]

Release Notes

- Master Program update ( Main ):
 Add: full support for HP Vertica Database Systems  (An analytic database management)  (5378)
 Upd: improved interrupt handling progress window, click on the status message no longer interrupt the update immediately closed the window (5378)
 Upd: Connection settings ( Connection Profile ): drop down automatically include database features, are not repeated when setting unchanged reads (5378)
 Upd: Improved related issues in the Remote Desktop Connection (Remote Desktop Connection) environment when used (5378)
 Upd: (NuoDB) component version update to NuoDb.Data.Client.dll 2.1.0.0 (2014/09/19) (5378)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5378)
- Row Editing ( Table Data Editor ):
 Fix: Correction (5336) resulting in Edit mode problem (Boolean) data type can not be updated (5378)
 Fix: Correction to close the current row after editing, then switch to a different database and turned row editing, showing that the problem (5378) unnecessary dialog
- Row browse ( Table Data Browser ):
 Fix: Correction Status column Total Rows Count switch to message in response to (Messages) after the count display that failure problem (5378)
 Upd: built-in batch processing and execution of non-query command, to avoid the message to respond (Messages) displays a blank questions (5378)
- Object Browser ( Object Navigator ):
 Add: Advanced View / Edit option ([ADV] Advanced Browsing / Edit Options): increased field Select and deselect all functions (Select All / Deselect All) (5378)
 Fix: Advanced navigation options ( [ADV] Advanced Browsing Options ): Correction closed disable status issue can not be re-display options (5378)
 Upd: Right menu insert text option (Insert Text) supported on all objects (5378)
- Automatic braces finish processing ( Automatic brace Completion ):
 Automatically replace the right side of the same characters and avoid duplication speed up input (5378)
 Click Backspece be deleted automatically brackets just finished processing the input (5378)
- Auto-sensing ( AutoComplete * ):
 Improved perception treatment table fields, to avoid duplication when parsing objects Quoted Strings treatment (5378)
- Query Builder ( Query Builder * ):
 Upd: selected query to the query generator processing ( Selected Text to Query Builder ): More improvement and optimization of selected automatically generating process (5378)
- Instruction code generation ( Data Definition Language ):
 Upd: (PostgreSQL) generate VIEWS AND FUNCTIONS object names added SCHEMANAME display (with other objects) (5378)

[close]

http://fishcodelib.com/Database.htm

[SiLæncer]

Release Notes

* Bugs Fixed
- InnoDB; Partitioning: Large numbers of partitioned InnoDB tables could consume much more memory when used in MySQL 5.6 or 5.7 than the memory used by the same tables used in previous releases of the MySQL Server.
- InnoDB: An ALTER TABLE ... ADD FOREIGN KEY operation could cause a serious error.
- InnoDB: In debug builds, an INSERT operation affecting compressed tables would raise a sync-related assertion.
- InnoDB: Retrieval of multiple values with a single get command would return incorrect results instead of an error message. The InnoDB memcached plugin does not currently support retrieval of multiple values with a single get command.
- InnoDB: Attempting to perform operations on a timed out key would cause the memcached daemon to crash and restart.
- InnoDB: With a transaction isolation level less than or equal to READ COMMITTED, gap locks were not taken when scanning a unique secondary index to check for duplicates. As a result, duplicate check logic failed allowing duplicate key values in the unique secondary index.
- InnoDB: In rare cases, the purge process would attempt to delete a secondary index record that was not marked for deletion, resulting in an inconsistent secondary index.
- InnoDB: During recovery, a segmentation fault would occur when marking a table as corrupt.
- InnoDB: A failed in-place ALTER TABLE operation would leave behind non-unique temporary file names in the data dictionary preventing future ALTER TABLE operations on the same table due to temporary file name conflicts. To avoid this problem, temporary file names are made unique by appending a static global number that is initialized to a random distributed 32-bit number using ut_time() and ut_crc32(). The number is then incremented atomically for each assigned temporary file name. Previously, temporary files were named using the format #sql-ibtid, where tid is the table ID. Temporary files are now named using the format #sql-ibtid-inc, where tid is the table ID and inc is the incremented number.
- InnoDB: srv_active_wake_master_thread() was called directly in innobase_commit and innobase_prepare, waking up the master thread and incrementing srv_activity_count. srv_active_wake_master_thread() should only be called after committing write transactions, not after read-only transactions or rollbacks. This patch also replaces some calls to srv_active_wake_master_thread() with calls to ib_wake_master_thread().
- InnoDB: An in-place ALTER TABLE operation on a table with a broken foreign key constraint could raise an assertion.
- InnoDB: Inserting a record into an InnoDB table with a key that falls between the maximum key of a full page and the minimum key of the “next” page could result in unnecessary page splits and under-filled pages. If the insert point is at the end of a page, InnoDB now attempts to insert to the next page before splitting the page.
- Replication: After the fix for Bug #16861624, killing a multi-threaded slave worker which was waiting for a commit lock caused a debug assertion to fail. This fix ensures that such a situation can not occur.
- Replication: When committing a transaction, a flag is now used to check whether a thread has been created, rather than checking the thread itself, which uses more resources, particularly when running the server with master_info_repository=TABLE.
- Replication: A multi-threaded slave now checks that a free worker is available to dispatch the next event. In previous versions, a multi-threaded slave crashes with a worker error if the thread coordinator can not find a free worker. The crash was caused when the coordinator did not return a free worker, for example if the coordinator was aborted at the same time using STOP SLAVE.
- Replication: When mysqlbinlog processed multiple binary log files into a single output file, this file was not in a useful state for point-in-time recovery, when it failed with the error, When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'xyz'. When mysqlbinlog processes a binary log containing GTIDs, it outputs SET gtid_next statements, but gtid_next is set to undefined whenever a commit occurs; this left gtid_next undefined when the server had finished processing the output from mysqlbinlog. When the next binary log file started with one or more anonymous statements or transactions, the combination of gtid_next being left undefined at the end of the first binary log and the second binary log containing anonymous transactions to the error described previously (Error 1837, ER_GTID_NEXT_TYPE_UNDEFINED_GROUP).
- Replication: When the I/O thread reconnected to a master using GTIDs and multithreaded slaves while in the middle of a transaction, it failed to abort the transaction, leaving a partial transaction in the relay log, and then retrieving the same transaction again. This occurred when performing a rotation of the relay log. Now when reconnecting, the server checks before rotating the log in such cases, and waits first for any ongoing transaction to complete.
- Replication: When using semisynchronous replication, if the binary log position was changed to a future position on a slave then an assertion error was generated on the master. This fix ensures that in such a situation the future position is correctly acknowledged and an error is instead generated on the slave.
- Replication: When an SQL thread which was waiting for a commit lock was killed and restarted it caused a transaction to be skipped on slave. This fix ensures that thread positions are correctly persisted and transactions resume at the correct position.
- Replication: On a master that is using semisynchronous replication, where rpl_semi_sync_master_wait_no_slave is enabled and rpl_semi_sync_master_timeout is set to long timeout, killing the I/O thread could cause the server to hang on shutdown. This fix ensures that if the dump thread finds that there no semisynchronous slaves connected to the master, the setting of rpl_semi_sync_master_wait_no_slave is ignored and the shutdown proceeds correctly.
- Replication: When using row-based replication, setting a slave's slave_rows_search_algorithms variable to HASH_SCAN caused an ER_RECORD_NOT_FOUND error even though that record existed in the storage layer. This fix ensures that the unique key for each record is correctly maintained and such a situation does not occur.
- Replication: When an event group was spanned across multiple relay log files, a slave could incorrectly identify GTID-header group boundaries. This meant that when a transaction was retried, or if the SQL thread was stopped in the middle of a transaction after some rotates, the Gtid_log_event was being silently skipped on the slave, and the transaction was logged with the slave's GTID. This problem also impacted on using START SLAVE UNTIL MASTER_LOG_POS = log_pos; with GTIDs enabled. If log_pos was in the middle of a transaction, the Gtid_log_event was not correctly detected as the beginning of the transaction and replication stopped before this event. With this fix, threads correctly detect that they are part of a group, and this is used to check if a Gtid_log_event is part of a transaction.
- Replication: The error messages generated when a duplicate server UUID causes issues during replication have been improved. The slave error now identifies the duplicate server UUID and the master error identifies the zombie thread that has been killed.
- Replication: The CLIENT_REMEMBER_OPTIONS flag for compressed slave connections is no longer reset and all options are retained. This restores functionality of all options to compressed slave connections.
- Replication: When using row-based replication, running a long transaction involving a large number of events could trigger an Out of Memory (OOM) error if the slave's table structure was not compatible with the master's table structure. Such an incompatible situation could occur if the table on the slave had been manually changed, or when replicating between different MySQL versions that have different data types. This OOM error was caused because the virtual temporary tables created for the row conversion were not being freed until the end of the transaction, which was a problem when replicating large numbers of events.
- With DTrace support enabled, certain other compilation options could cause the build to fail.
- yaSSL client code did not validate the encryption size or session ID length, which could cause the client to exit.
- yaSSL could fail preauthorization if the client supplied inaccurate buffer lengths.
- Competition between threads could lead to timeout failure trying to rotate the audit log file.
- LPAD() and RPAD() could cause a server exit if the pad string argument was not well formed.
- The optimizer could create a zero-length column for a temporary table, causing a server exit.
- MOD for very small decimal right-hand arguments could cause a server exit.
- The client library now includes a call to X509_verify_cert_error_string() in the SSL certificate verification code, to be more robust in detecting invalid certificates.
- If the left-hand-side of an IN predicate was a scalar subquery but returned no row, the server could exit.
- The thread_concurrency system variable is deprecated, but no warning resulted from setting it at server startup.
- Sending a SIGQUIT or SIGINT signal to mysql could result in a glibc double free or corruption error.
- Invalid memory access could occur when using prepared statements if a mysql client connection was lost after statement preparation was complete and there was at least one statement that was in initialized state but not prepared yet.
- LIKE matches failed for code points of HALF WIDTH KATAKANA in the sjis and cp932 character sets.
- On EL7, installation of MySQL from RPM packages could fail if postfix had previously been installed using yum.
- mysql_upgrade could fail if the mysql.user table contained multiple accounts with the same user name and host name where the host name differed in lettercase. This is still not permitted, but now mysql_upgrade prints a more informative error message to indicate the nature of the problem:
> ERROR 1644 (45000): Multiple accounts exist for user_name, host_name
> that differ only in Host lettercase; remove all except one of them
- If the general query log or slow query log file was set to a FIFO or socket file, and the file reader went away, the server stopped executing statements. Now the server detects such files, logs an error message, and continues with the appropriate log disabled.
- A simultaneous OPTIMIZE TABLE and online ALTER TABLE on the same InnoDB table could result in deadlock.
- The query cache was not invalidated for a table when a CASCADE DELETE or CASCADE UPDATE referential constraint was specified and the database name or table name contained special characters.

[close]

http://www.mysql.com/

[SiLæncer]

Release Notes

- Master Program update ( Main ):
 Add: (FoxPro) support adding tables to the database container feature (Tools -> Add Tables to a database container) (5385)
 Add: (FoxPro) Tools menu to add new database container and delete function (Tools -> Create and Delete a database container) (5385)
 Add: (dBase) Tools menu to add new database directory and delete function (Tools -> Create and Delete a dBase folder) (5385)
 Add: (Excel) Database Tools menu to add new and delete function (Tools -> Create and Delete an Excel file) (5385)
 Add: (Excel) to support the table object (WorkSheets) deletion process (5385)
 Upd: (Excel) instruction code generation ( Data Definition Language ) when TABLES object names to exclude $ characters (5385)
 Add: (Excel) Add Table editor ( Table Designer ) function (Excel 97-2003 only) (5385)
 Add: (Excel) Data column editing ( Table Data Editor ) Support # field is automatically updated with the automatic accumulation digital processing (similar AutoIncrement field processing) (5385)
 Upd: (OData) to rewrite the output XML data handling, avoid NULL cause exception (Input array is longer than the number of columns in this table) (5385)
 Upd: (OData) to improve problems with and without FunctionImport table also shows the (5385)
 Upd: (OData) to increase ComplexType data type display (5385)
 Upd: (MySQL) component version update to MySql.Data.dll 6.9.4 (2014/09/26) (5385)
 Upd: (PostgreSQL) component version update to Npgsql.dll 2.2.1 (2014/09/25) (5385)
 Upd: (Oracle) component version update to Oracle.ManagedDataAccess.dll 12.1.1.0 (2014/09/23) (5385)
 Fix: (Oracle) amendments to perform with Oracle Hints statement of, SQL History (in SQL History issues) are not to be displayed (5385)
 Add: Advanced navigation options ( [ADV] Advanced Browsing Options ): Click on the list of fields to support the sorting process, and increase the original field order message (5385)
 Upd: Improved Teradata and Sybase ASE all databases in the browser mode, database connections, such as switching and reconnect optimization (5385)
 Fix: Correction (5378) Progress window when clicked, interrupt handling, the next turn cause can not recover the state of the key issues (5385)
 Fix: Correction (5 ~ ~ ~) leads Tools menu database delete functionality issues stalled (5385)
 Upd: Other includes cumulative minor update, correction and optimization of processing (5385)
 Misc: Compatible with MySQL 5.6.21 (2014/09/23) / MySQL 5.5.40 (2014/09/22)

[close]

http://fishcodelib.com/Database.htm