database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL News 22424 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 22424
MySQL 4.0.21 Released (2004년 9월 06일)
작성자
강병기(asfreeas)
작성일
2004-09-20 23:48ⓒ
2004-09-20 23:48ⓜ
조회수
11,199

  • 추가 또는 변경된 함수
    • Print version_comment (from ./configure --comment during compilation) when starting the server. E.g.: Version: '4.0.21-debug' socket: '/tmp/mysql.sock' port: 0 Official MySQL Binary
    • Made the MySQL server not react to signals SIGHUP and SIGQUIT on Mac OS X 10.3. This is needed because under this OS, the MySQL server receives lots of these signals (reported as Bug #2030).
    • On Windows, the mysqld-nt and mysqld-max-nt servers now write error messages to the Windows event log in addition to the MySQL error log.
  • 버그픽스
    • Fixed an old bug in concurrent accesses to MERGE tables (even one MERGE table and MyISAM tables), that could've resulted in a crash or hang of the server. (Bug #2408)
    • Fixed a bug that caused incorrect results from GROUP BY queries with expression in HAVING clause that refers to a BLOB (TEXT, TINYBLOB, etc) fields. (Bug #4358)
    • Fixed a bug when memory was not released when HEAP table is dropped. It could only happen on Windows when a symlink file (.sym) is used and if that symlink file contained double backslashes (\\). (Bug #4973)
    • Fixed a bug which prevented TIMESTAMP(19) fields from being created. (Bug #4491)
    • Fixed a bug that caused wrong results in queries that were using index to search for NULL values in BLOB (TINYBLOB, TEXT, TINYTEXT, etc) columns of MyISAM tables. (Bug #4816)
    • Fixed a bug in the function ROUND() reporting incorrect metadata (number of digits after the decimal point). It can be seen, for example, in CREATE TABLE t1 SELECT ROUND(1, 34). (Bug #4393)
    • Fixed precision loss bug in some mathematical functions such as SQRT() and LOG(). (Bug #4356)
    • Fixed a long-standing problem with LOAD DATA with the LOCAL option. The problem occurs when an error happens during the LOAD DATA operation. Previously, the connection was broken. Now the error message is returned and connection stays open.
    • Optimizer now treats col IN (val) the same way it does for col = val.
    • Fixed a problem with net_buffer_length when building the DBD::mysql Perl module. (Bug #4206)
    • lower_case_table_names=2 (keep case for table names) was not honored with ALTER TABLE and CREATE/DROP INDEX. (Bug #3109)
    • Fixed a crash on declaration of DECIMAL(0,...) column. (Bug #4046)
    • Fixed a bug in IF() function incorrectly determining the result type if aggregate functions were involved. (Bug #3987)
    • Fixed bug in privilege checking where, under some conditions, one was able to grant privileges on the database, he has no privileges on. (Bug #3933)
    • Fixed crash in MATCH ... AGAINST() on a phrase search operator with a missing closing double quote. (Bug #3870)
    • Fixed a bug with truncation of big values (> 4294967295) of 64-bit system variables. (Bug #3754)
    • If server-id was not set using startup options but with SET GLOBAL, the replication slave still complained that it was not set. (Bug #3829)
    • Fixed potential memory overrun in mysql_real_connect() (which required a compromised DNS server and certain operating systems). (Bug #4017)
    • During the installation process of the server RPM on Linux, mysqld was run as the root system user, and if you had --log-bin=<somewhere_out_of_var_lib_mysql> it created binary log files owned by root in this directory, which remained owned by root after the installation. This is now fixed by starting mysqld as the mysql system user instead. (Bug #4038)
    • Made DROP DATABASE honor the value of lower_case_table_names. (Bug #4066)
    • The slave SQL thread refused to replicate INSERT ... SELECT if it examined more than 4 billion rows. (Bug #3871)
    • Fixed incorrect destruction of expression which led to crash of server on complex AND/OR expressions if query was ignored (either by a replication server because of replicate-*-table rules, or by any MySQL server because of a syntax error). (Bug #3969, Bug #4494)
    • Fixed that mysqlbinlog --position --read-from-remote-server had wrong # at lines. (Bug #4506)
    • If CREATE TEMPORARY TABLE t SELECT failed while loading the data, the temporary table was not dropped. (Bug #4551)
    • Fixed that when a multiple-table DROP TABLE failed to drop a table on master, the error code was not written to the binary log. (Bug #4553)
    • When the slave SQL thread was replicating a LOAD DATA INFILE it didn't show it in the output of SHOW PROCESSLIST. (Bug #4326)
    • Fixed that CREATE TABLE ... TYPE=HEAP ... AS SELECT... caused replication slave to stop. (Bug #4971)
    • Fixed that disable-local-infile option had no effect if client read it from a configuration file using mysql_options(...,MYSQL_READ_DEFAULT,...). (Bug #5073)
    • Fixed that mysql-test-run failed on the rpl_trunc_binlog test if running test from the installed (the target of 'make install') directory. (Bug #5050)
    • Fixed an unlikely deadlock which could happen when using KILL. (Bug #4810)
    • Fixed a crash when one connection got KILLed while it was doing START SLAVE. (Bug #4827)
    • Made FLUSH TABLES WITH READ LOCK block COMMIT if server is running with binary logging; this ensures that the binary log position is trustable when doing a full backup of tables and the binary log. (Bug #4953)
    • Fixed that the counter of an auto_increment column was not reset by TRUNCATE TABLE is the table was a temporary one. (Bug #5033)
    • Made database names to compare case-insensitively in fully qualified column names (database.table.column) when lower_case_table_names=1. (Bug #4792)
    • Fixed that SET CHARACTER SET was not replicated correctly. MySQL 4.1 does not have that bug. (Bug #4500)

[Top]
No.
제목
작성자
작성일
조회
23299MySQL 4.1.10a and 4.0.24 Released
이창민
2005-03-14
8454
23220MySQL 4.1.10 has been released
이창민
2005-03-02
7120
22674MS 소스 코드 오픈소스 데이터베이스 ‘MySQL’ 차기 버전에 쓰일 전망
정재익
2004-11-11
9968
22424MySQL 4.0.21 Released (2004년 9월 06일)
강병기
2004-09-20
11199
22023MySQL 4.1 Beta version released
최원용
2004-07-13
9581
21955MySQL 4.0.20 Released (2004년 5월 17일)
강병기
2004-07-02
7965
21036MySQL 4.0.18 Released
정재익
2004-02-15
13049
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.017초, 이곳 서비스는
	PostgreSQL v16.4로 자료를 관리합니다