MySQL Bugs

#2: Does not make Toast

Thu, 12 Sep 2002 05:26:12 +0000

Bug ID: 2
Submitted by: Mark Matthews
Category: Connector/J
Status: Patch pending
Severity: 7
OS: Linux (Windows and Others))
Version: 3.0.0

#363: SHOW SESSION VARIABLES LIKE 'x' != SELECT @@SESSION.x

Sat, 03 May 2003 06:19:27 +0000

Bug ID: 363
Submitted by: Guilhem Bichot
Category: Server
Status: Verified
Severity: 3
OS: Any (all)
Version: 5.0

#400: Security problems with backslash

Thu, 08 May 2003 10:53:21 +0000

Bug ID: 400
Submitted by: Peter Deacon
Category: Server: Parser
Status: Verified
Severity: 4
OS: Windows (win32)
Version: 4.1

#765: mysqlimport should read from stdin standard input

Mon, 30 Jun 2003 10:34:58 +0000

Bug ID: 765
Submitted by: Steffen Möller
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: Ver 3.4 Distrib 4.0.13

#1057: Add database links feature

Fri, 15 Aug 2003 18:03:15 +0000

Bug ID: 1057
Submitted by: Simon Windsor
Category: Server: Options
Status: Verified
Severity: 4
OS: Any

#1075: SQL DOMAIN support

Mon, 18 Aug 2003 07:08:41 +0000

Bug ID: 1075
Submitted by: Clint Sheffield
Category: Server
Status: Open
Severity: 4
OS: Any
Version: 4.0.14

#1154: cannot rename temporary table

Wed, 27 Aug 2003 13:37:46 +0000

Bug ID: 1154
Submitted by: Michael Wright
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.14-standard

#1207: substr_count

Fri, 05 Sep 2003 17:02:27 +0000

Bug ID: 1207
Submitted by: Sorin Neacsu
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#1214: Unique row identifier data type for MySQL (like MSSQL uniqueidentifier)

Sat, 06 Sep 2003 03:56:21 +0000

Bug ID: 1214
Submitted by: Deniz TATAR
Category: Server: Types
Status: Verified
Severity: 4
OS: Any

#1310: optionally add queries with lock times to slow_query log

Tue, 16 Sep 2003 13:54:25 +0000

Bug ID: 1310
Submitted by: Emery Ford
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any
Version: 4.x

#1327: Client event notification

Thu, 18 Sep 2003 00:46:52 +0000

Bug ID: 1327
Submitted by: Erland Lewin
Category: C API
Status: Verified
Severity: 4
OS: Any

#1341: InnoDB ibdata1 never shrinks after data is removed

Thu, 18 Sep 2003 12:40:19 +0000

Bug ID: 1341
Submitted by: Scott Ellsworth
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: All versions

#1382: SQLDescribeParam returns the same type information

Tue, 23 Sep 2003 09:40:52 +0000

Bug ID: 1382
Submitted by:
Category: Server: PS
Status: Verified
Severity: 2
OS: Any (all)
Version: 4.0, 4.1, 5.0, 5.1

#1459: max_allowed_packet does not just control the maximum allowed packet size

Wed, 01 Oct 2003 14:24:27 +0000

Bug ID: 1459
Submitted by: Justin Patrin
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.0.15a

#1460: inserts to merge tables lock all underlying tables

Wed, 01 Oct 2003 16:23:46 +0000

Bug ID: 1460
Submitted by:
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: FreeBSD (FreeBSD)
Version: 4.0.14

#1542: When will Mysql have parallel query and partitioning

Mon, 13 Oct 2003 11:10:32 +0000

Bug ID: 1542
Submitted by: Udi Karni
Category: Server
Status: Verified
Severity: 4
OS: Any (windows)
Version: 4.0.15, 5.5

#1588: "natural" sorting

Fri, 17 Oct 2003 09:47:58 +0000

Bug ID: 1588
Submitted by: Michael Winston
Category: Server
Status: Verified
Severity: 4
OS: MacOS (mac os x 10.2.8)
Version: any

#1607: allow for DB encryption i.e. database, Table and Column encryption

Mon, 20 Oct 2003 06:51:25 +0000

Bug ID: 1607
Submitted by: Ralf Hauser
Category: Server
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#1625: Built in sequence support

Wed, 22 Oct 2003 08:29:31 +0000

Bug ID: 1625
Submitted by:
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 4.1, 5.1

#1627: New Function: STRSPN(string1, string2)

Wed, 22 Oct 2003 09:32:03 +0000

Bug ID: 1627
Submitted by: Andreas Delleske
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#1628: mysqlimport does not support "LINES STARTING BY"

Wed, 22 Oct 2003 10:03:40 +0000

Bug ID: 1628
Submitted by:
Category: Client
Status: Verified
Severity: 4
Version: 4.0.15a

#1694: Crash error message is misleading

Tue, 28 Oct 2003 23:30:00 +0000

Bug ID: 1694
Submitted by: Peter Zaitsev
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 3.23

#1911: Add to mysqlimport --table and allow from stdin

Fri, 21 Nov 2003 13:02:43 +0000

Bug ID: 1911
Submitted by: Pete Lancashire
Category: Client
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#1926: REPLACEREGEXP

Sun, 23 Nov 2003 11:56:15 +0000

Bug ID: 1926
Submitted by: Dimitris Kounalakis
Category: Server: UDF
Status: Verified
Severity: 4
OS: Any

#1939: Wrong case sensitivity for table names when in "ANSI" mode

Mon, 24 Nov 2003 16:08:02 +0000

Bug ID: 1939
Submitted by: Troels Arvin
Category: Server
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.2

#1956: Parser allows naming of PRIMARY KEY

Tue, 25 Nov 2003 16:23:26 +0000

Bug ID: 1956
Submitted by: Arjen Lentz
Category: Server: Parser
Status: Verified
Severity: 3
OS: Any (Any)
Version: 4.0.12, 4.1.0, 5.1.52

#2051: INSTRREV / LASTINDEXOF

Mon, 08 Dec 2003 16:24:29 +0000

Bug ID: 2051
Submitted by: Arjen Lentz
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#2122: changing hostname confuses master or slave

Mon, 15 Dec 2003 13:53:30 +0000

Bug ID: 2122
Submitted by: Guilhem Bichot
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any (all)
Version: 4.0,5.1

#2144: Constraints lack the "enabled" attribute.

Wed, 17 Dec 2003 13:26:46 +0000

Bug ID: 2144
Submitted by: Jeff Holt
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#2240: New Index Type - "Super Index" (like an ADABAS superdescriptor)

Tue, 30 Dec 2003 14:44:32 +0000

Bug ID: 2240
Submitted by: Jon Koerber
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.16

#2261: Can't use @user_variable as FETCH target in stored procedure

Fri, 02 Jan 2004 14:37:52 +0000

Bug ID: 2261
Submitted by: Peter Gulutzan
Category: Server: General
Status: Verified
Severity: 3
OS: Linux (SuSE 8.2)
Version: 5.0.0

#2340: TCASE function ie Title Case Function

Fri, 09 Jan 2004 15:44:42 +0000

Bug ID: 2340
Submitted by: Yurais Fernandez Leal
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#2343: SSL without client certificate, and/or using system API for certificates

Sat, 10 Jan 2004 00:19:00 +0000

Bug ID: 2343
Submitted by: Nikolay Mirin
Category: C API
Status: Verified
Severity: 4
OS: Any

#2348: replication option to ignore deletes on certain db / tables

Sun, 11 Jan 2004 11:21:22 +0000

Bug ID: 2348
Submitted by: Stefan Praszalowicz
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 4.0 or 4.1

#2560: Relevancy and fine-tuning MySQL Full-text Search

Thu, 29 Jan 2004 09:51:15 +0000

Bug ID: 2560
Submitted by: Clay Webster
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5

#2585: Julian date character function

Fri, 30 Jan 2004 11:28:33 +0000

Bug ID: 2585
Submitted by: Matt Ryan
Category: Server
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#2588: Allow filtering of messages logged (general query log)

Fri, 30 Jan 2004 12:49:04 +0000

Bug ID: 2588
Submitted by:
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#2644: Secure record deletion

Wed, 04 Feb 2004 14:17:24 +0000

Bug ID: 2644
Submitted by: Julian Kurz
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (all)
Version: 8.0

#2666: --vertical flag for client cannot be overriden my \g on SQL query

Fri, 06 Feb 2004 11:13:59 +0000

Bug ID: 2666
Submitted by: Eric Raymond
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.16, 5.1.28

#2676: DECLARE can't have COLLATE clause in stored procedure

Sun, 08 Feb 2004 11:47:53 +0000

Bug ID: 2676
Submitted by: Peter Gulutzan
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (SuSE 8.2)
Version: 5.0.0-alpha-debug

#2681: Ability to determine when DB was last modified (generic method)

Mon, 09 Feb 2004 04:14:28 +0000

Bug ID: 2681
Submitted by: Phil Sladen
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux 9.0)
Version: 4.1.0

#2682: When MySQL user last logged into MySQL server.

Mon, 09 Feb 2004 05:14:34 +0000

Bug ID: 2682
Submitted by: Alexandr Gorlov
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any

#2742: fields-escaped-by only allows single character separator!

Thu, 12 Feb 2004 05:25:33 +0000

Bug ID: 2742
Submitted by: Are you mortal Then prepare to die.
Category: Client
Status: Verified
Severity: 3
OS: Any (3.23.58 RH linux gnu i386)
Version: mysqlimport Ver 2.8

#2812: wrong value for stmt->field_count

Sun, 15 Feb 2004 12:18:30 +0000

Bug ID: 2812
Submitted by: Georg Richter
Category: Server: PS
Status: Verified
Severity: 3
OS: Linux (Linux/Windows)
Version: 5.x

#2829: Don't silently fail when GRANT does not work due to out-of-date priv tables

Mon, 16 Feb 2004 10:50:03 +0000

Bug ID: 2829
Submitted by: Jim Winstead
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.12

#2841: flushing and suppressing zeros: mysqladmin --relative --sleep N extended-status

Tue, 17 Feb 2004 08:52:33 +0000

Bug ID: 2841
Submitted by: Tim Bunce
Category: Client
Status: Verified
Severity: 4

#2917: binlog-*-table needed

Sat, 21 Feb 2004 11:04:02 +0000

Bug ID: 2917
Submitted by: Przemyslaw Popielarski
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (Linux 2.4.x x86)
Version: 4.0.18

#2934: advanced search page turns string to wordlist

Tue, 24 Feb 2004 04:43:57 +0000

Bug ID: 2934
Submitted by:
Category: bugs.mysql.com
Status: Verified
Severity: 4
OS: Any (all)
Version: current

#3013: DROP DATABASE "force" option

Sun, 29 Feb 2004 09:28:10 +0000

Bug ID: 3013
Submitted by:
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#3052: Rollback in stored procedure doesn't close cursor

Wed, 03 Mar 2004 02:46:11 +0000

Bug ID: 3052
Submitted by: Peter Gulutzan
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (SuSE 8.2)
Version: 5.1

#3106: DBLinks - data access from another server

Mon, 08 Mar 2004 07:09:25 +0000

Bug ID: 3106
Submitted by: Mickael Besson
Category: Server: Federated
Status: Verified
Severity: 4
OS: Windows (Windows NT4)
Version: 5.0.1

#3166: Fulltext Sorting and Counting

Sun, 14 Mar 2004 09:25:37 +0000

Bug ID: 3166
Submitted by: Jim Nguyen
Category: Server: FTS
Status: Verified
Severity: 4
OS: Windows (Windows, Unix, Linix)
Version: 4.1

#3175: Add mechanism to serialize writes in InnoDB (e.g. for timestamp)

Mon, 15 Mar 2004 07:50:41 +0000

Bug ID: 3175
Submitted by: Tim Bunce
Category: Server: InnoDB
Status: Open
Severity: 4

#3186: new function: client_ip()

Tue, 16 Mar 2004 01:52:34 +0000

Bug ID: 3186
Submitted by: None None
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#3228: mysqldump should have a exclude

Thu, 18 Mar 2004 11:55:00 +0000

Bug ID: 3228
Submitted by: daniel poelzleithner
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any

#3234: trim spaces from username for dumb clients

Thu, 18 Mar 2004 14:53:26 +0000

Bug ID: 3234
Submitted by: Timothy Smith
Category: Client
Status: Verified
Severity: 4
OS: Any (all)

#3275: INSERT INTO table1 AS alias1 - to easier use of LOCK TABLES table1 AS alias1

Tue, 23 Mar 2004 14:14:40 +0000

Bug ID: 3275
Submitted by: Ondra Zizka
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#3286: Enhancement to Stored Procedure variables

Wed, 24 Mar 2004 10:13:39 +0000

Bug ID: 3286
Submitted by: Lynette Halka-Peel
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (Windows 2000)
Version: 5.0 alpha

#3310: Absence of "master-socket" parameter confuses

Sat, 27 Mar 2004 02:23:47 +0000

Bug ID: 3310
Submitted by: David Galoyan
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (FreeBSD, Any)
Version: 4.0.18, 4.1, 5.0, 5.1, 6.0

#3329: Incomplete lower_case_table_names=2 implementation

Mon, 29 Mar 2004 22:23:31 +0000

Bug ID: 3329
Submitted by: Sergei Kulakov
Category: Server
Status: Verified
Severity: 3
OS: Any (Windows, MacOSX)
Version: 4.0.18/4.0.19 Source, 5.0, 5.1, 6.0 bzr

#3346: i can not search user comments in the documentation

Wed, 31 Mar 2004 12:35:50 +0000

Bug ID: 3346
Submitted by: shimon doodkin
Category: MySQL Websites
Status: Verified
Severity: 4

#3351: Import and export databases from/to zip files.

Wed, 31 Mar 2004 17:22:18 +0000

Bug ID: 3351
Submitted by: Francisco Reinaldo
Category: Server
Status: Verified
Severity: 4
OS: Windows (Windows + UNIX.)
Version: 4.0

#3407: mysqlimport - Ability to handle better rows with repeating key fields

Wed, 07 Apr 2004 01:20:39 +0000

Bug ID: 3407
Submitted by:
Category: Client
Status: Verified
Severity: 4
OS: Windows (Win95/98 i32)
Version: Ver 3.4 Distrib 4.0.17

#3439: ON UPDATE CASCADE doesn't work on self-referential tables

Sun, 11 Apr 2004 19:55:22 +0000

Bug ID: 3439
Submitted by: Matthias Urlichs
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux 2.4)
Version: 4.0.1.18

#3475: ALTER TABLE x CHANGE COLUMN var enum ENUM;

Thu, 15 Apr 2004 04:29:15 +0000

Bug ID: 3475
Submitted by: Are you mortal Then prepare to die.
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (na)
Version: na

#3545: mysqlhotcopy should have a --passwordfile option

Thu, 22 Apr 2004 14:25:40 +0000

Bug ID: 3545
Submitted by: Tobias Burnus
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 3.23.49, 5.1.x

#3548: CONSTRAINT NAME NOT SHOWN IN ERROR MESSAGE

Fri, 23 Apr 2004 01:45:54 +0000

Bug ID: 3548
Submitted by: Sanjay Patil
Category: Server: Errors
Status: Verified
Severity: 4
OS: Windows (Win 2000)
Version: mysql-5.2.0-falcon-alpha-win32

#3558: Foreign keys: ON UPDATE/ON DELETE SET DEFAULT

Sun, 25 Apr 2004 17:13:29 +0000

Bug ID: 3558
Submitted by: Federico Razzoli
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any
Version: 5

#3575: Allow INSERT...SELECT MAX(x)+1 from the same table

Tue, 27 Apr 2004 07:20:51 +0000

Bug ID: 3575
Submitted by: Matthias Urlichs
Category: Server
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1

#3632: load data local ... lines starting by = inserts bad data

Mon, 03 May 2004 05:35:53 +0000

Bug ID: 3632
Submitted by: dave mausner
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#3705: Index Pre-cache failed for table with different index block sizes

Mon, 10 May 2004 23:54:26 +0000

Bug ID: 3705
Submitted by: Haitao Jiang
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0 4.1

#3706: ALTER TABLE MODIFY COLUMN foo IF NOT EXIST

Tue, 11 May 2004 00:58:46 +0000

Bug ID: 3706
Submitted by: Jonathan Lampe
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#3733: ALTER TABLE doesn't restore cardinality values on MyISAM indexes

Wed, 12 May 2004 22:55:06 +0000

Bug ID: 3733
Submitted by: Timothy Smith
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (any)
Version: 4.0

#3816: mysqldump option to wrap chunks of inserts into transactions

Tue, 18 May 2004 18:43:26 +0000

Bug ID: 3816
Submitted by: Timothy Smith
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#3819: Can 'Access Control Phase 1' (manual 5.4.5) be made to check the host table?

Tue, 18 May 2004 19:49:49 +0000

Bug ID: 3819
Submitted by: Brian Nelson
Category: Server: Privileges
Status: Open
Severity: 4
OS: Solaris (Solaris 9)
Version: 4.0.20

#3852: support for various datetime formats v4.1 and up

Fri, 21 May 2004 20:39:14 +0000

Bug ID: 3852
Submitted by: Gregory Z
Category: Server
Status: Verified
Severity: 4
OS: Any (any)

#3880: Enhance SELECT * syntax to leave out some columns

Tue, 25 May 2004 08:16:30 +0000

Bug ID: 3880
Submitted by: Mr. Venom
Category: Server
Status: Verified
Severity: 4
OS: Any (any)

#3926: Progress of ALTER TABLE ENABLE KEYS

Fri, 28 May 2004 14:08:46 +0000

Bug ID: 3926
Submitted by: Mirza Hadzic
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any

#4117: Too many columns while creating a table

Sat, 12 Jun 2004 23:48:38 +0000

Bug ID: 4117
Submitted by: Partha Dutta
Category: Server: DDL
Status: Verified
Severity: 2
OS: Solaris (Solaris 2.8 64bit)
Version: 4.1.2

#4134: innodb table space segment handling not as obvious as could be

Mon, 14 Jun 2004 23:17:56 +0000

Bug ID: 4134
Submitted by: Matthew Lord
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#4152: Fulltext 50% rule

Tue, 15 Jun 2004 20:37:12 +0000

Bug ID: 4152
Submitted by: Timothy Crider
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0.0

#4158: MySQL Fulltext Index doesn't Work for asian languages

Wed, 16 Jun 2004 01:37:35 +0000

Bug ID: 4158
Submitted by: Eks Wang
Category: Server
Status: Verified
Severity: 4
OS: Windows (WINDOWS XP)
Version: 4.1.12

#4210: Stored Procedure Encryption

Fri, 18 Jun 2004 20:33:34 +0000

Bug ID: 4210
Submitted by: Mike Palmer
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (Win2000)
Version: 5

#4270: add timestamp to 'SHOW BINLOG EVENTS'

Thu, 24 Jun 2004 11:47:19 +0000

Bug ID: 4270
Submitted by: Joerg Klein
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.0.18

#4291: max_heap_table_size affects creation of disk-based temporary tables

Fri, 25 Jun 2004 23:30:51 +0000

Bug ID: 4291
Submitted by: Dean Ellis
Category: Server
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0.21

#4402: Equivalence is not considered in group by and order by

Sun, 04 Jul 2004 08:21:16 +0000

Bug ID: 4402
Submitted by: Peter Zaitsev
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1, 5.1.28, 6.0.6

#4431: Intelligent MySQL Server

Wed, 07 Jul 2004 09:22:27 +0000

Bug ID: 4431
Submitted by: Mickael Besson
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Windows (Windows NT 4 and others maybe)
Version: 4.1.3

#4464: full text index search speed differs between count queries of the same type

Thu, 08 Jul 2004 15:11:43 +0000

Bug ID: 4464
Submitted by: Karsten Wenger
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 4.1.1-alpha-max-log

#4485: Floating point conversions are inconsistent.

Fri, 09 Jul 2004 14:23:35 +0000

Bug ID: 4485
Submitted by: Konstantin Osipov
Category: Server: Types
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: All

#4541: "Specified key was too long; max key length is 1000 bytes" with utf8

Wed, 14 Jul 2004 01:13:39 +0000

Bug ID: 4541
Submitted by: Björn Dieding
Category: Server: General
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1.2

#4607: Views: Descriptive information is lost for view definition

Sun, 18 Jul 2004 23:11:27 +0000

Bug ID: 4607
Submitted by: Trudy Pelzer
Category: Server
Status: Verified
Severity: 4
OS: Linux (SuSE 8.2)
Version: 5.0.1-alpha-debug

#4731: Table-completion fails

Fri, 23 Jul 2004 21:12:17 +0000

Bug ID: 4731
Submitted by: Gili
Category: Client
Status: Verified
Severity: 4
OS: Windows (Windows XP sp1)
Version: 4.0.20a

#4754: 'if exists' syntax for rename table

Mon, 26 Jul 2004 16:38:01 +0000

Bug ID: 4754
Submitted by: Karel Vervaeke
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Gentoo linux)
Version: 4.0.20

#4778: mysql doesn't try to setrlimit to maximum data size

Tue, 27 Jul 2004 23:38:34 +0000

Bug ID: 4778
Submitted by: Christopher Kantarjiev
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 4.0.18

#4840: Seperate MySQL Server version field for GUI tools

Sat, 31 Jul 2004 18:11:36 +0000

Bug ID: 4840
Submitted by: Michael G. Zinner
Category: bugs.mysql.com
Status: Verified
Severity: 4
OS: Any

#4960: Mysql cmdline client fails on byte order mark

Mon, 09 Aug 2004 16:42:24 +0000

Bug ID: 4960
Submitted by: Ulrich Bayer
Category: Client
Status: Verified
Severity: 4
Version: 4.1.3b

#5019: Duration of the query measured by MySQL

Thu, 12 Aug 2004 13:59:06 +0000

Bug ID: 5019
Submitted by: Ondra Zizka
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any

#5159: Views: Comments are not preserved

Mon, 23 Aug 2004 01:42:16 +0000

Bug ID: 5159
Submitted by: Peter Gulutzan
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha-debug

#5297: log-slow-queries: initial table locks time

Mon, 30 Aug 2004 19:46:56 +0000

Bug ID: 5297
Submitted by: Miguel Solorzano
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.0.XX

#5309: MySQL should reserve a connection for the admin (root) user

Tue, 31 Aug 2004 00:11:01 +0000

Bug ID: 5309
Submitted by: Christian Hammers
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Debian GNU/Linux)
Version: 4.0.20

#5366: incremental backup

Thu, 02 Sep 2004 09:30:38 +0000

Bug ID: 5366
Submitted by: Mickael Besson
Category: Server: Backup
Status: Verified
Severity: 4
OS: Linux (any OS)
Version: 6.0

#5446: list functions in my_list.h do not have namespace prefix

Tue, 07 Sep 2004 09:20:12 +0000

Bug ID: 5446
Submitted by: Ilja Booij
Category: Server: Compiling
Status: Verified
Severity: 4
OS: Any
Version: 4.1.0-alpha, 6.0-bzr

#5452: fulltext boolean is disagree with boolean logic

Tue, 07 Sep 2004 17:01:32 +0000

Bug ID: 5452
Submitted by: ladimir Kolpakov
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 4.0.20

#5502: Views: ALGORITHM clause should be changed and moved

Fri, 10 Sep 2004 02:09:21 +0000

Bug ID: 5502
Submitted by: Peter Gulutzan
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha

#5507: TRUNCATE wth views needs better error message

Fri, 10 Sep 2004 02:35:52 +0000

Bug ID: 5507
Submitted by: Peter Gulutzan
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha

#5573: Wrong/undocumented behaviour on UNIQUE column mass update

Tue, 14 Sep 2004 16:58:13 +0000

Bug ID: 5573
Submitted by: Matthias Leich
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any

#5608: Wrong default value for variable max_join_size

Thu, 16 Sep 2004 12:16:11 +0000

Bug ID: 5608
Submitted by:
Category: Server: General
Status: Verified
Severity: 4
OS: Solaris (Solaris 2.8 SPARC 64)
Version: 4.0.21

#5629: Collation information for columns not passed into UDF

Fri, 17 Sep 2004 12:42:02 +0000

Bug ID: 5629
Submitted by: Jose Miguel Pérez Ruiz
Category: Server: UDF
Status: Verified
Severity: 4
OS: Linux (Red Hat 8.0)
Version: 4.1.4-gamma

#5694: 'Explain mode' in client would be nice

Wed, 22 Sep 2004 07:45:24 +0000

Bug ID: 5694
Submitted by: yk
Category: Client
Status: Verified
Severity: 4
OS: Linux (linux/SunOS)
Version: 4.0.x and up

#5732: mysqlbug script still reports to list (ignoring bugs.mysql.com)

Fri, 24 Sep 2004 13:49:03 +0000

Bug ID: 5732
Submitted by: Arjen Lentz
Category: Client
Status: Verified
Severity: 4
OS: Unix
Version: any

#5769: Error 136 when doing CREATE TABLE...SELECT

Mon, 27 Sep 2004 17:30:16 +0000

Bug ID: 5769
Submitted by: Thomas Johnson
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Gentoo Linux)
Version: 4.0.20

#5804: Free datafile space in "SHOW INNODB STATUS"?

Wed, 29 Sep 2004 16:51:44 +0000

Bug ID: 5804
Submitted by: Christian Hammers
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Linux (Debian GNU/Linux)
Version: 4.0.21

#5857: Client libraries namespace pollution

Sat, 02 Oct 2004 09:47:50 +0000

Bug ID: 5857
Submitted by: Matthias Urlichs
Category: Server
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: all

#5929: Traditional: MOD with 0 divisor should return error

Wed, 06 Oct 2004 17:24:50 +0000

Bug ID: 5929
Submitted by: Trudy Pelzer
Category: Server: Errors
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.2-alpha-debug

#5931: Traditional: FLOAT and DOUBLE out-of-range values are accepted

Wed, 06 Oct 2004 18:05:04 +0000

Bug ID: 5931
Submitted by: Trudy Pelzer
Category: Server: Errors
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.2-alpha-debug

#5967: Stored procedure declared variable used instead of column

Thu, 07 Oct 2004 22:31:04 +0000

Bug ID: 5967
Submitted by: Peter Gulutzan
Category: Server: Parser
Status: Verified
Severity: 1
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha-debug

#5982: Index is ignored for BETWEEN constraint

Fri, 08 Oct 2004 14:28:50 +0000

Bug ID: 5982
Submitted by: Vassili Gorshkov
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Windows (Windows, others?)
Version: All releases, including 501

#6005: need to specify table name for mysqlimport and load data via stdin

Sun, 10 Oct 2004 10:37:40 +0000

Bug ID: 6005
Submitted by: Alex Kuklin
Category: Client
Status: Open
Severity: 4

#6062: Creating of primary key with CREATE INDEX not allowed

Wed, 13 Oct 2004 12:01:28 +0000

Bug ID: 6062
Submitted by: Andrey Hristov
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Linux 2.6.4)
Version: 4.1.4 (maybe others)

#6085: DROP TABLE fails if table is referenced

Thu, 14 Oct 2004 09:22:45 +0000

Bug ID: 6085
Submitted by: Georg Richter
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: all

#6100: connection limits

Thu, 14 Oct 2004 14:45:10 +0000

Bug ID: 6100
Submitted by: Eric Robibaro
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any

#6105: Traditional: Division with small float equalt to zero should return error

Thu, 14 Oct 2004 18:06:33 +0000

Bug ID: 6105
Submitted by: Trudy Pelzer
Category: Server: Errors
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.2-alpha-debug

#6164: INSERT ... SELECT ... LIMIT creating too-large temporary tables

Tue, 19 Oct 2004 20:10:32 +0000

Bug ID: 6164
Submitted by: Dean Ellis
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.0.22 4.1.7

#6180: Echoing output to console during script run.

Wed, 20 Oct 2004 15:14:21 +0000

Bug ID: 6180
Submitted by: William
Category: Client
Status: Verified
Severity: 4
OS: Any (All)
Version: Future

#6194: GRANT ... WITH MAX_DISC_SPACE 50M;

Thu, 21 Oct 2004 08:40:53 +0000

Bug ID: 6194
Submitted by:
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (all os)
Version: coming releases

#6220: mysqlcheck -A can't skip nonsensical choices

Fri, 22 Oct 2004 19:52:46 +0000

Bug ID: 6220
Submitted by: Eric Robibaro
Category: Client
Status: Open
Severity: 4

#6241: sync my_default_record_cache_size with read_buff_size on dynamic update

Mon, 25 Oct 2004 03:50:28 +0000

Bug ID: 6241
Submitted by: Masaki Fujimoto
Category: Server: General
Status: Open
Severity: 4
OS: Any (any)
Version: 4.0.21

#6254: IGNORE: should allow transactional tables to do partial transactions

Mon, 25 Oct 2004 20:34:33 +0000

Bug ID: 6254
Submitted by: Trudy Pelzer
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (SuSE 9.1)
Version: 4.1.7-debug

#6343: Passwords on commandline can be read via /proc//cmdline

Sun, 31 Oct 2004 11:26:43 +0000

Bug ID: 6343
Submitted by: Christian Hammers
Category: Client
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#6373: Add a "Limit n" to Load Data Infile command

Mon, 01 Nov 2004 21:53:20 +0000

Bug ID: 6373
Submitted by: Mike MySQLAB
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1

#6390: SHOW PROCEDURE/FUNCTION STATUS does not support FROM db_name clause

