Alterações na distribuição 3.21.15
Warning: Incompatible change! mysqlperl is now from Msql-Mysql-modules. This means that connect() now takes host, database, user, password arguments! The old version took host, database, password, user.
- Allow
DATE '1997-01-01',TIME '12:10:10'andTIMESTAMP '1997-01-01 12:10:10'formats required by SQL-99. Warning: Incompatible change! This has the unfortunate side-effect that you no longer can have columns namedDATE,TIMEorTIMESTAMP. :( Old columns can still be accessed throughtablename.columnname!) - Changed Makefiles to hopefully work better with BSD systems. Also,
manual.dviis now included in the distribution to avoid having stupidmakeprograms trying to rebuild it. readlinelibrary upgraded to version 2.1.- A new sortorder german-1. That is a normal ISO-Latin1 with a german sort order.
- Perl
DBI/DBDis now included in the distribution.DBIis now the recommended way to connect to MariaDB from Perl. - New portable benchmark suite with
DBD, with test results frommSQL2.0.3, MySQL, PostgreSQL 6.2.1 and Solid server 2.2. crash-meis now included with the benchmarks; this is a Perl program designed to find as many limits as possible in an SQL server. Tested withmSQL, PostgreSQL, Solid and MySQL.- Fixed bug in range-optimiser that crashed MariaDB on some queries.
- Table and column name completion for
MariaDBcommand-line tool, by Zeev Suraski and Andi Gutmans. - Added new command
REPLACEthat works likeINSERTbut replaces conflicting records with the new record.REPLACE INTO TABLE ... SELECT ...works also. - Added new commands
CREATE DATABASE db_nameandDROP DATABASE db_name. - Added
RENAMEoption toALTER TABLE:ALTER TABLE name RENAME TO new_name. make_binary_distributionnow includeslibgcc.ainlibmysqlclient.a. This should make linking work for people who don't havegcc.- Changed
net_write()tomy_net_write()because of a name conflict with Sybase. - New function
DAYOFWEEK()compatible with ODBC. - Stack checking and
bisonmemory overrun checking to make MariaDB safer with weird queries.