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
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
Description:
How-To-Repeat:
mysql -ecreate table `FIELDS` (x int) test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Submitter-Id: submitter ID
Originator:Matthias Urlichs
Organization:
noris network AG, Nuernberg, Germany
MySQL support: licence
Synopsis:
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 ) + 1
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
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)
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 = 15473;
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:
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
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 07:35:47 +0100 smurf
--- 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 llbuff[21
11 matches
Mail list logo