Tue, 02 Nov 2004 18:03:54 +0000

Bug ID: 6390
Submitted by: Paul DuBois
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#6399: getColumnDisplaySize wrong

Wed, 03 Nov 2004 11:46:43 +0000

Bug ID: 6399
Submitted by:
Category: Server
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1.x

#6400: Table comment truncated to 60 characters

Wed, 03 Nov 2004 12:03:45 +0000

Bug ID: 6400
Submitted by: Neculai Macarie
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.21, 5.0.x

#6442: Views: updatability not established at view creation time

Thu, 04 Nov 2004 20:33:44 +0000

Bug ID: 6442
Submitted by: Paul DuBois
Category: Server: Views
Status: Verified
Severity: 3
OS: Any
Version: 5.0.2, 5.1.28

#6587: Error message of SHOW GRANTS FOR ... misleading

Fri, 12 Nov 2004 08:36:17 +0000

Bug ID: 6587
Submitted by: Andrey Hristov
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any

#6606: Add safe_join setting to prevent cartesian products

Sat, 13 Nov 2004 14:50:55 +0000

Bug ID: 6606
Submitted by: Arjen Lentz
Category: Server: General
Status: Verified
Severity: 4
OS: Any (any)
Version: 6.0

#6673: Expressions not available as LIMIT parameters

Wed, 17 Nov 2004 00:13:47 +0000

Bug ID: 6673
Submitted by: Michael Long
Category: Server: DML
Status: Verified
Severity: 4
OS: Windows (Win XP)
Version: 4.1.7

#6698: Native SQL prepared statements without using variables

Thu, 18 Nov 2004 16:52:30 +0000

Bug ID: 6698
Submitted by: Georg Richter
Category: Server: PS
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1.8

#6718: custom aliases for mysql client utility.

Fri, 19 Nov 2004 11:07:34 +0000

Bug ID: 6718
Submitted by: Yashesh Bhatia
Category: Client
Status: Verified
Severity: 4
OS: Linux (Fedora Core 2)
Version: mysql Ver 14.6 Distrib 4.1.5-gamma

#6733: Kerberos user authentication support

Sat, 20 Nov 2004 23:32:23 +0000

Bug ID: 6733
Submitted by:
Category: C API
Status: Verified
Severity: 4
OS: Any

#6742: No way to store Timezone toogether with datetime?

Sun, 21 Nov 2004 22:17:13 +0000

Bug ID: 6742
Submitted by: Geert Vanderkelen
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 4.x

#6800: 'WHERE MATCH (foo) AGAINST ("-bar" IN BOOLEAN MODE)' never matches anything

Wed, 24 Nov 2004 14:49:16 +0000

Bug ID: 6800
Submitted by: Stig Brautaset
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (RedHat Linux 9.0)
Version: 4.0.20

#6801: Reset Thread statement?

Wed, 24 Nov 2004 15:14:41 +0000

Bug ID: 6801
Submitted by: Olaf van der Spek
Category: Server: General
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#6861: begin after begin calls commit

Sun, 28 Nov 2004 15:03:40 +0000

Bug ID: 6861
Submitted by: Sergey Frolovichev
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (SuSe 9.1)
Version: 4.0.22-standard-log

#6899: rollup as name

Tue, 30 Nov 2004 23:17:14 +0000

Bug ID: 6899
Submitted by: Randall Wiggins
Category: Server
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1.7

#6945: [mysqldump] One .sql.gz file per table

Thu, 02 Dec 2004 14:11:31 +0000

Bug ID: 6945
Submitted by: Olaf van der Spek
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#6980: Error 1093 - You can't specify target table for update in FROM

Fri, 03 Dec 2004 10:20:16 +0000

Bug ID: 6980
Submitted by: Sanvido Federico
Category: Server: DML
Status: Verified
Severity: 2
OS: Windows (Windows 2000)
Version: 4.1.7

#7074: InnoDB slow on select with Blobs that are not in where clause

Tue, 07 Dec 2004 13:42:49 +0000

Bug ID: 7074
Submitted by: Daniel Schneller
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Windows (Windows 2000)
Version: 4.1.7

#7080: Optimizer choose incorrect index

Tue, 07 Dec 2004 15:23:30 +0000

Bug ID: 7080
Submitted by: Victoria Reznichenko
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0

#7083: CHAR columns should report correct length

Tue, 07 Dec 2004 20:30:16 +0000

Bug ID: 7083
Submitted by: Trudy Pelzer
Category: Server: Types
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug

#7113: Include GRANT, USE and CREATE INDEX in Prepared Statement api.

Wed, 08 Dec 2004 18:31:18 +0000

Bug ID: 7113
Submitted by: Michael Houlberg
Category: Server: PS
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1.7 Pro

#7121: LOAD_DATA_INFILE replaces when necessary

Thu, 09 Dec 2004 08:54:17 +0000

Bug ID: 7121
Submitted by: Mickael Besson
Category: Client
Status: Open
Severity: 4
OS: Windows (Windows NT4)
Version: 4.1.7

#7173: Add charset and collation to 'DESCRIBE table' output

Fri, 10 Dec 2004 15:57:34 +0000

Bug ID: 7173
Submitted by: Struchkov Vladimir
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (All)
Version: >=4.1

#7174: RFE: libmysql should mark sockets close-on-exec

Fri, 10 Dec 2004 16:44:57 +0000

Bug ID: 7174
Submitted by:
Category: C API
Status: Open
Severity: 4
OS: Any
Version: 4.1.7

#7191: REVOKE doens't remove permissions from a logged in user

Sat, 11 Dec 2004 09:46:25 +0000

Bug ID: 7191
Submitted by: Jan Kneschke
Category: Server: Privileges
Status: Verified
Severity: 2
OS: Any
Version: 4.1.7, 5.6.17

#7290: update should check primary keys after all records altered

Tue, 14 Dec 2004 17:27:10 +0000

Bug ID: 7290
Submitted by: Yuliy Pisetsky
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Solaris (Solaris)
Version: 4.1.7

#7367: User-friendly error messages for socket errors

Thu, 16 Dec 2004 22:11:02 +0000

Bug ID: 7367
Submitted by: Olaf van der Spek
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#7409: InnoDB: function to count usage of a key as foreign key in the child tables

Sat, 18 Dec 2004 18:05:13 +0000

Bug ID: 7409
Submitted by: Zrin Ziborski
Category: Server: InnoDB
Status: Open
Severity: 4

#7412: Cannot delete a row that references itself.

Sat, 18 Dec 2004 19:29:57 +0000

Bug ID: 7412
Submitted by: Sergey Koshcheyev
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Windows (Windows XP SP2)
Version: 4.1.8

#7414: mysqldumpslow improvements: inverse grep, rows examined, abstractions IN, VALUES

Sat, 18 Dec 2004 20:22:15 +0000

Bug ID: 7414
Submitted by: Nils Goroll
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: 4.0, still present in 4.1.7, 5.0.45,5.1.21

#7497: Make myisam_data_pointer_size a session variable

Wed, 22 Dec 2004 22:12:47 +0000

Bug ID: 7497
Submitted by: Dean Ellis
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any
Version: 4.1.9, 5.1.53

#7529: Constraints: support deferred constraints

Fri, 24 Dec 2004 16:02:05 +0000

Bug ID: 7529
Submitted by: Nagi Peters
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#7590: Evaluation order in multi table update

Thu, 30 Dec 2004 14:51:14 +0000

Bug ID: 7590
Submitted by: Kai Ruhnau
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.22

#7604: Row subqueries don't work with ALL

Fri, 31 Dec 2004 20:13:04 +0000

Bug ID: 7604
Submitted by: Peter Gulutzan
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.21-BK, 6.0.14

#7606: Embedded newlines break table-format display

Sat, 01 Jan 2005 14:25:40 +0000

Bug ID: 7606
Submitted by: Geoff Kuenning
Category: Client
Status: Open
Severity: 4
OS: Linux (Linux)
Version: 4.0.21

#7638: Tool like PostGIS's SHP2SQL

Mon, 03 Jan 2005 16:06:41 +0000

Bug ID: 7638
Submitted by:
Category: Server: GIS
Status: Open
Severity: 4
OS: Any (Any)
Version: 4.1.x

#7695: Should be able to disable max_connect_errors completely

Thu, 06 Jan 2005 01:44:28 +0000

Bug ID: 7695
Submitted by: Dean Ellis
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 4.0.24, 5.0.46 and all versions

#7727: BASE_TABLE function for use w/ MERGE tables

Fri, 07 Jan 2005 07:47:48 +0000

Bug ID: 7727
Submitted by: Carsten Pedersen
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any

#7742: You can't reinvoke the same Temporary Table more than once.

Sat, 08 Jan 2005 11:06:34 +0000

Bug ID: 7742
Submitted by: Carlos Uldérico Cirello Filho
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux Red Hat 9)
Version: 4.1 +

#7748: Including popular functions like metaphone/levenshtein into MySQL

Sat, 08 Jan 2005 20:27:43 +0000

Bug ID: 7748
Submitted by: Gunnar von Boehn
Category: Server: UDF
Status: Verified
Severity: 4
OS: Any

#7753: A SPLIT function in MySQL?!?

Sun, 09 Jan 2005 20:57:30 +0000

Bug ID: 7753
Submitted by: Are you mortal Then prepare to die.
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (all)
Version: next

#7804: InnoDB: support varying page sizes

Tue, 11 Jan 2005 15:03:21 +0000

Bug ID: 7804
Submitted by: Shawn Hartsock
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (GNU/Linux 2.6.9 SMP)
Version: 4.1.7-log

#7817: HEAP table faster for duplicate keys with "MTF" & bitwise hash function

Tue, 11 Jan 2005 19:33:21 +0000

Bug ID: 7817
Submitted by: Shelby Moore
Category: Server: Memory
Status: Open
Severity: 4
OS: FreeBSD (FreeBSD)
Version: 4.0.17

#7861: Column level security inconsistent with db/table level security

Thu, 13 Jan 2005 06:19:10 +0000

Bug ID: 7861
Submitted by: Arjen Lentz
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Any (any)
Version: any

#7882: Function CONVERT ODBC database independent types not translated

Thu, 13 Jan 2005 18:02:21 +0000

Bug ID: 7882
Submitted by:
Category: Connector/ODBC
Status: Verified
Severity: 3
OS: Any (all)
Version: all

#7888: optimization request for query UNION query LIMIT statements...

Thu, 13 Jan 2005 21:49:28 +0000

Bug ID: 7888
Submitted by: Matthew Murphy
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1x, 5.x, etc.

#7936: HEAP table HASH not optimized for searches that usually do not match KEY

Sun, 16 Jan 2005 01:15:57 +0000

Bug ID: 7936
Submitted by: Shelby Moore
Category: Server: Memory
Status: Open
Severity: 4
OS: FreeBSD (FreeBSD)
Version: 4.0.17

#7940: --log-queries-not-using-indexes with option to exclude non conditional querry

Sun, 16 Jan 2005 16:37:57 +0000

Bug ID: 7940
Submitted by: Martin Friebe
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (-)
Version: -

#7957: Some way to make a copy of a table.

Mon, 17 Jan 2005 14:56:54 +0000

Bug ID: 7957
Submitted by: Hans-Henrik Stærfeldt
Category: Server: DDL
Status: Verified
Severity: 4
OS: Other (IRIX64 genome 6.5 04070317 IP35)
Version: 4.1.5-gamma-20041010-log

#7982: FEDERATED storage engine

Tue, 18 Jan 2005 10:40:48 +0000

Bug ID: 7982
Submitted by:
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any
Version: 5

#7986: Syntactic sugar

Tue, 18 Jan 2005 13:05:41 +0000

Bug ID: 7986
Submitted by: Hans-Henrik Stærfeldt
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any ((ALL))
Version: 1.4.5

#8036: Bad optimization of ORDER BY ... LIMIT 1 if one table is MyISAM, another InnoDB

Thu, 20 Jan 2005 10:12:51 +0000

Bug ID: 8036
Submitted by: Nick Peterson
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: FreeBSD (Free BSD 4.5, Linux)
Version: 4.0.18, 4.1.10, 5.1.52

#8092: INSERT_METHOD feature request

Sat, 22 Jan 2005 18:38:07 +0000

Bug ID: 8092
Submitted by: Wilfried Schobeiri
Category: Server: Merge
Status: Open
Severity: 4
OS: Any

#8094: Variables in the LIMIT Clause

Sun, 23 Jan 2005 00:19:11 +0000

Bug ID: 8094
Submitted by: Robert Seaborn
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Suse Linux)
Version: 5.01

#8113: Select with between optimization

Mon, 24 Jan 2005 15:43:39 +0000

Bug ID: 8113
Submitted by: Emmanuel van der Meulen
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.0, 5.1, azalea bzr

#8246: Ability to have a static foreign key field

Tue, 01 Feb 2005 18:52:40 +0000

Bug ID: 8246
Submitted by: Andrew Hanna
Category: Server: InnoDB
Status: Open
Severity: 4

#8250: Simple XML-RPC interface

Wed, 02 Feb 2005 01:48:30 +0000

Bug ID: 8250
Submitted by: Brian McConnell
Category: Server: XML
Status: Open
Severity: 4
OS: Any (cross platform)

#8323: LOAD DATA INFILE not supported anymore? in preparedStatement

Fri, 04 Feb 2005 18:05:12 +0000

Bug ID: 8323
Submitted by: bruno haleblian
Category: Server: PS
Status: Verified
Severity: 4
OS: Any (WK2K/XP)
Version: 3.1.6, 3.2.0-alpha

#8376: Adding a Time/Date Range Column Type

Tue, 08 Feb 2005 22:27:57 +0000

Bug ID: 8376
Submitted by: Andrew Hanna
Category: Server: Types
Status: Verified
Severity: 4
OS: Any

#8394: Knowing the exact position of the master when it is down

Wed, 09 Feb 2005 14:37:17 +0000

Bug ID: 8394
Submitted by: KEvin
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 6.0

#8415: ALTER TABLE syntax limitation with foreign key constraints

Thu, 10 Feb 2005 09:46:24 +0000

Bug ID: 8415
Submitted by: Dmitriy Kruglyak
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1.9

#8423: Traditional: Division by 0 returns NULL

Thu, 10 Feb 2005 20:54:40 +0000

Bug ID: 8423
Submitted by: Trudy Pelzer
Category: Server: Errors
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug

#8463: SQRT: Should return an error when argument is negative

Fri, 11 Feb 2005 23:30:14 +0000

Bug ID: 8463
Submitted by: Trudy Pelzer
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug

#8485: BOOLEAN: Silent data type change to TINYINT

Sun, 13 Feb 2005 00:40:17 +0000

Bug ID: 8485
Submitted by: Trudy Pelzer
Category: Server: Types
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug

#8488: a bigger DATETIME datatype

Sun, 13 Feb 2005 13:31:17 +0000

Bug ID: 8488
Submitted by: Federico Razzoli
Category: Server: Types
Status: Verified
Severity: 4
OS: Any

#8494: clusterlog statistics=8 prints to stats for all ndbd nodes

Mon, 14 Feb 2005 11:25:08 +0000

Bug ID: 8494
Submitted by: Johan Andersson
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any (*)
Version: mysql-5.1

#8516: SHOW CREATE TABLE `db`.`table` should return schema in result

Tue, 15 Feb 2005 11:46:03 +0000

Bug ID: 8516
Submitted by: Mike Lischke
Category: Server
Status: Verified
Severity: 4

#8571: impossible where not regocnized

Thu, 17 Feb 2005 15:18:47 +0000

Bug ID: 8571
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1.10

#8598: innodb with autoindex on multicol prim key

Fri, 18 Feb 2005 12:08:23 +0000

Bug ID: 8598
Submitted by: Andre Justus
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (debian)
Version: 4.1.x

#8604: Provide alternative way to encode backslash in windows pathes?

Fri, 18 Feb 2005 15:45:33 +0000

Bug ID: 8604
Submitted by: Hartmut Holzgraefe
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (windows)
Version: any

#8644: make the cp1250_czech_cs act like latin2_czech_cs

Mon, 21 Feb 2005 10:39:18 +0000

Bug ID: 8644
Submitted by: Roman Porizka
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Linux (any)
Version: 4.1.X, 5.1

#8662: optimizer, query takes 3 to 10 times as long when using index

Mon, 21 Feb 2005 21:31:23 +0000

Bug ID: 8662
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 6.0.14, 5.1.12-BK, 4.1.10

#8674: CREATE DATABASE db DEFAULT ROW_FORMAT=...

Tue, 22 Feb 2005 10:58:07 +0000

Bug ID: 8674
Submitted by: Marko Mäkelä
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.3

#8683: explain could show aliases of derived tables

Tue, 22 Feb 2005 13:12:06 +0000

Bug ID: 8683
Submitted by: Martin Friebe
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1

#8704: warn if CREATE ... UNION is used on a non merge table

Tue, 22 Feb 2005 18:22:47 +0000

Bug ID: 8704
Submitted by: Martin Friebe
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1.10, 5.1

#8734: more fine grained control over comparisons and sorting

Wed, 23 Feb 2005 16:20:16 +0000

Bug ID: 8734
Submitted by: Matthew Lord
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1+

#8749: EXPLAIN report different "type" w and w/o USE INDEX(...) for the same used key

Wed, 23 Feb 2005 21:08:11 +0000

Bug ID: 8749
Submitted by: jocelyn fournier
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (*)
Version: 4.1.10, 5.0.67

#8814: ALTER error: BLOB/TEXT column 't' used in key specification without a key

Fri, 25 Feb 2005 17:57:35 +0000

Bug ID: 8814
Submitted by: Paul DuBois
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any
Version: 3.23, 4.0, 4.1, 5.0, 5.0.66a

#8867: ALTER TABLE RENAME strips symlinked .MYI filename partially

Tue, 01 Mar 2005 15:13:09 +0000

Bug ID: 8867
Submitted by: Eugene Vedistchev
Category: Server: MyISAM
Status: Verified
Severity: 1
OS: FreeBSD (FreeBSD 4.9, FreeBSD 5.3)
Version: 4.0.18, 4.1.7

#8873: Merge table with INDEX statements out of order returns NULL for index colums

Tue, 01 Mar 2005 20:13:58 +0000

Bug ID: 8873
Submitted by: Edward Sweeney
Category: Server: Merge
Status: Verified
Severity: 2
OS: Linux (Linux 2.4.21-4 ELsmp)
Version: 4.1.8a, 4.1, 5.0, 5.1, 6.0 bzr

#8901: mysqldump needs mysql41 compatibility mode

Wed, 02 Mar 2005 19:44:22 +0000

Bug ID: 8901
Submitted by: Paul DuBois
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: MySQL 5

#8904: Ability to specify column separator in batch mode

Wed, 02 Mar 2005 20:30:00 +0000

Bug ID: 8904
Submitted by: Rob LoPresti
Category: Client
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1, 5.0, 5.1, 5.4, 6.0

#8919: Foreign keys handling

Thu, 03 Mar 2005 10:14:17 +0000

Bug ID: 8919
Submitted by:
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1, 5.0

#8938: libmysql should loop through all hosts returned by getaddrinfo

Fri, 04 Mar 2005 02:42:26 +0000

Bug ID: 8938
Submitted by: Andrew Donkin
Category: C API
Status: Open
Severity: 4
OS: Any

#8990: Feature request for new way to clear query cache when table changes

Sun, 06 Mar 2005 14:29:53 +0000

Bug ID: 8990
Submitted by: Tore Krudtaa
Category: Server: Query Cache
Status: Open
Severity: 4
OS: Any (ALL)

#8992: Enums and quotes

Sun, 06 Mar 2005 15:13:31 +0000

Bug ID: 8992
Submitted by: Erik Wijdemans
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#9018: Implement SQL 2003 MERGE command

Mon, 07 Mar 2005 12:34:58 +0000

Bug ID: 9018
Submitted by: Eduardo Pérez
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#9034: Views: Can't GRANT CREATE VIEW unless view already exists

Tue, 08 Mar 2005 00:25:10 +0000

Bug ID: 9034
Submitted by: Trudy Pelzer
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Linux (SuSE 9.1)
Version: 5.0.3-alpha-debug

#9051: Stored Functions: Database name in fully qualified name is case sensitive

Tue, 08 Mar 2005 14:20:44 +0000

Bug ID: 9051
Submitted by: Disha
Category: Server: SP
Status: Verified
Severity: 3
OS: Windows (Windows Server 2003, XP, Linux)
Version: 5.0.12-beta-nt, 5.0.13-BK

#9114: mysqld_safe should react on signals (patch)

Fri, 11 Mar 2005 00:22:24 +0000

Bug ID: 9114
Submitted by: Christian Hammers
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: all

#9170: Dynamic Pointer Resizing

Mon, 14 Mar 2005 16:49:30 +0000

Bug ID: 9170
Submitted by: Cornelius Sybrandy
Category: Server: MyISAM
Status: Open
Severity: 4

#9197: system command available also for Windows

Tue, 15 Mar 2005 13:46:04 +0000

Bug ID: 9197
Submitted by: Emanuele Dolis
Category: Client
Status: Verified
Severity: 4
OS: Windows (Windows XP SP2)
Version: 4.1.9

#9230: option so that [character_set|collation]_connection are auto-set to current ...

Wed, 16 Mar 2005 19:40:04 +0000

Bug ID: 9230
Submitted by: Matthew Lord
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1.x

#9244: Provide better support for chroot=...

Thu, 17 Mar 2005 08:17:15 +0000

Bug ID: 9244
Submitted by: Jürgen Kreileder
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Debian Linux)
Version: 4.1.10a

#9251: follow a discussion via email even if we don't reply

Thu, 17 Mar 2005 15:19:31 +0000

Bug ID: 9251
Submitted by: Federico Razzoli
Category: forums.mysql.com
Status: Verified
Severity: 4
OS: Any

#9343: INFORMATION_SCHEMA contains wrong data type names

Tue, 22 Mar 2005 18:58:25 +0000

Bug ID: 9343
Submitted by: Matthias Leich
Category: Server: I_S
Status: Verified
Severity: 4
Version: 5.0

#9403: mysqld: check --tmpdir exists at start, and write an error to log if it doesn't

Fri, 25 Mar 2005 14:38:14 +0000

Bug ID: 9403
Submitted by: Victoria Reznichenko
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#9420: Shared memory limits

Sun, 27 Mar 2005 14:16:44 +0000

Bug ID: 9420
Submitted by:
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 4.1

#9514: Provide a way to select a lock status of a row or rows

Thu, 31 Mar 2005 05:49:58 +0000

Bug ID: 9514
Submitted by: Lachlan Mulcahy
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1

#9588: Support for ALTER (or CREATE OR REPLACE) PROCEDURE/FUNCTION

Sat, 02 Apr 2005 20:15:51 +0000

Bug ID: 9588
Submitted by: Niels G
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0.3

#9651: Full-text indexes not supported by MERGE table handler

Tue, 05 Apr 2005 15:07:48 +0000

Bug ID: 9651
Submitted by:
Category: Server
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.23

#9679: errors in cascaded updates

Wed, 06 Apr 2005 14:38:59 +0000

Bug ID: 9679
Submitted by: Arnout Vreugdenhil
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Any (any)
Version: 4.*

#9736: DISABLE USER

Thu, 07 Apr 2005 22:25:02 +0000

Bug ID: 9736
Submitted by: Carsten Pedersen
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#9762: Can't delete records which have foreign keys to themselves

Fri, 08 Apr 2005 14:47:27 +0000

Bug ID: 9762
Submitted by: Matthew Sgarlata
Category: Server: InnoDB
Status: Verified
Severity: 3
OS: Windows (Win XP Pro)
Version: 4.1

#9905: AVG() on a datetime/timestamp does not return expected values

Thu, 14 Apr 2005 14:06:31 +0000

Bug ID: 9905
Submitted by:
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (RHEL 3 update 4)
Version: 4.1.11 rpm

#9934: DROP USER fails if mysql.procs_priv doesn't exists

Fri, 15 Apr 2005 15:25:37 +0000

Bug ID: 9934
Submitted by: MySQL-Front Team
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: 5.0.3-beta

#10048: 4.1 datetime fields aren't as 'relaxed' as 4.0; can cause replication issues

Wed, 20 Apr 2005 22:45:11 +0000

Bug ID: 10048
Submitted by: Lachlan Mulcahy
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1.11, 5.0.x

#10049: rownum functionality (alá Oracle)

Wed, 20 Apr 2005 23:02:52 +0000

Bug ID: 10049
Submitted by: Andris Kardos
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#10063: ANSI standard updating multiple rows -- foreign key constraints

Thu, 21 Apr 2005 15:15:57 +0000

Bug ID: 10063
Submitted by: d d
Category: Server: InnoDB
Status: Verified
Severity: 1
OS: Windows (Windows XP)
Version: 4.1.11

#10132: Crashing the server on corrupt InnoDB page is unhelpful

Mon, 25 Apr 2005 03:00:20 +0000

Bug ID: 10132
Submitted by: James Day
Category: Server: InnoDB
Status: Verified
Severity: 1
OS: Linux (Linux)
Version: 5.1, 6.0

#10133: Emergency fast shutdown options for power loss

Mon, 25 Apr 2005 03:59:05 +0000

Bug ID: 10133
Submitted by: James Day
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux, all)
Version: 4,5

#10139: limit resource usage instead of number of queries

Mon, 25 Apr 2005 09:43:44 +0000

Bug ID: 10139
Submitted by: Yannick Majoros
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1, 5.5

#10199: Allow Unicode escape sequence for string literals.

Wed, 27 Apr 2005 09:17:10 +0000

Bug ID: 10199
Submitted by: Paul van Rossem
Category: Server: Parser
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0

#10204: Memory DB: Restriction of 4 GB table size should not apply to 64-bit servers.

Wed, 27 Apr 2005 15:01:05 +0000

Bug ID: 10204
Submitted by: Disha
Category: Server
Status: Verified
Severity: 4
OS: Linux (Linux 9.x)
Version: 5.0.4 Beta

#10231: Problem creating fulltext index on a view

Thu, 28 Apr 2005 08:56:57 +0000

Bug ID: 10231
Submitted by: Gerard McGarry
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#10278: Not getting email notifications of replies to threads

Sat, 30 Apr 2005 08:45:13 +0000

Bug ID: 10278
Submitted by: NICHOLAS ROPER
Category: forums.mysql.com
Status: Verified
Severity: 3
OS: Any

#10327: Can't reopen temporary table - should be allowed

Tue, 03 May 2005 05:18:18 +0000

Bug ID: 10327
Submitted by: Jacek Becla
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Redhat Enterprise Linux)
Version: 5.0, 5.1

#10333: Incorrect error when deleting a foreign key with incorrect constraint name

Tue, 03 May 2005 13:29:35 +0000

Bug ID: 10333
Submitted by: Disha
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.7

#10342: disable keys for all tables

Tue, 03 May 2005 16:37:30 +0000

Bug ID: 10342
Submitted by: Jacek Becla
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#10396: UPDATE... [ON NONE FOUND INSERT]

Thu, 05 May 2005 19:03:36 +0000

Bug ID: 10396
Submitted by: Michael Winston
Category: Client
Status: Verified
Severity: 4
OS: Any (any)
Version: 4.1

#10503: data_seek to end (after last row)

Tue, 10 May 2005 11:25:51 +0000

Bug ID: 10503
Submitted by: Olaf van der Spek
Category: C API
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#10573: BOM(of UTF-8) is not correctly handled by LOAD DATA

Thu, 12 May 2005 08:08:24 +0000

Bug ID: 10573
Submitted by: Hartmut Holzgraefe
Category: Server: DML
Status: Verified
Severity: 2
OS: Linux (Linux)
Version: 4.1.11/5.6

#10744: Adding two constraints with the same name.

Thu, 19 May 2005 13:45:36 +0000

Bug ID: 10744
Submitted by: Kai Ruhnau
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Gentoo Linux)
Version: 4.1.11, 5.0.6

#10772: slave I/O thread should check for available disk space

Fri, 20 May 2005 18:24:43 +0000

Bug ID: 10772
Submitted by: Jonathan Miller
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (All)
Version: mysql-5.1

#10789: The ALTER syntax should support IF EXISTS like DROP

Sun, 22 May 2005 17:11:02 +0000

Bug ID: 10789
Submitted by: Ævar Arnfjörð Bjarmason -
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#10806: Garbage (?) value for "Max_data_length"

Mon, 23 May 2005 17:25:21 +0000

Bug ID: 10806
Submitted by: Joerg Bruehe
Category: Server: MyISAM
Status: Verified
Severity: 2
OS: IBM AIX (AIX 5.2)
Version: 5.0.6

#10817: Using resultsets returned by a SP in another SP

Tue, 24 May 2005 08:46:49 +0000

Bug ID: 10817
Submitted by: serle shuman
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.0

#10866: full log partition causes indefinite hang, stops system boot up

Wed, 25 May 2005 20:29:55 +0000

Bug ID: 10866
Submitted by: sean finney
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (debian gnu/linux)
Version: 4.1

#10907: need to be able to create tables of local scope in sp

Fri, 27 May 2005 08:55:21 +0000

Bug ID: 10907
Submitted by: serle shuman
Category: Server: SP
Status: Open
Severity: 4
OS: Any (all)
Version: 5.0.0

#10989: The subquery doesnt use the index type range

Tue, 31 May 2005 15:28:58 +0000

Bug ID: 10989
Submitted by: Mark Nozz
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1.11, 6.0.7

