summaryrefslogtreecommitdiff
path: root/databases/mysql55-server
diff options
context:
space:
mode:
authoradam <adam>2011-07-28 08:10:29 +0000
committeradam <adam>2011-07-28 08:10:29 +0000
commit5739785828c85f7427b40c923d770f852dd047c7 (patch)
tree8c013be5da29709f6c03e83cb1ab0b118b90a41d /databases/mysql55-server
parent4243fdfd739c9a19e7cc5d0b7c5f91e9b8c654f3 (diff)
downloadpkgsrc-5739785828c85f7427b40c923d770f852dd047c7.tar.gz
Changes 5.5.15:
* The undocumented --all option for perror is deprecated and will be removed in MySQL 5.6. Bugs Fixed: * InnoDB Storage Engine: A failed CREATE INDEX operation for an InnoDB table could result in some memory being allocated and not freed. This memory leak could affect tables created with the ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED settings. * Partitioning: Auto-increment columns of partitioned tables were checked even when they were not being written to. In debug builds, this could lead to a crash of the server. * Partitioning: The UNIX_TIMESTAMP() function was not treated as a monotonic function for purposes of partition pruning. * Replication: If a LOAD DATA INFILE statement—replicated using statement-based replication—featured a SET clause, the name-value pairs were regenerated using a method (Item::print()) intended primarily for generating output for statements such as EXPLAIN EXTENDED, and which cannot be relied on to return valid SQL. This could in certain cases lead to a crash on the slave. * To fix this problem, we now name each value in its original, user-supplied form, and use that to create LOAD DATA INFILE statements for statement-based replication. * Previously, an inappropriate error message was produced if a multiple-table update for an InnoDB table with a clustered primary key would update a table through multiple aliases, and perform an update that may physically move the row in at least one of these aliases. Now the error message is: Primary key/partition key update is not allowed since the table is updated both as 'tbl_name1' and 'tbl_name2' * ALTER TABLE {MODIFY|CHANGE} ... FIRST did nothing except rename columns if the old and new versions of the table had exactly the same structure with respect to column data types. As a result, the mapping of column name to column data was incorrect. The same thing happened for ALTER TABLE DROP COLUMN, ADD COLUMN statements intended to produce a new version of table with exactly the same structure as the old version. * Incorrect handling of metadata locking for FLUSH TABLES WITH READ LOCK for statements requiring prelocking caused two problems: * Execution of any data-changing statement that required prelocking (that is, involved a stored function or trigger) as part of transaction slowed down somewhat all subsequent statements in the transaction. Performance in a transaction that periodically involved such statements gradually degraded over time.
Diffstat (limited to 'databases/mysql55-server')
-rw-r--r--databases/mysql55-server/PLIST4
1 files changed, 3 insertions, 1 deletions
diff --git a/databases/mysql55-server/PLIST b/databases/mysql55-server/PLIST
index 94a5dc644f6..4a3b1ca1e08 100644
--- a/databases/mysql55-server/PLIST
+++ b/databases/mysql55-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2011/07/08 09:32:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2011/07/28 08:10:29 adam Exp $
bin/innochecksum
bin/my_print_defaults
bin/myisam_ftdump
@@ -1007,6 +1007,7 @@ share/mysql/test/r/mysql.result
share/mysql/test/r/mysql_client_test.result
share/mysql/test/r/mysql_comments.result
share/mysql/test/r/mysql_cp932.result
+share/mysql/test/r/mysql_embedded.result
share/mysql/test/r/mysql_locale_posix.result
share/mysql/test/r/mysql_not_windows.result
share/mysql/test/r/mysql_protocols.result
@@ -5821,6 +5822,7 @@ share/mysql/test/t/mysql_cp932.test
share/mysql/test/t/mysql_delimiter.sql
share/mysql/test/t/mysql_delimiter_19799.sql
share/mysql/test/t/mysql_delimiter_source.sql
+share/mysql/test/t/mysql_embedded.test
share/mysql/test/t/mysql_locale_posix.test
share/mysql/test/t/mysql_not_windows.test
share/mysql/test/t/mysql_protocols.test