Alterações na distribuição 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
readlinelibrary frombash-2.0. - LOTS of small changes to
configureand makefiles (and related source). - It should now be possible to compile in another directory using
VPATH. Tested with GNU Make 3.75. safe_mysqldandmysql.serverchanged to be more compatible between the source and the binary releases.LIMITnow 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()toELT(). Changed SQL functionINTERVALL()toINTERVAL(). - Made
SHOW COLUMNSa synonym forSHOW FIELDS. Added compatibility syntaxFRIEND KEYtoCREATE TABLE. In MySQL, this creates a non-unique key on the given columns. - Added
CREATE INDEXandDROP INDEXas compatibility functions. In MySQL,CREATE INDEXonly checks if the index exists and issues an error if it doesn't exist.DROP INDEXalways succeeds. mysqladmin.c: added client version to version information.- Fixed core dump bug in
sql_acl(core on new connection). - Removed
host,useranddbtables from databasetestin the distribution. FIELD_TYPE_CHARcan now be signed (-128 to 127) or unsigned (0 to 255) Previously, it was always unsigned.- Bug fixes in
CONCAT()andWEEKDAY(). - Changed a lot of source to get
mysqldto 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 identifierUSERfollowed by a'(', not as a function call.