Karam,
- Original Message -
From: Karam Chand [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, January 25, 2005 8:58 PM
Subject: RE: Serious bug (or my foolishness) with alter table and InnoDB
Hello,
I just checked with the same version at home and it
works.
Dont
Hello,
I am running mysql 4.1.7 on Win2K.
I have two tables:
CREATE TABLE `child` (
`id` int(11) NOT NULL default '0',
`name` char(1) NOT NULL default '',
PRIMARY KEY (`id`,`name`)
Works fine on WinXP 4.1.8. Only generates warning:
mysql show warnings;
+-+--+--+
| Level | Code | Message
|
There is certainly *something* wrong if the ALTER TABLE statement causes the
server to hang; the statement should either succeed or fail with an error
but in neither case should the server hang.
I'm still back on 4.0.15 so I'm not in a great position to try the code
myself but I see a few odd
There was a serious (threat of data loss) bug in 4.1.7 InnoDB . I'm not
very familiar with the specifics, but this problem could be that.
In any case I'd be scared to run InnoDB on a 4.1.7 without fully
understanding the problem. You should definitely consider upgrading to
4.1.8 , or, at the
Can somebody try this on 4.1.7?
I will download 4.1.8 tomorrow and check it out.
Damn...my connection is slow (on a dialup) and 35MB of
download...h
Regards,
Karam
--- Chris [EMAIL PROTECTED] wrote:
There was a serious (threat of data loss) bug in
4.1.7 InnoDB . I'm not
very familiar
Thanks for your ultra detailed reply.
The tables are just samples (no where related to
actual table). Well I am not that bad in db designing
also ;)
I checked the manual - you indeed can execute two
statements like this in one. And if you see the query
I am even changing the table type in the
Hello,
I just checked with the same version at home and it
works.
Dont know whats the problem at office.
Will check again?
Karam
--- Artem Koltsov [EMAIL PROTECTED] wrote:
Works fine on WinXP 4.1.8. Only generates warning:
mysql show warnings;