Constraint violations don't show which constraint fails

>Description: A constraint violation doesn't show which constraint was violated, which is bad for fixing bugs. >How-To-Repeat: create table a(b int, index(b)) type=innodb; create table c(d int, index(d)) type=innodb; alter table c add constraint foo foreign k

"select distinct" doesn't coalesce NULL rows

>Description: "select distinct FOO from BAR" reports multiple NULL rows >How-To-Repeat: Unknown. It's a large table (1 entries or so). The problem didn't show with a simple test table. The table: -- MySQL dump 10.0 -- -- Host: localhostDatabase: pop ---

mysqldump doesn't quote table names

>Description: >How-To-Repeat: mysql -e"create table `FIELDS` (x int)" test mysqldump test >Fix: Teach mysqldump to use backquotes. >Submitter-Id: >Originator:Matthias Urlichs >Organization: noris network AG, Nuernberg, Germany >MySQL support: licence >Synopsis:

Update with sub-select from same table FAILS

>Description: MySQL doesn't allow me to use a sub-select in an update if the subselect happens to be from the same table. >How-To-Repeat: mysql> use test; mysql> create table T(lfd int, foo int); mysql> insert into T (lfd, foo) values ( ( select max( lfd ) +

innodb deadlock leads to server crash

>Description: A deadlock within innodb leads to a server crash. I have a large table which I need to update in-place. So one mysql connection does a SELECT, and another updates the data. I thought that, since innodb supports transactions and multiversioning, the

Innodb table with auto-increment column doesn't create (err 1005)

>Description: Table not creatable >How-To-Repeat: mysql> create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql> create table stundenliste (id int auto_increment) type=in

"Sending data", but no data sent?

>Description: Selecting for a number in a char table is REALLY slow. >How-To-Repeat: Large table, main index on column 'id' varchar(100). mysql> select id from ticketid where id = '15473'; Empty set (0.00 sec) mysql> select id from ticketid where id = 154

After a crash, a bogus log entry doesn't appear on the slave

>Description: I had a system crash today. The master log didn't get written after some point (zeroed-out data). The slave's log stated: 010302 12:59:47 Slave: Failed reading log event, reconnecting to retry, log 'mysql.138449' position 86713 010302 12:59:47 Slave: reco

Large updates don't travel through the binary log

>Description: Updates > 4 MBytes cause the binary replication to stall. >How-To-Repeat: Try to replicate an UPDATE command with >4MB of data >Fix: log_event.h, line 45: delete MAX_EVENT_LEN log_event.cc, line 88: replace MAX_EVENT_LEN with max_allowed_packet >Submi

Adding the offset to mysqlbinlog

binlog.cc --- noris.38/sql/mysqlbinlog.cc Wed, 24 Jan 2001 21:35:51 +0100 smurf (database_mysql/N/b/20_mysqlbinlo 1.12 664) +++ noris.39/sql/mysqlbinlog.cc Mon, 05 Feb 2001 22:00:12 +0100 smurf +(database_mysql/N/b/20_mysqlbinlo 1.13 664) @@ -355,18 +355,25 @@ while(1) { char

Restarting a slave didn't work

>Description: Restarting doesn't connect to the master. >How-To-Repeat: mysql restart. show slave status. Read server log. >Fix: The master's file name still had a newline. Index: noris.38/sql/slave.cc --- noris.38/sql/slave.cc Thu, 25 Jan 2001 0

New configure.in check doesn't work

>Description: One of the configure checks is faulty. Specifically, this one: # Check 3rd argument of getthostbyname_r ac_save_CXXFLAGS="$CXXFLAGS" AC_CACHE_CHECK([3 argument to gethostname_r routines], mysql_cv_gethostname_arg, AC_LANG_SAVE AC_LANG_CPLUSPLUS if test "$ac_cv_prog_gxx" = "