Changelog for DBI-monitor-3.21.30-rh50.1.i386.rpm :

* Tue May 12 1998 Antoni Pamies Olive - Update to 3.21.30- \'mysql\' now returns a exit code > 0 if the query returned an error.- Save of command line history to file in mysql client. by Tommy Larsen - Fixed problem with empty lines that was ignored in mysql.cc- Save the pid of the signal handler thread in the pid file instead of the pid of the main thread.- Added patch by tommyAATTvalley.ne.jp to support Japanese characters SJIS and UJIS.- Changed safe_mysqld to redirect startup messages to \'hostname\'.err instead of \'hostname\'.log to reclaim file space on \'mysqladmin refresh\'- enum() had always the first entry as default value.- ALTER TABLE wrote two entires to the update log.- sql_acc() now closes the mysql privilige tables after a reload to save table space and memory.- Changed LOAD DATA to use less memory with tables and blobs.- Sorting on a function which made a division / 0 produced a wrong set in some cases.- Fixed select problem with LEFT() when using the czech character set.- Fixed problem in isamchk; It couldn\'t repair a packed table in a very unusual case.- Selects with & or | (bit functions) failed on columns with NULL values.- When comparing a field = field, where one of the fields was a part key, only the length of the part key was compared.
* Mon Apr 20 1998 Antoni Pamies Olive - Update to 3.21.29a- LOCK TABLES + \'DELETE from table\' never removed locks properly.- Fixed problem when grouping on a OR function.- Fixed permission problem with umask() and creating new databases.- Fixed permission problem on result file with SELECT ... INTO OUTFILE...- Fixed problem in range optimizer (core dump) for a very complex query.- Fixed problem when using MIN(integer) or MAX(integer) in GROUP BY.- Fixed bug on Alpha when using integer keys. (Other keys worked on Alpha).- Fixed bug in WEEK(\"XXXX-xx-01\").
* Wed Apr 01 1998 Antoni Pamies Olive - Update to 3.21.28- Fixed socket permission (clients couldn\'t connect to unix socket on Linux).- Fixed bug in record caches; One could get \'Error from table handler: #\' on some OS from some queries.- Added user level locks: GET_LOCK(string,timeout), RELEASE_LOCK(string)- Added opened_tables to \'show status\'.- Changed connect timeout to 3 seconds to make it somewhat harder for crackers to kill mysqld trough telnet + TCP/IP.- Fixed bug in range optimizer when using: WHERE key_part_1 >= something and key_part_2 <= something_else- Changed configure for detection of FreeBSD 3.0 9803xx and above- WHERE with string-column-key = constant-string didn\'t always find all rows if the column had many values differing only with characters of the same sort value (like e and �).- Strings keys looked up with \'ref\' was not compared case sensitively.- Added umask() to make log_files non-readable for normal users.- Ignore users with old password (8 byte) on startup if not using --old-protocol.- select which matched all key fields returned the values in the same case as the matched values instead of the found values. (Minor problem)
* Thu Mar 12 1998 Antoni Pamies Olive - Update to 3.21.26- from_days(0) now returns \"0000-00-00\"- In DATE_FORMAT() PM and AM was swapped for hours 00 and 12.- Extended the default max key size to 256.- Fixed bug when using BLOB/TEXT in GROUP BY with many tables.- A enum field that is not declared NOT NULL has NULL as default value. (Before the default value was the first enum option)- Fixed bug in the join optimizer code when using many part keys on the same key: INDEX (Organisation,Surname(35),Initials(35)).- Added some tests to the table order optimizer to get some cases with \'SELECT ... FROM many_tables\' much faster.- Added a retry loop around accept() to possible fix some problems on some Linux machines.
* Wed Mar 04 1998 Antoni Pamies Olive - Remove -l from mysql.init- update spec
* Sat Feb 28 1998 Antoni Pamies Olive - Update to 3.21.25- Changed typedef \'string\' to \'my_string\' for better portability.- One can now kill threads that are waiting for \'disk full\'.- Fixed some problems with UDF functions.- Added long options for isamchk. Try isamchk --help.- Fixed a bug when using 8 bytes long (alpha); filesort() didn\'t work. Affects DISTINCT, ORDER BY and GROUP BY on 64 bit processors.
* Mon Feb 23 1998 Antoni Pamies Olive - Update to 3.21.24- Dynamic loadable functions. Based on source from Alexis Mikhailov.- One couldn\'t delete from a table if no one had done a select on the table.- Fixed problem with range optimizer which many OR\'s on key parts inside each other.- Recoded min() and max() to work properly with strings and HAVING.- Changed default umask for new files from 0664 to 0660.- Fixed problem with LEFT JOIN and constant expressions in the ON part.- Added Italian error messages from brennoAATT3cord.philips.nl- configure now works better on OSF1 (tested on 4.0D).- Added hooks to allow LIKE optimization with international character support.- Upgraded DBI to 0.93
* Thu Feb 12 1998 Antoni Pamies Olive - Change spec- Add ln -s /usr/lib/terminfo/ /usr/share/terminfo to post section
* Tue Feb 10 1998 Antoni Pamies Olive - Change spec
* Fri Feb 06 1998 Antoni Pamies Olive - Update to 3.21.23- Change spec in order to use mysql-readline- Fixed that the following symbols are not reserved words: TIME DATE TIMESTAMP TEXT BIT ENUM NO ACTION CHECK YEAR MONTH DAY HOUR MINUTE SECOND STATUS VARIABLES.- Setting a TIMSTAMP to NULL in LOAD DATA INFILE... didn\'t set the current time for the TIMESTAMP.- Fix that BETWEEN recognizes binary strings. Now BETWEEN is case sensitive.- Added switch --skip-thread-priority for systems where mysqld\'s thread scheduling doesn\'t work properly (BSDI 3.1).- Added ODBC functions DAYNAME() and MONTHNAME().- Added function TIME_FORMAT(). This works like DATE_FORMAT() but takes a time string (HH:MM:DD) as argument.- Fixed unlikely(?) key optimizer bug when using ORs of key parts inside ANDs.- Added command \'variables\' to mysqladmin.- A lot of small changes to the binary releases.- Fixed a bug in the new protocol from MySQL 3.21.20.- Changed ALTER TABLE to work with WIN32 (Win32 can\'t rename open files). Fixed also a couple of small bugs in the WIN32 version.- All standard MySQL clients are now ported to MySQL-win32.- MySQL can now be started as a service on NT.
* Fri Jan 30 1998 Antoni Pamies Olive - Starting with this version all MySQL distributions will be configured, compiled and tested with crash-me and the benchmarks on the following platforms: SunOS 5.6 sun4u, SunOS 5.5.1 sun4u, SunOS 4.14 sun4c, SunOS 5.6 i86pc, IRIX 6.3 mips5k, HP-UX 10.20 hppa, AIX 4.2.1 ppc, OSF1 V4.0 alpha, FreeBSD 2.2.2 i86pc and BSDI 3.1 i386.-Fix of count(
*) problems when the WHERE clause didn\'t match any records. (Bug from 3.21.17)-Removed that NULL = NULL is true. Now one must use IS NULL or IS NOT NULL to test if a value is NULL. (This is according to ANSI-SQL but may break old applications that are ported from mSQL) One can get the old behaviour by compiling with -DmSQL_COMPLIANT-Fixed bug that core dumped when using many LEFT OUTER JOIN\'s.-Fixed bug in ORDER BY on string formula with possible NULL values.-Fixed problem in range optimizer when <= on sub index.-Added functions DAYOFYEAR(), DAYOFMONTH(), MONTH(), YEAR(), WEEK(), QUARTER(), HOUR(), MINUTE(), SECOND() and FIND_IN_SET().-Added command SHOW VARIABLES.-Added support of \'long constant strings\' from ANSI SQL: select \'first \' \'second\'; -> \'first second\';-Upgraded mSQL-Mysql-modules to 1.1825-Upgraded mysqlaccess to 2.02-Fixed problem with Russian character set and LIKE.-Ported to openbsd 2.1-New Dutch error messages
* Fri Jan 16 1998 Antoni Pamies Olive - Upgraded to 3.21.21a
* Fri Jan 09 1998 Antoni Pamies Olive - New Spec
* Mon Jan 05 1998 Antoni Pamies Olive - Upgraded DBD to 1823. This version implements mysql_use_result in DBD-Mysql.- Benchmarks updated for empress (by Luuk)- Fixed a case of slow range searching.- Configure fixes (Docs directory).- Added function `REVERSE()\' (by Zeev Suraski)
* Fri Jan 02 1998 Antoni Pamies Olive - Change infodir to /usr/info- Give error message if client C functions are called in wrong order.- Added automatic reconnect to the libmysql.c library. If a write command fails a automatic reconnect is done.- Small sort sets doesn\'t use temporary files anymore.- Upgraded DBI to 0.91- Fixed a couple of problems with LEFT OUTER JOIN.- Added CROSS JOIN syntax. CROSS is now a reserved word.- Recoded yacc/bison stack allocation to be even safer and allow MySQL to handle even bigger expressions.- Fixed a couple of problems with the update log.- ORDER BY was slow when used with key ranges.
* Mon Dec 22 1997 Antoni Pamies Olive - update to mysql 3.21.17a beta- Changed documentation string of -with-unix-socket-path to avoid confusion.- Added ODBC and ANSI SQL style `LEFT OUTER JOIN\'.- The following are new reserved words: `LEFT\', `NATURAL\', `USING\'- The client library is now using the environment variable `MYSQL_HOST\' as the default host if it\'s defined.- `SELECT column, SUM(expr)\' now returns `NULL\' for column when there is no matching rows.- Fixed problem with compare of binary strings and blobs with ASCII characters over 127.- Fixed lock problem: When freeing a read lock on a table with multiple read locks, a thread waiting for write lock would have given the lock. This shouldn\'t affect data integrity, but could possible make mysqld to restart if one thread was reading data that another thread modified.- LIMIT offset,count didn\'t work in INSERT ... SELECT.- optimized key block caching. This will be quicker than the old one when using bigger key caches.
* Fri Dec 12 1997 Antoni Pamies Olive - mv /sql-bench to /var/lib/sql-bench- new spec (sparc & alpha support)
* Thu Dec 11 1997 Antoni Pamies Olive - update to mysql 3.21.16a beta- new beta spec- Added ODBC 2.0 & 3.0 functions: POWER(), SPACE(), COT(), DEGREES(), RADIANS(), ROUND(2 arg) and TRUNCATE().- LOCATE() parameters where swapped according to ODBC standard. Fixed.- Added function TIME_TO_SEC()- In some cases default values was not used for NOT NULL fields.- Timestamp wasn\'t updated in UPDATE SET... if the timestamp was used as- Allow empty strings as default values for BLOB and TEXT to be compatible with mysqldump.