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
,TIME
orTIMESTAMP
. :( Old columns can still be accessed throughtablename.columnname
!) - Changed Makefiles to hopefully work better with BSD systems. Also,
manual.dvi
is now included in the distribution to avoid having stupidmake
programs trying to rebuild it. readline
library upgraded to version 2.1.- A new sortorder german-1. That is a normal ISO-Latin1 with a german sort order.
- Perl
DBI
/DBD
is now included in the distribution.DBI
is now the recommended way to connect to MariaDB from Perl. - New portable benchmark suite with
DBD
, with test results frommSQL
2.0.3, MySQL, PostgreSQL 6.2.1 and Solid server 2.2. crash-me
is 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
MariaDB
command-line tool, by Zeev Suraski and Andi Gutmans. - Added new command
REPLACE
that works likeINSERT
but replaces conflicting records with the new record.REPLACE INTO TABLE ... SELECT ...
works also. - Added new commands
CREATE DATABASE db_name
andDROP DATABASE db_name
. - Added
RENAME
option toALTER TABLE
:ALTER TABLE name RENAME TO new_name
. make_binary_distribution
now includeslibgcc.a
inlibmysqlclient.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
bison
memory overrun checking to make MariaDB safer with weird queries.