#10992: MyISAM foreign key definitions create indexes

Tue, 31 May 2005 16:17:14 +0000

Bug ID: 10992
Submitted by: Dean Ellis
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any
Version: 4.1.13, 5.1.52

#11145: Minor suggections for additional TimeZone support

Tue, 07 Jun 2005 17:02:22 +0000

Bug ID: 11145
Submitted by: Darryl Miles
Category: Server: General
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.0/4.1

#11202: Monitoring of ConcurrentOperations

Thu, 09 Jun 2005 12:28:43 +0000

Bug ID: 11202
Submitted by: Hartmut Holzgraefe
Category: Server: Cluster
Status: Verified
Severity: 4
OS: HP/UX (hp-ux, solaris)
Version: mysql-4.1

#11232: Return a warning if creating a FOREIGN KEY on storage engines w/out support

Fri, 10 Jun 2005 09:56:09 +0000

Bug ID: 11232
Submitted by: Tobias Asplund
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#11442: INSERT... ON DUPLICATE KEY UPDATE; w/ values taken from the INSERT part

Mon, 20 Jun 2005 02:25:29 +0000

Bug ID: 11442
Submitted by: Ondra Zizka
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0

#11480: Bad file option for LOAD DATA INFILE

Tue, 21 Jun 2005 12:23:34 +0000

Bug ID: 11480
Submitted by:
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.x

#11592: mysqld_safe restarts mysqld too quickly while port is still busy

Mon, 27 Jun 2005 13:15:31 +0000

Bug ID: 11592
Submitted by: Victoria Reznichenko
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 4.1

#11641: mysql_fix_privilege_tables: --no-defaults used, wrong mysql app

Wed, 29 Jun 2005 14:00:50 +0000

Bug ID: 11641
Submitted by: Geert Vanderkelen
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: *

#11644: large table with 4 byte pointers

Wed, 29 Jun 2005 17:10:30 +0000

Bug ID: 11644
Submitted by: Martin Friebe
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#11665: information_schema lacks information on available datatypes

Thu, 30 Jun 2005 12:27:21 +0000

Bug ID: 11665
Submitted by: Roland Bouman
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (NA)
Version: 5.0.7

#11696: Please add CREATE MODULE syntax, or Oracle PACKAGE equivalent

Fri, 01 Jul 2005 23:55:25 +0000

Bug ID: 11696
Submitted by: Roland Bouman
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (NA)
Version: 5.0.7

#11701: mysqlhotcopy - lock tables only when about to copy them

Sat, 02 Jul 2005 09:57:43 +0000

Bug ID: 11701
Submitted by: Dean Richardson
Category: Client
Status: Open
Severity: 4
OS: Any (any)
Version: current

#11715: naming rules for constraints lead to illstructured information_schema

Mon, 04 Jul 2005 00:08:10 +0000

Bug ID: 11715
Submitted by: Roland Bouman
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any
Version: 5.0.7

#11741: Cannot index a 0-length blob prefix

Tue, 05 Jul 2005 18:23:52 +0000

Bug ID: 11741
Submitted by: Frederic Briere
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.0.24_Debian-10

#11746: Stored Procedures: Update failure not handled by any of the error handlers

Tue, 05 Jul 2005 20:23:38 +0000

Bug ID: 11746
Submitted by: sujay koduri
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (Red Hat Linux 9.0)
Version: 5.0.4 beta, 5.0.13-BK

#11748: mysql.h exports generally-named functions

Tue, 05 Jul 2005 20:49:35 +0000

Bug ID: 11748
Submitted by: Timothy Smith
Category: Client
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#11948: MyISAM only, nested JOIN Views, dramatic performance loss

Thu, 14 Jul 2005 18:00:15 +0000

Bug ID: 11948
Submitted by: Matthias Leich
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0

#11984: It would be nice to be able to use "DESCRIBE" on more than one table at once

Sat, 16 Jul 2005 19:26:06 +0000

Bug ID: 11984
Submitted by: Aaron Gussman
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#12086: Check for enough free disk space before executing ALTER TABLE

Thu, 21 Jul 2005 18:49:53 +0000

Bug ID: 12086
Submitted by: David Ishee
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#12108: sum() for datatype time

Fri, 22 Jul 2005 12:40:01 +0000

Bug ID: 12108
Submitted by: Andreas Mller
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (Linux, Windows)
Version: 4.0.18, 4.1.12. 5.0.9

#12113: Composite index chosen partially for ORDER BY ... LIMIT query.

Fri, 22 Jul 2005 14:23:01 +0000

Bug ID: 12113
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 1
OS: Any
Version: 5.0.28-BK, 4.0,5.0

#12120: MySQL client always sends build-in charset when connecting

Fri, 22 Jul 2005 17:10:14 +0000

Bug ID: 12120
Submitted by: Alexander Drozdov
Category: C API
Status: Open
Severity: 4
OS: Linux (Linux)
Version: 4.1

#12130: SHOW WARNINGS improvement for monitoring

Sat, 23 Jul 2005 12:06:50 +0000

Bug ID: 12130
Submitted by: Jean-Luc Fontaine
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any
Version: 4.1

#12192: libmysqlclient_r should be built by default

Tue, 26 Jul 2005 23:36:55 +0000

Bug ID: 12192
Submitted by: Kate
Category: Server: Compiling
Status: Open
Severity: 4
OS: Any (Unix)
Version: 5.0.9

#12195: Use system EOL in 'LOAD DATA INFILE' and 'SELECT .. INTO OUTFILE'

Wed, 27 Jul 2005 06:10:43 +0000

Bug ID: 12195
Submitted by: Mario Esteves
Category: Server
Status: Verified
Severity: 4
OS: Windows (Microsoft Windows 2000)
Version: 4.1.12a-nt

#12197: GRANT should allow several objects to be specified

Wed, 27 Jul 2005 07:16:01 +0000

Bug ID: 12197
Submitted by: Carsten Pedersen
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (All)
Version: All

#12208: Function to return source table name when selecting from merge table?

Wed, 27 Jul 2005 15:28:30 +0000

Bug ID: 12208
Submitted by: James Harvard
Category: Server: General
Status: Open
Severity: 4
OS: Any

#12305: Feature Request: limiting database size

Mon, 01 Aug 2005 21:07:33 +0000

Bug ID: 12305
Submitted by: Markus Popp
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1?

#12414: index merge optimization doesn't work with FULLTEXT indexes

Sat, 06 Aug 2005 14:21:42 +0000

Bug ID: 12414
Submitted by: Gleb Paharenko
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.10

#12417: Connection.prepareCall() is database name case sensitive

Sat, 06 Aug 2005 20:01:42 +0000

Bug ID: 12417
Submitted by: Paul van Rossem
Category: Server: SP
Status: Verified
Severity: 3
OS: Windows (Windows XP)
Version: 5.0

#12445: convert_tz returns null if named time zone used

Mon, 08 Aug 2005 20:39:05 +0000

Bug ID: 12445
Submitted by: Jacek Becla
Category: Server
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0.9-beta-standard, 5.1

#12463: Help command line option doensn't work when you have an incorrect config file

Tue, 09 Aug 2005 14:51:17 +0000

Bug ID: 12463
Submitted by: Reggie Burnett
Category: Client
Status: Verified
Severity: 3
OS: Windows (Windows)
Version: 5.0

#12552: connection pooling does not work with MyODBC

Fri, 12 Aug 2005 14:31:07 +0000

Bug ID: 12552
Submitted by: Mathieu DESPRIEE
Category: Connector/ODBC
Status: Verified
Severity: 4
OS: Windows (windows)
Version: 3.51

#12568: Add a show QEP funktion as a SQL command

Sat, 13 Aug 2005 10:44:53 +0000

Bug ID: 12568
Submitted by: Peter Volk
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any

#12619: \! doesn't work on Windows

Wed, 17 Aug 2005 09:37:16 +0000

Bug ID: 12619
Submitted by: Victoria Reznichenko
Category: Client
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: any

#12657: ft_min_word_len for every fulltext index

Thu, 18 Aug 2005 21:05:01 +0000

Bug ID: 12657
Submitted by: Andre Timmer
Category: Server: FTS
Status: Verified
Severity: 4
OS: Any (Solaris, any)
Version: 5

#12658: Want to drop index on fk.

Thu, 18 Aug 2005 21:14:48 +0000

Bug ID: 12658
Submitted by: Andre Timmer
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Solaris (Solaris)
Version: 5

#12671: SHOW CREATE DATABASE shows versioned CHARACTER SET specification

Fri, 19 Aug 2005 10:32:18 +0000

Bug ID: 12671
Submitted by: Anders Karlsson
Category: Server: General
Status: Verified
Severity: 3
OS: Any (Linux)
Version: 5.0.10, 5.0.91, 5.1.53

#12679: myisam-recovery doesn't affect MyISAM tables if they are opened via MERGE table

Fri, 19 Aug 2005 15:41:30 +0000

Bug ID: 12679
Submitted by: Victoria Reznichenko
Category: Server: Merge
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#12699: SUBSTRING_INDEX() enhancement

Sun, 21 Aug 2005 08:35:12 +0000

Bug ID: 12699
Submitted by: Ondra Zizka
Category: Server: General
Status: Verified
Severity: 4
OS: Any (All)

#12707: The ON UPDATE and DEFAULT constructs need an Enahncement

Sun, 21 Aug 2005 23:33:52 +0000

Bug ID: 12707
Submitted by: Dale Harris
Category: Server: DDL
Status: Verified
Severity: 4
OS: Windows (Windows and Linux)
Version: 4.0, 5.1

#12719: SHOW CREATE PROCEDURE/FUNCTION does obey sql_quote_show_create

Mon, 22 Aug 2005 10:51:11 +0000

Bug ID: 12719
Submitted by: Anders Karlsson
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.12, 5.0.14-rc, 5.1.34

#12795: Non-locking ALTER TABLE for updating UNION of MERGEs

Thu, 25 Aug 2005 02:23:36 +0000

Bug ID: 12795
Submitted by: Lachlan Mulcahy
Category: Server: Merge
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1.12, 5.0.x

#12799: one result returned when change from summer time causes dup unique key recs

Thu, 25 Aug 2005 09:46:52 +0000

Bug ID: 12799
Submitted by: James Day
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Windows (windows xp)
Version: 5.0.10-log, 4.1.13a-log on win, 4.1 on RHES3.0

#12808: SHOW OPEN TABLES doesn't sort the output

Thu, 25 Aug 2005 15:05:16 +0000

Bug ID: 12808
Submitted by: Bugs System
Category: Server: I_S
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: 5.0.11-beta

#12811: DELETE doesn't support aliases

Thu, 25 Aug 2005 17:08:22 +0000

Bug ID: 12811
Submitted by: Jeremy Cole
Category: Server
Status: Verified
Severity: 4
OS: Any (any)
Version: 4.1.x, 5.0.11

#12866: No accessible transaction id within triggers

Tue, 30 Aug 2005 03:11:51 +0000

Bug ID: 12866
Submitted by: Frank McGeough
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (Windows 2003 server)
Version: 5.0.11

#12880: MaxNoOfTables option applies incorrect

Tue, 30 Aug 2005 14:49:26 +0000

Bug ID: 12880
Submitted by: Serge Kozlov
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (Mandrake Linux 10)
Version: 5.0+

#12888: Multiple Installations

Tue, 30 Aug 2005 17:03:15 +0000

Bug ID: 12888
Submitted by: Richard de Courtney
Category: MySQL Installer
Status: Verified
Severity: 4
OS: Windows (WINDOWS 2003)
Version: 4.x

#12901: Arbitration should not kick in in a system restart wich "becomes partial"

Wed, 31 Aug 2005 08:15:20 +0000

Bug ID: 12901
Submitted by: Tomas Ulin
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#12952: [NOTE] in mysqld error log from graceful cluster shutdown may misslead customer

Fri, 02 Sep 2005 15:51:33 +0000

Bug ID: 12952
Submitted by: Jonathan Miller
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: mysql-5.1

#12999: mysqldump consistent dump of MyISAM and InnoDB tables with minimal locking

Mon, 05 Sep 2005 22:28:37 +0000

Bug ID: 12999
Submitted by: Timothy Smith
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#13024: optimizer does not use index when where has (field1,field2,..)=(value1,value2,.

Tue, 06 Sep 2005 23:04:30 +0000

Bug ID: 13024
Submitted by: Jason Pyeron
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.1.14, 5.0.11

#13131: Creation of user groups

Tue, 13 Sep 2005 07:44:30 +0000

Bug ID: 13131
Submitted by: Frederic MASSOT
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Linux (Debian Sarge/i386)
Version: 4.1.11

#13156: myisam-recover rebuilds are hard to interrupt when necessary to restore service

Tue, 13 Sep 2005 21:55:33 +0000

Bug ID: 13156
Submitted by: James Day
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 4.1.14-pro-gpl-log

#13205: My.cnf Configurable GWS_FREQ Please?

Thu, 15 Sep 2005 00:26:19 +0000

Bug ID: 13205
Submitted by: John Crichton
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (Slackware Linux 10.1)
Version: 4.1.14 and Above

#13206: Boolean Full-Text Search Relevance Request

Thu, 15 Sep 2005 00:32:47 +0000

Bug ID: 13206
Submitted by: John Crichton
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (Slackware 10.1)
Version: 4.1.14 and Above

#13225: Symbolic links with UTF8 characters in the name don't work

Thu, 15 Sep 2005 15:02:21 +0000

Bug ID: 13225
Submitted by: Geert Vanderkelen
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 4.1

#13268: SQL mode to make identifiers uppercase

Fri, 16 Sep 2005 15:29:25 +0000

Bug ID: 13268
Submitted by: Lukas Smith
Category: Server: General
Status: Verified
Severity: 4
OS: Any (irrelevant)
Version: mysql5

#13375: Index with Desc sort feature

Wed, 21 Sep 2005 11:14:59 +0000

Bug ID: 13375
Submitted by: Sebastián Araya
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.x, 5.x, 6.0

#13382: Renaming a Table that is use in VIEWS leads to client problems

Wed, 21 Sep 2005 15:16:30 +0000

Bug ID: 13382
Submitted by: David Hammink
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (Linux Fedora Core 2)
Version: 5.0.12/BK source

#13413: Unable to get any information or stats on additional key buffers

Thu, 22 Sep 2005 21:51:11 +0000

Bug ID: 13413
Submitted by: Matthew Lord
Category: Server: General
Status: Verified
Severity: 4
OS: Any (all)
Version: 4.1.x, 5.0.x

#13468: Mysql optimizer decides to use tempfile and filesort when it's not necessary

Sun, 25 Sep 2005 10:10:08 +0000

Bug ID: 13468
Submitted by: Alexander Drozdov
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.1.14

#13572: PREPARE statement breaks on locally declared variables

Wed, 28 Sep 2005 15:33:40 +0000

Bug ID: 13572
Submitted by: Beat Vontobel
Category: Server: PS
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.13

#13577: HKSCS characters problem

Wed, 28 Sep 2005 16:39:37 +0000

Bug ID: 13577
Submitted by: Cyrus Choi
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1.x, 5.0.x, 5.1.x

#13617: enhancement to fillfactor

Thu, 29 Sep 2005 17:52:25 +0000

Bug ID: 13617
Submitted by: Rick James
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Any

#13741: cannot re-add constraint

Tue, 04 Oct 2005 12:53:12 +0000

Bug ID: 13741
Submitted by: Vladimir Kolesnikov
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux, win xp sp2)
Version: 5.0.13-rc-nt, 5.0.15-rc BK

#13768: Embedded MySQL Server is not re-entrant. (crashes)

Wed, 05 Oct 2005 10:49:29 +0000

Bug ID: 13768
Submitted by: Gary Ashford
Category: libmysqld
Status: Verified
Severity: 4
OS: Windows (Win 2000)
Version: 5.0.13 rc

#13819: Optionally suppress resultsets returned by SP's (DO syntax but now for SP's)

Thu, 06 Oct 2005 20:10:03 +0000

Bug ID: 13819
Submitted by: Roland Bouman
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.0.13

#13830: Support for ROW, ARRAY, and MULTISET type constructors

Fri, 07 Oct 2005 08:13:42 +0000

Bug ID: 13830
Submitted by: Sebastian Bergmann
Category: Server: Types
Status: Verified
Severity: 4
OS: Any (Irrelevant)
Version: Irrelevant

#13870: Allow variable filename for INTO OUTFILE clause

Sun, 09 Oct 2005 10:06:25 +0000

Bug ID: 13870
Submitted by: Roland Bouman
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.13

#13912: Add support for UCS2 with LOAD DATA INFILE

Tue, 11 Oct 2005 06:48:28 +0000

Bug ID: 13912
Submitted by: Lachlan Mulcahy
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1

#13933: Path name replacement fails in case-insignificant systems

Tue, 11 Oct 2005 16:31:57 +0000

Bug ID: 13933
Submitted by: Joerg Bruehe
Category: Server
Status: Verified
Severity: 3
OS: MacOS (Mac OS X 10.4)
Version: 4.1.15 and up

#13939: extension to SQL syntax: SELECT DEFAULT_IF_NULL

Tue, 11 Oct 2005 20:55:43 +0000

Bug ID: 13939
Submitted by: SweetAs
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (n/a)
Version: n/a

#13943: update tbl set fld1=fld2, fld2=fld1 fails to switch values

Wed, 12 Oct 2005 01:26:58 +0000

Bug ID: 13943
Submitted by: Joe Murray
Category: Server: DML
Status: Verified
Severity: 4
OS: Windows (Windows xp)
Version: 4.1

#13945: BENCHMARK() function not fully implemented

Wed, 12 Oct 2005 03:01:16 +0000

Bug ID: 13945
Submitted by:
Category: Server: DML
Status: Verified
Severity: 4
OS: Solaris (solaris 9)
Version: 5.0.13-RC/BK source

#13977: InnoDB foreign keys with multiple parent rows act incorrectly

Wed, 12 Oct 2005 20:00:22 +0000

Bug ID: 13977
Submitted by: Ian Gulliver
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Linux (Debian Sarge)
Version: 5.0.13

#14010: Precision math: DECIMAL(38,38) not accepted

Thu, 13 Oct 2005 17:09:41 +0000

Bug ID: 14010
Submitted by: Trudy Pelzer
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (SuSE 9.3)
Version: 5.0.15-rc-debug

#14017: mysql_stmt_param_metadata() needs to be implemented in C API

Thu, 13 Oct 2005 20:06:42 +0000

Bug ID: 14017
Submitted by: J Jorgenson
Category: C API
Status: Verified
Severity: 4
OS: Any (Linux/Windows)
Version: 5.0.9, 6.0.x, 5.5.x, 5.6.x

#14031: TIMESTAMP conflicts with Standard SQL 92 - please change

Fri, 14 Oct 2005 15:32:53 +0000

Bug ID: 14031
Submitted by: Jari Aalto
Category: Server
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0, 5.1, 5.4, 6.0

#14032: Comment with space requirement '-- ' is not standard SQL 92

Fri, 14 Oct 2005 15:58:54 +0000

Bug ID: 14032
Submitted by: Jari Aalto
Category: Server: General
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.x

#14050: Blocking some replication statements.

Sat, 15 Oct 2005 17:52:46 +0000

Bug ID: 14050
Submitted by: daniel lo
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (Any)
Version: Any

#14053: Impossible to access auto_increment values in triggers on insert

Sat, 15 Oct 2005 23:44:29 +0000

Bug ID: 14053
Submitted by: Beat Vontobel
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0.13-rc-standard-log

#14084: index_merge access method not used for federated engine

Mon, 17 Oct 2005 20:09:56 +0000

Bug ID: 14084
Submitted by: Sergey Petrunya
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0-bk

#14101: Allow KILL to take a list of processes to kill

Tue, 18 Oct 2005 00:57:36 +0000

Bug ID: 14101
Submitted by: Tobias Asplund
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (Windows/FreeBSD)
Version: 5.0.13-rc/BK source

#14102: PROCEDURE ANALYSE() should have Current_fieldtype in addition to Optimal_fieldt

Tue, 18 Oct 2005 01:02:06 +0000

Bug ID: 14102
Submitted by: Tobias Asplund
Category: Server
Status: Verified
Severity: 4
OS: Any (MS Windows/FreeBSD/Linux)
Version: 5.0.13-rc, all

#14111: Move metaphon from udf_example to main distribution

Tue, 18 Oct 2005 10:04:02 +0000

Bug ID: 14111
Submitted by: Sebastian Nohn
Category: Server: General
Status: Verified
Severity: 4
OS: Any (Irrelevant)
Version: 5.0

#14128: Trigger logging

Wed, 19 Oct 2005 02:41:17 +0000

Bug ID: 14128
Submitted by: dan
Category: Server: SP
Status: Open
Severity: 4
OS: Any

#14131: Report PAD attribute in SHOW COLLATION and INFORMATION_SCHEMA.COLLATIONS

Wed, 19 Oct 2005 06:06:28 +0000

Bug ID: 14131
Submitted by: Jan Lindström
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Linux (any)
Version: 5.0, 5.1, 6.0

#14203: SQL_LOG_OFF should not need priv_super

Fri, 21 Oct 2005 09:16:45 +0000

Bug ID: 14203
Submitted by: Christian Hammers
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Debian GNU/Linux)
Version: 4.1 and 5.0

#14208: SHOW COLUMNS FROM returns incorrect default val for TIMESTAMP

Fri, 21 Oct 2005 12:58:07 +0000

Bug ID: 14208
Submitted by: John Lucas
Category: Server: I_S
Status: Verified
Severity: 4
OS: Windows (Win 2k)
Version: 5.0.13

#14243: Statistics on MySQL cluster

Sun, 23 Oct 2005 19:45:38 +0000

Bug ID: 14243
Submitted by: Yann Neuhaus
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: mysql-5.0

#14253: Optimizer uses partial indexes for subqueries, where it should not

Mon, 24 Oct 2005 09:26:12 +0000

Bug ID: 14253
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0, 4.1, 6.0.14-bzr

#14303: Internal temporary tables consume too much memory

Tue, 25 Oct 2005 18:20:13 +0000

Bug ID: 14303
Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (Solaris)
Version: 5.0.26-BK, 5.0.18

#14347: Can't remove FOREIGN KEY

Wed, 26 Oct 2005 18:53:40 +0000

Bug ID: 14347
Submitted by: Vadim Tkachenko
Category: Server: Parser
Status: Verified
Severity: 2
OS: Linux (Linux Suse 10, Windows)
Version: 5.0.15, 5.0.74, 5.1.30, 6.0.9

#14487: Comments are being ripped out of SP's during restore.

Sun, 30 Oct 2005 08:37:02 +0000

Bug ID: 14487
Submitted by: Peter Hamilton-Scott
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.16-BK

#14521: FULLTEXT index provides no way to access indexed word lists

Mon, 31 Oct 2005 20:31:56 +0000

Bug ID: 14521
Submitted by: Ian Gulliver
Category: Server
Status: Verified
Severity: 4
OS: Linux (Debian Sid)
Version: 5.0.15

#14545: Median SQL Aggregate function

Tue, 01 Nov 2005 17:01:13 +0000

Bug ID: 14545
Submitted by: Joe Genshlea
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (any)

#14547: mysql_affected_rows() and mysql_info() client calls not made upon error

Tue, 01 Nov 2005 19:08:34 +0000

Bug ID: 14547
Submitted by: Matthew Lord
Category: C API
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#14594: mysqlhotcopy does not support tar method

Wed, 02 Nov 2005 23:01:00 +0000

Bug ID: 14594
Submitted by: Patrick Feliciano
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1.13

#14601: MySQL 5.0.15 with --ansi mode allows non-SQL92 operators (!, !=, etc.)

Thu, 03 Nov 2005 11:37:41 +0000

Bug ID: 14601
Submitted by: Jari Aalto
Category: Server: Parser
Status: Verified
Severity: 4
OS: Windows (Windows 2k)
Version: 5.0.15

#14636: Manual endian emulation - unneeded on some platforms

Fri, 04 Nov 2005 12:30:01 +0000

Bug ID: 14636
Submitted by: Gunnar von Boehn
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0.15

#14638: ptr_compare processes data only byte wise

Fri, 04 Nov 2005 13:10:07 +0000

Bug ID: 14638
Submitted by: Gunnar von Boehn
Category: Server: General
Status: Verified
Severity: 5
OS: Any (any)
Version: 5.0-BK, 5.1.43-bzr

#14641: Async client lib

Fri, 04 Nov 2005 13:48:28 +0000

Bug ID: 14641
Submitted by: Olaf van der Spek
Category: C API
Status: Open
Severity: 4
OS: Any (*)
Version: *

#14642: Please implement a CURRENT_DATABASE()/CURRENT_SCHEMA() function

Fri, 04 Nov 2005 14:01:20 +0000

Bug ID: 14642
Submitted by: Roland Bouman
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (NA)
Version: 5.0.15-nt

#14661: ALTER TRIGGER trigger_name DISABLE or ALTER TABLE table_name DISABLE TRIGGERS;

Fri, 04 Nov 2005 21:38:27 +0000

Bug ID: 14661
Submitted by: meo bogliolo
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (ALL)
Version: 5.0/5.1

#14668: funktions storing in machine independent format not optimized for PPC

Sat, 05 Nov 2005 08:19:09 +0000

Bug ID: 14668
Submitted by: Gunnar von Boehn
Category: Server
Status: Verified
Severity: 5
OS: Any (any)
Version: 5.0.16-BK, 5.1.34

#14669: Optimizer unneccesary re-evaluates static parts

Sat, 05 Nov 2005 10:06:11 +0000

Bug ID: 14669
Submitted by: Gunnar von Boehn
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0 and before

#14674: REAL_USER() function

Sat, 05 Nov 2005 22:56:03 +0000

Bug ID: 14674
Submitted by: Dan Lukes
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any

#14709: LOAD DATA INFILE: Indexes get disabled by LOAD DATA

Mon, 07 Nov 2005 15:30:22 +0000

Bug ID: 14709
Submitted by: martin koegler
Category: Server
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.16-BK, 4.1.14 (4.1.15),5.0.16

#14718: Support offset to DELETE with LIMIT

Mon, 07 Nov 2005 19:15:46 +0000

Bug ID: 14718
Submitted by: Gbz Bugzilla
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0

#14721: Should be allowed to reference column alias in another column expression

Mon, 07 Nov 2005 20:52:10 +0000

Bug ID: 14721
Submitted by: Mike MySQLAB
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.1

#14742: ALTER TABLE: unclear error message for a NULL value.

Tue, 08 Nov 2005 13:14:54 +0000

Bug ID: 14742
Submitted by: Kenneth Wagner
Category: Server: Errors
Status: Verified
Severity: 4
OS: Windows (Windows XP Pro)
Version: 5.0.15-nt

#14793: auto_increment pointer is not updated when auto_increment field is updated.

Wed, 09 Nov 2005 16:50:22 +0000

Bug ID: 14793
Submitted by: Nizamettin OZPOLAT
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0-BK, 5.0.15

#14883: Wanted "mode" parameter for functions dayofweek(), weekday()

Fri, 11 Nov 2005 19:30:37 +0000

Bug ID: 14883
Submitted by: Gisbert Selke
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (Win XP)
Version: 5.0.15

#14979: request for more than just one bind-address

Wed, 16 Nov 2005 12:40:24 +0000

Bug ID: 14979
Submitted by: Nils Goroll
Category: C API
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1, 5.0

#14985: Removing a Table "referenced" by a View is allowed

Wed, 16 Nov 2005 13:07:39 +0000

Bug ID: 14985
Submitted by: Alexandre Gomes
Category: Server: Views
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.17 BK

#14987: use of async i/o could lower latency and increase throughput per thread

Wed, 16 Nov 2005 14:17:38 +0000

Bug ID: 14987
Submitted by: Nils Goroll
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Solaris (Solaris)
Version: 4.1

#15026: File/directory watcher, File System Trigger?

Thu, 17 Nov 2005 16:55:35 +0000

Bug ID: 15026
Submitted by: Keith Blackwell
Category: Server: Locking
Status: Verified
Severity: 4
OS: Windows (Win32)
Version: 5.0

#15044: Query Cache synchronisation for multiple identical threads

Fri, 18 Nov 2005 09:09:21 +0000

Bug ID: 15044
Submitted by: James Bromberger
Category: Server: Query Cache
Status: Open
Severity: 4
OS: Any (All)
Version: 5.0.13

#15045: can't drop and recreate foreign key in a single ALTER TABLE statement

Fri, 18 Nov 2005 09:35:16 +0000

Bug ID: 15045
Submitted by: Hartmut Holzgraefe
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Windows (windows xp)
Version: 4.1

#15046: constraint incorrectly enforced

Fri, 18 Nov 2005 10:01:01 +0000

Bug ID: 15046
Submitted by: Aleksandar Ivanisevic
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Linux (linux)
Version: 4.1.15

#15066: Information schema

Sat, 19 Nov 2005 11:55:00 +0000

Bug ID: 15066
Submitted by: Zoltán Török
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any

#15085: Vote: Full-text Stemming

Sun, 20 Nov 2005 21:02:49 +0000

Bug ID: 15085
Submitted by: James Robertson
Category: Server: FTS
Status: Verified
Severity: 4
OS: Any (n/a)
Version: n/a

#15088: No status variable exists to test join_buffer_size efficientcy

Mon, 21 Nov 2005 04:06:34 +0000

Bug ID: 15088
Submitted by: Matthew Montgomery
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0

