Autor Thema: Datenbanksoftware und Tools diverses ...  (Gelesen 95365 mal)

0 Mitglieder und 1 Gast betrachten dieses Thema.

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 9.7.5053
« Antwort #255 am: 01 November, 2013, 06:25 »
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: >>

Ver 9.7 (2013/11/01) Stable Version
- The main program update ( Main ):
Add: (SQL Server / SQLAzure) increased System Views / System Stored Procedures / System Functions such as Object Management (including script generation) (5053)
Add: (Firebird) increased System Functions such as Object Management (including script generation) (5053)
Fix: correction FoxPro automatically installing components the same process is repeated after the issue (5053)
Fix: (Object / Code / SQL Treeview) Object Browser: Solving click to expand the node to be treated as a continuous double when the issues addressed (5053)
Fix: After solving SybaseASE Ruozai reconnect disconnected, it will cause an exception error problem (ADO Provider's bug?) (5053)
Upd: (SQLite) update components to System.Data.SQLite.dll 1.0.89.0 (3.8.1) (2013/10/28) (5053)
Upd: Other minor fixes and optimization includes many updates ... they accumulate processing (5053)
- Command-line update (Command-line): :
Add: New Batch Mode ( Batch mode ): the ability to open multiple tabs for batch processing (5053)

    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"-t: 30
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-ca
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-f: "c: \ export.sql"-ca
    database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-f: "c: \ export.csv"
    database4.exe 6 codelib
    database4.exe 6 codelib "c: \ 1.sql"-ct
    database4.exe 0 "c: \ 1.mdb" "c: \ batch.lst"
    database4.exe 6 codelib "c: \ batch.lst"
        Batch mode: you can create a file 'batch.lst' that includes the following arguments:
        "C: \ 1.sql"
        "C: \ 1.sql",-t: 30
        "C: \ 1.sql",-ct
        "C: \ 1.sql",-f: "c: \ export.sql"

Support for AutoLogin (MySQL / SQL Server / SQL Azure / PostgreSQL / Oracle / IBM DB2/Informix/Sybase ASE)
Export formats:-f: "x: \ xxx. [Csv / xml / txt / xlsx / xls / sql / htm / json]"

- Auto-complete processing ( AutoComplete * ):
Add: (SQL Server / SQLAzure) increased System Views / System Stored Procedures / System Functions such as auto-completion and auto-sensing object processing (5053)
Upd: optimization [ IntelliSense-> COLUMNS ] object auto-sensing process: to strengthen the SELECT + Space + FROM awareness processing (5053)
- Script generation ( Data Definition Language ):
Fix: correction (4971) Processing Field Default value (Default Value) function (Function) whether or not the judge, may result in some cases can not be generated script problems (including table editor) (5053)
Fix: (Firebird) Fixed multiple function object (FUNCTIONS) script generation processing (5053)
- Query Builder ( Query Builder * ):
Add: Add System Tables and System Views and other objects support (5053)
Upd: 1. Adding the same table name change use short alias processing, 2 windows to increase the list of fields automatic scaling, 3. Use quoted identifiers setting adding memory processing (5053)
- SQL Editor ( SQL Editor ):
Add: add a list of recently used file menu ( Recently Used Files ) (5053)
Upd: Improved preservation process: 1. Taskbar save save processing integration process, 2. Unspecified code is preset to save processing node, 3. Maintaining Save deal last position (5053)


http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 9.7.5056
« Antwort #256 am: 04 November, 2013, 16:30 »
Whats new: >>

Fix: correction (5053) result (Access) database is not normally open issues (5056)

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
phpMyAdmin 4.0.9
« Antwort #257 am: 05 November, 2013, 06:20 »
4.0.9.0

- bug #4104 Can't edit updatable view when searching
- bug #4108 Missing refresh by deleting databases
- bug #3995 Drizzle server charset notice
- bug #3911 Filtering database names includes empty groupings
- bug #3678 Does not display or manipulate bit(64) fields appropriately
- bug #4129 Unneeded navi panel refresh
- bug #4120 SSL redirects to port 80
- bug #4144 DROP DATABASE displays wrong database name
- bug #4059 Running delete query asks for confirmation but says it was already executed
- bug #4147 Accessibility: Images without Alt nor title attribute

http://www.phpmyadmin.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
ESEDatabaseView v1.16
« Antwort #258 am: 09 November, 2013, 17:01 »
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: >>

Added 'Clear Recent Files List' option.

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Snap DB v1.4.3
« Antwort #259 am: 10 November, 2013, 18:20 »
Snap DB is a simple, lightweight and customizable flat-file database application. Columns can be easily created, deleted, renamed and moved, and it has an instant search to provide rapid access to the stored information.

License: Freeware

What's new: >>

The Add/Edit record box was not appearing properly.
Changed resizing routines to, hopefully, avoid a Windows XP bug.
SnapDB is now DPI aware.

http://skwire.dcmembers.com/wb/pages/software/snap-db.php

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 9.8.5067.21644
« Antwort #260 am: 15 November, 2013, 16:40 »
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: >>

Upd: Update for DB2 9.1

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Snap DB 1.4.5 Build 1
« Antwort #261 am: 15 November, 2013, 20:45 »
What's new: >>

Small cosmetic issue fixed

http://skwire.dcmembers.com/wb/pages/software/snap-db.php

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
ESEDatabaseView 1.17
« Antwort #262 am: 20 November, 2013, 14:10 »
Whats new: >>

Added 'Open SoftwareDistribution Database' option, which opens the database file containing information about installed Winodws updates (C:\WINDOWS\SoftwareDistribution\DataStore\DataStore.edb)

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

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database Browser 5.1.0.0
« Antwort #263 am: 21 November, 2013, 13:04 »
Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

What's new: >>

- Corrected issues with delimiters in sql scripts

http://www.etl-tools.com/database-editors/database-browser/overview.html

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
ClipTable 1.0.5.0 Beta
« Antwort #264 am: 23 November, 2013, 17:07 »
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

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/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Exportizer 5.3.4
« Antwort #265 am: 27 November, 2013, 05:40 »
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: >>

Minor changes.

http://www.vlsoftware.net/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database .NET 9.9.5080.19774
« Antwort #266 am: 28 November, 2013, 13:17 »
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: >>

Query Builder ( Query Builder * ):
Add: add a table automatically join processing ( Automatic Join ), when [the child] add table with [main] an association table itself will automatically create links (5080)
Upd: Updated generative grammar formatted content while optimizing multiple processing (5080)
The main program update ( Main ):
Fix: Correction in the absence of any object selected under ArgumentOutOfRangeException may cause problems when switching databases (5080)
Upd: (Firebird) updated components FirebirdSql.Data.FirebirdClient.dll 4.0.0 ( ) (2013/11/18) (5080)
Upd: contains many other minor fixes and updates ... etc. accumulate process optimization (5080)
SQL editor ( SQL Editor ):
Fix: search and replace function ( Quick Find and Replace ): fix the selected text and then open the search window, the text fails to fill synchronization issues (5080)
Row Editing ( Data Editor ):
Fix: form editor ( Form Editor * ): Correction New Row Without primary health (PK) when, under certain conditions may not complete the question (5080)
Script generation ( Data Definition Language ):
Upd: Update When Provider in the Data Type Format and Parameters deemed empty Null handling to avoid exception occurs (5080)
Fix: (PostgreSQL) amendment (5008) Failed to generate questions (

http://fishcodelib.com/Database.htm

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
Database Browser 5.1.0.1
« Antwort #267 am: 01 Dezember, 2013, 13:03 »
Database Browser is an easy to use tool allows you to connect to any database (Oracle, MS-SQL, MySQL, Firebird, etc) and browse or modify data, run sql scripts, export and print data.

Features

    * Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, Interbase and Firebird
    * Support for ODBC connection strings
    * Unlimited number of connections
    * One click switching from one connection to another
    * One click table browsing
    * Data browsing
    * Data exports into CSV, Excel, Html files
    * Execution history
    * SQL Builder with wide range of supported databases
    * Execution Log
    * Incremental Table Search

What's new: >>

Unbekannt

http://www.etl-tools.com/database-editors/database-browser/overview.html

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
MySQL 5.6.15
« Antwort #268 am: 03 Dezember, 2013, 22:16 »
Whats new: >>

# Bugs Fixed
* InnoDB: A regression fix resulted a memory leak for memcached insert operations.
* InnoDB: The trx->error_key_num field was not initialized in the error injection code found in storage/innobase/handler/handler0alter.cc. The error_key_num field is usually 0 but can be a non zero value if the memory buffer of a DDL transaction object is reused.
* InnoDB: Fault-tolerant code found in the log apply code for InnoDB ALTER TABLE ... IN PLACE could result in data corruption.
* InnoDB: Databases names beginning with a digit would cause a full-text search (FTS) parser error.
* InnoDB: An ALTER TABLE ... CHANGE [COLUMN] operation would result in an rbt_empty(index_cache->words) assertion.
* InnoDB: Running SHOW ENGINE INNODB STATUS on one connection thread and killing that thread by running a KILL CONNECTION statement from a different connection thread would result in a severe error.
* InnoDB: An excessive amount of memory would be consumed when querying INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE. The problem would occur for very large full-text search indexes.
* InnoDB: CHECK TABLE would ignore the QUICK option.
* InnoDB: The information_schema.innodb_metrics index_merge counter was not incremented in btr0btr.cc. This patch also introduces new counters (index_page_reorg_attempts, index_page_reorg_successful and index_page_discards) and renames the index_merges counter to “index_page_merge_attempts” to distinguish it from the index_page_merge_successful counter.
* InnoDB: Setting the O_DIRECT flag on a file on tmpfs on some operating systems would result in an error printed to the error log. Creating multiple temporary tables on tmpfs would cause the error to be printed repeatedly. The error message has been changed to a warning that is only printed once when running CREATE TABLE multiple times.
* InnoDB: In debug builds, test case failures would occur due to ibuf_contract_ext performing merges and dict_stats_update returning evicted pages back into the buffer pool while ibuf_change_buffering_debug is enabled.
* InnoDB: InnoDB would fail to return an error when attempting to run a query after discarding the tablespace.
* InnoDB: A severe error would occur after discarding a tablespace.
* InnoDB: During a TRUNCATE TABLE operation, InnoDB: Trying to TRUNCATE a missing index of table ... warnings would be printed to the error log. These warnings should not be printed when the index is a full-text search (FTS) index.
* InnoDB: Full-text index creation on a large table would fail due to insufficient temporary table space and result in a misleading “incorrect key file” error.
* InnoDB: The InnoDB mecached plugin would update a record before inserting to the binlog, which would cause slave server replication to stop. The insert should occur before the update.
* InnoDB: During parallel full-text search (FTS) index creation, a scanner thread reads in documents and passes them to the tokenizer. The tokenizer frees documents from memory when tokenization is complete. When tokenizing documents with a large amount of text, the tokenizer thread would not keep pace with the scanner thread. As a result, memory would not be freed fast enough and the “tokenization pending list” would grow in size.
* InnoDB: A full-text search (FTS) BOOLEAN MODE query with an invalid character in the query string could result in a memory access violation failure.
* InnoDB: trx_create and trx_free would be called for every memcached get request.
* InnoDB: The hardcoded size for the srv_max_n_threads variable was insufficient. The variable setting is now configured based on the maximum number of connection threads and InnoDB background threads.
* InnoDB: In btr_validate_level there are checks to ensure that all B-tree pages are marked when allocated. The checks would fail on the change buffer because the allocation of change buffer pages is handled differently than other B-tree pages.
* InnoDB: When the change buffer is enabled, InnoDB would fail to write a transaction log record when merging a record from the insert buffer to a secondary index page if the insert was performed as an “update-in-place”.
* InnoDB: A SELECT COUNT (*) query would run very slowly when run concurrently with a LOAD DATA operation.
* InnoDB: An existing full-text index would become invalid after running ALTER TABLE ADD FULLTEXT due to an unsynchronized full-text cache.
* InnoDB: Due to a regression in MySQL 5.6, creating or dropping tables with innodb_force_recovery set to 3 (SRV_FORCE_NO_TRX_UNDO) would fail. Additionally, this bug fix includes a code modification that sets InnoDB to read-only when innodb_force_recovery is set to a value greater than 3 (SRV_FORCE_NO_TRX_UNDO).
* InnoDB: An InnoDB memcached configuration error message contained an incorrect file name. The error message stated, Please create config table containers in database innodb_memcache by running innodb_config.sql. error 31. The correct file name is innodb_memcached_config.sql. Also, the “error 31” portion of the error message has been translated to its text equivalent, which is “Table not found”.
* InnoDB: In mutex_spin_wait(), the sync_array_reserve_cell function could fail to find an empty slot on systems with sync wait arrays that are small in size, resulting in an error.
* InnoDB: When index_read_map is called for an exact search and fails to return a record due to non-matching search criteria, the cursor would be positioned on the next record after the searched key. A subsequent call to index_next would return the next record instead of returning the previous non-matching row, thereby skipping a record.
* InnoDB: Full-text search (FTS) index savepoint information would not be set resulting in a severe error when attempting to rollback to the savepoint.
* InnoDB: Converting a table with a large number of columns from MyISAM to InnoDB would cause an assertion due to insufficient log buffer space. Instead of asserting, InnoDB now attempts to increase log buffer size automatically if the redo log size is too large.
* Partitioning: The storage engine was set incorrectly during a rebuild of a partition; the table storage engine was ignored and the default storage engine used instead. Thus, in MySQL 5.1, it was possible for REBUILD PARTITION to change the partition storage engine from InnoDB to MyISAM, and for the reverse (rebuilding partitions of MyISAM tables causing the partitions to use InnoDB) to occurin MySQL 5.5 and later. Now, when rebuilding partitions, the storage engine actually used by the table is checked and used by the handler for the rebuild operation, so that the partition storage engine is not inadvertently changed.
* Partitioning: After disabling the parent table's indexes with ALTER TABLE ... DISABLE KEYS, rebuilding any of its partitions enabled the indexes on those partitions, leading MyISAM to fail with an error when the optimizer tried to use one of the affected indexes.
* Replication: A replication master did not handle correctly the disabling of the semisync plugin on the master and the slave, with a subsequent stopping of the slave.
* Replication: The final argument in the SET clause of a LOAD DATA ... SET statement was repeated in the binary log.
* Replication: When an error encountered by the dump thread while reading events from the active binary log file was a temporary error, so that the dump thread tried to read the event, it was possible for the dump thread to seek the wrong position, which could cause one or more events to be resent. To prevent this, the thread's position is obtained after each correct read of an event.
* Replication: When stopping the I/O thread, it was possible with a very large transaction (equivalent to a binary log size greater than 100MB) that the thread did not receive the transaction to the end. When reconnecting with MASTER_AUTO_POSITION=1 it then tried to fetch changes from the next transaction, which could lead to loss of the incomplete transaction and its data.
* Replication: Setting rpl_semi_sync_master_enabled while the master was waiting for a reply from the slave could in some cases cause the master to fail.
* Replication: Trying to set CHANGE MASTER TO ... MASTER_AUTO_POSITION = 0 failed with error 1777 (ER_AUTO_POSITION_REQUIRES_GTID_MODE_ON).
* Replication: The value of LAST_INSERT_ID() was not correctly replicated when filtering rules were used on the slave.
* Replication: An internal function used for storing GTID values could sometimes try to handle them as strings of the wrong length.
* Replication: During row-based replication with binlog_row_image set to MINIMAL, updating only some columns of a table having 9 or more columns caused mysqlbinlog to fail when it was used with the --verbose option.
* Replication: Issuing a GRANT statement with invalid parameters caused the master to write LOST_EVENTS events into its binary logs, causing replication to stop. Now such cases, if one or more grants or revocations of privileges are successful, an incident is written to the log; otherwise, only a warning is logged.
* libmysqlclient version 18 files were removed from MySQL-shared-compat RPM packages to avoid a conflict between the MySQL-shared and MySQL-shared-compat RPM packages.
* Enabling Index Merge optimizer switches and setting a small sort_buffer_size value could lead to a server exit.
* Semi-join materialization strategy was not used for VARCHAR columns longer than 512 bytes, resulting in use of a less-efficient strategy and worse query performance. (The limit in characters rather than bytes depends on the column character set; 170 characters for utf8, for example.)
* Some license and documentation files were missing from Windows MSI packages.
* Selecting from the Performance Schema session_connect_attrs table under high load could cause a server exit.
* Compilation failures under Visual Studio 2012 were corrected.
* The CLIENT_CONNECT_WITH_DB flag was improperly handled in the C client library. This could lead to a malformed packet sent to the server.
* An assertion was raised if SET PASSWORD was used for an account that has been manually deleted from the mysql.user table but still present in memory.
* The mysql_options() C API function could leak memory if called more than once with the MYSQL_SET_CLIENT_IP option.
* The CONV() function could call abs(INT_MIN), which is undefined, and cause a server exit.
* An error array in the SSL code was missing a comma, leading to implicit concatenation of adjacent messages and a resulting off-by-one error in the relationship between error numbers and messages.
* The filesort implementation sometimes failed to allocate enough buffer space, leading to a server exit.
* GRANT without an IDENTIFIED BY clause resulted in an error even for existing users.
* GROUP_CONCAT() with an invalid separator could cause a server exit.
* An internal InnoDB string routine could write past the end of a buffer.
* GIS intersection-related code was missing a return value check, leading to a loop in nondebug builds and a raised assertion in debug builds.
* Using the binary client/server protocol, the second execution of a prepared statement for a query with parameters in the LIMIT clause raised an assertion.
* For upgrades using the Windows MSI package installer, the upgrade dialog message was missing the “from” version.
* Very long database names in queries could cause the server to exit.
* Standalone Windows MSI packages did not have the ALLUSERS property set. They now set ALLUSERS=1. For earlier MSI packages in this MySQL series, a workaround is to use the following command:
- C:\> msiexec /i msi_installer_name ALLUSERS=1
* Recursion by functions called as arguments to XPath expressions was not handled correctly, sometimes causing such expressions to fail.
* For an ALTER TABLE statement that renamed or changed the default value of a BINARY column, the alteration was done using a table copy and not in place.
* Some possible cases of memory use after being freed were fixed. Thanks to Jan Staněk for the patch.
* In debug builds, static initialization code could call DBUG functions before the DBUG subsystem was initialized.
* With the thread pool plugin enabled, the the PROCESSLIST_USER and PROCESSLIST_HOST columns of the Performance Schema threads table were always NULL for client sessions. Also, for the main thread, those columns were not NULL but set to a user account.
* COUNT(DISTINCT) should not count NULL values, but they were counted when the optimizer used Loose Index Scan.
* For queries of the form UPDATE ... WHERE unique_key ORDER BY ... LIMIT ..., incorrect rows could be updated. Unique keys permit multiple NULL values, but the optimizer did not always consider all of them.
* If asked to upgrade a server that was running without InnoDB enabled, mysql_upgrade issued complaints about InnoDB tables not existing (tables that will not exist unless InnoDB is available).
* In some cases, range conditions over indexes defined on column prefixes returned incomplete result sets. (For example, SELECT ... WHERE 'abcdef1' < col_name AND col_name < 'abcdef9', where the index on col_name indexed only the first 6 characters.)
* Performance Schema instrumentation overhead was reduced for frequent connect/disconnect operations.
* Setting host_cache_size at startup had no effect.
* InnoDB full-text searches failed to find records within transactions that included savepoints.
* Some INSERT INTO ... SELECT ... FROM statements were slow unless the tmp_table_size and max_heap_table_size system variables were set large enough to permit the temporary table used for query processing to be stored in the MEMORY storage engine.
* Incorrect reference counting in the range optimizer module resulted in potential for missing or duplicate rows in the query result set.
* Host names in grant tables are stored in lowercase, but mysql_install_db could fail to observe this convention, leading to accounts that could not be dropped with DROP USER.
* The server uses the ethernet hardware address for UUID generation, but made assumptions about the names of ethernet devices rather than querying the system for their names.
* Several issues identified by the Coverity static analysis tool were fixed. Thanks to Jan Staněk and Honza Horak for the patches.
* Missing va_end() calls were added to logging and UCS2 code. Thanks to Jan Staněk for the patch.
* MySQL did not compile on Mac OS X 10.9 (Mavericks).
* Killing a query that is performing a filesort operation resulted in an ER_SERVER_SHUTDOWN (Server shutdown in progess) error.

www.mysql.com

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )

Offline SiLæncer

  • Cheff-Cubie
  • *****
  • Beiträge: 158890
  • Ohne Input kein Output
    • DVB-Cube
PostgreSQL 9.3.2
« Antwort #269 am: 06 Dezember, 2013, 19:20 »
Whats new: >>

# Changes
* Fix VACUUM's tests to see whether it can update relfrozenxid
* Fix multiple bugs in MultiXactId freezing
* Fix initialization of pg_clog and pg_subtrans during hot standby startup
* Fix multiple bugs in update chain traversal
* Fix dangling-pointer problem in fast-path locking
* Fix assorted race conditions in timeout management
* Truncate pg_multixact contents during WAL replay
* Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing
* Fix full-table-vacuum request mechanism for MultiXactIds
* Fix race condition in GIN index posting tree page deletion
* Fix "unexpected spgdoinsert() failure" error during SP-GiST index creation
* Fix assorted bugs in materialized views
* Re-allow duplicate table aliases if they're within aliased JOINs
* Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT
* Fix planner's processing of non-simple-variable subquery outputs nested within outer joins
* Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses
* Fix planner crash with whole-row reference to a subquery
* Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees
* Fix premature deletion of temporary files
* Prevent intra-transaction memory leak when printing range values
* Fix memory leaks when reloading configuration files
* Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages
* Allow default arguments and named-argument notation for window functions
* Suppress trailing whitespace on each line when pretty-printing rules and views
* Fix possible read past end of memory in rule printing
* Fix array slicing of int2vector and oidvector values
* Return a valid JSON value when converting an empty hstore value to json
* Fix incorrect behaviors when using a SQL-standard, simple GMT offset timezone
* Prevent possible misbehavior when logging translations of Windows error codes
* Properly quote generated command lines in pg_ctl
* Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET
* Fix pg_isready to handle its -d option properly
* Fix parsing of WAL file names in pg_receivexlog
* Report out-of-disk-space failures properly in pg_upgrade
* Make ecpg search for quoted cursor names case-sensitively
* Fix ecpg's processing of lists of variables declared varchar
* Make contrib/lo defend against incorrect trigger definitions
* Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.

http://www.postgresql.org/

Arbeits.- Testrechner :

Intel® Core™ i7-6700 (4 x 3.40 GHz / 4.00 GHz)
16 GB (2 x 8 GB) DDR4 SDRAM 2133 MHz
250 GB SSD Samsung 750 EVO / 1 TB HDD
ZOTAC Geforce GTX 1080TI AMPExtreme Core Edition 11GB GDDR5
MSI Z170A PC Mate Mainboard
DVD-Brenner Laufwerk
Microsoft Windows 10 Home 64Bit

TT S2 3200 ( BDA Treiber 5.0.1.8 ) + Terratec Cinergy 1200 C ( BDA Treiber 4.8.3.1.8 )