Anzeigen der neuesten Beiträge
0 Mitglieder und 1 Gast betrachten dieses Thema.
# Bugs Fixed* Performance: InnoDB: Improved the algorithm related to adaptive flushing. This fix increases the rate of flushing in cases where compression is used and the data set is larger than the buffer pool, leading to eviction.* InnoDB: In a transaction using the REPEATABLE READ isolation level, an UPDATE or DELETE statement for an InnoDB table could sometimes overlook rows recently committed by other transactions. As explained in Section 14.3.9.2, “Consistent Nonlocking Reads”, DML statements within a REPEATABLE READ transaction apply to rows committed by other transactions, even if a query could not see those rows.* InnoDB: The Innodb_buffer_pool_pages_flushed status variable was incorrectly set to twice the value it should be. Its value should never exceed the value of Innodb_pages_written.* InnoDB: The error handling and message was improved for attempting to create a foreign key with a column referencing itself. The message suggested a potential problem with the data dictionary, when no such problem existed.* InnoDB: The CHECK TABLE statement could fail for a large InnoDB table due to a timeout value of 2 hours. For typical storage devices, the issue could occur for tables that exceeded approximately 200 or 350 GB, depending on I/O speed. The fix relaxes the locking performed on the table being checked, which makes the timeout less likely. It also makes InnoDB recognize the syntax CHECK TABLE QUICK, which avoids the possibility of the timeout entirely.* Replication: It was theoretically possible for concurrent execution of more than one instance of SHOW BINLOG EVENTS to crash the MySQL Server.* Replication: Statements using AUTO_INCREMENT, LAST_INSERT_ID(), RAND(), or user variables could be applied in the wrong context on the slave when using statement-based replication and replication filtering server options (see Section 16.2.3, “How Servers Evaluate Replication Filtering Rules”).* Replication: An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based binary logging or replication. Such statements are now marked as unsafe and fail with an error when using the STATEMENT binary logging format. For more information, see Section 16.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”, as well as Section 16.4.1.1, “Replication and AUTO_INCREMENT”.- Note : Tables using the InnoDB storage engine are not affected by this issue, since InnoDB does not allow the creation of a composite key that includes an AUTO_INCREMENT column, where this column is not the first column in the key.* SHOW TABLES was very slow unless the required information was already in the disk cache.
Ver 6.6.4549 (2012/06/15)- The main program updates ( Main ):Add: (OData) to support an OData v3 format (4549)Add: (OData) to increase the data version of the message is displayed, and add a new type of data ( Types ) (4 549)Fix: (OData) Amendment Tree tree information browser, <ROOT>, does not contain the attribute display problem (4549)Upd: (SQLite) updated components System.Data.SQLite.DLL 1.0.81.0 (3.7.12.1) (2012/05/27) (4534)Misc: Compatible with the PostgreSQL 9.1.4 (2012/06/04)Misc: Compatible with the MySQL 5.5.25 (2012/05/31)Upd: includes many minor fixes and optimization of the update ... the cumulative processing (4549)- SQL Editor ( SQL Editor ):Upd: Update the Transaction the Mode with the Parse Mode joined the Command the Timeout setting (with the Execution Mode) (4549)Add: Support batch SQL commands to output the following results ( Displaying the results of the batch of SQL statements ) (the presumptuous batch GO) (4 534)Upd: [single line] SQL command semicolon (;) batch processing, changing only the database supports the INSERT INTO and does not support batch processing (Access / Excel / FoxPro, / dBase / Firebird / SQLCe) (4534)- Generated by the script ( the SCRIPT AS ):Upd: updated Data (INSERTs) script to generate the source for the (Access / Excel / FoxPro / dBase / Firebird / SQLCe), the export settings ( GO ) is checked by default (4534)- Code management ( Code Manager ):Fix: Fixed (4524) led to the initial use of the additional two useless sample directory (4534)
- bug #3521416 [interface] JS error when editing index- bug #3521313 [core] Call to undefined function __()- bug #3521016 [edit] NOW() function incorrectly selected- bug [GUI] Invalid HTML code on transformation_overview.php- bug #3522930 [browse] Missing validation in Ajax mode- bug Fix popup message on build SQL of import- bug #3523499 [core] Make X-WebKit-CSP work better- replace Highcharts with jqplot for query profiling, zoom search- bug #3531584 [interface] No form validation in change password dialog- bug #3531585 [interface] Broken password validation in copy user form- bug #3531586 [unterface] Add user form prints JSON when user presses enter- bug #3534121 [config] duplicate line in config.sample.inc.php- bug #3534311 [interface] Grid editing incorrectly parses ENUM/SET values- bug #3510196 [core] More clever URL rewriting with ForceSSL
Ver 6.7 (2012/06/25) Stable Version- SQL Editor ( SQL Editor ):Add: Add the display assessment of the implementation plan ( the Display Estimated Execution Plan ) (4559)Support for SQL Server / SQL Azure / SQLCe / SQLite / MySQL / PostgreSQL / Oracle and other databaseUpd: Update the Transaction the Mode with the Parse Mode joined the Command the Timeout setting (with the Execution Mode) (4549)Add: support batch SQL commands to perform the resulting output ( Displaying the results of the batch SQL statements ) (presumptuous batch GO) (4534)Fix: Fixed (4534) lead to non-SELECT the RecordsAffected without [the] record numbers (4559.1)Upd: [single-line SQL command semicolon (;) batch processing, change only supports the INSERT INTO and does not support batch database processing (Access / Excel / FoxPro, / dBase / Firebird / SQLCe) (4534)- The main program updates ( Main ):Fix: Fixed (453?) Command line ( Command-line: Lead to lost (4554): The test command is not removed) DB type: Access = 0, Excel = 1, dBase = 2, FoxPro = 3, Firebird = 4, MySQL = 5, SQLServer = 6, SQLAzure = 7, SQLCe = 8, SQLite = 9, PostgreSQL = 10, Oracle = 11 the OleDB = 12, Odbc = 13, an OData = 14, the DB2 = 15, for Informix = 16, Sybase, = 17 [DB type (0 to 17)], the DB file / Profile name] <[Script file], [Close Tab (-ct) / Application (ca)]> database4.exe -? database4.exe "c: \ 1.mdb" database4.exe "c: \ 1.sdf" database4.exe 0 "c: \ 1.mdb" database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-ca database4.exe 6 codelib database4.exe 6 codelib "c: \ 1.sql"-ct the Support for the AutoLogin (MySQL / SQL Server / SQL Azure / PostgreSQL / Oracle / IBM DB2/Informix/Sybase of ASE) Add: (OData) support in OData v3 format processing (4549)Add: (OData) to increase the data version of the message is displayed, and add a new type of data ( Types ) (4 549)Fix: (OData) correction Tree tree information Browse, <ROOT> to not contain a property to display the problems (4549)Upd: (SQLite) updated components System.Data.SQLite.DLL 1.0.81.0 (3.7.12.1) (2012/05/27) (4534)Upd: contains many small fixes and optimize the update ... the cumulative processing (4559)Misc: Compatible with of Firebird 2.1.5 (2012/06/21)Misc: Compatible with the PostgreSQL 9.1.4 (2012/06/04)Misc: Compatible with the MySQL 5.5.25 (2012/05/31)- Generated by the script ( the SCRIPT AS ):Upd: updated Data (INSERTs) script to generate the source for the (Access / Excel / FoxPro / dBase / Firebird / SQLCe), the export settings ( GO ) is checked by default (4534)- Code management ( Code Manager ):Fix: Fixed (4524) led to the initial use of the additional two useless sample directory (4534)
Ver 6.7.4565 (2012/07/01)- The main program updates ( Main ):Add: Add disable indexing processing (Disable Indexes): (SQL Server / SQL Azure / Oracle) (4565)Add: Add rebuild the index treatment (Rebuild Indexes): (SQL Server / SQL Azure / Oracle / PostgreSQL / SQLite) (4565)Add: Add to reorganize the index processing Reorganize Indexes: (SQL Server) (4 565)Add: new index statistics update process (Update Statistics): the (SQLCe / Firebird / of Sybase ASE) (4565)Fix: (Sybase ASE) amendment object to specify a different Schema (4565)Fix: (Sybase ASE) fix the TRIGGERS object can not display the problem (4565)Upd: contains many small fixes and optimize the update ... the cumulative processing (4565)- Table ( Table Editor ):Upd: updated information on the type of case consistent treatment in the text display (including a script to generate DDL processing) (4565)Upd: (MySQL) to amend and update the ENUM SET data type, and DEFAULT is empty,'' display processing (including the script to generate DDL handle) (4565)Upd: (FoxPro) the DEFAULT quotes update string type, the original "" to'' the consistency of treatment (for other databases) (containing the script to generate DDL handle) (4565)Fix: (Sybase ASE) amend the DEFAULT settings can not be in the new mode to normal handling (including the script to generate DDL handle) (4565)- SQL Editor ( SQL Editor ):Fix: correction and open the main program (Database4.exe) and [different] when the database can not be their own proprietary syntax highlighting (4565)Add: Add the contents of the editor and grammar heavy brush shortcut key handling ( Refresh : Ctrl + R) (4 565)
Autor
Thema: Datenbanksoftware und Tools diverses ... (Gelesen 161692 mal)