#15089: BLOB data should not remain in memory

Mon, 21 Nov 2005 04:24:52 +0000

Bug ID: 15089
Submitted by: Gili
Category: Server
Status: Verified
Severity: 2
OS: Any (Linux, Windows XP sp2)
Version: 3.1.10, 4.1, 5.0, 5.1, 6.0 bzr

#15105: mysqld ignores umask when creating its unix socket

Mon, 21 Nov 2005 18:09:31 +0000

Bug ID: 15105
Submitted by:
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux, sun-solaris2.10 on sparc)
Version: 5.0.17-BK, 4.0.24

#15109: Compound PKs with auto_increment don't work in InnoDB

Mon, 21 Nov 2005 20:24:13 +0000

Bug ID: 15109
Submitted by: Kristian Koehntopp
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Debian stable)
Version: 5.0.15

#15131: On-disk temporary tables created for GROUP BY should use indexes

Tue, 22 Nov 2005 11:44:08 +0000

Bug ID: 15131
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.1,5.0

#15189: Optimise INSERT ... ON DUPLICATE KEY ... for identical column values

Wed, 23 Nov 2005 15:59:48 +0000

Bug ID: 15189
Submitted by: James Harvard
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.17-BK

#15234: Returning a table as result of a function

Thu, 24 Nov 2005 16:55:41 +0000

Bug ID: 15234
Submitted by: Jonnes Bouma
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#15250: Limit a user CPU usage

Fri, 25 Nov 2005 18:31:06 +0000

Bug ID: 15250
Submitted by: Bernardo Torres
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1, 5.5

#15301: Server mode to reject UDF calls with type mismatched arguments

Tue, 29 Nov 2005 00:10:30 +0000

Bug ID: 15301
Submitted by: Roland Bouman
Category: Server: UDF
Status: Verified
Severity: 3
OS: Windows (WinXP pro)
Version: 5.0.15

#15325: initializing raw partition with INNODB extraordinarily clumsy

Tue, 29 Nov 2005 19:05:52 +0000

Bug ID: 15325
Submitted by: Eric Goff
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Linux (Linux)
Version: 5.0.16

#15344: Comments on views and triggers

Wed, 30 Nov 2005 09:43:08 +0000

Bug ID: 15344
Submitted by: Federico Razzoli
Category: Server: Views
Status: Verified
Severity: 4
OS: Any

#15423: Add support for 2-phase to blackhole

Fri, 02 Dec 2005 05:19:15 +0000

Bug ID: 15423
Submitted by: Elliot Murphy
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#15444: Non-unique indexes hidden on Information_schema

Fri, 02 Dec 2005 18:56:10 +0000

Bug ID: 15444
Submitted by: Eber Duarte
Category: Server: I_S
Status: Verified
Severity: 4
OS: Linux (Debian Linux i386)
Version: 5.0.16

#15519: Soundex in the words, not in the phrase.

Tue, 06 Dec 2005 14:17:48 +0000

Bug ID: 15519
Submitted by: Luis A S Junior Camargo
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.16

#15525: Misleading error when selecting non-existant keyword

Tue, 06 Dec 2005 16:05:37 +0000

Bug ID: 15525
Submitted by: Kolbe Kegel
Category: Server: Errors
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.x, 5.1.3

#15580: Some binlog functionality is missing in the embedded library

Thu, 08 Dec 2005 09:57:29 +0000

Bug ID: 15580
Submitted by: Guilhem Bichot
Category: Server: Replication
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.0

#15584: Server can not tell clients about generated keys

Thu, 08 Dec 2005 12:25:25 +0000

Bug ID: 15584
Submitted by: David Newcomb
Category: Server
Status: Analyzing
Severity: 4
OS: Any

#15609: ALTER TEMPORARY TABLE

Thu, 08 Dec 2005 23:27:42 +0000

Bug ID: 15609
Submitted by: Carsten Pedersen
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (Any)
Version: Any

#15638: need an id for db objects

Fri, 09 Dec 2005 16:07:00 +0000

Bug ID: 15638
Submitted by: Federico Razzoli
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#15704: NO_AUTO_CREATE_USER and empty password

Tue, 13 Dec 2005 07:22:05 +0000

Bug ID: 15704
Submitted by: Sergei Golubchik
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Any
Version: 5.0

#15720: wanting to restore specific tables from mysqldump generated dump

Tue, 13 Dec 2005 21:36:22 +0000

Bug ID: 15720
Submitted by: Bob McGuire
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Linux (linux (or all))
Version: 4.1 >

#15748: Enable a way to shrink innodb file (ibdata) after drop database commands

Wed, 14 Dec 2005 16:49:27 +0000

Bug ID: 15748
Submitted by: Bob McGuire
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Linux (linux (or all))
Version: 4.1 > or any

#15813: Feature Request for Named Parameters in the CALL statement

Fri, 16 Dec 2005 16:32:23 +0000

Bug ID: 15813
Submitted by: Jay Pipes
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0+

#15827: to be able to set foreign_key_checks with mysqlimport

Sat, 17 Dec 2005 15:48:14 +0000

Bug ID: 15827
Submitted by: Nizamettin OZPOLAT
Category: Client
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#15837: Convert datetime to integer as number of seconds from "zero time"

Sun, 18 Dec 2005 22:45:09 +0000

Bug ID: 15837
Submitted by:
Category: Server
Status: Open
Severity: 4

#15862: Dump of spatial data in WKT format

Mon, 19 Dec 2005 16:46:44 +0000

Bug ID: 15862
Submitted by: Giuseppe Maxia
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.16-max

#15880: The use of delimiters when creating procedures.

Tue, 20 Dec 2005 08:58:37 +0000

Bug ID: 15880
Submitted by: Andrew Gilfrin
Category: Client
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0+

#15907: Binary comparison ignores indexes

Wed, 21 Dec 2005 15:23:00 +0000

Bug ID: 15907
Submitted by: Jon Bright
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 5.0.19-BK, 5.0.13, 6.0.14-bzr

#15940: new data types

Thu, 22 Dec 2005 19:23:29 +0000

Bug ID: 15940
Submitted by: d d
Category: Server
Status: Open
Severity: 4

#15975: Optional parameters support in stored procedures

Sat, 24 Dec 2005 16:49:07 +0000

Bug ID: 15975
Submitted by: Roberto Meardi
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 5.0, 8.0

#15979: Support table_options on create table tbl_name like tbl_name

Sun, 25 Dec 2005 22:59:00 +0000

Bug ID: 15979
Submitted by: Stuart Friedberg
Category: Server
Status: Open
Severity: 4
OS: Windows (Windows 2000)
Version: 5.0.16

#16039: Data integrity is not validated after foreign key constraints are enabled !

Wed, 28 Dec 2005 11:05:47 +0000

Bug ID: 16039
Submitted by: g2293 g2293
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.19-BK

#16088: mysqldump cann't be used when innodb table had been locked by FLUSH READ LOCKS

Fri, 30 Dec 2005 02:54:17 +0000

Bug ID: 16088
Submitted by: ming lu
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0.12+

#16111: destroyed key cache still usable

Sat, 31 Dec 2005 05:26:35 +0000

Bug ID: 16111
Submitted by: Kolbe Kegel
Category: Server: MyISAM
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.17

#16130: A stored procedure can have the same name has a function.

Mon, 02 Jan 2006 17:28:04 +0000

Bug ID: 16130
Submitted by: Hasani Blackwell
Category: Server
Status: Open
Severity: 4
OS: Windows (Windows 2000 SP4)
Version: 5.0.18

#16184: DatabaseMetaData.getImportedKeys returns lower case tablename

Wed, 04 Jan 2006 13:14:54 +0000

Bug ID: 16184
Submitted by: Markus Fuchs
Category: Server: I_S
Status: Verified
Severity: 1
OS: Any (Windows, MacOSX)
Version: 5.0.18, 5.0, 5.1, 6.0 bzr

#16202: Add support for multiple InnoDB log file locations

Wed, 04 Jan 2006 20:29:27 +0000

Bug ID: 16202
Submitted by: Rob Blick
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0

#16225: Write logs for each new incoming TCP connection to ease attacks detections

Thu, 05 Jan 2006 14:56:32 +0000

Bug ID: 16225
Submitted by: Cyril Bouthors
Category: Server: Logging
Status: Open
Severity: 4
OS: Linux (Debian GNU/Linux)
Version: 4.1

#16227: Limit the number of unauthenticated users from the same IP address

Thu, 05 Jan 2006 15:01:19 +0000

Bug ID: 16227
Submitted by: Cyril Bouthors
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Debian GNU/Linux)
Version: 4.1

#16243: support for one-instance startup exclusive lock

Fri, 06 Jan 2006 03:50:28 +0000

Bug ID: 16243
Submitted by: xuefer tinys
Category: Server
Status: Open
Severity: 4
OS: Linux (linux)
Version: 4.1

#16264: MySQL hangs ugly if no space on device

Fri, 06 Jan 2006 19:38:04 +0000

Bug ID: 16264
Submitted by: Philip Stoev
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Fedora Core 4 2.6.13 in VMWare)
Version: 5.0.16-standard

#16356: Single packet limitation on transmissions a problem

Tue, 10 Jan 2006 23:00:08 +0000

Bug ID: 16356
Submitted by: Kevin Benton
Category: Server
Status: Verified
Severity: 4
OS: Any (All)
Version: All

#16367: SLEEP is considered Slow Query

Wed, 11 Jan 2006 11:30:30 +0000

Bug ID: 16367
Submitted by: Luis A S Junior Camargo
Category: Server: Logging
Status: Verified
Severity: 4
OS: Windows (Win2000 SP4)
Version: 5.0.18

#16402: Events: SHOW EVENT STATUS doesn't work

Thu, 12 Jan 2006 03:44:53 +0000

Bug ID: 16402
Submitted by: Peter Gulutzan
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1.6-alpha-debug

#16437: mysqlhotcopy rsync support

Thu, 12 Jan 2006 05:01:48 +0000

Bug ID: 16437
Submitted by:
Category: Client
Status: Open
Severity: 4
OS: Linux (Debian "sarge" 3.1)
Version: 4.0.24-10sarge1

#16524: Database accounting/monitoring per user

Sun, 15 Jan 2006 22:28:43 +0000

Bug ID: 16524
Submitted by: Dennis Krul
Category: Server: Logging
Status: Verified
Severity: 4
OS: Linux (GNU/Linux)
Version: 5

#16525: INSTEAD OF triggers

Sun, 15 Jan 2006 23:37:12 +0000

Bug ID: 16525
Submitted by: Markus Popp
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.X

#16542: "--purge-master-logs" option for mysqldump

Mon, 16 Jan 2006 16:49:55 +0000

Bug ID: 16542
Submitted by: Eric Martel
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#16556: DD: New error messages needed

Tue, 17 Jan 2006 02:14:19 +0000

Bug ID: 16556
Submitted by: Nikolay Grishakin
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#16564: Efficient way to use IN() in prepared statements

Tue, 17 Jan 2006 15:36:41 +0000

Bug ID: 16564
Submitted by: Kevin Musker
Category: Server: PS
Status: Verified
Severity: 4
OS: Any

#16646: mysql-test-run.pl ignores --socket , when not running in --extern mode

Thu, 19 Jan 2006 18:18:50 +0000

Bug ID: 16646
Submitted by: Matthias Leich
Category: Client
Status: Verified
Severity: 4
OS: Any (4.1)

#16690: Allow date calculations on incomplete dates (like YYYY-MM-00)

Fri, 20 Jan 2006 22:42:21 +0000

Bug ID: 16690
Submitted by: Peter Thomassen
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: All (?)

#16692: Allow deny in privileges

Sat, 21 Jan 2006 01:12:21 +0000

Bug ID: 16692
Submitted by: Michael Caldwell
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 5.0.16

#16707: --force doesn't work with --execute

Sun, 22 Jan 2006 05:03:34 +0000

Bug ID: 16707
Submitted by: Kolbe Kegel
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.19

#16764: SHOW BINLOG EVENTS not showing error_code or exec_time

Wed, 25 Jan 2006 01:51:49 +0000

Bug ID: 16764
Submitted by: Hartmut Holzgraefe
Category: Server: Replication
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.0

#16826: SQL_CALC_FOUND_ROWS and NULLs

Fri, 27 Jan 2006 03:04:50 +0000

Bug ID: 16826
Submitted by: Peter Larb
Category: Server
Status: Open
Severity: 4
OS: UNIX
Version: 5.0x

#16862: Views appear to have no indices

Fri, 27 Jan 2006 23:20:50 +0000

Bug ID: 16862
Submitted by: Alan Bruce
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0.18

#16864: strxmov in the code, possible buffer overruns

Sat, 28 Jan 2006 10:09:04 +0000

Bug ID: 16864
Submitted by: Sergei Golubchik
Category: Server: General
Status: Verified
Severity: 2
OS: Any
Version: 5.0

#16904: CAST and CONVERT limitation

Mon, 30 Jan 2006 16:26:01 +0000

Bug ID: 16904
Submitted by: Nuno Soares
Category: Server: Types
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 5.0.18

#16916: binlog feature request -- DML and DDL logging control

Mon, 30 Jan 2006 21:37:52 +0000

Bug ID: 16916
Submitted by: Sheeri Cabral
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (Fedora Core 3 i86_64)
Version: 4.1, 5.1

#16994: CREATE TABLE for MERGE should logically allow LIKE tablename

Wed, 01 Feb 2006 04:19:38 +0000

Bug ID: 16994
Submitted by: David Nugent
Category: Server
Status: Open
Severity: 4
OS: FreeBSD (FreeBSD 6.0)
Version: 5

#17009: Stored Procedures: allow cursors on anything that returns a result set.

Wed, 01 Feb 2006 15:28:41 +0000

Bug ID: 17009
Submitted by: Beat Vontobel
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0.18

#17025: memory tables don't use large-pages for now

Wed, 01 Feb 2006 22:05:28 +0000

Bug ID: 17025
Submitted by: Harald Petrovitsch
Category: Server: Memory
Status: Open
Severity: 4
OS: Linux (linux)
Version: 5.0.16

#17034: Error messages from stored routines should name their source

Thu, 02 Feb 2006 11:05:37 +0000

Bug ID: 17034
Submitted by: Beat Vontobel
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.1

#17050: FEDERATED storage engine does not support FULLTEXT index

Thu, 02 Feb 2006 15:53:50 +0000

Bug ID: 17050
Submitted by: Kristian Koehntopp
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any (any Linux)
Version: 5.0.18 (MySQL download)

#17077: MyISAM: controlling data files fragmentation

Thu, 02 Feb 2006 17:47:32 +0000

Bug ID: 17077
Submitted by: David Lombardi
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any
Version: 5.x

#17092: allowing TRUNCATE TABLE while LOCKing done.

Fri, 03 Feb 2006 07:34:40 +0000

Bug ID: 17092
Submitted by: vijay patel
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#17098: Drop column should drop any indexes of which that column is a part

Fri, 03 Feb 2006 12:55:57 +0000

Bug ID: 17098
Submitted by: Olaf van der Spek
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any (*)
Version: 5

#17115: Secure by default, default root password

Sat, 04 Feb 2006 11:46:15 +0000

Bug ID: 17115
Submitted by: Olaf van der Spek
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#17153: Cursors impossible on dynamic SQL

Mon, 06 Feb 2006 13:46:13 +0000

Bug ID: 17153
Submitted by: Beat Vontobel
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0.18

#17193: Long lock time in slow query log

Tue, 07 Feb 2006 15:51:19 +0000

Bug ID: 17193
Submitted by: Olaf van der Spek
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#17258: Cast of x'hexstring' fails to cast if odd length hexstring is given.

Thu, 09 Feb 2006 01:43:39 +0000

Bug ID: 17258
Submitted by: Ralf Leidinger
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Windows (windows xp sp2)
Version: 5.0.18-nt-max

#17259: Query optimizer chooses wrong index

Thu, 09 Feb 2006 02:23:04 +0000

Bug ID: 17259
Submitted by: Brad Green
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 5.0.15, 6.0.7

#17299: Inefficient optimizer for fulltext queries.

Fri, 10 Feb 2006 12:35:42 +0000

Bug ID: 17299
Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any (All)
Version: 5.0.18

#17318: allow to throttle/lock user after x wrong password entries

Sat, 11 Feb 2006 08:31:24 +0000

Bug ID: 17318
Submitted by: Ralf Hauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#17319: Allow to server SSL users via a different port

Sat, 11 Feb 2006 08:35:29 +0000

Bug ID: 17319
Submitted by: Ralf Hauser
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#17322: allow for self signed SSL client certificates to be added on the fly

Sat, 11 Feb 2006 11:23:16 +0000

Bug ID: 17322
Submitted by: Ralf Hauser
Category: Server
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#17343: XAConnection doesn't allow second XA START

Mon, 13 Feb 2006 17:23:55 +0000

Bug ID: 17343
Submitted by: Sergey Vladimirov
Category: Server: General
Status: Verified
Severity: 2
OS: Linux (Linux, Windows XP)
Version: 5.0.19-BK

#17350: General log should indicate whether commands were successful

Mon, 13 Feb 2006 18:11:38 +0000

Bug ID: 17350
Submitted by: Markus Popp
Category: Server: Logging
Status: Verified
Severity: 4
OS: Linux (SuSE Linux 10.0)
Version: 5.1.7-beta

#17370: creation of invalid views impossible, valid flag missing

Tue, 14 Feb 2006 10:52:10 +0000

Bug ID: 17370
Submitted by: Kristian Koehntopp
Category: Server: Views
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#17409: PREPARE doesn't support queries in local variables

Wed, 15 Feb 2006 02:21:46 +0000

Bug ID: 17409
Submitted by: Ian Gulliver
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (Debian Etch)
Version: 5.1.5-alpha-max

#17426: Add support for skipping locks

Wed, 15 Feb 2006 13:52:25 +0000

Bug ID: 17426
Submitted by: Philip Ross
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1

#17428: TRIGGER EVENT does not work

Wed, 15 Feb 2006 15:24:23 +0000

Bug ID: 17428
Submitted by: Andrey Hristov
Category: Server: SP
Status: Verified
Severity: 4
Version: 5.1.7-beta

#17448: create table like is missing all constraint definitions

Thu, 16 Feb 2006 11:10:01 +0000

Bug ID: 17448
Submitted by: Kristian Koehntopp
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#17456: Error message trying to delete records from general_log or slow_log

Thu, 16 Feb 2006 13:57:05 +0000

Bug ID: 17456
Submitted by: Markus Popp
Category: Server: Logging
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.1.6

#17513: User defined functions API is undedeveloped

Fri, 17 Feb 2006 09:03:39 +0000

Bug ID: 17513
Submitted by: Kristian Koehntopp
Category: Server: UDF
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#17561: I want to configure InnoDB Page Size at ./configure

Sun, 19 Feb 2006 21:43:17 +0000

Bug ID: 17561
Submitted by: Tetsuro Ikeda
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: MyQL 5.1.7

#17597: CREATE TRIGGER does not check privileges the standard way

Mon, 20 Feb 2006 20:20:57 +0000

Bug ID: 17597
Submitted by: Sergei Golubchik
Category: Server: SP
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#17598: privilege checks when trigger is executed

Mon, 20 Feb 2006 20:26:23 +0000

Bug ID: 17598
Submitted by: Sergei Golubchik
Category: Server: SP
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#17613: Change privileges after object is changed

Tue, 21 Feb 2006 13:19:49 +0000

Bug ID: 17613
Submitted by: Markus Popp
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0/5.1

#17627: .my.cnf: Multiple host, user, pass, db entries

Tue, 21 Feb 2006 20:12:35 +0000

Bug ID: 17627
Submitted by: Olaf van der Spek
Category: Client
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#17632: Automatically trigger stored precedures based on events (user login, shutdown)

Tue, 21 Feb 2006 23:08:45 +0000

Bug ID: 17632
Submitted by: Morgan Tocker
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (ALL)
Version: 5.1+

#17640: wrong where clause optimization

Wed, 22 Feb 2006 10:18:03 +0000

Bug ID: 17640
Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0.18

#17656: Perform Check for User before Creating Views in info_schema.views

Wed, 22 Feb 2006 23:32:38 +0000

Bug ID: 17656
Submitted by: Chris Calender
Category: Server: Views
Status: Verified
Severity: 4

#17738: --log-queries-not-using-indexes can not be seen in SHOW VARIABLES

Mon, 27 Feb 2006 13:20:01 +0000

Bug ID: 17738
Submitted by: Geert Vanderkelen
Category: Server: General
Status: Verified
Severity: 4
OS: Any (*)
Version: 5.0.18

#17785: Transactions on Federated Engine do not work when initiated on federated server

Tue, 28 Feb 2006 14:38:59 +0000

Bug ID: 17785
Submitted by: Ivan Zoratti
Category: Server: Federated
Status: Verified
Severity: 2
OS: Linux (Linux Fedora Core 4)
Version: 5.1.6

#17788: LCP should start on out of Redo, ndb_restore should retry more

Tue, 28 Feb 2006 15:57:48 +0000

Bug ID: 17788
Submitted by: Johan Andersson
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any (*)
Version: mysql-4.1

#17825: Request: UNIQUE index which treats NULL as a unique value

Wed, 01 Mar 2006 14:15:41 +0000

Bug ID: 17825
Submitted by: Erland Lewin
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any

#17832: group_concat seperator parameter doesn't accept variables

Wed, 01 Mar 2006 18:41:34 +0000

Bug ID: 17832
Submitted by: Marques Johansson
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#17842: Statement pruning on UNION SELECT

Wed, 01 Mar 2006 21:42:33 +0000

Bug ID: 17842
Submitted by: Beat Vontobel
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0.18

#17897: progress indicator

Fri, 03 Mar 2006 13:21:52 +0000

Bug ID: 17897
Submitted by: Alex Zimnitski
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (any)

#17902: Support years < 1000 and >= -9999 for date/datetime data type

Fri, 03 Mar 2006 17:17:47 +0000

Bug ID: 17902
Submitted by: Matthew Schultz
Category: Server: Types
Status: Verified
Severity: 4
OS: Any

#17909: default index location variable

Fri, 03 Mar 2006 22:43:46 +0000

Bug ID: 17909
Submitted by: Rob Blick
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#17979: my_print_defaults/mysql_install_db ignore [mysqld-X.Y] sections in option files

Mon, 06 Mar 2006 18:29:53 +0000

Bug ID: 17979
Submitted by: Geert Vanderkelen
Category: Server
Status: Patch approved
Severity: 3
OS: Any
Version: 5.0

#17991: General log doesn't have --init-file statements

Mon, 06 Mar 2006 20:47:21 +0000

Bug ID: 17991
Submitted by: Peter Gulutzan
Category: Server: Logging
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0)
Version: 5.1.8-beta-debug/5.0BK/4.1BK

#17998: prevent users from setting ALLOW_INVALID_DATES in their session

Mon, 06 Mar 2006 22:21:17 +0000

Bug ID: 17998
Submitted by: Lukas Smith
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (irrelevant)
Version: all

#18003: FULL OUTER JOIN (no syntax to cover)

Mon, 06 Mar 2006 23:33:02 +0000

Bug ID: 18003
Submitted by: Michael Christen
Category: Server: DML
Status: Verified
Severity: 4
OS: MacOS (OS-X)
Version: 5.1

#18042: Optimizer chooses nonoptimal plan

Tue, 07 Mar 2006 16:27:46 +0000

Bug ID: 18042
Submitted by: Vadim Tkachenko
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (RedHat)
Version: 5.0

#18073: selective enabling/disabling of binary log

Wed, 08 Mar 2006 15:11:31 +0000

Bug ID: 18073
Submitted by: Rob Blick
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0.18

#18138: FORCE INDEX is ignored when using NDB tables

Fri, 10 Mar 2006 15:56:19 +0000

Bug ID: 18138
Submitted by: Walter Bertot
Category: Server: Cluster
Status: Verified
Severity: 1
OS: Linux (RHE 3.0)
Version: mysql-5.0

#18178: Index Fill Factor

Mon, 13 Mar 2006 03:24:46 +0000

Bug ID: 18178
Submitted by: Simon Litchfield
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#18240: needs TIMESUM() function. SUM doesn't SUM Timediffs

Wed, 15 Mar 2006 00:00:14 +0000

Bug ID: 18240
Submitted by: Jim Michaels
Category: Server
Status: Open
Severity: 4
Version: 5.0.18

#18248: error messages issued with STRICT_ALL_TABLES are sometimes misleading

Wed, 15 Mar 2006 07:38:34 +0000

Bug ID: 18248
Submitted by: Giuseppe Maxia
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.19, 5.1.7

#18253: mysqlclient: Ctrl+C -> abort query result displaying

Wed, 15 Mar 2006 14:04:06 +0000

Bug ID: 18253
Submitted by: Olaf van der Spek
Category: Client
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#18260: mysqldumpslow doesn't properly handle multi-row inserts/updates

Wed, 15 Mar 2006 17:08:31 +0000

Bug ID: 18260
Submitted by: Olaf van der Spek
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Linux (Debian)
Version: 5.0.18

#18304: it's not possible to set collation_connection in the my.cnf

Fri, 17 Mar 2006 11:56:26 +0000

Bug ID: 18304
Submitted by: Arnim Rupp
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Solaris (solaris 8 64bit)
Version: 5.0.19

#18335: LOAD DATA INFILE fixed row bug with CHAR and VARCHAR

Sat, 18 Mar 2006 19:57:53 +0000

Bug ID: 18335
Submitted by: Marco Carvalho
Category: Server: Charsets
Status: Verified
Severity: 2
OS: Linux (Linux, Windows XP)
Version: 5.0.22-BK, 5.0.19-nt

#18340: Granting/revoking access privleges

Sun, 19 Mar 2006 03:53:18 +0000

Bug ID: 18340
Submitted by: Michael Stanton
Category: Server: General
Status: Open
Severity: 4

#18433: Lift limitation on using variables in view definition

Wed, 22 Mar 2006 19:16:00 +0000

Bug ID: 18433
Submitted by: Dmitry L
Category: Server: Views
Status: Verified
Severity: 4
OS: Any (irrevelant)
Version: 5.0.25-BK, 5.1.x

#18446: INFORMATION_SCHEMA.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME always lowercase

Thu, 23 Mar 2006 02:56:03 +0000

Bug ID: 18446
Submitted by: Joel Bruick
Category: Server: DDL
Status: Verified
Severity: 2
OS: Windows (Windows)
Version: 5.0.22, 5.0.19

#18458: ORDER BY (a,b) LIMIT ... should be able to utilize single-column index on (a)

Thu, 23 Mar 2006 14:57:22 +0000

Bug ID: 18458
Submitted by: Domas Mituzas
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1,5.0,5.1

#18465: Optimizer/execution plan bug with dependent subqueries in ON clauses of JOINs

Thu, 23 Mar 2006 17:43:41 +0000

Bug ID: 18465
Submitted by: Beat Vontobel
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (any)
Version: 5.0.20-BK, 5.0.19, 5.0.85

#18466: add REPLACE to CREATE FUNCTION, PROCEDURE, TRIGGER

Thu, 23 Mar 2006 18:37:33 +0000

Bug ID: 18466
Submitted by: vadim likhota
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.x

#18493: "Using index for group-by" not used in subqueries

Fri, 24 Mar 2006 17:01:10 +0000

Bug ID: 18493
Submitted by: Björn Steinbrink
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18

#18520: Index V not used for 'where V' and 'where not V'

Sun, 26 Mar 2006 13:26:34 +0000

Bug ID: 18520
Submitted by: Olaf van der Spek
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.21-BK, 5.0.18

#18532: An Aggregate Function that returns the product of all values, similar to SUM

Mon, 27 Mar 2006 07:15:41 +0000

Bug ID: 18532
Submitted by: Stephen Martindale
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (All)
Version: All Future

#18576: Latin1 character set is obsolete, should use euro-compatible latin9 as default

Tue, 28 Mar 2006 16:00:42 +0000

Bug ID: 18576
Submitted by: Bruce Attah
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any

#18688: non-optimal plan for SELECT

Fri, 31 Mar 2006 14:07:35 +0000

Bug ID: 18688
Submitted by: Victoria Reznichenko
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 4.0, 4.1, 5.0

#18692: myisampack cannot be executed on a live server

Fri, 31 Mar 2006 15:50:21 +0000

Bug ID: 18692
Submitted by: Ajit Deshpande
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (Linux (Centos 4.2))
Version: 5.0.19, 5.0.74, 5.1.30

#18821: mysqlimport

Wed, 05 Apr 2006 19:22:15 +0000

Bug ID: 18821
Submitted by: john h
Category: Client
Status: Verified
Severity: 4

#18845: Cursor traversal issues

Thu, 06 Apr 2006 12:29:10 +0000

Bug ID: 18845
Submitted by: Robin Schumacher
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#18865: Table definitions "stay" even after a ndbd --initial

Thu, 06 Apr 2006 19:29:52 +0000

Bug ID: 18865
Submitted by: Kris Buytaert
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: mysql-4.1

#18913: Physical order of rows in table alters update behavior of unique index

Sun, 09 Apr 2006 02:01:51 +0000

Bug ID: 18913
Submitted by: John Miller
Category: Server: DML
Status: Verified
Severity: 2
OS: Any
Version: 5.0.21-BK, 5.0.19,5.7.4

#18938: Disallowing DROP DATABASE via privileges

Mon, 10 Apr 2006 10:47:40 +0000

