Alterações na distribuição 3.21.23
The following symbols are now reserved words: TIME
, DATE
, TIMESTAMP
, TEXT
, BIT
, ENUM
, NO
, ACTION
, CHECK
, YEAR
, MONTH
, DAY
, HOUR
, MINUTE
, SECOND
, STATUS
, VARIABLES
.
- Setting a
TIMESTAMP
toNULL
inLOAD DATA INFILE ...
didn't set the current time for theTIMESTAMP
. - Fix
BETWEEN
to recognise binary strings. NowBETWEEN
is case-sensitive. - Added
--skip-thread-priority
option tomysqld
, for systems wheremysqld
's thread scheduling doesn't work properly (BSDI 3.1). - Added ODBC functions
DAYNAME()
andMONTHNAME()
. - Added function
TIME_FORMAT()
. This works likeDATE_FORMAT()
, but takes a time string ('HH:MM:SS'
) as argument. - Fixed unlikely(?) key optimiser bug when using
OR
operators of key parts insideAND
expressions. - Added
variables
command tomysqladmin
. - A lot of small changes to the binary releases.
- Fixed a bug in the new protocol from MariaDB Version 3.21.20.
- Changed
ALTER TABLE
to work with Windows (Windows can't rename open files). Also fixed a couple of small bugs in the Windows version. - All standard MariaDB clients are now ported to MariaDB for Windows.
- MySQL can now be started as a service on NT.