Alterações na distribuição 3.23.11
Allow the ALTER TABLE tbl_name ADD (field_list)
syntax.
- Fixed problem with optimiser that could sometimes use incorrect keys.
- Fixed that
GRANT/REVOKE ALL PRIVILEGES
doesn't affectGRANT OPTION
. - Removed extra '
)
' from the output ofSHOW GRANTS
. - Fixed problem when storing numbers in timestamps.
- Fix problem with timezones that have half hour offsets.
- Allow the syntax
UNIQUE INDEX
inCREATE
statements. mysqlhotcopy
- fast online hot-backup utility for local MariaDB databases. By Tim Bunce.- New more secure
mysqlaccess
. Thanks to Steve Harvey for this. - Added
--i-am-a-dummy
and--safe-updates
options toMariaDB
. - Added
select_limit
andmax_join_size
variables toMariaDB
. - Added
SQL_MAX_JOIN_SIZE
andSQL_SAFE_UPDATES
options. - Added
READ LOCAL
lock that doesn't lock the table for concurrent inserts. (This is used bymysqldump
.) - Changed that
LOCK TABLES ... READ
doesn't anymore allow concurrent inserts. - Added
--skip-delay-key-write
option tomysqld
. - Fixed security problem in the protocol regarding password checking.
_rowid
can now be used as an alias for an integer type unique indexed column.- Added back blocking of
SIGPIPE
when compiling with--thread-safe-clients
to make things safe for old clients.