Bug ID: 18938
Submitted by: Jelle Raaijmakers
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any

#19003: Transpose table utility

Tue, 11 Apr 2006 07:30:22 +0000

Bug ID: 19003
Submitted by: Mark V
Category: Client
Status: Verified
Severity: 4
OS: Windows (WinXP)
Version: 5.x

#19028: Option for mysqldump to dump table names in uppercase

Wed, 12 Apr 2006 03:44:20 +0000

Bug ID: 19028
Submitted by: Justin Plock
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 5.0.20

#19054: FEDERATED storage engine generates non-efficient queries with LIMIT clause

Wed, 12 Apr 2006 15:00:41 +0000

Bug ID: 19054
Submitted by: Manuel Matonin
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.1.12-BK, 5.0.23-BK, 5.0.17

#19150: batch statements

Mon, 17 Apr 2006 20:59:29 +0000

Bug ID: 19150
Submitted by: cristian vanti
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1

#19173: Foreign Key reference integrity

Tue, 18 Apr 2006 18:19:42 +0000

Bug ID: 19173
Submitted by: Barry Quiel
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.20

#19195: Optimizer does not use proper index for join

Wed, 19 Apr 2006 12:09:46 +0000

Bug ID: 19195
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.27-BK, 5.0.21-BK, 5.0.19

#19292: libmysql default-charset cannot be changed

Mon, 24 Apr 2006 08:15:27 +0000

Bug ID: 19292
Submitted by:
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: <=5.1

#19324: Structured system variables are not displayed nor have a status

Tue, 25 Apr 2006 07:53:39 +0000

Bug ID: 19324
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any (n.a.)
Version: any

#19327: Optimizer estimates columns with many NULL values wrong

Tue, 25 Apr 2006 08:41:03 +0000

Bug ID: 19327
Submitted by: Oli Sennhauser
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: 4.1 and 5.0

#19355: RETURN inside SP

Tue, 25 Apr 2006 21:06:45 +0000

Bug ID: 19355
Submitted by: cristian vanti
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1

#19447: Have default values for fields when using INSERT on a view

Sun, 30 Apr 2006 16:53:23 +0000

Bug ID: 19447
Submitted by: Mike Hartmann
Category: Server
Status: Open
Severity: 4
OS: Any (all)
Version: 5

#19538: Doesn't report protection error on my.cnf carries on with defaults

Thu, 04 May 2006 15:48:05 +0000

Bug ID: 19538
Submitted by: Kerry Gibbings
Category: Server: General
Status: Verified
Severity: 4
OS: Any (OpenVMS, linux)
Version: 4.1.14-log, 5.0bk

#19548: JOIN and composite indexes (not using full length)

Thu, 04 May 2006 22:09:30 +0000

Bug ID: 19548
Submitted by: Mathew Johnston
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Redhat Linux ES4)
Version: 5.0.18-pro, 5.1.40sp1

#19567: Case insensitive multilingual unicode collations

Fri, 05 May 2006 17:19:08 +0000

Bug ID: 19567
Submitted by: Lutz Schwarz
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Windows (windows)
Version: 5.0.22, 4.1.15

#19584: CREATE USER in STORED PROCEDURE doesn't work with Variables

Sat, 06 May 2006 18:42:22 +0000

Bug ID: 19584
Submitted by: Christian Benner
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (W2K SRV)
Version: 5.0.20-nt-max

#19586: Index corruption (errno 144) doesn't get handled by auto-recover

Sat, 06 May 2006 20:46:18 +0000

Bug ID: 19586
Submitted by: Alexey Polyakov
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Linux (RHEL4)
Version: 4.1.18, probably affects other versions

#19597: listen, unlisten, notify

Sun, 07 May 2006 21:42:00 +0000

Bug ID: 19597
Submitted by: ladimir Kolpakov
Category: Server: DML
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#19607: German Case Sensitive Collation is missing

Mon, 08 May 2006 13:45:08 +0000

Bug ID: 19607
Submitted by: Kristian Koehntopp
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1, 5.0, 5.1

#19614: log_bin variables show something else than entered in my.cnf

Mon, 08 May 2006 14:56:16 +0000

Bug ID: 19614
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1

#19646: Searching for bugs on ALL keywords

Tue, 09 May 2006 17:30:56 +0000

Bug ID: 19646
Submitted by: Andre Timmer
Category: bugs.mysql.com
Status: Verified
Severity: 4
OS: Any (not relevant)
Version: 5.0.18

#19673: Bursts in checkpointing with a main memory database

Wed, 10 May 2006 11:57:00 +0000

Bug ID: 19673
Submitted by: Heikki Tuuri
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Any
Version: All

#19735: wait_timeout=0 sets wait_timeout=1 (requesting 0=infinite).

Thu, 11 May 2006 17:57:20 +0000

Bug ID: 19735
Submitted by: Morgan Tocker
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#19783: triggers are triggered on just single node in clustered table

Fri, 12 May 2006 19:27:51 +0000

Bug ID: 19783
Submitted by: johnny slakva
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Linux (RHEL3)
Version: mysql-5.0

#19794: Stored Procedures: No way to "print" log messages to clients

Sat, 13 May 2006 12:48:18 +0000

Bug ID: 19794
Submitted by: Paul Medynski
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (Linux 2.4.27-2-386)
Version: 5.1.7-beta-log

#19812: EXPLAIN: add option that causes the statement to be actually executed

Mon, 15 May 2006 09:23:27 +0000

Bug ID: 19812
Submitted by: Lukas Smith
Category: Client
Status: Verified
Severity: 4
OS: Any (irrelevant)
Version: irrelevant

#19826: SHOW MASTER LOGS blocks when filesystem is full

Mon, 15 May 2006 18:22:48 +0000

Bug ID: 19826
Submitted by: Geert Vanderkelen
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.1

#19837: myisamchk doesn't return error status

Tue, 16 May 2006 02:41:09 +0000

Bug ID: 19837
Submitted by: Thiago Figueiro
Category: Client
Status: Verified
Severity: 4
OS: Linux (RHEL4)
Version: 5.0.21-1

#19851: Make ndb_mgm report data/index memory usage per node and a cluster wide total

Tue, 16 May 2006 13:15:55 +0000

Bug ID: 19851
Submitted by: heh heh
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any (*)
Version: mysql-5.1

#19887: concurrent updates restricted by queries not using the binlog

Wed, 17 May 2006 15:17:20 +0000

Bug ID: 19887
Submitted by: Martin Friebe
Category: Server: Locking
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1 / 5.0

#19913: Misleading error messages when user attempts to GRANT a priv he doesn't have

Thu, 18 May 2006 17:01:04 +0000

Bug ID: 19913
Submitted by: Erica Moss
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Windows (win32 - XP SP2)
Version: 5.0.21-community-nt

#19945: no DATE_FORMAT(date, %Z)

Fri, 19 May 2006 16:15:52 +0000

Bug ID: 19945
Submitted by: Paul Miller
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.19

#19953: Incomplete error when attempting to CREATE VIEW without SELECT GRANT

Fri, 19 May 2006 18:58:47 +0000

Bug ID: 19953
Submitted by: Erica Moss
Category: Server: Views
Status: Verified
Severity: 3
OS: Windows (win32 - XP SP2)
Version: 5.0.21-community-nt

#19989: log-files on windows should follow windows standards

Sun, 21 May 2006 19:50:37 +0000

Bug ID: 19989
Submitted by: Peter Laursen
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (windows)
Version: any

#19996: mysqlimport needs "ignore foreign keys" option

Mon, 22 May 2006 10:59:06 +0000

Bug ID: 19996
Submitted by: Johan Idrén
Category: Client
Status: Verified
Severity: 4
OS: Any (All)
Version: 4.0 and up

#20001: Support for temp-tables in INFORMATION_SCHEMA

Mon, 22 May 2006 14:57:37 +0000

Bug ID: 20001
Submitted by: Peter Laursen
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.x

#20026: FEDERATED lacks support for auto_increment_increment and auto_increment_offset

Tue, 23 May 2006 19:34:53 +0000

Bug ID: 20026
Submitted by: Guilhem Bichot
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1-bk

#20040: SSL connections do not affect SSL statistics in STATUS output

Wed, 24 May 2006 10:46:26 +0000

Bug ID: 20040
Submitted by: Domas Mituzas
Category: Server: Options
Status: Verified
Severity: 3
OS: Any (*)
Version: 5.1-bk, 5.0.38

#20058: Query Internal ANALYZE counter in show status (or similar)

Wed, 24 May 2006 21:31:37 +0000

Bug ID: 20058
Submitted by: Morgan Tocker
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (ALL)
Version: 5.1+

#20082: mysqlimport: no option corresponding to LINES STARTING BY clause for LOAD DATA

Fri, 26 May 2006 01:25:33 +0000

Bug ID: 20082
Submitted by: Paul DuBois
Category: Client
Status: Verified
Severity: 4
OS: Any

#20111: named columns used in subqueries hinder optimisation of LIKE, BETWEEN, range

Sun, 28 May 2006 10:57:40 +0000

Bug ID: 20111
Submitted by: Daniel Treplin
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Linux (Linux)
Version: 4.1.19-log

#20117: YaST2's run level editor can't detect status of mysql

Mon, 29 May 2006 07:54:58 +0000

Bug ID: 20117
Submitted by: Miles Barry
Category: Client
Status: Verified
Severity: 4
OS: Linux (SLES9)
Version: 5.0.21-1

#20184: Patch to add #!/path/mysql shebang capability to cmdline client

Thu, 01 Jun 2006 02:03:43 +0000

Bug ID: 20184
Submitted by: Arjen Lentz
Category: Client
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#20193: Table Full with InnoDB and autoextending per Table Table Space, tmp+disk free

Thu, 01 Jun 2006 11:28:32 +0000

Bug ID: 20193
Submitted by: Sebastian Nohn
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.18-standard

#20205: mysqlbinlog command, extend filtering options

Thu, 01 Jun 2006 13:47:01 +0000

Bug ID: 20205
Submitted by: Kristian Koehntopp
Category: Client
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0

#20228: engine_condition_pushdown = on in my.cnf should work. currently must be 1

Fri, 02 Jun 2006 15:04:32 +0000

Bug ID: 20228
Submitted by: Jonathan Miller
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux 32 Bit OS)
Version: 5.1.12/5.0BK

#20232: MERGE table corruption error message should indicate which member is corrupted

Fri, 02 Jun 2006 15:51:30 +0000

Bug ID: 20232
Submitted by:
Category: Server: Merge
Status: Verified
Severity: 4
OS: Linux (RedHat 9)
Version: 4.1.18

#20235: Unable to SHOW CREATE PROCEDURE without SELECT grant

Fri, 02 Jun 2006 18:03:01 +0000

Bug ID: 20235
Submitted by: Erica Moss
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Windows (win32 - XP SP2, Fedora core 5)
Version: 5.0.21-community-nt

#20241: Access to procedures/functions is lost if the definer is dropped

Sat, 03 Jun 2006 05:08:02 +0000

Bug ID: 20241
Submitted by: Erica Moss
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (MS win32 - XP SP2, Fedora core 5)
Version: WIN -5.0.21 LIN 5.0.22

#20263: mysql.cnf line break incompatibility

Mon, 05 Jun 2006 02:35:15 +0000

Bug ID: 20263
Submitted by: Marcus Bointon
Category: Server: Options
Status: Verified
Severity: 3
OS: Any
Version: 5.0.22

#20288: Compatibility-feature for migrating MySQL 4.0 to 4.1/5.0

Tue, 06 Jun 2006 10:31:14 +0000

Bug ID: 20288
Submitted by: Anders Henke
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1 and higher

#20302: Union all is not 'streaming'

Tue, 06 Jun 2006 18:15:55 +0000

Bug ID: 20302
Submitted by: Andre Timmer
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.1.12, 5.0.23-BK, 5.0.18

#20314: SHOW MASTER STATUS showing latest error/errno

Wed, 07 Jun 2006 10:25:36 +0000

Bug ID: 20314
Submitted by: Geert Vanderkelen
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#20353: Prefix key search return incorrect results for ignorable characters

Fri, 09 Jun 2006 11:12:36 +0000

Bug ID: 20353
Submitted by: Alexander Barkov
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Any
Version: 4.1, 5.0, 5.1

#20356: Names containing UPPERCASES get LOWERCASE'd

Fri, 09 Jun 2006 11:55:45 +0000

Bug ID: 20356
Submitted by: Peter Laursen
Category: Server: Views
Status: Verified
Severity: 2
OS: Windows (Windows, Mac OS X)
Version: 5.0.22 + 5.1.11

#20377: enum implemented incorrectly?

Sat, 10 Jun 2006 23:17:07 +0000

Bug ID: 20377
Submitted by: Roman Lamotkin
Category: Server: Types
Status: Verified
Severity: 4
OS: Windows (Windows 98 SE)
Version: 5.0.22

#20379: string syntax proposals

Sun, 11 Jun 2006 10:19:16 +0000

Bug ID: 20379
Submitted by: Roman Lamotkin
Category: Server
Status: Open
Severity: 4
OS: Any (any)
Version: 5.0.22

#20447: Problem with prefix keys with contractions and expansions

Wed, 14 Jun 2006 05:06:02 +0000

Bug ID: 20447
Submitted by: Alexander Barkov
Category: Server: Charsets
Status: Verified
Severity: 2
OS: Any (any)
Version: 4.0, 4.1, 5.0, 5.1

#20453: mysqldumpslow cannot grep and sort by host and user

Wed, 14 Jun 2006 09:32:52 +0000

Bug ID: 20453
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.1.x

#20464: Request For Selective Journalling Of Tables Within MySQL NDB Cluster

Wed, 14 Jun 2006 15:07:43 +0000

Bug ID: 20464
Submitted by: Dean Swift
Category: Server: Cluster
Status: Open
Severity: 4
OS: Any (All)
Version: mysql-5.1

#20525: Can't drop primary key if there's a foreign key

Sun, 18 Jun 2006 20:43:13 +0000

Bug ID: 20525
Submitted by: Peter Gulutzan
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.0.23-debug

#20563: ISO/IEC 9075:1992 column constraint names are not supported

Tue, 20 Jun 2006 09:18:24 +0000

Bug ID: 20563
Submitted by: David Gradwell
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (Windows)
Version: 5.1

#20571: Allow MySQL to bind only to selected interfaces

Tue, 20 Jun 2006 11:30:10 +0000

Bug ID: 20571
Submitted by: Renuka R
Category: Server: General
Status: Verified
Severity: 4
OS: Solaris (Solaris)
Version: 4.1.15

#20628: Modify NDBAPI optimized node selection to request preferred nodes

Thu, 22 Jun 2006 14:30:06 +0000

Bug ID: 20628
Submitted by: Hartmut Holzgraefe
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any (*)
Version: mysql-5.0

#20630: Remove restriction on option file parameters being first

Thu, 22 Jun 2006 15:45:54 +0000

Bug ID: 20630
Submitted by: Rob Desbois
Category: Server: General
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.22 (+?)

#20652: variable skip_grant_table is not listed with show variables

Fri, 23 Jun 2006 08:39:48 +0000

Bug ID: 20652
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any (n.a.)
Version: 5.0.22

#20677: Race condition between table discovery and insert

Sat, 24 Jun 2006 17:28:56 +0000

Bug ID: 20677
Submitted by: Kristian Nielsen
Category: Server: ClusterRep
Status: Verified
Severity: 2
OS: Linux (Linux)
Version: mysql-5.1

#20679: SHOW STATUS does not display granular data for multiple key caches

Sat, 24 Jun 2006 20:33:08 +0000

Bug ID: 20679
Submitted by: J Rabbit
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any
Version: 5.x, 6.x

#20680: It is not possible to determine which key cache a particular table uses

Sat, 24 Jun 2006 20:48:09 +0000

Bug ID: 20680
Submitted by: J Rabbit
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Windows (Windows 2003)
Version: 5.0.22

#20681: Support wild cards in table names on CACHE INDEX statement

Sat, 24 Jun 2006 22:12:43 +0000

Bug ID: 20681
Submitted by: J Rabbit
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Windows (Windows 2003)
Version: 5.0.22

#20724: FEDERATED does not honour SET INSERT_ID

Tue, 27 Jun 2006 14:00:09 +0000

Bug ID: 20724
Submitted by: Guilhem Bichot
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1-bk

#20764: Have mysql.server script pass $datadir/my.cnf via --defaults-extra-file

Thu, 29 Jun 2006 03:07:09 +0000

Bug ID: 20764
Submitted by: Lachlan Mulcahy
Category: Server: Options
Status: Verified
Severity: 4
OS: Any
Version: 5.5

#20781: KILLALL [WHERE condition, ...]

Thu, 29 Jun 2006 16:38:51 +0000

Bug ID: 20781
Submitted by: Dean Swift
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: 5.0.22

#20786: mysqldump always includes AUTO_INCREMENT

Thu, 29 Jun 2006 22:31:42 +0000

Bug ID: 20786
Submitted by: Erik Kay
Category: Server: I_S
Status: Verified
Severity: 2
OS: Linux (Redhat Linux ES3)
Version: 5.1.11 beta

#20796: MySQL doesn't support more than 32000 databases

Fri, 30 Jun 2006 17:24:28 +0000

Bug ID: 20796
Submitted by: Boris Burtin
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 4.1

#20842: client libraries installed in wrong location

Tue, 04 Jul 2006 04:49:20 +0000

Bug ID: 20842
Submitted by: Mark Johnson
Category: Server: Compiling
Status: Verified
Severity: 4
OS: Linux (Linux 2.6.15/Slackware 10.2)
Version: 5.0.22

#20844: interval datatype

Tue, 04 Jul 2006 08:51:28 +0000

Bug ID: 20844
Submitted by: Mircea LUTIC
Category: Server: Types
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.1

#20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various functions

Sun, 09 Jul 2006 06:42:05 +0000

Bug ID: 20924
Submitted by: Matthew Montgomery
Category: Server: Types
Status: Verified
Severity: 2
OS: Linux (Linux 2.6)
Version: All

#20925: C API "show columns" report incorrect length of Type column

Sun, 09 Jul 2006 07:52:21 +0000

Bug ID: 20925
Submitted by: Jacques Venter
Category: C API
Status: Verified
Severity: 4
OS: Windows (XP SP2)
Version: 5.0.22

#20932: optimizer/statistics takes 20 times (and more) as long as actual query execution

Sun, 09 Jul 2006 17:10:52 +0000

Bug ID: 20932
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux, freebsd)
Version: 5.0.25-BK, 4.1.20 and 5.0.22

#21038: quota support for mysql

Thu, 13 Jul 2006 14:43:48 +0000

Bug ID: 21038
Submitted by: Liam Hoekenga
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#21063: subscribed bugs should be listed under "view your bugs"

Fri, 14 Jul 2006 15:40:44 +0000

Bug ID: 21063
Submitted by: Lukas Smith
Category: bugs.mysql.com
Status: Verified
Severity: 4
OS: Any

#21094: ALTER TABLE ... ROW_FORMAT=compressed does not lead into error

Mon, 17 Jul 2006 14:50:32 +0000

Bug ID: 21094
Submitted by: Oli Sennhauser
Category: Server: DDL
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1-BK, 5.0-BK, 5.0.19

#21110: limit of max_sp_recursion_depth

Tue, 18 Jul 2006 10:46:46 +0000

Bug ID: 21110
Submitted by: Nikolay Shestakov
Category: Server: SP
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0

#21146: Replication Filtering before sending on the network

Wed, 19 Jul 2006 12:53:08 +0000

Bug ID: 21146
Submitted by: Paul Lemay
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0, 5.1, 6.0

#21175: Fulltext cannot find misspelled words

Thu, 20 Jul 2006 09:10:21 +0000

Bug ID: 21175
Submitted by: Mirza Hadzic
Category: Server: FTS
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: All

#21309: simple way to quiesce the data files for backup

Thu, 27 Jul 2006 05:55:45 +0000

Bug ID: 21309
Submitted by: Dave Yost
Category: Client
Status: Verified
Severity: 4
OS: Any (whatever)
Version: 5.0.22

#21326: Can SELECT from table being updated in a stored function, but can't in subquery

Fri, 28 Jul 2006 09:26:55 +0000

Bug ID: 21326
Submitted by: Tomash Brechko
Category: Server: DML
Status: Verified
Severity: 3
OS: Any (any)
Version: 5.0.25-BK, 5.0.22/5.1BK

#21358: mysqlslap does not report error properly

Mon, 31 Jul 2006 08:31:46 +0000

Bug ID: 21358
Submitted by: Magnus Blåudd
Category: Server: Tests
Status: Patch pending
Severity: 3
OS: Any (all)
Version: 5.1

#21359: mysqldumpslow: show the database name in the output

Mon, 31 Jul 2006 09:36:20 +0000

Bug ID: 21359
Submitted by: Thierry Randrianiriana
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any

#21403: more specific SQL states for 23nnn

Tue, 01 Aug 2006 19:21:16 +0000

Bug ID: 21403
Submitted by: Matthew Lord
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#21431: Incomplete support of temporary tables

Thu, 03 Aug 2006 16:17:38 +0000

Bug ID: 21431
Submitted by: Tomash Brechko
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 4.1.22-BK, 5.0-BK

#21500: Indirect parameters for prepared statmets

Tue, 08 Aug 2006 10:41:57 +0000

Bug ID: 21500
Submitted by: Duncan Simpson
Category: Server
Status: Open
Severity: 4
OS: Linux (Linux (but n/a))
Version: 5.0

#21516: MySQL sorts -INF as greater than +INF

Tue, 08 Aug 2006 18:02:56 +0000

Bug ID: 21516
Submitted by: Sveta Smirnova
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 5.1, 5.0, 4.1

#21517: Several variables need to be added to show variabels and slave status

Tue, 08 Aug 2006 18:10:59 +0000

Bug ID: 21517
Submitted by: Jonathan Miller
Category: Server: Replication
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.1.12

#21532: Support for DEFAULT in TEXT/BLOB columns

Wed, 09 Aug 2006 09:28:34 +0000

Bug ID: 21532
Submitted by: Ask Hansen
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0.25

#21534: function returning a table

Wed, 09 Aug 2006 10:03:28 +0000

Bug ID: 21534
Submitted by: gtbear gtbear
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.1.11

#21538: Logging warnings during replication

Wed, 09 Aug 2006 13:24:11 +0000

Bug ID: 21538
Submitted by: Victoria Reznichenko
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0

#21565: More verbose connection log

Thu, 10 Aug 2006 10:53:52 +0000

Bug ID: 21565
Submitted by: Cedric Wider
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0.25

#21599: Suggestion to add ISO-8859-1 charset

Fri, 11 Aug 2006 22:08:21 +0000

Bug ID: 21599
Submitted by: Martin Stjernholm
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#21641: nonpreserving of InnoDB auto_increment values can lead to unintended inheritance

Mon, 14 Aug 2006 23:57:28 +0000

Bug ID: 21641
Submitted by: Stephen Dewey
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: 4.1, 5.1, 5.5

#21669: Too much information visible for users with column privileges

Wed, 16 Aug 2006 04:22:02 +0000

Bug ID: 21669
Submitted by: Michal Ludvig
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any
Version: 5.1.11

#21693: variable report_host is nor listed within show variables nor show slave status

Thu, 17 Aug 2006 10:11:12 +0000

Bug ID: 21693
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any (n.a.)
Version: 5.0.24

#21768: Kunyomi sort/collation for Japanese characters

Tue, 22 Aug 2006 04:34:58 +0000

Bug ID: 21768
Submitted by: Jacob Levine
Category: Server: Charsets
Status: Verified
Severity: 4
OS: Any
Version: 4.1.12-nt

#21815: mysqld is not informed of cluster shutdown, making slave thread print errors

Thu, 24 Aug 2006 18:04:38 +0000

Bug ID: 21815
Submitted by: Jonathan Miller
Category: Server: ClusterRep
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: mysql-5.1

#21866: Trigger check sql statement at runtime not at compile time

Mon, 28 Aug 2006 09:56:59 +0000

Bug ID: 21866
Submitted by: Andrea Pantaleoni
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (linux ubuntu)
Version: 5.0.24

#21895: Add fulltext parser plugin testcase

Tue, 29 Aug 2006 08:06:20 +0000

Bug ID: 21895
Submitted by: Magnus Blåudd
Category: Server: Tests
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#21934: perror: Add option for looking up SQLSTATE values

Thu, 31 Aug 2006 00:06:02 +0000

Bug ID: 21934
Submitted by: Paul DuBois
Category: Server: Errors
Status: Verified
Severity: 4

#21939: EXPLAIN EXTENDED does not return information "as advertised" in manual

Thu, 31 Aug 2006 05:52:56 +0000

Bug ID: 21939
Submitted by: Arjen Lentz
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: 4.1 and up, 5.0.36-BK

#21978: 'flush_time' value set for 1800 sec. on Non Win9x/Me installs by default

Fri, 01 Sep 2006 22:13:27 +0000

Bug ID: 21978
Submitted by: Matthew Montgomery
Category: Server: Options
Status: Verified
Severity: 3
OS: Windows (Windows 2000)
Version: 4.0.18, 5.0, 6.0.10, 5.5

#21979: Log reason in slow-log

Fri, 01 Sep 2006 22:21:50 +0000

Bug ID: 21979
Submitted by: Thomas Auge
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: any

#22001: Prepared Statements unusable with unbuffered queries, mysql_stmt_refetch needed

Mon, 04 Sep 2006 16:07:10 +0000

Bug ID: 22001
Submitted by: Domas Mituzas
Category: Server: PS
Status: Verified
Severity: 4
Version: 5.0, 5.1, etc

#22008: [Request] Myanmar Collation Extension for UCS and UTF8

Tue, 05 Sep 2006 06:52:23 +0000

Bug ID: 22008
Submitted by: Ngwe Tun
Category: Server: Charsets
Status: Verified
Severity: 2
OS: Windows (Linux/Windows)
Version: 5.4

#22011: Timing feedback of statements in stored procedure is incorrect

Tue, 05 Sep 2006 10:15:51 +0000

Bug ID: 22011
Submitted by: Andre Timmer
Category: Client
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.25-BK, 5.0.18

#22012: Store procedure: support LEAVE without label

Tue, 05 Sep 2006 11:32:53 +0000

Bug ID: 22012
Submitted by: Andre Timmer
Category: Server: SP
Status: Verified
Severity: 4
Version: 5

#22021: mysqlmanager --install windows service with --defaults-file option

Tue, 05 Sep 2006 13:57:48 +0000

Bug ID: 22021
Submitted by: KimSeong Loh
Category: Instance Manager
Status: Verified
Severity: 4
OS: Windows (windows)
Version: 5.0.22

#22034: Events: U and ü are the same name

Tue, 05 Sep 2006 23:10:34 +0000

Bug ID: 22034
Submitted by: Peter Gulutzan
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.12-beta-debug

#22035: LOAD DATA INFILE "no-such-file" returns a general error

Tue, 05 Sep 2006 23:39:46 +0000

Bug ID: 22035
Submitted by: Marc ALFF
Category: Server: Errors
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0, 5.1

#22037: limits number of tables per database

Wed, 06 Sep 2006 00:51:53 +0000

Bug ID: 22037
Submitted by: pavel stano
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#22050: dynamic row format for nullable integer columns in myisam

Wed, 06 Sep 2006 12:00:42 +0000

Bug ID: 22050
Submitted by: Martin Friebe
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#22106: can't output to error log file when INNODB happened ERROR1205

Fri, 08 Sep 2006 06:46:19 +0000

Bug ID: 22106
Submitted by: Kanako Nakai
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.26-BK

#22222: stream buffers not always flushed

Sun, 10 Sep 2006 09:12:07 +0000

Bug ID: 22222
Submitted by: Georg Richter
Category: Client
Status: Verified
Severity: 3
OS: Windows (Windows)
Version: 4.0, 4.1, 5.0, 5.1

#22246: Allow LOCK TABLE WRITE lock a non-existent table.

Mon, 11 Sep 2006 21:37:49 +0000

Bug ID: 22246
Submitted by: Shawn Green
Category: Server: Locking
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.22, 5.0.45, 5.1.43, 6.0.14

#22287: mysql.server script needs some fixes

Tue, 12 Sep 2006 23:08:13 +0000

Bug ID: 22287
Submitted by: Dave Yost
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0.24a

#22430: -xstrconst -mt in Makefile for gcc-4.1.1 on Solaris 10

Mon, 18 Sep 2006 04:58:00 +0000

Bug ID: 22430
Submitted by: Mark Detrick
Category: Client
Status: Verified
Severity: 3
OS: Solaris (Solaris 10)
Version: 5.0r4

#22487: mysql performs extremely slow when creating unique indexes on huge table

Tue, 19 Sep 2006 17:57:05 +0000

Bug ID: 22487
Submitted by: Alexander Valyalkin
Category: Server: DDL
Status: Verified
Severity: 5
OS: Any
Version: 5.0.26

#22499: Unable to rename 'packed' table, Unable to 'myisampack' table with live databas.

Tue, 19 Sep 2006 22:33:51 +0000

Bug ID: 22499
Submitted by: J Jorgenson
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any
Version: 5.0.18

#22565: Support for Directory Services

Thu, 21 Sep 2006 20:08:17 +0000

Bug ID: 22565
Submitted by: Arjan Hulshoff
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.2

#22606: InnoDB waits for a gap lock if a rec-not-gap-lock is ahead in queue

