summaryrefslogtreecommitdiff
path: root/databases/mysql-server
AgeCommit message (Collapse)AuthorFilesLines
2004-01-22replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.grant1-2/+2
2004-01-07Rework patch-al to let it compile on !NetBSD platforms.cube2-6/+6
2003-10-05Updated mysql-server to 3.23.58martti19-478/+85
A lot of bug and security fixes since 3.23.51...
2003-09-28make mysql 3.23.51 compile on 1.6.x, which uses bundled mit-pthreadsjdolecek2-1/+15
fixes PR pkg/22988 by Adrian Portelli
2003-09-28Update mysql-client and mysql-server to 3.23.51nb1 - pkg revision keptjdolecek4-17/+17
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.
2003-09-19Bumping once is enough, oops.wiz1-2/+2
2003-09-19Do the chown of MYSQL_DATADIR to MYSQL_USER:MYSQL_GROUP automatically inwiz1-2/+2
the install file instead of only mentioning it in MESSAGE. Closes PR 22197. tron says ok.
2003-09-19Do the chown of MYSQL_DATADIR to MYSQL_USER:MYSQL_GROUP automatically inwiz3-9/+7
the install file instead of only mentioning it in MESSAGE. Closes PR 22197. tron says ok. Bump PKGREVISION.
2003-09-18Add missing ../ in path to included file.wiz1-2/+2
2003-09-18Specify the category when including other files and when depending on otherjmmv1-2/+2
packages. From PR pkg/21864 by ccatrian at eml.cc.
2003-09-17Update to nb5: Add patch fromwiz3-3/+17
http://lists.netsys.com/pipermail/full-disclosure/2003-September/009819.html against a vulnerability.
2003-09-01DEINSTALL script was removed.seb1-2/+1
2003-08-30Add definitions for DEINSTALL_EXTRA_TMPL and INSTALL_EXTRA_TMPL ifjlam1-2/+5
USE_PKGINSTALL is "YES". bsd.pkg.install.mk will no longer automatically pick up a INSTALL/DEINSTALL script in the package directory and assume that you want it for the corresponding *_EXTRA_TMPL variable.
2003-08-30We don't need it anymore, really, the usage of OWNS_DIRS_PERMSseb1-16/+0
take care of signaling the user deleting the pkg...
2003-08-30Prepare for pkgviews by making sure that passing VIEW-INSTALL orjlam2-6/+20
VIEW-DEINSTALL to the INSTALL/DEINSTALL scripts don't cause errors.
2003-08-30Use the potential of bsd.pkg.install.mk:seb3-54/+3
- Remove extraneous bits in the INSTALL script snippet and let the framework execute the script at post-install time. - Use OWN_DIRS_PERMS instead of MAKE_DIRS_PERMS for ${MYSQL_DATADIR} thus save a DEINSTALL script snippet and its handling.
2003-08-24Bump package revision of mysql-client and mysql-server withtaca1-2/+2
introducing MYSQL_CHARSET and MYSQL_EXTRA_CHARSET.
2003-06-13Fix typo in ONLY_FOR_PLATFORM: s/NetBSD-arm/NetBSD-*-arm/abs1-2/+2
2003-06-11Update for the fact that 'arm' ports have been called NetBSD-*-arm for a whileabs1-3/+4
now and not NetBSD-*-arm32. Changes include one or more of: - Change MACHINE_ARCH == arm32 to also match arm - Where ONLY_FOR_PLATFORM includes NetBSD-*-arm32, add NetBSD-*-arm - Where BROKEN or worked around for arm gcc bugs, set USE_GCC3 The last may shake out a few more broken packages the next bulk build.
2003-05-06Drop trailing whitespace. Ok'ed by wiz.jmmv1-2/+2
2003-04-21lintcjep1-0/+5
2003-03-24remove unnecessary parens and indent some conditionals forgrant1-7/+5
readability purposes. whitespace police.
2003-02-09attempt to clarify password instructionslukem1-5/+7
2003-01-31oops, share/mysql/mysql.server was missinglukem1-1/+2
2003-01-29add explicit reminder about ${MYSQL_DATADIR} ownershiplukem2-1/+8
2003-01-28Instead of including bsd.pkg.install.mk directly in a package Makefile,jlam1-2/+3
have it be automatically included by bsd.pkg.mk if USE_PKGINSTALL is set to "YES". This enforces the requirement that bsd.pkg.install.mk be included at the end of a package Makefile. Idea suggested by Julio M. Merino Vidal <jmmv at menta.net>.
2003-01-21also need to set the "mysql root" password on -h `hostname`lukem1-1/+3
2003-01-21install bin/mysql.server for people who won't or can't use etc/rc.d/mysqld.lukem4-7/+9
fixes rest of [pkg/19936].
2003-01-21- add rc.d script; based on [pkg/19055], with rework by me.lukem8-11/+153
- add support for MYSQL_USER and MYSQL_GROUP (user & group to run database as) - change ownership of $MYSQL_DATADIR to ${MYSQL_USER}:${MYSQL_GROUP} 700 - fix safe_mysqld to send all output to the error log and to NOT output random messages to the tty it was started on. - display a MESSAGE reminding people to change the password of the mysql 'root' user. - bump PKGREVISION (to 3.23.49nb2)
2003-01-20use native pthreads on NetBSD, if availablejdolecek1-9/+19
the explicit exits(/usr/include/pthread.h) here is not ideal, but this pkg didn't use pthread.buildlink2.mk before
2003-01-20need to include <signal.h> in my_pthread.h to be compilablejdolecek2-1/+14
with native NetBSD threads - header uses sigset_t and not all sources pulling the header pull <signal.h> before my_pthread.h
2003-01-03this needs gmake to build...lukem1-1/+2
2002-12-13Fix security problem in MySQL client library and server which weretron3-5/+30
recently discovered by e-matters.
2002-09-20buildlink1 -> buildlink2 and move the USE_BUILDLINK2 definition to thejlam1-6/+4
common Makefile.
2002-08-23databases/myslq-server appears to work fine on Linux as well, so addjschauma1-2/+2
Linux-*-* to the list of ONLY_FOR_PLATFORMs.
2002-06-16Depend on mysql-client>=3.23.49.wiz1-2/+2
2002-06-03Make included MIT pthread library build under NetBSD 1.6.tron2-1/+42
2002-04-14Now, fix PR pkg/16038 for real. Remember to do a clean build after addingveego2-6/+6
a patch, a Makefile could be overwritten by a Makefile.in. So we have to patch Makefile.in and not the Makefile.
2002-04-11Ahh, the pitfalls of including bsd.*.mk. Keep up with NetBSD-1.5ZC, andfredb2-1/+14
don't install libpthread.a there, either. Closes PR pkg/16038.
2002-04-11Prefix register names with '%' in included mit-pthreads to let this buildfredb4-1/+160
on current/m68k (plus minor clean-ups: a paste-o and whitespace).
2002-03-25Adjust syscalls-powerpc-netbsd.S so it will build correctly again.briggs2-1/+128
Problem reported on port-macppc by Ryan La Riviere <larz@cbis.ece.drexel.edu>.
2002-03-18Updated mysql-server to 3.23.49martti4-18/+18
* 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.
2002-01-08Updated mysql-{client,server} to 3.23.47. This is a bug-fix release, amartti4-18/+18
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
2001-11-02Strongly buildlinkify. Note dependency on tcp_wrappers for platformsjlam4-33/+13
without -lwrap. Also prevent finding any existing Berkeley DB 3.x in /usr/local.
2001-11-01Oops, back out previous. This locally modified file wasn't supposedzuntum1-2/+2
to be checked in.
2001-11-01Move pkg/ files into package's toplevel directoryzuntum5-5/+5
2001-10-18SVR4 packages have a limit of 9 chars for a package name.veego1-1/+2
The automatic truncation in gensolpkg doesn't work for packages which have the same package name for the first 5-6 chars. e.g. amanda-server and amanda-client would be named amanda and amanda. Now, we add a SVR4_PKGNAME and use amacl for amanda-client and amase for amanda-server. All svr4 packages also have a vendor tag, so we have to reserve some chars for this tag, which is normaly 3 or 4 chars. Thats why we can only use 6 or 5 chars for SVR4_PKGNAME. I used 5 for all the packages, to give the vendor tag enough room. All p5-* packages and a few other packages have now a SVR4_PKGNAME.
2001-10-08Fix a build problem with the new toolchain, where you would get:veego2-1/+19
mysqld.cc:2268: implicit declaration of function `int select(...)' Patch from Christoph Badura.
2001-10-08Update mysql to 3.23.43.veego8-167/+19
- mysqlbinlog moved from the mysql-server to the mysql-client package - some pkgsrc patches are now part of the mysql distribution. Changes in release 3.23.43 -------------------------- * Fixed a bug in INSERT DELAYED and FLUSH TABLES introduced in 3.23.42. * Fixed unlikely bug, which returned not matching rows, in SELECT with many tables and multi-column indexes and 'range' type. * Fixed a unlikely core-dump bug when doing EXPLAIN SELECT when using many tables and ORDER BY. * Fixed bug in LOAD DATA FROM MASTER when using table with CHECKSUM=1. * Added unique error message when one gets a DEADLOCK during a transaction with BDB tables. * Fixed problem with BDB tables and UNIQUE columns defined as NULL. * Fixed problem with myisampack when using pre-space filled CHAR columns. * Applied patch from Yuri Dario for OS2. * Fixed bug in --safe-user-create Changes in release 3.23.42 -------------------------- * Fixed problem when using LOCK TABLES and BDB tables. * Fixed problem with REPAIR TABLE on MyISAM tables with row lengths between 65517 - 65520 bytes * Fixed rare hang when doing mysqladmin shutdown when there was a lot of activity in other threads. * Fixed problem with INSERT DELAYED where delay thread could be hanging on upgrading locks without any apparent reasons. * Fixed problem with myisampack and BLOB. * Fixes problem when one edited .MRG tables by hand. (Patch from Benjamin Pflugmann). * Enforce that all tables in a MERGE table come from the same database. * Fixed bug with LOAD DATA INFILE and transactional tables. * Fix bug when using INSERT DELAYED with wrong column definition. * Fixed coredump during REPAIR of some particularly broken tables. * Fixed bug in InnoDB and AUTO_INCREMENT columns. * Fixed bug in InnoDB and RENAME TABLE columns. * Fixed critical bug in InnoDB and BLOB columns. If one has used BLOB columns larger than 8000 bytes in an InnoDB table, one must dump the table with mysqldump, drop it and restore it from the dump. * Applied large patch for OS/2 from Yuri Dario. * Fixed problem with InnoDB when one could get the error Can't execute the given command... even when one didn't have an active transaction. * Applied some minor fixes that concern Gemini. * Use real arithmetic operations even in integer context if not all arguments are integers. (Fixes uncommon bug in some integer contexts). * Don't force everything to lower cases on Windows. (To fix problem with Windows and ALTER TABLE). Now --lower_case_names also works on Unix. * Fixed that automatic rollback that is done when thread end doesn't lock other threads. Changes in release 3.23.41 -------------------------- * Added option --sql-mode=option[,option[,option]]. See section 4.1.1 mysqld Command-line Options. * Fixed possible problem with shutdown on Solaris where the `.pid' file wasn't deleted. * InnoDB now supports < 4 GB rows. The former limit was 8000 bytes. * The doublewrite file flush method is used in InnoDB. It reduces the need for Unix fsync calls to a fraction and improves performance on most Unix flavors. * You can now use the InnoDB Monitor to print a lot of InnoDB state information, including locks, to the standard output; useful in performance tuning. * Several bugs which could cause hangs in InnoDB have been fixed. * Split record_buffer to record_buffer and record_rnd_buffer. To make things compatible to previous MySQL versions, if record_rnd_buffer is not set, then it takes the value of record_buffer. * Fixed optimizing bug in ORDER BY where some ORDER BY parts where wrongly removed. * Fixed overflow bug with ALTER TABLE and MERGE tables. * Added prototypes for my_thread_init() and my_thread_end() to `mysql_com.h' * Added option --safe-user-create to mysqld. * Fixed bug in SELECT DISTINCT ... HAVING that casued error message Can't find record in '#... Changes in release 3.23.40 -------------------------- * Fixed problem with --low-priority-updates and INSERT's. * Fixed bug in slave thread when under some rare circumstances it could get 22 bytes ahead on the offset in the master. * Added slave_wait_timeout for replication. * Fixed problem with UPDATE and BDB tables. * Fixed hard bug in BDB tables when using key parts. * Fixed problem when using the GRANT FILE ON database.* ...; Previously we added the DROP privilege for the database. * Fixed DELETE FROM table_name ... LIMIT 0 and UPDATE FROM table_name ... LIMIT 0 acted as though the LIMIT clause was not present (they deleted or updated all selected rows). * CHECK TABLE now checks if an AUTO_INCREMENT column contains the value 0. * Sending a SIGHUP to mysqld will now only flush the logs, not reset the replication. * Fixed parser to allow floats of type 1.0e1 (no sign after e). * Option --force to myisamchk now also updates states. * Added option --warnings to mysqld. Now mysqld only prints the error Aborted connection if this option is used. * Fixed problem with SHOW CREATE TABLE when you didn't have a PRIMARY KEY. * Properly fixed the rename of innodb_unix_file_flush_method to innodb_flush_method. * Fixed bug when converting UNSIGNED BIGINT to DOUBLE. This caused a problem when doing comparisons with BIGINT values outside of the signed range. * Fixed bug in BDB tables when querying empty tables. * Fixed a bug when using COUNT(DISTINCT) with LEFT JOIN and there wasn't any matching rows. * Removed all documentation referring to the GEMINI table type. GEMINI is not released under an Open Source license.
2001-07-08Change the patch to only do this #ifdef __NetBSD__.bad2-9/+13
generated by cgit v1.2.3 (git 2.39.1) at 2024-08-04 14:50:23 +0000