Copyright (C) 2000-2012 |
GNU Info (mysql.info)News-3.20.3Changes in release 3.20.3 ------------------------- * The `configure' source now compiles a thread-free client library `-lmysqlclient'. This is the only library that needs to be linked with client applications. When using the binary releases, you must link with `-lmysql -lmysys -ldbug -lstrings' as before. * New `readline' library from `bash-2.0'. * LOTS of small changes to `configure' and makefiles (and related source). * It should now be possible to compile in another directory using `VPATH'. Tested with GNU Make 3.75. * `safe_mysqld' and `mysql.server' changed to be more compatible between the source and the binary releases. * `LIMIT' now takes one or two numeric arguments. If one argument is given, it indicates the maximum number of rows in a result. If two arguments are given, the first argument indicates the offset of the first row to return, the second is the maximum number of rows. With this it's easy to do a poor man's next page/previous page WWW application. * Changed name of SQL function `FIELDS()' to `ELT()'. Changed SQL function `INTERVALL()' to `INTERVAL()'. * Made `SHOW COLUMNS' a synonym for `SHOW FIELDS'. Added compatibility syntax `FRIEND KEY' to `CREATE TABLE'. In MySQL, this creates a non-unique key on the given columns. * Added `CREATE INDEX' and `DROP INDEX' as compatibility functions. In MySQL, `CREATE INDEX' only checks if the index exists and issues an error if it doesn't exist. `DROP INDEX' always succeeds. * `mysqladmin.c': added client version to version information. * Fixed core dump bug in `sql_acl' (core on new connection). * Removed `host', `user' and `db' tables from database `test' in the distribution. * `FIELD_TYPE_CHAR' can now be signed (-128 - 127) or unsigned (0 - 255) Previously, it was always unsigned. * Bug fixes in `CONCAT()' and `WEEKDAY()'. * Changed a lot of source to get `mysqld' to be compiled with SunPro compiler. * SQL functions must now have a `'('' immediately after the function name (no intervening space). For example, `'user('' is regarded as beginning a function call, and `'user ('' is regarded as an identifier `user' followed by a `'('', not as a function call. automatically generated by info2www version 1.2.2.9 |