Fri, 22 Sep 2006 17:02:00 +0000

Bug ID: 22606
Submitted by: Heikki Tuuri
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Any (All)
Version: All

#22626: Impossible to give just a column name in CREATE TABLE AS

Sat, 23 Sep 2006 10:52:51 +0000

Bug ID: 22626
Submitted by: Maciej Pilichowski
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.24a

#22627: Please provide SQL compliant SELECT INTO

Sat, 23 Sep 2006 10:57:38 +0000

Bug ID: 22627
Submitted by: Maciej Pilichowski
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.24a

#22632: SHOW CREATE TABLE is inconsistent in showing unsupported options

Sat, 23 Sep 2006 20:45:35 +0000

Bug ID: 22632
Submitted by: Roland Bouman
Category: Server: DDL
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1.11-beta

#22636: eq_ref on part of composite index, if unique

Sun, 24 Sep 2006 11:46:59 +0000

Bug ID: 22636
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4 / 5

#22644: LC_TIME_NAMES: Some names are doubtful

Sun, 24 Sep 2006 19:41:03 +0000

Bug ID: 22644
Submitted by: Peter Gulutzan
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.12-beta-debug

#22657: No statistics available on DiskPageBufferMemory

Mon, 25 Sep 2006 09:13:51 +0000

Bug ID: 22657
Submitted by: Johan Andersson
Category: Server: ClusterDD
Status: Verified
Severity: 4
OS: Any (*)
Version: mysql-5.1

#22699: Counter missing for "number of restarts" of mysqld

Tue, 26 Sep 2006 11:31:12 +0000

Bug ID: 22699
Submitted by: Johan Andersson
Category: Server: General
Status: Verified
Severity: 4
OS: Any (*)
Version: 5.1

#22718: Allow MyISAM to be used with Direct I/O

Tue, 26 Sep 2006 22:31:49 +0000

Bug ID: 22718
Submitted by: Chris Calender
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (All OS)
Version: All Versions

#22755: myisampack on partitioned tables

Wed, 27 Sep 2006 18:56:31 +0000

Bug ID: 22755
Submitted by: Cuong Nguyen
Category: Server
Status: Verified
Severity: 4
OS: Linux (RHEL 4 AS U3)
Version: 5.1.11-beta-log

#22774: Incorrectly reported data truncation with server prepared statements

Thu, 28 Sep 2006 10:24:33 +0000

Bug ID: 22774
Submitted by: Alexander Hristov
Category: Server: PS
Status: Verified
Severity: 2
OS: Linux (Fedora Core 5 and Windows XP)
Version: 5.0.24a

#22853: max_allowed_packet misnomer - CONCAT() in SQL command allows for loss of data

Sat, 30 Sep 2006 01:59:03 +0000

Bug ID: 22853
Submitted by: Joseph Drago
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: 4.1.14-nt

#22856: "start transaction" syntax: add isolation level

Sat, 30 Sep 2006 09:41:46 +0000

Bug ID: 22856
Submitted by: Maciej Pilichowski
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.24a

#22857: add mode for stopping implicit commit

Sat, 30 Sep 2006 09:45:14 +0000

Bug ID: 22857
Submitted by: Maciej Pilichowski
Category: Server
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.24a

#22858: Improve privilege system for very large number of entries

Sat, 30 Sep 2006 13:38:38 +0000

Bug ID: 22858
Submitted by: SINISA MILIVOJEVIC
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1

#22875: "FLUSH STATUS" does not reset global Com_% status variables

Sun, 01 Oct 2006 19:53:02 +0000

Bug ID: 22875
Submitted by: Christian Hammers
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.26-BK, 5.0.24

#22878: Query tagging does not work anymore in 4.1 and 5.0

Mon, 02 Oct 2006 07:38:01 +0000

Bug ID: 22878
Submitted by: Oli Sennhauser
Category: Client
Status: Verified
Severity: 4
Version: 4.1 and 5.0

#22933: information_schema.TABLES does not have a TABLESPACE_NAME column

Tue, 03 Oct 2006 12:54:07 +0000

Bug ID: 22933
Submitted by: Roland Bouman
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (na)
Version: 5.1.12

#23039: feature request: lower_case_table_names should default to 2 on all OS'es

Fri, 06 Oct 2006 03:24:48 +0000

Bug ID: 23039
Submitted by: Morgan Tocker
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.1+

#23069: Too long UNIQUE indices allowed in InnoDB

Sat, 07 Oct 2006 10:46:25 +0000

Bug ID: 23069
Submitted by: Oli Sennhauser
Category: Server: DDL
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.18, 5.0.24, 5.0.27-BK

#23098: Solutions by Error number

Mon, 09 Oct 2006 06:03:41 +0000

Bug ID: 23098
Submitted by: Terry James
Category: Server
Status: Open
Severity: 4
OS: Windows (Windows Server)
Version: any

#23140: Explicit support of datetime type for aggregate functions like AVG()

Tue, 10 Oct 2006 14:33:01 +0000

Bug ID: 23140
Submitted by: Benjamin Root
Category: Server
Status: Open
Severity: 4
OS: Any (All)
Version: 5.0

#23164: Query summary Warnings count capped at 65535

Wed, 11 Oct 2006 06:08:25 +0000

Bug ID: 23164
Submitted by: Clarence Risher
Category: C API
Status: Verified
Severity: 3
OS: Any (Mac OS X 10.6.3, Linux)
Version: 5.1.42, 4.1, 5.0, 5.1, 5.6.99

#23206: Federated server and SSL connections

Thu, 12 Oct 2006 09:54:25 +0000

Bug ID: 23206
Submitted by: Damien Bezborodow
Category: Server: Federated
Status: Verified
Severity: 4
OS: Linux (Debian)
Version: 5.0.24a-Debian_4-log

#23212: allow missing data = NULL in LOAD DATA INFILE

Thu, 12 Oct 2006 12:15:20 +0000

Bug ID: 23212
Submitted by: Rob Blick
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#23260: String converted to floating-point when comparing to DECIMAL type

Fri, 13 Oct 2006 14:06:55 +0000

Bug ID: 23260
Submitted by: Geert Vanderkelen
Category: Server: Types
Status: Verified
Severity: 4
OS: Any (*)
Version: 5.0.26

#23274: Installer did not provide several options that advanced users expect.

Fri, 13 Oct 2006 20:01:47 +0000

Bug ID: 23274
Submitted by: Shawn Green
Category: Monitoring: Install
Status: Verified
Severity: 4
OS: Any
Version: 0.6.33

#23290: FEATURE REQUEST: Don't listen tcp-port until the slave is "up to date"

Sat, 14 Oct 2006 11:50:14 +0000

Bug ID: 23290
Submitted by: Daniel Caballero Rodr�guez
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (R4HES)
Version: 5.0.24

#23319: Separately Trigger

Mon, 16 Oct 2006 03:29:19 +0000

Bug ID: 23319
Submitted by: Fauzan Badriawan
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: 5.0

#23327: Strange mapping of certain values for system variable

Mon, 16 Oct 2006 09:15:17 +0000

Bug ID: 23327
Submitted by: Heinz Schweitzer
Category: Server
Status: In progress
Severity: 3
OS: Windows (XP)
Version: 4.1 BK, 5.0 BK, 5.1 BK

#23340: Calculate Age Function (days,months and years of age)

Mon, 16 Oct 2006 17:01:40 +0000

Bug ID: 23340
Submitted by: Luis Antonio Castro Henriques
Category: Server
Status: Open
Severity: 4

#23353: cannot update a table and select from the same table in a subquery

Tue, 17 Oct 2006 01:49:52 +0000

Bug ID: 23353
Submitted by: Fauzan Badriawan
Category: Server: DML
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: Future

#23422: verbosity and error reporting of mysql client

Wed, 18 Oct 2006 13:50:40 +0000

Bug ID: 23422
Submitted by: Shane Bester
Category: Client
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#23511: Admin Feature: Need to Be Able to Disable SET SQL_BIG_SELECTS

Fri, 20 Oct 2006 17:44:52 +0000

Bug ID: 23511
Submitted by: Bill Adams
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0

#23547: Please make default ArbitrationRank = 2 for MySQLD nodes

Mon, 23 Oct 2006 09:31:37 +0000

Bug ID: 23547
Submitted by: Roland Bouman
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#23550: tool for converting offline from old ISAM format

Mon, 23 Oct 2006 11:49:38 +0000

Bug ID: 23550
Submitted by: sean finney
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#23553: SBR needs to recognize appropriate cross-database DML

Mon, 23 Oct 2006 14:32:23 +0000

Bug ID: 23553
Submitted by: Shawn Green
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0.26

#23568: "point" column makes MyISAM row_format dynamic

Tue, 24 Oct 2006 02:45:17 +0000

Bug ID: 23568
Submitted by: Ask Hansen
Category: Server: GIS
Status: Verified
Severity: 4
OS: Any
Version: 5.0.26

#23569: The calling convention of TIMESTAMPDIFF() is counter-intuitive

Tue, 24 Oct 2006 03:22:35 +0000

Bug ID: 23569
Submitted by: Siu Ching Pong (Asuka Kenji)
Category: Server: DML
Status: Verified
Severity: 4
OS: Windows (Windows XP Professional)
Version: 5.0.24a-community-nt

#23642: Error instance-specific information request

Wed, 25 Oct 2006 19:01:32 +0000

Bug ID: 23642
Submitted by: Sheeri Cabral
Category: Monitoring
Status: Open
Severity: 4
OS: Linux (Fedora Core 3 (i386))
Version: mysqlnetwork-0.6.33

#23652: Partitions: intermittent use of ansi_quotes causes errors

Wed, 25 Oct 2006 22:31:13 +0000

Bug ID: 23652
Submitted by: Peter Gulutzan
Category: Server: Partition
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.13-beta-debug

#23664: LOAD DATA CONCURRENT doesn't work with replication

Thu, 26 Oct 2006 13:00:07 +0000

Bug ID: 23664
Submitted by: Victoria Reznichenko
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0

#23683: SHOW DATABASES doesn't filter invalid directory names

Thu, 26 Oct 2006 19:33:29 +0000

Bug ID: 23683
Submitted by: Jose Luis Martinez
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.20

#23715: full outer join is missing

Fri, 27 Oct 2006 13:15:57 +0000

Bug ID: 23715
Submitted by: Maciej Pilichowski
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.26

#23716: Server-side log of query errors/warnings required

Fri, 27 Oct 2006 13:18:30 +0000

Bug ID: 23716
Submitted by: Domas Mituzas
Category: Server: General
Status: Verified
Severity: 4

#23720: There is no way to defer schema checking on CREATE VIEW

Fri, 27 Oct 2006 14:09:49 +0000

Bug ID: 23720
Submitted by: Baron Schwartz
Category: Server: Views
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.0.21-log

#23911: BETWEEN could be optimized as IN for constants

Fri, 03 Nov 2006 02:40:25 +0000

Bug ID: 23911
Submitted by: Peter Brodersen
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.26-Debian_0.dotdeb.1-log

#24004: Cannot running MXJ as part of the JDBC driver on non-3306 ports when ...

Mon, 06 Nov 2006 10:42:32 +0000

Bug ID: 24004
Submitted by: Guangyu Liu
Category: Connector/MXJ
Status: Patch pending
Severity: 2
Version: 5.0

#24083: GROUP BY expressions should be allowed in the HAVING clause

Wed, 08 Nov 2006 11:02:39 +0000

Bug ID: 24083
Submitted by: Mick Francis
Category: Server: DML
Status: Verified
Severity: 4
OS: Linux (Linux, WinXP)
Version: 5.0.29-BK, 5.0.26-community

#24084: Options named inconsistently in show status and my.cnf

Wed, 08 Nov 2006 12:14:21 +0000

Bug ID: 24084
Submitted by: Kristian Koehntopp
Category: Server: General
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#24096: Please provide third parameter ROUND_METHOD to round() or round_common()

Wed, 08 Nov 2006 17:48:29 +0000

Bug ID: 24096
Submitted by: Christian Hammers
Category: Server: DML
Status: Verified
Severity: 4
OS: Any

#24130: empty values for bit field

Thu, 09 Nov 2006 09:18:22 +0000

Bug ID: 24130
Submitted by: Maciej Pilichowski
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.26, 5.1

#24176: bigint.test fails with --cursor-protocol

Fri, 10 Nov 2006 10:32:31 +0000

Bug ID: 24176
Submitted by: Magnus Blåudd
Category: Server: PS
Status: Verified
Severity: 3
OS: Any
Version: 5.0.30

#24183: optimizer misoptimize "LIKE" when using constant values

Fri, 10 Nov 2006 11:53:50 +0000

Bug ID: 24183
Submitted by: Anders Henke
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.30-BK, 4.0.27 and 5.0.19

#24214: time_zone and datetime_format

Sat, 11 Nov 2006 16:06:44 +0000

Bug ID: 24214
Submitted by: Adolf Szabo
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux, Fedora5)
Version: 5.0.22, 5.5+

#24251: Non-optimal choice of indexes for queries

Mon, 13 Nov 2006 10:58:50 +0000

Bug ID: 24251
Submitted by: Gisbert Selke
Category: Server: Optimizer
Status: In progress
Severity: 5
OS: Linux (Linux, Win XP SP2)
Version: 5.0.30-BK, 5.1.12

#24260: Events: Don't compile scheduler code in embedded

Mon, 13 Nov 2006 13:02:47 +0000

Bug ID: 24260
Submitted by: Andrey Hristov
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#24268: function to determine size of result set

Mon, 13 Nov 2006 15:54:45 +0000

Bug ID: 24268
Submitted by: Yahoo Serious
Category: Server: General
Status: Open
Severity: 4
OS: Any (all)
Version: all

#24286: Triggers should be able to callback

Tue, 14 Nov 2006 06:59:12 +0000

Bug ID: 24286
Submitted by: Morgan Tocker
Category: Server: SP
Status: Verified
Severity: 4
Version: 5.2+

#24313: Request for non-ACID option for implicit LOAD DATA INFILE periodic commits

Tue, 14 Nov 2006 17:48:08 +0000

Bug ID: 24313
Submitted by: Douglas Fischer
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0.26

#24349: date/time function behavior with zero '0000-00-00' date

Thu, 16 Nov 2006 00:50:06 +0000

Bug ID: 24349
Submitted by: Timothy Smith
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.0

#24413: Misleading error message when hard drive is full

Sat, 18 Nov 2006 12:56:23 +0000

Bug ID: 24413
Submitted by: Philip Stoev
Category: Server: MyISAM
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.32-BK, 5.0.26

#24424: CHAR data-type not space-padding

Sun, 19 Nov 2006 04:28:27 +0000

Bug ID: 24424
Submitted by: Michael Austin
Category: Server: Types
Status: Verified
Severity: 1
OS: Any (ALL)
Version: 5.1.11

#24444: Please add FEDERATED query feature

Mon, 20 Nov 2006 18:36:16 +0000

Bug ID: 24444
Submitted by: Roland Bouman
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any (NA)
Version: NA

#24455: procs_priv shows error user after granting procedure's privilege to special user

Tue, 21 Nov 2006 08:40:54 +0000

Bug ID: 24455
Submitted by: leo
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Linux (linux, window 2000)
Version: 5.1.12-beta-community-nt, 5.0 BK

#24460: near operator

Tue, 21 Nov 2006 10:05:02 +0000

Bug ID: 24460
Submitted by: Sergei Golubchik
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#24489: @@sql_select_limit applies to stored functions, triggers, events

Tue, 21 Nov 2006 22:16:39 +0000

Bug ID: 24489
Submitted by: Konstantin Osipov
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0 BK, 5.1 BK

#24500: InnoDB please implement transactional NOWAIT locks

Wed, 22 Nov 2006 11:55:43 +0000

Bug ID: 24500
Submitted by: Ingo Strüwing
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#24516: MGMAPI reports bad data for down datanodes

Wed, 22 Nov 2006 18:44:27 +0000

Bug ID: 24516
Submitted by: Anders Karlsson
Category: Server: NDBAPI
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: mysql-5.1

#24530: BOOLEAN literals are not of BOOLEAN i.e. TINYINT(1)

Thu, 23 Nov 2006 03:07:48 +0000

Bug ID: 24530
Submitted by: Siu Ching Pong (Asuka Kenji)
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (Linux (Fedora Core 5))
Version: 5.1.12-beta

#24531: BOOLEAN literal UNKNOWN is missing

Thu, 23 Nov 2006 03:32:23 +0000

Bug ID: 24531
Submitted by: Siu Ching Pong (Asuka Kenji)
Category: Server: Types
Status: Verified
Severity: 4
OS: Linux (Linux (Fedora Core 5))
Version: 5.1.12-beta

#24540: Fulltext Searching

Thu, 23 Nov 2006 12:08:58 +0000

Bug ID: 24540
Submitted by: Adam Phillips
Category: Server: FTS
Status: Verified
Severity: 4
OS: Windows (Windows 2003 Server)
Version: 5

#24577: limited replication for upgrading major versions

Fri, 24 Nov 2006 16:43:46 +0000

Bug ID: 24577
Submitted by: Martin Friebe
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#24606: ndb_mgm does not return to command prompt immediately after a node shutdown

Mon, 27 Nov 2006 04:42:46 +0000

Bug ID: 24606
Submitted by: Anatoly Pidruchny
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: mysql-5.1

#24626: show processlist should display "pid" for each entry

Mon, 27 Nov 2006 17:02:09 +0000

Bug ID: 24626
Submitted by: Roberto Spadim
Category: Server
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#24663: Possiblity of indexes for ARCHIVE engine

Tue, 28 Nov 2006 17:15:10 +0000

Bug ID: 24663
Submitted by: Thorben Jändling
Category: Server: Archive
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5

#24668: CASCADING FOREIGN KEYS do not work on same TABLE

Tue, 28 Nov 2006 19:02:32 +0000

Bug ID: 24668
Submitted by: Sebastien Caisse
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (Linux, Windows XPsp2)
Version: 5.0.32-BK, 5.0.27

#24680: mysqldump writes the definer of a view to the dump file

Wed, 29 Nov 2006 09:10:05 +0000

Bug ID: 24680
Submitted by: Kai Sautter
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: 5.0.22

#24693: explain output should provide un-aliased table names

Wed, 29 Nov 2006 13:26:56 +0000

Bug ID: 24693
Submitted by: Anders Henke
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any

#24696: Detached SQL Node allows CREATE TABLE but shouldn't

Wed, 29 Nov 2006 14:53:03 +0000

Bug ID: 24696
Submitted by: Roland Bouman
Category: Server: Cluster
Status: Verified
Severity: 2
OS: Linux (ubuntu edgy)
Version: mysql-5.1

#24697: insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name

Wed, 29 Nov 2006 15:13:33 +0000

Bug ID: 24697
Submitted by: Dave Pullin
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Windows (Windows 2000 and Linux)
Version: 5.0.24a-community-nt-log/4.1BK/5.0BK/5.1BK

#24708: Cluster shutdown to easy

Wed, 29 Nov 2006 23:33:25 +0000

Bug ID: 24708
Submitted by: Oli Sennhauser
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#24720: Allow recursive stored functions

Thu, 30 Nov 2006 10:25:01 +0000

Bug ID: 24720
Submitted by: Maciej Pilichowski
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.26

#24726: mode for controling comparison record against recordset

Thu, 30 Nov 2006 16:46:34 +0000

Bug ID: 24726
Submitted by: Maciej Pilichowski
Category: Server: Parser
Status: Verified
Severity: 4
OS: Linux (opensuse 10.0)
Version: 5.0.26

#24754: Index is not used when joining two tables

Fri, 01 Dec 2006 13:34:26 +0000

Bug ID: 24754
Submitted by: Alexander Barkov
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.1.14, 5.1.43-bzr

#24757: No way to limit memory consumption of some server subsystems.

Fri, 01 Dec 2006 15:21:33 +0000

Bug ID: 24757
Submitted by: Konstantin Osipov
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#24758: max_user_connections=0 doesn't work had to set a value to make it work

Fri, 01 Dec 2006 18:08:35 +0000

Bug ID: 24758
Submitted by: Jim Rendant
Category: Server: Options
Status: Verified
Severity: 3
OS: Linux (Fedora Core6)
Version: 5.0.27, 4.1 BK, 5.1 BK

#24761: dropped TCP connections not logged as errors but result in blocked host

Fri, 01 Dec 2006 20:50:56 +0000

Bug ID: 24761
Submitted by: Joshua Franklin
Category: Server: General
Status: Verified
Severity: 3
OS: Linux (Linux (Fedora))
Version: 5.0.36-BK, 5.0.27, 5.1, 6.0.7

#24762: Failure to import data (timestamp)

Fri, 01 Dec 2006 21:41:02 +0000

Bug ID: 24762
Submitted by:
Category: Server
Status: Verified
Severity: 1
OS: Linux (CentOS,Mac OSX)
Version: 4.1.20,5.0.60,5.1.38,5.1.40

#24769: Delayed queries

Sat, 02 Dec 2006 00:30:11 +0000

Bug ID: 24769
Submitted by: Roberto Spadim
Category: Server
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1

#24770: update with subquery slow

Sat, 02 Dec 2006 00:37:17 +0000

Bug ID: 24770
Submitted by: Roberto Spadim
Category: Server: Optimizer
Status: In progress
Severity: 5
OS: Any (all)
Version: 5.1

#24773: Error message does not contain enough specifics

Sat, 02 Dec 2006 10:29:38 +0000

Bug ID: 24773
Submitted by: Kristian Koehntopp
Category: Server: Errors
Status: Verified
Severity: 4
OS: Linux (Linux 2.6 Kernel)
Version: 5.0.18

#24819: subquery with more than 1 row

Tue, 05 Dec 2006 13:25:01 +0000

Bug ID: 24819
Submitted by: Balazs Odor
Category: Server
Status: Verified
Severity: 4
OS: Linux (Debian Linux)
Version: 5.0.27

#24826: Patch: number of connections to reserved for SUPER users

Tue, 05 Dec 2006 16:55:09 +0000

Bug ID: 24826
Submitted by: Lenz Grimmer
Category: Server: General
Status: In progress
Severity: 4
OS: Any
Version: 5.0-community

#24831: Patch: KILL thread_id WITH QUERY query_id

Tue, 05 Dec 2006 17:58:44 +0000

Bug ID: 24831
Submitted by: Lenz Grimmer
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0-community

#24832: Patch: SHOW SESSION {VARIABLES|STATUS} FOR CONNECTION

Tue, 05 Dec 2006 18:02:36 +0000

Bug ID: 24832
Submitted by: Lenz Grimmer
Category: Server: General
Status: Open
Severity: 4
OS: Any
Version: 5.0-community

#24833: QUICK option to DELETE lost in a multiple-table delete

Tue, 05 Dec 2006 18:34:54 +0000

Bug ID: 24833
Submitted by: Philip Stoev
Category: Server: Parser
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.26, 5.1 BK

#24843: MyISAM key buffer not 100% used, though it should be?

Wed, 06 Dec 2006 04:04:56 +0000

Bug ID: 24843
Submitted by: P Eger
Category: Server: Options
Status: Verified
Severity: 4
OS: Linux (RHEL4 x64, Windows x64)
Version: 5.0.27, 5.0.24a, 5.1.12

#24870: mysqlhotcopy cannot display binary log position to STDOUT

Thu, 07 Dec 2006 01:46:21 +0000

Bug ID: 24870
Submitted by: Matt Cowger
Category: Server: General
Status: Open
Severity: 4
OS: Linux (Linux)
Version: 5.0

#24898: No suitable error code for 'resource in use' in DROP/ALTER/RENAME

Fri, 08 Dec 2006 07:51:09 +0000

Bug ID: 24898
Submitted by: Jan Lindström
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0&5.1

#24903: timeout in mysqld.conf causes Got timeout reading communication packets

Fri, 08 Dec 2006 10:23:41 +0000

Bug ID: 24903
Submitted by: Arkadiusz Miskiewicz
Category: Server
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0.27

#24939: showing ALL structured system variables

Sat, 09 Dec 2006 22:08:39 +0000

Bug ID: 24939
Submitted by: Martin Friebe
Category: Server: General
Status: Verified
Severity: 4
OS: Any (*)
Version: 4.1 5.0

#24950: Using a incorrect message file not prevented

Mon, 11 Dec 2006 09:24:20 +0000

Bug ID: 24950
Submitted by: Jan Lindström
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0

#25007: memory tables with dynamic rows format

Tue, 12 Dec 2006 13:05:11 +0000

Bug ID: 25007
Submitted by: Roberto Spadim
Category: Server: Memory
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1, 5.5

#25010: There is no way to display TIMESTAMP values in UTC without setting variables

Tue, 12 Dec 2006 14:34:34 +0000

Bug ID: 25010
Submitted by: Victoria Reznichenko
Category: Server: Types
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0

#25030: InnoDB and Memory storage engines to support indexing of geometries

Wed, 13 Dec 2006 09:10:22 +0000

Bug ID: 25030
Submitted by: Vincent Gay
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (all)
Version: any

#25031: No foreign key definition passed to storage engine

Wed, 13 Dec 2006 09:35:34 +0000

Bug ID: 25031
Submitted by: Jan Lindström
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0 & 5.1

#25068: MyISAM-Optimizer prefers full table scan than index for IN with >15 elements

Thu, 14 Dec 2006 11:56:09 +0000

Bug ID: 25068
Submitted by: Anders Henke
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.0.27, 5.0.19, 5.0.36-BK

#25093: slave replay of transaction with CREATE TMP table fails

Fri, 15 Dec 2006 12:49:42 +0000

Bug ID: 25093
Submitted by: Andrei Elkin
Category: Server: Replication
Status: Verified
Severity: 3
OS: Linux (linux5.)
Version: 5.1.14

#25117: mysql hangs if during creating logfile group or tablespace one ndbd was stopped

Sun, 17 Dec 2006 08:19:53 +0000

Bug ID: 25117
Submitted by: Serge Kozlov
Category: Server: ClusterDD
Status: Verified
Severity: 3
OS: Linux (Linux FC4)
Version: mysql-5.1

#25128: command line client discards comments

Mon, 18 Dec 2006 02:27:39 +0000

Bug ID: 25128
Submitted by: Roland Bouman
Category: Client
Status: Verified
Severity: 4
OS: Any (all)
Version: all

#25143: mysql.exe client: shows password in command prompt window title

Mon, 18 Dec 2006 14:37:23 +0000

Bug ID: 25143
Submitted by: luca nanetti
Category: Client
Status: Verified
Severity: 4
OS: Windows (win xp)
Version: 5.0.27-community-nt

#25153: mysqld --skip-engine option

Mon, 18 Dec 2006 17:35:27 +0000

Bug ID: 25153
Submitted by: Peter Gulutzan
Category: Server: Options
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.0,5.1

#25194: please implement bulk inserts for federated table

Wed, 20 Dec 2006 03:55:06 +0000

Bug ID: 25194
Submitted by: Shane Bester
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any (*)
Version: 5.1, 5.5

#25225: Maximum attribute length has changed?

Wed, 20 Dec 2006 20:40:20 +0000

Bug ID: 25225
Submitted by: Geoff Crossland
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (Linux 2.6.9)
Version: mysql-5.1

#25243: Add CSV output option to the MySQL command line client

Fri, 22 Dec 2006 11:02:08 +0000

Bug ID: 25243
Submitted by: Lenz Grimmer
Category: Client
Status: Verified
Severity: 4

#25253: KILL should inform about the operation (file/line #) where kill flag was checked

Sat, 23 Dec 2006 07:19:41 +0000

Bug ID: 25253
Submitted by: Valeriy Kravchuk
Category: Server: General
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.x

#25258: Support condition pushdown in the federated table handler

Sat, 23 Dec 2006 17:45:16 +0000

Bug ID: 25258
Submitted by: Mark Callaghan
Category: Server: Federated
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.1

#25353: --version: insufficient information

Mon, 01 Jan 2007 20:23:26 +0000

Bug ID: 25353
Submitted by: Mark Johnson
Category: Server
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.0.27+

#25366: Easily check reserved words

Tue, 02 Jan 2007 15:17:15 +0000

Bug ID: 25366
Submitted by: Shiraz Esat
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#25370: database comment

Tue, 02 Jan 2007 16:28:34 +0000

Bug ID: 25370
Submitted by: Hans Ginzel
Category: Server: DDL
Status: Verified
Severity: 4
OS: Linux (All OS)
Version: 5.0, 5.1, 8.0

#25401: InnoDB should automatically create additional table space files as needed

Thu, 04 Jan 2007 00:57:11 +0000

Bug ID: 25401
Submitted by: Rick Mann
Category: Server: InnoDB
Status: Open
Severity: 4
OS: Any (Any)
Version: 5.1.14 beta

#25402: Optimisation replacing filesort for bigger result sets

Thu, 04 Jan 2007 01:58:27 +0000

Bug ID: 25402
Submitted by: Arjen Lentz
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#25472: Patch: Speed up execution of NDB Cluster when using Dolphin Super Sockets

Mon, 08 Jan 2007 18:24:55 +0000

Bug ID: 25472
Submitted by: Lenz Grimmer
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#25491: Detach and attach InnoDB tablespace files.

Tue, 09 Jan 2007 11:06:51 +0000

Bug ID: 25491
Submitted by: Kristian Koehntopp
Category: Server: InnoDB
Status: In progress
Severity: 4
OS: Any

#25508: Federated: Failure to Remove Partitioning

Tue, 09 Jan 2007 23:54:18 +0000

