mysql 5.1.31sp1 64位_MySQL 5.1 英文手册 :: C.1.18 Release Notes for MySQL Enterprise 5.1.34sp1 [QSP] (25 ...

MySQL 5.1.31sp1 64位版本存在一些已知问题,包括JOIN_TAB清理不完全导致的GROUP BY子查询文件排序崩溃,HANDLER语句与INFORMATION_SCHEMA表结合使用时的服务器崩溃,以及在64位系统中超过4GB key_buffer_size可能导致的MyISAM索引损坏等。此外,还修复了浮动点值插入CHAR列、libmysqld初始化崩溃、某些语句可能导致的死锁以及XML函数错误结果等问题。
摘要由CSDN通过智能技术生成

Incomplete cleanup of JOIN_TAB::select during

the filesort of rows for a GROUP BY clause

inside a subquery caused a server crash.

(Bug#44290)

Use of HANDLER statements with

INFORMATION_SCHEMA tables caused a server

crash. Now HANDLER is prohibited

with such tables.

(Bug#44151)

On 64-bit systems, a

key_buffer_size value larger

than 4GB could couse MyISAM index corruption.

(Bug#43932)

On Windows, a server crash occurred for attempts to insert a

floating-point value into a CHAR

column with a maximum length less than the converted

floating-point value length.

(Bug#43833)

libmysqld crashed when it was reinitialized.

(Bug#43706, Bug#44091)

Certain statements might open a table and then wait for an

impending global read lock without noticing whether they hold a

table being waiting for by the global read lock, causing a hang.

Affected statements are

SELECT ... FOR

UPDATE,

LOCK TABLES ...

WRITE, TRUNCATE TABLE,

and LOAD DATA

INFILE.

(Bug#43230)

Using an XML function such as ExtractValue()

more than once in a single query could produce erroneous

results.

(Bug#43183)

See also Bug#43937.

Incorrect elevation of warning messages to error messages for

unsafe statements caused a server crash.

(Bug#42640)

In an UPDATE or

DELETE via a secondary index,

InnoDB did not store the cursor position.

This made InnoDB crash in semi-consistent

read while attempting to unlock a nonmatching record.

(Bug#39320)

The functions listed in

Section 11.13.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”, previously

accepted WKB arguments and returned WKB values. They now accept

WKB or geometry arguments and return geometry values.

The functions listed in Section 11.13.4.2.2, “Creating Geometry Values Using WKB Functions”,

previously accepted WKB arguments and returned geometry values.

They now accept WKB or geometry arguments and return geometry

values.

(Bug#38990)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值