D.7.13 Changes 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 -lmystrings 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 to 127) or unsigned (0 to 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.

User Comments

Add your own comment.