Bug ID: 25508
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.2.0

#25509: Federated: Failure with non-ASCII characters

Tue, 09 Jan 2007 23:56:29 +0000

Bug ID: 25509
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.2.0

#25510: Federated: double trigger activation

Tue, 09 Jan 2007 23:59:06 +0000

Bug ID: 25510
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (Linux, SUSE 10.0 / 64-bit)
Version: 5.0.36-BK, 5.2.0

#25535: load_defaults() no longer included by mysql.h

Wed, 10 Jan 2007 20:17:54 +0000

Bug ID: 25535
Submitted by: Hartmut Holzgraefe
Category: C API
Status: Verified
Severity: 4
OS: Any (*)
Version: 5.1.12 and up

#25568: Providing optional use of O_DIRECT for binary logs, InnoDB logs

Fri, 12 Jan 2007 01:50:30 +0000

Bug ID: 25568
Submitted by: Arjen Lentz
Category: Server: Replication
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 6.0

#25571: EXPLAIN returns incorrect estimation of rows for federated table

Fri, 12 Jan 2007 07:27:04 +0000

Bug ID: 25571
Submitted by: Valeriy Kravchuk
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.34-BK, 5.0.27

#25572: SHOW INDEX does not report cardinality (always NULL) for FEDERATED table

Fri, 12 Jan 2007 10:04:59 +0000

Bug ID: 25572
Submitted by: Valeriy Kravchuk
Category: Server: Federated
Status: Verified
Severity: 2
OS: Linux (Linux)
Version: 5.0.34-BK, 5.0.27

#25588: neither mysql.server nor mysqld_multi support status command

Fri, 12 Jan 2007 14:38:39 +0000

Bug ID: 25588
Submitted by: Oli Sennhauser
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: any

#25597: Extraneous error message displayed for slave SQL thread errors.

Fri, 12 Jan 2007 21:55:04 +0000

Bug ID: 25597
Submitted by: Chuck Bell
Category: Server: Replication
Status: In progress
Severity: 3
OS: Any (All)
Version: 5.0, 5.1

#25607: mysqladmin version does not show enough info for OS X

Sat, 13 Jan 2007 08:54:37 +0000

Bug ID: 25607
Submitted by: Jon Koerber
Category: Client
Status: Verified
Severity: 4
OS: MacOS (OS X Server 10.4)
Version: 5.0.27

#25630: INFORMATION_SCHEMA collation wrong for filesystems with case sensitive filenames

Mon, 15 Jan 2007 15:59:41 +0000

Bug ID: 25630
Submitted by: Kristian Koehntopp
Category: Server: I_S
Status: Verified
Severity: 3
OS: Linux (Centos 4.x)
Version: 5.0.33-standard-log/5.1BK

#25654: Add filtering by time to mysqldumpslow

Tue, 16 Jan 2007 16:47:26 +0000

Bug ID: 25654
Submitted by: Mark Leith
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any (Any)
Version: All

#25672: ALTER/DROP SERVER does not immediately affect open tables

Wed, 17 Jan 2007 08:33:55 +0000

Bug ID: 25672
Submitted by: Giuseppe Maxia
Category: Server: Federated
Status: Verified
Severity: 3
OS: Linux (linux)
Version: 5.1.15

#25676: information on federated server missing

Wed, 17 Jan 2007 10:17:03 +0000

Bug ID: 25676
Submitted by: Giuseppe Maxia
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.1.15

#25703: XML: ExtractValue() user-specified multiple match delimiter

Thu, 18 Jan 2007 19:14:23 +0000

Bug ID: 25703
Submitted by: Travis Haagen
Category: Server: XML
Status: Verified
Severity: 4
OS: Windows (Win32)
Version: 5.1, 6.0.9

#25707: Federated: CREATE SERVER database names with non-Latin characters

Thu, 18 Jan 2007 22:10:10 +0000

Bug ID: 25707
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.15-beta-debug-log

#25709: Federated: disallow duplicate CREATE SERVER options

Thu, 18 Jan 2007 22:24:30 +0000

Bug ID: 25709
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.15-beta-debug-log

#25713: contents in file relay-log sometimes error

Fri, 19 Jan 2007 02:09:18 +0000

Bug ID: 25713
Submitted by: mingfei hua
Category: Server: Replication
Status: Verified
Severity: 1
OS: MacOS (Mac OS X)
Version: 5.0.24

#25722: Federated: change definitions that CREATE SERVER uses

Fri, 19 Jan 2007 17:59:44 +0000

Bug ID: 25722
Submitted by: Peter Gulutzan
Category: Server: Federated
Status: Verified
Severity: 4
OS: Linux (SUSE 10.0 / 64-bit)
Version: 5.1.15-beta-debug

#25745: Setting configuration items which are in megabytes can have ambiguity

Mon, 22 Jan 2007 00:54:27 +0000

Bug ID: 25745
Submitted by: Morgan Tocker
Category: Server: General
Status: Verified
Severity: 4

#25748: my.ini (Windows) file demands Unix file syntax for SSL parameters

Mon, 22 Jan 2007 11:14:28 +0000

Bug ID: 25748
Submitted by: Peter Laursen
Category: Server: Options
Status: Verified
Severity: 3
OS: Windows (windows)
Version: 5.0.32-33/5.1.14/5.2.0

#25764: Query Cost Estimate seems to only cover a part of subqueries, not full query.

Mon, 22 Jan 2007 20:59:13 +0000

Bug ID: 25764
Submitted by: Tobias Asplund
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux, Mac OS X)
Version: 5.0.36-BK, 6.0.8-bzr

#25791: Ambiguous "Enter password" message while logging into client

Tue, 23 Jan 2007 16:21:42 +0000

Bug ID: 25791
Submitted by: Franco A.
Category: Client
Status: Verified
Severity: 4
OS: Linux (Linux)

#25826: Unique keys: show constraint name in error message

Wed, 24 Jan 2007 13:26:45 +0000

Bug ID: 25826
Submitted by: Sanjay Patil
Category: Server: Errors
Status: Verified
Severity: 4
OS: Windows (Windows 2000/XP)
Version: 5.0.36-BK, mysql-5.2.0-falcon-alpha-win32

#25847: Add predicate locking to avoid deadlocks due to locking non-existent rows

Thu, 25 Jan 2007 14:06:50 +0000

Bug ID: 25847
Submitted by: Mark Leith
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0.32

#25855: mysqldumpslow: needs better --help output

Thu, 25 Jan 2007 20:14:38 +0000

Bug ID: 25855
Submitted by: Paul DuBois
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: all

#25891: Creation of temporary table with key causing error 124

Sat, 27 Jan 2007 14:17:13 +0000

Bug ID: 25891
Submitted by: Matthew Clark
Category: Server: MyISAM
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.36-BK, 5.0.27

#25914: MySQL optimizer should be aware that SELECT ... FOR UPDATE is not key read

Mon, 29 Jan 2007 13:03:51 +0000

Bug ID: 25914
Submitted by: Heikki Tuuri
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (All)
Version: 5.1

#25918: ndb_restore fails when restoring a backup of a disk-data cluster

Mon, 29 Jan 2007 15:48:04 +0000

Bug ID: 25918
Submitted by: Rob Kinyon
Category: Server: ClusterDD
Status: Patch approved
Severity: 1
OS: Linux (Ubuntu 6.06 ETS)
Version: mysql-5.1

#25922: InnoDB crash recovery changes: make DDL in MySQL 'atomic'

Mon, 29 Jan 2007 16:08:57 +0000

Bug ID: 25922
Submitted by: Chris Calender
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any (All)
Version: All

#26033: Cannot use directories that contain spaces in my.cnf

Fri, 02 Feb 2007 00:53:38 +0000

Bug ID: 26033
Submitted by: Ben J
Category: Server: Installing
Status: Verified
Severity: 3
OS: Linux (Ubuntu Linux 6.10 64-bit)
Version: 5.0.24a-Debian_9-log (Ubuntu .deb Pkg)

#26060: Create ExtractXML() function to get parts of XML tree

Sun, 04 Feb 2007 02:36:31 +0000

Bug ID: 26060
Submitted by: Marcin Kurzyna
Category: Server: XML
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.2

#26096: Too strong assertion when frm file has corrupted character set/collation data

Mon, 05 Feb 2007 19:25:43 +0000

Bug ID: 26096
Submitted by: Mark Leith
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0, 5.1

#26130: support CAST(column AS BIGINT)

Tue, 06 Feb 2007 23:56:00 +0000

Bug ID: 26130
Submitted by: Dan Karp
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 5.0.27, 5.1

#26150: Omitting meaningess lines from err-logfile

Wed, 07 Feb 2007 14:46:46 +0000

Bug ID: 26150
Submitted by: Christian Starka
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.1.14 beta

#26182: patch: process percentage of a process -- contributed from Jeremy Cole

Thu, 08 Feb 2007 11:02:38 +0000

Bug ID: 26182
Submitted by: Chad MILLER
Category: Server: I_S
Status: Verified
Severity: 3
OS: Any
Version: 6.0

#26183: Can't find a bug using up-level category

Thu, 08 Feb 2007 12:02:47 +0000

Bug ID: 26183
Submitted by: Sergei Kulakov
Category: bugs.mysql.com
Status: Verified
Severity: 2
OS: Any (www)
Version: http://bugs.mysql.com/search.php

#26229: Allow "ls" as alias for "SHOW TABLES" or "SHOW DATABASES".

Fri, 09 Feb 2007 15:59:24 +0000

Bug ID: 26229
Submitted by: Derick Rethans
Category: Client
Status: Verified
Severity: 4
OS: -
Version: -

#26232: review of bug #20944 / proof of concept attached

Fri, 09 Feb 2007 17:28:20 +0000

Bug ID: 26232
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 4.1.22, 5.0.34, 5.0.36-BK

#26259: Provide generic support to save and retrieve per table create and update time

Sat, 10 Feb 2007 18:01:03 +0000

Bug ID: 26259
Submitted by: Mark Callaghan
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5.0

#26283: add cmdline option to ndbd for stdout redirection in --nodaemon mode

Mon, 12 Feb 2007 12:24:12 +0000

Bug ID: 26283
Submitted by: Axel Schwenke
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#26284: bug #26273 / optimize, not executed for index, if datafile is gap-free

Mon, 12 Feb 2007 12:32:58 +0000

Bug ID: 26284
Submitted by: Martin Friebe
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.bk

#26312: mysqldump and other tools should ignore prompt configuration option

Tue, 13 Feb 2007 10:30:56 +0000

Bug ID: 26312
Submitted by: Jacques
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: 5.0.33

#26334: Inconsistency: ALTER PROC/FUNC doesn't allow [NOT] DETERMINISTIC

Tue, 13 Feb 2007 16:50:03 +0000

Bug ID: 26334
Submitted by: Alex Rytov
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.1.15

#26367: MIN_ROWS not working for MyISAM tables

Wed, 14 Feb 2007 13:10:47 +0000

Bug ID: 26367
Submitted by: Mark Leith
Category: Server: MyISAM
Status: Verified
Severity: 4
OS: Any (Any)
Version: 4.1-BK, 5.0-BK, 5.1-BK

#26374: insert/update of unsigned bigint column fails when using variable larger than

Wed, 14 Feb 2007 17:17:45 +0000

Bug ID: 26374
Submitted by: Patrick Lin
Category: Server: Types
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0 BK. 5.1 BK

#26394: IF error message "ERROR 1054 (42S22): Unknown column 'X' in 'field list'"

Thu, 15 Feb 2007 08:20:47 +0000

Bug ID: 26394
Submitted by: Roland Bouman
Category: Server: SP
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.36-NK, all

#26410: InnoDB row operations counters wraps around at 2^32

Thu, 15 Feb 2007 15:32:14 +0000

Bug ID: 26410
Submitted by: Per Hallström
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any (Any)
Version: 5.0.27

#26419: # diff -u mysql-test-run.pl mysql-test-run mysql-test-run and basedir

Thu, 15 Feb 2007 18:08:08 +0000

Bug ID: 26419
Submitted by: Christian Hammers
Category: Server: Tests
Status: Open
Severity: 4
OS: Any
Version: 5.0.32

#26422: Generating statements in MySQL client

Thu, 15 Feb 2007 19:39:00 +0000

Bug ID: 26422
Submitted by: Andre Timmer
Category: Client
Status: Verified
Severity: 4
Version: 5.0.18

#26453: patch to speed up range-optimizer

Fri, 16 Feb 2007 17:05:46 +0000

Bug ID: 26453
Submitted by: Martin Friebe
Category: Server: MyISAM
Status: Verified
Severity: 5
OS: Any (*)
Version: 5.0.36bk

#26476: DUMP 2502 (TcDumpAllScanRec) dumps the last record twice

Mon, 19 Feb 2007 08:13:30 +0000

Bug ID: 26476
Submitted by: Hartmut Holzgraefe
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (linux)
Version: mysql-5.1

#26483: Slave MySQLD does not reconnect w/ slave cluster after network outage restored

Mon, 19 Feb 2007 22:26:21 +0000

Bug ID: 26483
Submitted by: Jonathan Miller
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (Linux 32 Bit)
Version: mysql-5.1-telco-6.2

#26511: A composite index prefix is used when all of the key_len could be used.

Tue, 20 Feb 2007 22:47:41 +0000

Bug ID: 26511
Submitted by: Sean Pringle
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 4.0, 4.1, 5.0, 5.1

#26525: Add --skip-thread option to mysqlbinlog

Wed, 21 Feb 2007 13:30:46 +0000

Bug ID: 26525
Submitted by: Mark Leith
Category: Client
Status: Verified
Severity: 4

#26545: usability: make the UI auto-detect the TZ and select it in the config pulldown

Wed, 21 Feb 2007 21:29:30 +0000

Bug ID: 26545
Submitted by: Sloan Childers
Category: Monitoring: Web
Status: Verified
Severity: 4
OS: Any
Version: 2.0

#26570: CHECK TABLE not allowed in PSs

Thu, 22 Feb 2007 15:02:25 +0000

Bug ID: 26570
Submitted by: Max Mether
Category: Server: PS
Status: Verified
Severity: 4
OS: Linux (Linux)
Version: 5,1.14/5.1BK

#26602: Consolidate lock wait timeouts

Fri, 23 Feb 2007 18:05:32 +0000

Bug ID: 26602
Submitted by: Jeremy Cole
Category: Server: Locking
Status: Verified
Severity: 4
OS: Any
Version: All

#26615: field for "fixed in"

Sat, 24 Feb 2007 14:09:27 +0000

Bug ID: 26615
Submitted by: Martin Friebe
Category: bugs.mysql.com
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#26630: Partition pruning not working against joins

Mon, 26 Feb 2007 11:21:14 +0000

Bug ID: 26630
Submitted by: Lim tienaik
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.1.18-BK, 5.1.14-beta

#26651: MyODBC / ADO Set data type is frequently failing to update when no Primary Key

Mon, 26 Feb 2007 23:12:27 +0000

Bug ID: 26651
Submitted by: Erica Moss
Category: Connector/ODBC
Status: Verified
Severity: 2
OS: Windows (win xp)
Version: 3.51.12

#26671: record when mysqld server deleted binlogs

Tue, 27 Feb 2007 09:00:14 +0000

Bug ID: 26671
Submitted by: Shane Bester
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: *

#26697: Every query to a federated table results in a full scan of MyISAM table.

Tue, 27 Feb 2007 21:53:26 +0000

Bug ID: 26697
Submitted by: Jose Luis Palacios
Category: Server: Federated
Status: Verified
Severity: 2
OS: Linux (Linux, Windows 2000)
Version: 5.0.38-BK, 5.0.27, 5.1

#26731: ALTER TABLE `Table` CONVERT TO CHARSET .... Fails on Enums

Wed, 28 Feb 2007 20:06:15 +0000

Bug ID: 26731
Submitted by: Jonas Jonsson
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Linux (Gentoo Linux)
Version: 5.0.26-log, 4.1, 5.1, 5.2

#26776: No error log entry when SSL cannot read /dev/random

Thu, 01 Mar 2007 23:11:07 +0000

Bug ID: 26776
Submitted by: Kolbe Kegel
Category: Server: General
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.36

#26799: Char and binary types without padding/stripping

Fri, 02 Mar 2007 16:02:12 +0000

Bug ID: 26799
Submitted by: Olaf van der Spek
Category: Server: Types
Status: Verified
Severity: 4
OS: Any (*)
Version: *

#26824: Libmysql, possibly C/XYZ, does not handle error of COM_STMT_SEND_LONG_DATA

Sat, 03 Mar 2007 14:21:35 +0000

Bug ID: 26824
Submitted by: Andrey Hristov
Category: Server: PS
Status: Verified
Severity: 2
OS: Any (All)
Version: 5.1.17-bk, probably 4.1 and 5.0 too

#26832: ENUM types not optimized

Sun, 04 Mar 2007 18:17:45 +0000

Bug ID: 26832
Submitted by: Roberto Spadim
Category: Server: Optimizer
Status: Verified
Severity: 5
OS: Any
Version: 5.5

#26886: No ROUTINE_PRIVILEGES table in INFORMATION_SCHEMA

Tue, 06 Mar 2007 17:36:47 +0000

Bug ID: 26886
Submitted by: Max Mether
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#26888: func_in fails on many different platforms, but with low probability

Tue, 06 Mar 2007 18:09:26 +0000

Bug ID: 26888
Submitted by: Daniel Fischer
Category: Server: Tests
Status: Verified
Severity: 3
OS: Any
Version: 5.0 + 5.1 + 5.5

#26906: No message slogan found

Wed, 07 Mar 2007 08:47:43 +0000

Bug ID: 26906
Submitted by: Paul Maunders
Category: Server: Cluster
Status: Verified
Severity: 1
OS: Any
Version: mysql-5.1

#26920: WatchDog termination, reported in error "please report a bug"

Wed, 07 Mar 2007 14:44:29 +0000

Bug ID: 26920
Submitted by: johnny slakva
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (RHEL3)
Version: mysql-5.0

#26948: SHOW COLUMNS FROM table LIKE '%ver%'

Thu, 08 Mar 2007 06:16:17 +0000

Bug ID: 26948
Submitted by: Hans Ginzel
Category: Server: Parser
Status: Verified
Severity: 4
OS: Windows (MS Windows XP)
Version: 5.0.26-community-nt, 5.1

#26955: RESTART of management server fails

Thu, 08 Mar 2007 10:10:39 +0000

Bug ID: 26955
Submitted by: Johan Andersson
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1-telco-6.2

#26967: SHOW PROFILE: Inconsistent output capitalization

Thu, 08 Mar 2007 18:00:01 +0000

Bug ID: 26967
Submitted by: Paul DuBois
Category: Server: General
Status: Verified
Severity: 3
OS: Any (all)
Version: 5.0.37

#26984: ERROR 1206 (HY000): The total number of locks exceeds the lock table size

Fri, 09 Mar 2007 01:34:45 +0000

Bug ID: 26984
Submitted by: Roland Bouman
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (linux)
Version: 5.1.16

#27041: generalise column names in SELECT glob*name

Mon, 12 Mar 2007 09:11:02 +0000

Bug ID: 27041
Submitted by: Hans Ginzel
Category: Server: Parser
Status: Verified
Severity: 4
OS: Windows (MS Windows XP)
Version: 5.0.26-community-nt, 5.1

#27077: ndb->extra(HA_EXTRA_IGNORE_NO_KEY) becomes repeatedl ineffectiv once was reset

Tue, 13 Mar 2007 10:46:27 +0000

Bug ID: 27077
Submitted by: Andrei Elkin
Category: Server: ClusterRep
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#27080: Dashboard graphs should have view options for 1 day, 1 week, 1 month and 1 year.

Tue, 13 Mar 2007 12:59:10 +0000

Bug ID: 27080
Submitted by: Johan Idrén
Category: Monitoring: Web
Status: Verified
Severity: 4
OS: Any
Version: 1.1.0

#27082: Dashboard should have slave controls

Tue, 13 Mar 2007 13:36:46 +0000

Bug ID: 27082
Submitted by: Johan Idrén
Category: Monitoring: Web
Status: Verified
Severity: 4
Version: 1.1.0

#27098: Cluster: tablespace names are case sensitive

Tue, 13 Mar 2007 18:05:36 +0000

Bug ID: 27098
Submitted by: Peter Gulutzan
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any (SUSE 10.0 / 64-bit)
Version: mysql-5.1

#27124: Add timespans to rule scheduling

Wed, 14 Mar 2007 09:50:47 +0000

Bug ID: 27124
Submitted by: Johan Idrén
Category: Monitoring: Advisor/Rules
Status: Verified
Severity: 4
Version: 1.1.0

#27156: Not even if strict mode will halt on warnings

Wed, 14 Mar 2007 23:33:35 +0000

Bug ID: 27156
Submitted by: Stephen Gornick
Category: Server: Types
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0, 5.1, 5.6.99

#27157: Option to halt execution on error in client when interactive, just like batch

Thu, 15 Mar 2007 00:16:15 +0000

Bug ID: 27157
Submitted by: Stephen Gornick
Category: Client
Status: Open
Severity: 4
Version: 5.1

#27159: restrict permissions for table maintenance statements

Thu, 15 Mar 2007 01:02:37 +0000

Bug ID: 27159
Submitted by: Arjen Lentz
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#27160: Automatically subscribe submitter to e-mail updates for bugs they reported

Thu, 15 Mar 2007 01:22:18 +0000

Bug ID: 27160
Submitted by: Stephen Gornick
Category: bugs.mysql.com
Status: Verified
Severity: 4

#27175: invalid colum attributes in create/alter table

Thu, 15 Mar 2007 14:48:39 +0000

Bug ID: 27175
Submitted by: Martin Friebe
Category: Server: DDL
Status: Verified
Severity: 3
OS: Linux (Linux)
Version: 5.0.38 4.1.23

#27180: #1030 - Got error 1 from storage engine with big tables

Thu, 15 Mar 2007 15:49:02 +0000

Bug ID: 27180
Submitted by: Stefan Novak
Category: Server: Federated
Status: In progress
Severity: 1
OS: Linux (Linux Ubuntu)
Version: mysql Ver 14.12 Distrib 5.0.24a

#27194: error 121: Duplicate key on write or update

Fri, 16 Mar 2007 01:14:17 +0000

Bug ID: 27194
Submitted by: Johan Andersson
Category: Server: ClusterRep
Status: Verified
Severity: 3
OS: Any (*)
Version: mysql-5.1-telco-6.2

#27215: autopush, please cleanup after a successful push

Fri, 16 Mar 2007 14:11:45 +0000

Bug ID: 27215
Submitted by: Ingo Strüwing
Category: Server: Compiling
Status: Open
Severity: 4

#27223: Partitions: undocumented display with ndb status

Fri, 16 Mar 2007 18:46:06 +0000

Bug ID: 27223
Submitted by: Peter Gulutzan
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (SUSE 10.0 / 64-bit)
Version: mysql-5.1

#27234: INSERT into Merge Table implicitly locks all underlying tables

Sat, 17 Mar 2007 04:48:18 +0000

Bug ID: 27234
Submitted by: Venu Anuganti
Category: Server: Merge
Status: Verified
Severity: 4
OS: Any

#27246: Windows: mysql_real_connect should get username of current process if not specif

Sun, 18 Mar 2007 10:13:45 +0000

Bug ID: 27246
Submitted by: Georg Richter
Category: C API
Status: Verified
Severity: 4
OS: Windows (Windows)
Version: all

#27299: Multi-table UPDATE does not work properly (IMHO)

Tue, 20 Mar 2007 18:20:11 +0000

Bug ID: 27299
Submitted by: James Goatcher
Category: Server: DML
Status: Verified
Severity: 3
OS: Linux (Linux 2.6.9-34.ELsmp)
Version: 5.0.40-BK, 5.0.19

#27334: data disconsistency while alter modify column to enum

Wed, 21 Mar 2007 14:39:16 +0000

Bug ID: 27334
Submitted by: Hans Ginzel
Category: Server: Types
Status: Verified
Severity: 4
OS: Windows (Windows XP)
Version: 5.0.26-community-nt

#27353: MyODBC 3/ ADO server side static cursor not supporting required functions

Wed, 21 Mar 2007 18:42:40 +0000

Bug ID: 27353
Submitted by: Erica Moss
Category: Connector/ODBC
Status: Verified
Severity: 3
OS: Windows (XP sp2)
Version: 3.51.14, 5.1.8

#27376: Uncorrect unique key implementation on multiple optional columns

Thu, 22 Mar 2007 14:51:10 +0000

Bug ID: 27376
Submitted by: Andre Timmer
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: 5.0.18

#27389: regular expression substitute

Fri, 23 Mar 2007 06:24:10 +0000

Bug ID: 27389
Submitted by: Hans Ginzel
Category: Server
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.0

#27418: DROP TABLE should drop views too

Sat, 24 Mar 2007 17:31:41 +0000

Bug ID: 27418
Submitted by: Baron Schwartz
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any (all)
Version: 5.0.24

#27452: Correlated subquery produces inefficient optimizer plan for INFORMATION_SCHEMA

Mon, 26 Mar 2007 17:35:17 +0000

Bug ID: 27452
Submitted by: Jay Pipes
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.40-BK, 5.0.24a-debian-log, 5.1.31-bzr, 6.0.7-alpha, 6.0.9-bzr

#27475: mysql_fetch_field do NOT report correctly certain field types

Tue, 27 Mar 2007 15:25:29 +0000

Bug ID: 27475
Submitted by: Alonso Murillo
Category: Server: Types
Status: Verified
Severity: 2
OS: Windows (Wincows/Linux)
Version: Mysql 5.0.37/5.BK/4.1BK

#27508: Semantic of SHOW [SESSION|GLOBAL] STATUS

Wed, 28 Mar 2007 22:19:24 +0000

Bug ID: 27508
Submitted by: Marc ALFF
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1

#27518: Table character set changes do not set fields, provide option or document..

Thu, 29 Mar 2007 11:17:50 +0000

Bug ID: 27518
Submitted by: Domas Mituzas
Category: MySQL Workbench: Administration
Status: Verified
Severity: 4
OS: Any (any)
Version: 5.2

#27527: Handle User Defined Functions with geometry types

Thu, 29 Mar 2007 15:14:16 +0000

Bug ID: 27527
Submitted by: Albert Rovira
Category: Server: UDF
Status: Verified
Severity: 4
OS: Any
Version: 5.0.37

#27538: ClusterRep -> InnoDB (Delete fails to be rep when table uses partitions 4 clause

Fri, 30 Mar 2007 00:08:03 +0000

Bug ID: 27538
Submitted by: Jonathan Miller
Category: Server: Cluster
Status: Verified
Severity: 2
OS: Linux (Linux 32 Bit OS)
Version: mysql-5.1-telco-6.2

#27549: SELinux Support including MLS (Multi-Level Security) policy

Fri, 30 Mar 2007 13:17:26 +0000

Bug ID: 27549
Submitted by: Nils Hammar
Category: Server: General
Status: Open
Severity: 4
OS: Linux (Linux)

#27552: NO_BACKSLASH_ESCAPES with replication fails with apostrophes

Fri, 30 Mar 2007 15:37:56 +0000

Bug ID: 27552
Submitted by: Ken Johanson
Category: Server: Replication
Status: Verified
Severity: 1
OS: Linux (Linux (x86_64))
Version: 5.0.37-log, 5.0, 5.1 BK

#27579: Table names taken from expressions - SELECT * FROM @table

Mon, 02 Apr 2007 04:30:35 +0000

Bug ID: 27579
Submitted by: Ondra Zizka
Category: Server
Status: Open
Severity: 4
OS: Any
Version: 5.0.x

#27615: unnecessary push down of condition in presence of utilized index

Tue, 03 Apr 2007 13:21:29 +0000

Bug ID: 27615
Submitted by: Roland Bouman
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (linux)
Version: mysql-5.1

#27644: ndb: connecting api node/mysqld may "steal" node_id from running mysqld

Wed, 04 Apr 2007 12:30:33 +0000

Bug ID: 27644
Submitted by: Tomas Ulin
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.0

#27661: fields comments - storage engines

Thu, 05 Apr 2007 04:19:06 +0000

Bug ID: 27661
Submitted by: Roberto Spadim
Category: Server
Status: Open
Severity: 4
OS: Any
Version: all

#27687: ALTER TABLE ... CONVERT TO uses @@collation_database

Fri, 06 Apr 2007 12:47:28 +0000

Bug ID: 27687
Submitted by: Alexander Nozdrin
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Any
Version: 5.0.40-BK

#27713: INSERTs fail for empty table using WITH_CHECK_OPTION

Mon, 09 Apr 2007 11:17:58 +0000

Bug ID: 27713
Submitted by: Christian Hammers
Category: Server: Views
Status: Verified
Severity: 3
OS: Any
Version: 5.0.38, 5.1, 5.2

#27721: In current Event Scheduler you cannot relate one temporal event to another one

Mon, 09 Apr 2007 20:12:17 +0000

Bug ID: 27721
Submitted by: Jacob Nikom
Category: Server: SP
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#27724: mysqldump --hex-blob -T doesn't work

Mon, 09 Apr 2007 23:35:49 +0000

Bug ID: 27724
Submitted by: Peter Gulutzan
Category: Client: mysqldump
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#27737: Erroneous usage of blobs via ndbapi may cause mysqld to crash

Tue, 10 Apr 2007 17:16:09 +0000

