Age | Commit message (Collapse) | Author | Files | Lines |
|
See http://dev.mysql.com/doc/mysql/en/News-4.0.23.html for the full
list of changes.
This update applies the fix for the mysqlaccess script symlink
vulnerability, bump BUILDLINK_RECOMMENDED.
|
|
* Use PTHREAD_AUTO_VARS=no to disable linking to libpthread all programs
and libraries, which is wrong.
* Set USE_LIBTOOL and GNU_CONFIGURE before including bsd.prefs.mk, so
the test for _OPSYS_MAX_CMDLEN is not skipped.
Bump PKGREVISION to each package respectively
(mysql-client and mysql4-client), closes PR pkg/28162 and PR pkg/28222.
|
|
Functionality added or changed:
* The --with-openssl option for configure now accepts a path
prefix as an argument. --with-openssl-includes and
--with-openssl-libs are still supported, but are needed only
to override the default values. (Bug #5494)
* Added new --without-man option to configure to suppress
building/installing the manual pages. (Bug #5379)
* InnoDB: New mysqld option --innodb-table-locks and session
variable innodb_table_locks (on by default). In applications
using AUTOCOMMIT=1, InnoDB's internal table locks can cause
deadlocks. You can set innodb_table_locks=0 in `my.cnf' to
remove that problem. See section 16.17 Restrictions on InnoDB
Tables. (Bug #3299, Bug #5998)
* InnoDB: Added the startup option and settable global variable
innodb_max_purge_lag for delaying INSERT, UPDATE and DELETE
operations when the purge operations are lagging. The default
value of this parameter is zero, meaning that there will not be
any delays. See section 16.13 Implementation of Multi-Versioning.
* InnoDB: Change error code to HA_ERR_ROW_IS_REFERENCED if we
cannot DROP a parent table because it is referenced by a FOREIGN
KEY constraint.
And a lot of bugfixes: http://dev.mysql.com/doc/mysql/en/News-4.0.22.html
|
|
|
|
All library names listed by *.la files no longer need to be listed
in the PLIST, e.g., instead of:
lib/libfoo.a
lib/libfoo.la
lib/libfoo.so
lib/libfoo.so.0
lib/libfoo.so.0.1
one simply needs:
lib/libfoo.la
and bsd.pkg.mk will automatically ensure that the additional library
names are listed in the installed package +CONTENTS file.
Also make LIBTOOLIZE_PLIST default to "yes".
|
|
|
|
|
|
so that PLIST wouldn't need to be updated on each pkg update
|
|
set, the packages contain extra security fixes, which are not part
of 3.23.51 distribution
NOTE: this is the last 3.23.x version with bundled mit-pthreads package;
any further upgrade would need some additional efford to keep the package
usable on NetBSD 1.6.x and older
Highlights of changes:
* Add missing <row> tags for mysqldump XML output.
* SHOW VARIABLES LIKE 'xxx' is now case-insensitive
* InnoDB now allows foreign key constraints to be added through the
ALTER TABLE syntax.
* InnoDB tables can now be set to automatically grow in size (autoextend).
* Changed name of server variables Com_show_master_stat to
Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.
* Changed handling of gethostbyname() to make the client library thread-safe
even if gethostbyname_r doesn't exist.
* If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED
columns, we will just drop the sign.
* many bugfixes
Full list of changes:
3.23.50:
* Fixed buffer overflow problem if someone specified a too long datadir
parameter to mysqld
* Add missing <row> tags for mysqldump XML output.
* Fixed problem with crash-me and gcc 3.0.4.
* Fixed that @@unknown_variable doesn't hang server.
* Added @@VERSION as a synonym for VERSION().
* SHOW VARIABLES LIKE 'xxx' is now case-insensitive.
* Fixed timeout for GET_LOCK() on HP-UX with DCE threads.
* Fixed memory allocation bug in the glibc library used to build Linux
binaries, which caused mysqld to die in 'free()'.
* Fixed SIGINT and SIGQUIT problems in mysql.
* Fixed bug in character table converts when used with big ( > 64K) strings.
* InnoDB now retains foreign key constraints through ALTER TABLE and
CREATE/DROP INDEX.
* InnoDB now allows foreign key constraints to be added through the
ALTER TABLE syntax.
* InnoDB tables can now be set to automatically grow in size (autoextend).
* Our Linux RPMS and binaries are now compiled with gcc 3.0.4, which should
make them a bit faster.
* Fixed some buffer overflow problems when reading startup parameters.
* Because of problems on shutdown we have now disabled named pipes on Windows
by default. One can enable named pipes by starting mysqld
with --enable-named-pipe.
* Fixed bug when using WHERE key_column = 'J' or key_column='j'.
* Fixed core-dump bug when using --log-bin with LOAD DATA INFILE without
an active database.
* Fixed bug in RENAME TABLE when used with lower_case_table_names=1 (default
on Windows).
* Fixed unlikely core-dump bug when using DROP TABLE on a table that was
in use by a thread that also used queries on only temporary tables.
* Fixed problem with SHOW CREATE TABLE and PRIMARY KEY when using 32 indexes.
* Fixed that one can use SET PASSWORD for the anonymous user.
* Fixed core dump bug when reading client groups from option files using
mysql_options().
* Memory leak (16 bytes per every corrupted table) closed.
* Fixed binary builds to use --enable-local-infile.
* Update source to work with new version of bison.
* Updated shell scripts to now agree with new POSIX standard.
* Fixed bug where DATE_FORMAT() returned empty string when used with GROUP BY.
3.23.51:
* Fix bug with closing tags missing slash for mysqldump XML output.
* Remove end space from ENUM values. (This fixed a problem with SHOW CREATE
TABLE.)
* Fixed bug in CONCAT_WS() that cut the result.
* Changed name of server variables Com_show_master_stat to
Com_show_master_status and Com_show_slave_stat to Com_show_slave_status.
* Changed handling of gethostbyname() to make the client library thread-safe
even if gethostbyname_r doesn't exist.
* Fixed core-dump problem when giving a wrong password string to GRANT.
* Fixed bug in DROP DATABASE with symlinked directory.
* Fixed optimisation problem with DATETIME and value outside DATETIME range.
* Removed Sleepycat's BDB doc files from the source tree, as they're not needed
(MySQL covers BDB in its own documentation).
* Fixed MIT-pthreads to compile with glibc 2.2 (needed for make dist).
* Fixed the FLOAT(X+1,X) is not converted to FLOAT(X+2,X). (This also affected
DECIMAL, DOUBLE and REAL types)
* Fixed the result from IF() is case in-sensitive if the second and third
arguments are case sensitive.
* Fixed core dump problem on OSF/1 in gethostbyname_r.
* Fixed that underflowed decimal fields are not zero filled.
* If we get an overflow when inserting '+11111' for DECIMAL(5,0) UNSIGNED
columns, we will just drop the sign.
* Fixed optimisation bug with ISNULL(expression_which_cannot_be_null) and
ISNULL(constant_expression).
* Fixed host lookup bug in the glibc library that we used with the 3.23.50
Linux-x86 binaries.
|
|
|
|
Bump PKGREVISION.
Fixes part of PR [pkg/19936].
|
|
* Don't give warning for statement that is only a comment; This is
needed for mysqldump --disable-keys to work.
* Fixed unlikely caching bug when doing a join without keys. In this case
the last used field for a table always returned NULL.
* Added options to make LOAD DATA LOCAL INFILE more secure.
* Added --xml option to mysqldump for producing XML output.
* Changed to use autoconf 2.52 (from autoconf 2.13)
* Fixed bug in complicated join with const tables.
* Added internal safety checks for InnoDB.
* Some InnoDB variables was always shown in SHOW VARIABLES as OFF on
high-byte-first systems (like sparc).
* Fixed problem with one thread using an InnoDB table and another thread
doing an ALTER TABLE on the same table. Before that, mysqld could crash
with an assertion failure in row0row.c, line 474.
* Tuned the InnoDB SQL optimizer to favor more often index searches over
table scans. SELECT queries will now also generally run faster on all
platforms.
* If MySQL binlogging is used, InnoDB now prints after crash recovery the
latest MySQL binlog name and the offset InnoDB was able to recover to.
This is useful, for example, when resynchronizing a master and a slave
database in replication.
* Added better error messages to help in installation problems of
InnoDB tables.
* One can now recover also MySQL temporary tables which have become
orphaned inside the InnoDB tablespace.
* InnoDB now prevents a FOREIGN KEY declaration where the signedness is
not the same in the referencing and referenced integer columns.
* Calling SHOW CREATE TABLE or SHOW TABLE STATUS could cause memory
corruption and make mysqld to crash. Especially at risk was mysqldump,
because it calls frequently SHOW CREATE TABLE.
* If inserts to several tables containing an auto-inc column were wrapped
inside one LOCK TABLES, InnoDB asserted in lock0lock.c.
* In 3.23.47 we allowed several NULLS in a UNIQUE secondary index for an
InnoDB table. But CHECK TABLE was not relaxed: it reports the table as
corrupt. CHECK TABLE no longer complains in this situation.
* SHOW GRANTS now shows REFERENCES instead of REFERENCE.
|
|
Summary of changes:
- removal of USE_GTEXINFO
- addition of mk/texinfo.mk
- inclusion of this file in package Makefiles requiring it
- `install-info' substituted by `${INSTALL_INFO}' in PLISTs
- tuning of mk/bsd.pkg.mk:
removal of USE_GTEXINFO
INSTALL_INFO added to PLIST_SUBST
`${INSTALL_INFO}' replace `install-info' in target rules
print-PLIST target now generate `${INSTALL_INFO}' instead of `install-info'
- a couple of new patch files added for a handful of packages
- setting of the TEXINFO_OVERRIDE "switch" in packages Makefiles requiring it
- devel/cssc marked requiring texinfo 4.0
- a couple of packages Makefiles were tuned with respect of INFO_FILES and
makeinfo command usage
See -newly added by this commit- section 10.24 of Packages.txt for
further information.
|
|
complete (and a too-long to be included here) ChangeLog can be found at:
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x
|
|
|