Bug ID: 27737
Submitted by: Jonathan Miller
Category: Server: NDBAPI
Status: Verified
Severity: 3
OS: Linux (32 bit)
Version: mysql-5.1

#27743: inconsistent destructive propagation of DROP DATABASE across SQL nodes

Wed, 11 Apr 2007 01:33:51 +0000

Bug ID: 27743
Submitted by: Roland Bouman
Category: Server: Cluster
Status: Verified
Severity: 2
OS: Linux (ubuntu edgy)
Version: mysql-5.1

#27761: Option to disable logins with empty password

Wed, 11 Apr 2007 15:57:54 +0000

Bug ID: 27761
Submitted by: Olaf van der Spek
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any
Version: *

#27766: DN restarts using ndb_mgm give inconsistent results

Wed, 11 Apr 2007 19:55:59 +0000

Bug ID: 27766
Submitted by: Jonathan Miller
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (32 Bit)
Version: mysql-5.1-telco-6.2

#27776: Disk scan cant see uncommitted inserts by own transaction

Thu, 12 Apr 2007 04:56:52 +0000

Bug ID: 27776
Submitted by: Jonas Oreland
Category: Server: ClusterDD
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#27793: RENAME PROCEDURE / FUNCTION and ALTER PROCEDURE / FUNCTION ... RENAME

Thu, 12 Apr 2007 21:02:09 +0000

Bug ID: 27793
Submitted by: Ondra Zizka
Category: Server: SP
Status: Verified
Severity: 4
OS: Any

#27794: subqueries optimizations

Thu, 12 Apr 2007 21:14:59 +0000

Bug ID: 27794
Submitted by: Roberto Spadim
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any (any)
Version: any

#27795: patch for explain extended to show outer aggregates like outer fields

Thu, 12 Apr 2007 22:26:05 +0000

Bug ID: 27795
Submitted by: Martin Friebe
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.0.40, 5.1

#27832: XAConnection does not allow XA Start xid JOIN

Sun, 15 Apr 2007 01:59:02 +0000

Bug ID: 27832
Submitted by: abayi tay
Category: Server: General
Status: Verified
Severity: 4
OS: Windows (XP)
Version: 5.0.27-standard

#27835: Strange version number encoding for plugins

Sun, 15 Apr 2007 10:14:35 +0000

Bug ID: 27835
Submitted by: Hartmut Holzgraefe
Category: Server: General
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#27849: version incompatibility for comma operator between 4.1.x and 5.0.x

Mon, 16 Apr 2007 12:21:11 +0000

Bug ID: 27849
Submitted by: Vadim Smelyansky
Category: Server: General
Status: Verified
Severity: 4
OS: Linux
Version: 5.0.37

#27855: 5.1 log table crashes 5.0

Mon, 16 Apr 2007 17:05:48 +0000

Bug ID: 27855
Submitted by: Andrey Hristov
Category: Server: CSV
Status: Verified
Severity: 2
OS: Any
Version: 5.1

#27869: Comparison between string and very large integer fails

Tue, 17 Apr 2007 02:59:16 +0000

Bug ID: 27869
Submitted by: Kolbe Kegel
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 5.0.38, 5.1.17

#27872: Incorrect error message when disk fills up running a large query against a view

Tue, 17 Apr 2007 06:26:38 +0000

Bug ID: 27872
Submitted by: Joseph Libson
Category: Server: General
Status: Verified
Severity: 3
OS: Linux
Version: 5.0.37-community-log

#27885: command line clients puke on 'init-command' in my.cnf

Tue, 17 Apr 2007 15:13:46 +0000

Bug ID: 27885
Submitted by: Axel Schwenke
Category: Client
Status: Verified
Severity: 3
OS: Any
Version: 5.0.38

#27886: ALTER TABLESPACE ADD DATAFILE does not honor NO_ENGINE_SUBSTITUTION

Tue, 17 Apr 2007 15:26:55 +0000

Bug ID: 27886
Submitted by: Roland Bouman
Category: Server: ClusterDD
Status: Verified
Severity: 2
OS: Any
Version: mysql-5.1

#27906: MySQL doesn't accept ISO8601 date

Tue, 17 Apr 2007 23:27:38 +0000

Bug ID: 27906
Submitted by: Sander Marechal
Category: Server: Types
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#27909: Can't use Null for AI PK in RS.Update with Client-side cursor

Wed, 18 Apr 2007 01:29:38 +0000

Bug ID: 27909
Submitted by: Tobus .
Category: Connector/ODBC
Status: Verified
Severity: 4
OS: Windows (XP/2000)
Version: 5.1 alpha

#27910: Suggested feature for triggers and functions

Wed, 18 Apr 2007 01:53:06 +0000

Bug ID: 27910
Submitted by: Luciano Fantuzzi
Category: Server: PS
Status: Verified
Severity: 4
OS: Any
Version: 5.0.37-community-nt

#27913: Exit error message correct, but followed by "unknown..."

Wed, 18 Apr 2007 04:45:20 +0000

Bug ID: 27913
Submitted by: LR Mack McBride
Category: Server: Cluster
Status: In progress
Severity: 2
OS: Linux (CentOS 4.4)
Version: mysql-5.1

#27925: X509_Issuer and X509_Subject does not uniquely identify a user

Wed, 18 Apr 2007 11:24:24 +0000

Bug ID: 27925
Submitted by: Oli Sennhauser
Category: Server: Privileges
Status: Open
Severity: 4
OS: Any
Version: >= 5.0

#27966: Optimize LOWER() away when collation is case insensitive

Thu, 19 Apr 2007 23:00:09 +0000

Bug ID: 27966
Submitted by: Nils Meyer
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#27982: Summary: NdbScanfilter cmp api evolution proposal

Fri, 20 Apr 2007 13:52:48 +0000

Bug ID: 27982
Submitted by: Tomas Ulin
Category: Server: NDBAPI
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#27983: Provide more information about internal resource usage

Fri, 20 Apr 2007 13:58:00 +0000

Bug ID: 27983
Submitted by: Tomas Ulin
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#28010: SHOW PROCESSLIST does not report connection flags

Sun, 22 Apr 2007 03:48:31 +0000

Bug ID: 28010
Submitted by: Ondra Zizka
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any
Version: 5.0.37

#28017: Plugins should support LGPL license

Sun, 22 Apr 2007 13:39:06 +0000

Bug ID: 28017
Submitted by: Mark Leith
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.1-BK

#28043: set default umask in mysqld.cc, not my_init()

Mon, 23 Apr 2007 20:48:43 +0000

Bug ID: 28043
Submitted by: Timothy Smith
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 4.1, 5.0, 5.1

#28047: Merge doesn't check for compatible version on CREATE/ALTER

Mon, 23 Apr 2007 21:19:55 +0000

Bug ID: 28047
Submitted by: Matthew Montgomery
Category: Server: Merge
Status: Verified
Severity: 4
OS: Any
Version: any

#28062: MyODBC 3/ ADO record set status - adRecPermissionDenied not working correctly

Tue, 24 Apr 2007 02:09:10 +0000

Bug ID: 28062
Submitted by: Erica Moss
Category: Connector/ODBC
Status: Verified
Severity: 3
OS: Windows (xp sp 2)
Version: 3.51.22 / 5.1.1 / 5.2.2

#28101: MyODBC 3/ADO batch updating is not working with adUseServer cursor location

Wed, 25 Apr 2007 17:20:51 +0000

Bug ID: 28101
Submitted by: Erica Moss
Category: Connector/ODBC
Status: Verified
Severity: 2
OS: Windows (XP sp2)
Version: 3.51

#28108: mysqlbinlog reports "file not found" when file exists

Wed, 25 Apr 2007 23:43:09 +0000

Bug ID: 28108
Submitted by: Ofer Inbar
Category: Client
Status: Verified
Severity: 4
OS: Linux (RHEL 4)
Version: 5.0.24

#28109: add sql mode to error out when doing DDL inside a transaction

Thu, 26 Apr 2007 00:05:47 +0000

Bug ID: 28109
Submitted by: Lukas Smith
Category: Server: General
Status: Open
Severity: 4
OS: Any

#28134: NDB fails totally in "debug" server of RPM on IA64

Fri, 27 Apr 2007 12:17:33 +0000

Bug ID: 28134
Submitted by: Joerg Bruehe
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Linux (IA64, RPM)
Version: mysql-5.0

#28139: client in user language

Fri, 27 Apr 2007 17:00:52 +0000

Bug ID: 28139
Submitted by: Susanne Ebrecht
Category: Client
Status: Verified
Severity: 4
OS: Any
Version: all

#28164: Perl Compatible Regular Expressions (PREGEX/PRLIKE syntax)

Mon, 30 Apr 2007 14:05:33 +0000

Bug ID: 28164
Submitted by: Lester Hightower
Category: Server: Parser
Status: Verified
Severity: 4
OS: Any
Version: All

#28175: Slave Host loosing network connection w/ Slave Batching can cause NDBD failure

Mon, 30 Apr 2007 21:57:18 +0000

Bug ID: 28175
Submitted by: Jonathan Miller
Category: Server: ClusterRep
Status: Verified
Severity: 2
OS: Linux (32 Bit)
Version: mysql-5.1-telco-6.2

#28198: Single User Mode. Difference of output for empty and non-empty tables

Wed, 02 May 2007 12:36:55 +0000

Bug ID: 28198
Submitted by: Serge Kozlov
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#28199: Single User Mode. Status of sql nodes is shown wrong.

Wed, 02 May 2007 13:12:01 +0000

Bug ID: 28199
Submitted by: Serge Kozlov
Category: Server: Cluster
Status: Verified
Severity: 3
OS: Any
Version: mysql-5.1

#28214: Inconsistency in setting BINARY flag for fields with binary collation

Thu, 03 May 2007 08:11:51 +0000

Bug ID: 28214
Submitted by: Tonci Grgin
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Windows (XPPro SP2)
Version: 5.0.42-BK, 5.0.38BK

#28232: Need separate logs for different databases / users

Fri, 04 May 2007 08:42:55 +0000

Bug ID: 28232
Submitted by: media forest
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: 5.0.38-1

#28241: QCache stores dublicates

Fri, 04 May 2007 13:51:06 +0000

Bug ID: 28241
Submitted by: Martin Friebe
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: 5.0.42,5.1BK

#28258: A version of GREATEST() / LEAST() what would ignore NULL values

Sat, 05 May 2007 06:18:30 +0000

Bug ID: 28258
Submitted by: Ondra Zizka
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: 5.0.37

#28270: CHANGE MASTER command does not accept variables

Mon, 07 May 2007 00:49:18 +0000

Bug ID: 28270
Submitted by: MICHELE SARTORI
Category: Server: Replication
Status: Verified
Severity: 3
OS: Any
Version: 5.0, 5.1, 4.1

#28300: General RTREE indicies

Tue, 08 May 2007 10:03:10 +0000

Bug ID: 28300
Submitted by: Kristian Koehntopp
Category: Server: GIS
Status: Verified
Severity: 4
OS: Any
Version: any

#28313: Cluster needs to handle management of user accounts across nodes

Tue, 08 May 2007 19:04:29 +0000

Bug ID: 28313
Submitted by: Gerry Reno
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Any
Version: 5.1.17-beta

#28329: missleading error message on attempt to do parallel backups

Wed, 09 May 2007 07:39:19 +0000

Bug ID: 28329
Submitted by: Hartmut Holzgraefe
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#28342: MyODBC 3/ADO extra spaces in data after writing with appendchunk into blob field

Wed, 09 May 2007 22:47:41 +0000

Bug ID: 28342
Submitted by: Erica Moss
Category: Connector/ODBC
Status: Verified
Severity: 2
OS: Windows (XP sp2)
Version: 3.51.14

#28371: Add SQL 'hints' for fine grained control of engine_condition_pushdown

Fri, 11 May 2007 08:43:03 +0000

Bug ID: 28371
Submitted by: Roland Bouman
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 5.1.16

#28404: Optimizer does not consider index that can be used for ORDER BY

Sun, 13 May 2007 18:33:11 +0000

Bug ID: 28404
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Linux
Version: 4.0.31, 4.1.25, 4.1.26, 5.0.42-BK, 5.0.46, 5.1.33

#28405: please add a Com_change_user status variable

Sun, 13 May 2007 18:50:41 +0000

Bug ID: 28405
Submitted by: Shane Bester
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0, 5.1, 5.5

#28406: GRANT using a stored procedure variable as PASSWORD fails

Sun, 13 May 2007 20:58:34 +0000

Bug ID: 28406
Submitted by: Emery Fabrice NZEYIMANA
Category: Server: SP
Status: Verified
Severity: 4
OS: Linux (Ubuntu 7.04)
Version: 5.0.42-BK, 5.0.38-Ubuntu

#28412: insert_id in OK Packet not working with multiple rows INSERT

Mon, 14 May 2007 11:35:17 +0000

Bug ID: 28412
Submitted by: Geert Vanderkelen
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.0.41

#28422: mysql client does not recognize bit values

Mon, 14 May 2007 18:35:01 +0000

Bug ID: 28422
Submitted by: Mark Leith
Category: Client
Status: Verified
Severity: 3
OS: Any
Version: 5.0.40, 5.5.6

#28429: Replication: ldap style Automatic query forwarding for writing queries to master

Mon, 14 May 2007 23:07:26 +0000

Bug ID: 28429
Submitted by: Michael Hafen
Category: Proxy
Status: Verified
Severity: 4
OS: Any
Version: Any

#28466: Error message is unnecessary repetitive and long

Wed, 16 May 2007 11:43:30 +0000

Bug ID: 28466
Submitted by: Jason Garrett
Category: Server: Errors
Status: Verified
Severity: 4
OS: Any (MS Windows, Linux)
Version: 5.0+

#28481: No Query Timeouts

Wed, 16 May 2007 20:23:40 +0000

Bug ID: 28481
Submitted by: Steven Cain
Category: Server: General
Status: Verified
Severity: 4
OS: Windows

#28511: UDF API does not check whether a function exceeds max_length

Fri, 18 May 2007 08:35:15 +0000

Bug ID: 28511
Submitted by: Hartmut Holzgraefe
Category: Server: UDF
Status: Verified
Severity: 4
OS: Any
Version: 5.1.17, probably all

#28516: 64-bit version fails to bind a tcp socket if bind-address is the hostname

Fri, 18 May 2007 12:58:30 +0000

Bug ID: 28516
Submitted by: Edda Hochstrate
Category: Server: General
Status: Verified
Severity: 3
OS: Solaris
Version: 5.0.41

#28538: Assertion failure when replicating "DELETE FROM t" from ndb to myisam.

Sat, 19 May 2007 14:16:48 +0000

Bug ID: 28538
Submitted by: Rafal Somla
Category: Server: Replication
Status: Verified
Severity: 3
OS: Linux
Version: 5.1.18, 5.1.21

#28540: mysqdump --verbose does not provide informations about triggers and stored procs

Sun, 20 May 2007 09:20:42 +0000

Bug ID: 28540
Submitted by:
Category: Client
Status: Verified
Severity: 4
OS: Linux (any OS)
Version: 5.0, 5.1, 6.0

#28554: Optimizer wrongly prefers index for (col = value) over (PK <= value)

Mon, 21 May 2007 09:32:16 +0000

Bug ID: 28554
Submitted by: Valeriy Kravchuk
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 4.1.22, 5.0.42-BK

#28565: Information disclosure during SELECT

Mon, 21 May 2007 15:39:53 +0000

Bug ID: 28565
Submitted by: Andrey Hristov
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.0

#28576: Slave recovery from a bad connection

Mon, 21 May 2007 22:05:57 +0000

Bug ID: 28576
Submitted by: Arjen Lentz
Category: Server: Replication
Status: Verified
Severity: 4
OS: Any
Version: any

#28592: Multi-column Updates Using Row Constructors and Row Subqueries

Tue, 22 May 2007 13:16:28 +0000

Bug ID: 28592
Submitted by: Mark
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#28624: Improving FULL-TEXT index and searching

Wed, 23 May 2007 16:36:24 +0000

Bug ID: 28624
Submitted by: Miguel Velilla meucat
Category: Server: FTS
Status: Verified
Severity: 4
OS: Any (Bit to bit search for matching against '*needle*' (as %like% does) )
Version: 5.0

#28667: Privilege to allow TRUNCATE and deny DROP ?

Fri, 25 May 2007 08:35:25 +0000

Bug ID: 28667
Submitted by: Nicolae Namolovan
Category: Server: Privileges
Status: Open
Severity: 4
OS: Any
Version: 5.1.18

#28700: VIEWs using the MERGE algorithm ignore STRAIGHT_JOIN

Sun, 27 May 2007 02:16:54 +0000

Bug ID: 28700
Submitted by: Björn Steinbrink
Category: Server: Optimizer
Status: In progress
Severity: 4
OS: Linux (Debian Unstable)
Version: 5.0.44-BK, 5.0.41

#28727: ALTER TABLE does not roll back

Mon, 28 May 2007 15:39:21 +0000

Bug ID: 28727
Submitted by: Laas Toom
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Linux (openSUSE 10.2 linux-2.6.18.8-0.3)
Version: 5.0.26-12

#28753: wrong implementation of symbolic links on windows

Tue, 29 May 2007 16:01:19 +0000

Bug ID: 28753
Submitted by: Ömer Faruk Özer
Category: Server: General
Status: Verified
Severity: 4
OS: Windows
Version: 5.0

#28792: Compressing duplicate column values

Wed, 30 May 2007 23:08:08 +0000

Bug ID: 28792
Submitted by: Jason Shuler
Category: Server: DDL
Status: Verified
Severity: 4
OS: Any
Version: 5.x

#28834: Frq: New "type" of indexes on XML documents is needed

Fri, 01 Jun 2007 12:27:19 +0000

Bug ID: 28834
Submitted by: Valeriy Kravchuk
Category: Server: XML
Status: Verified
Severity: 4
OS: Any
Version: 5.1.x

#28836: --log-warnings=2 does not report max_connections limit reached

Fri, 01 Jun 2007 13:33:23 +0000

Bug ID: 28836
Submitted by: Yusuf Nulwala
Category: Server: Logging
Status: Verified
Severity: 4
OS: Linux (suse-linux-gnu on x86_64 (SUSE MySQL RPM))
Version: mysqld Ver 5.0.26-log

#28874: Monitoring and Advisory Service should read logfiles from mysqld.

Mon, 04 Jun 2007 12:59:06 +0000

Bug ID: 28874
Submitted by: Johan Idrén
Category: Monitoring: Agent
Status: Verified
Severity: 4
OS: Any
Version: 1.1.0.4876

#28886: Union, Sort and Enum

Mon, 04 Jun 2007 22:01:02 +0000

Bug ID: 28886
Submitted by: Sherif Zaroubi
Category: Server: Types
Status: Verified
Severity: 3
OS: Any
Version: 5.1, 5.5, 5.6, 5.7

#28887: SQLBIGINT is assumed to be a long long

Mon, 04 Jun 2007 22:27:59 +0000

Bug ID: 28887
Submitted by: Jim Winstead
Category: Connector/ODBC
Status: Verified
Severity: 3
OS: Any
Version: 5.2

#28892: Edit charcter set and add new characters to the ctype Table

Tue, 05 Jun 2007 07:40:38 +0000

Bug ID: 28892
Submitted by: KARIM EL GENDY
Category: Server: FTS
Status: Verified
Severity: 4
OS: Any (Windows XP Professional)
Version: 5.0 - 5.2

#28913: Running MySQL data on a GPT drive?

Wed, 06 Jun 2007 04:54:38 +0000

Bug ID: 28913
Submitted by: Marcos Boyington
Category: Server: InnoDB
Status: Verified
Severity: 2
OS: Windows
Version: 5.0.45, 5.1

#28939: Failing test causes other subsequent tests to fail

Thu, 07 Jun 2007 05:13:04 +0000

Bug ID: 28939
Submitted by: Adam Dixon
Category: Server: Tests
Status: Verified
Severity: 3
OS: Any
Version: 5.0.92

#28947: Optimize foreign key checks for truncate table with empty referencing table

Thu, 07 Jun 2007 14:47:07 +0000

Bug ID: 28947
Submitted by: Ed Dawley
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: 5.0.33

#28954: Installer does not give option to automatically setup boot scripts

Thu, 07 Jun 2007 18:16:29 +0000

Bug ID: 28954
Submitted by: Harrison Fisk
Category: Monitoring: Install
Status: Verified
Severity: 4
OS: Linux
Version: 1.1.0

#28957: Ordered Analytical Functions

Thu, 07 Jun 2007 19:30:11 +0000

Bug ID: 28957
Submitted by: Jason Shuler
Category: Server: DML
Status: Verified
Severity: 4
OS: Any
Version: 5.x

#28961: MySQL should provide a unixtime() function which uses UTC

Thu, 07 Jun 2007 21:11:20 +0000

Bug ID: 28961
Submitted by: Matthew Montgomery
Category: Server: General
Status: Verified
Severity: 4
OS: Linux (2.6.20-1.2307.fc5)
Version: 5.0.42

#28968: mysqldump includes autoincrement value when --no-data is specified

Fri, 08 Jun 2007 08:59:53 +0000

Bug ID: 28968
Submitted by: Flavio Tordini
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any

#29043: Add mysqldump option to dump privileges in GRANT format

Tue, 12 Jun 2007 06:37:32 +0000

Bug ID: 29043
Submitted by: Alexander Keremidarski
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any

#29120: new partition type

Thu, 14 Jun 2007 18:31:52 +0000

Bug ID: 29120
Submitted by: Roberto Spadim
Category: Server: Partition
Status: Open
Severity: 4
OS: Any
Version: any

#29162: show table status row counts for innodb include deleted but unpurged rows

Sun, 17 Jun 2007 17:27:13 +0000

Bug ID: 29162
Submitted by: Shane Bester
Category: Server: InnoDB
Status: Verified
Severity: 4
OS: Any
Version: 5.0.44, 5.1.20

#29202: Result of UDF in subquery is truncated

Tue, 19 Jun 2007 09:11:11 +0000

Bug ID: 29202
Submitted by: Sergei Golubchik
Category: Server: UDF
Status: Verified
Severity: 3
OS: Any
Version: 5.1

#29237: Privilege system inconsistent

Wed, 20 Jun 2007 13:51:02 +0000

Bug ID: 29237
Submitted by: Max Mether
Category: Server: Privileges
Status: Verified
Severity: 3
OS: Any
Version: 5.1.19, 5.0-BK

#29244: log-queries-not-using-indexes logs all UNION SELECTs to slow query log

Wed, 20 Jun 2007 16:12:17 +0000

Bug ID: 29244
Submitted by: Axel Schwenke
Category: Server: Logging
Status: Verified
Severity: 4
OS: Any
Version: 4.1.22, 5.0.44, 5.1.20

#29265: Field Comments

Thu, 21 Jun 2007 11:19:20 +0000

Bug ID: 29265
Submitted by: Ben Burch
Category: Server: I_S
Status: Verified
Severity: 4
OS: Any (All)
Version: All

#29287: Please grant system root user all privileges.

Thu, 21 Jun 2007 21:21:24 +0000

Bug ID: 29287
Submitted by: Soren Hansen
Category: Server: Privileges
Status: Verified
Severity: 4
OS: Linux
Version: any

#29327: mysqld_multi doesn't support !include or !includedir directives

Mon, 25 Jun 2007 00:59:53 +0000

Bug ID: 29327
Submitted by: Jason Sydes
Category: Client
Status: Verified
Severity: 4
OS: Any
Version: 5.0.38, 5.1

#29340: Possible DoS attack: any user can set sort_buffer_size/max_heap_size

Mon, 25 Jun 2007 15:04:27 +0000

Bug ID: 29340
Submitted by: Kai Voigt
Category: Server: General
Status: Verified
Severity: 2
OS: Any
Version: 5.1.19-beta/5.0

#29347: inconsistency in grant update(col) on view if user doesnt have select

Mon, 25 Jun 2007 23:20:48 +0000

Bug ID: 29347
Submitted by: Martin Friebe
Category: Server: Views
Status: Verified
Severity: 3
OS: FreeBSD
Version: 5.1.20bk 5.0.44

#29349: dropping MEMORY table very slow

Tue, 26 Jun 2007 01:01:49 +0000

Bug ID: 29349
Submitted by: Jacek Becla
Category: Server: Memory
Status: Verified
Severity: 3
OS: Any
Version: 5.0.27

#29370: need tool to enforce mysqld error number compatibility

Tue, 26 Jun 2007 19:12:32 +0000

Bug ID: 29370
Submitted by: Timothy Smith
Category: Server: Errors
Status: Verified
Severity: 3
OS: Any
Version: any

#29412: Execute SQL or a script when a rule fires

Thu, 28 Jun 2007 07:26:55 +0000

Bug ID: 29412
Submitted by: Kristian Koehntopp
Category: Monitoring: Advisors/Rules
Status: Verified
Severity: 4
OS: Any
Version: 1.1.0

#29421: MySQL allows mixing of GROUP columns with no GROUP columns in complex terms

Thu, 28 Jun 2007 13:43:41 +0000

Bug ID: 29421
Submitted by: Szymon Nowakowski
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.14-beta/5.0

#29423: Query gets stuck in the "PREPARING" stage

Thu, 28 Jun 2007 14:59:56 +0000

Bug ID: 29423
Submitted by: Tobias Asplund
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: MacOS
Version: 5.0.41, 5.1, 4.1

#29427: flush table low_priority

Thu, 28 Jun 2007 18:32:47 +0000

Bug ID: 29427
Submitted by: Matthew Lord
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: all

#29433: composite index not used

Fri, 29 Jun 2007 00:03:28 +0000

Bug ID: 29433
Submitted by: Jacek Becla
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.0.27, 5.0, 5.1, 4.1, 5.2 BK, 6.0.14-bzr

#29443: cost calculations are off

Fri, 29 Jun 2007 13:28:44 +0000

Bug ID: 29443
Submitted by: Matthew Lord
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 5.1.19

#29519: KILL additions

Tue, 03 Jul 2007 13:40:34 +0000

Bug ID: 29519
Submitted by: Matthew Lord
Category: Server: General
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#29523: Transactions do not work - cross-session data corruption

Tue, 03 Jul 2007 15:56:55 +0000

Bug ID: 29523
Submitted by: Antony Curtis
Category: Server: Federated
Status: Verified
Severity: 4
OS: Any
Version: 5.1

#29540: C/J should round-trip all-zero dates when in "round" mode

Wed, 04 Jul 2007 04:46:07 +0000

Bug ID: 29540
Submitted by: Mark Matthews
Category: Connector/J
Status: Verified
Severity: 4
OS: Any
Version: All

#29542: Allow to use a table referenced by a trigger in the query

Wed, 04 Jul 2007 08:42:01 +0000

Bug ID: 29542
Submitted by: Zigmund Bulinsh
Category: Server: SP
Status: Verified
Severity: 4
OS: Windows (XP SP2)
Version: 5.0.37

#29590: Request to add support for back-references in regular expressions

Fri, 06 Jul 2007 05:30:45 +0000

Bug ID: 29590
Submitted by: Robbie Haertel
Category: Server: General
Status: Verified
Severity: 4
OS: Any

#29628: mysqldump should put newlines between VALUES when using extended inserts

Sun, 08 Jul 2007 18:01:53 +0000

Bug ID: 29628
Submitted by: dAniel hAhler
Category: Client: mysqldump
Status: Verified
Severity: 4
OS: Any
Version: 5.0.38

#29637: ER_BAD_TABLE_ERROR returned for DROP TABLE during NDB errno 701 schema ops

Mon, 09 Jul 2007 06:21:08 +0000

Bug ID: 29637
Submitted by: Sean Pringle
Category: Server: Cluster
Status: Verified
Severity: 4
OS: Any
Version: mysql-5.1

#29712: mysqlimport lacks option for CHARACTER SET clause in LOAD DATA

Wed, 11 Jul 2007 06:23:51 +0000

Bug ID: 29712
Submitted by: Alexander Keremidarski
Category: Client
Status: Verified
Severity: 4
OS: Any
Version: 5.0

#29757: STRING FUNCTIONS WITH LIMITS

Thu, 12 Jul 2007 13:56:46 +0000

Bug ID: 29757
Submitted by: Roberto Spadim
Category: Server: DML
Status: Verified
Severity: 3
OS: Any
Version: 5.5

#29781: Adding in Pattern Replace (RegExp) for MySQL Engine

Fri, 13 Jul 2007 02:24:14 +0000

Bug ID: 29781
Submitted by: David Boccabella
Category: Server
Status: Verified
Severity: 4
OS: Any
Version: 5.0.41

#29790: information schema returns non-atomic content => replication (binlog) fails

Fri, 13 Jul 2007 16:30:52 +0000

Bug ID: 29790
Submitted by: Martin Friebe
Category: Server: I_S
Status: Verified
Severity: 3
OS: FreeBSD
Version: 5.1.21 5.0.46

#29840: A PRIMARY KEY must include all columns in the table's partitioning function

Tue, 17 Jul 2007 08:59:18 +0000

Bug ID: 29840
Submitted by: Chunning Wang
Category: Server: Partition
Status: Verified
Severity: 4
OS: Linux
Version: 5.6.21

#29845: GROUP BY does not make best use of indicies when evaluating SUM aggregates

Tue, 17 Jul 2007 13:10:35 +0000

Bug ID: 29845
Submitted by: Chris Ricks
Category: Server: Optimizer
Status: Verified
Severity: 4
OS: Any
Version: 6.0.0-alpha