Re: Locating "Duplicate" records always results in Error 127

On Mon, 2003-03-17 at 16:17, Jocelyn Fournier wrote:
> Hi,
>
> This sounds like a MySQL bug.

>
> # ------------------------------------------------------------ -----------
> USE test;
> #
> # Table structure for table 'error127'
> #
> DROP TABLE IF EXISTS `error127`;
> CREATE TABLE `error127` (
> `ItemID` int(11) NOT NULL default '0',
> `Name` varchar(70) NOT NULL default '',
> `Status` int(11) NOT NULL default '0',
> PRIMARY KEY (`ItemID`),
> KEY `Name` (`Name`)
> ) TYPE=MyISAM;
> #
> # Dumping data for table 'error127'
> #
> INSERT INTO `error127` (`ItemID`, `Name`) VALUES("1", "AAAAAAAA");
> INSERT INTO `error127` (`ItemID`, `Name`) VALUES("2", "AAAAAAAA");
> #
> # Set status
> #
> UPDATE error127 AS a,error127 AS b SET a.status=2 WHERE a.name = b.name AND
> a.itemid != b.itemid;
>
> # ------------------------------------------------------------ -----------
>
> >
> >
> >
> > MySQL 4.011g, WinXP Prof


I've just checked this bug with current version of MySQL 4.0.12 and
I can't repeat it. MySQL works just fine.

Could you please also try it once again with MySQL 4.0.12 as soon as it
is released (it is likely to happen this week) and let us know if it is
still repeatable for you so we can dig further.


--
MySQL 2003 Users Conf. -> http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13983@lists.mysql.com
To unsubscribe, e-mail

RE: Locating "Duplicate" records always results in Error 127

on 17 March 2003 16:42 Peter Zaitsev wrote:

> On Mon, 2003-03-17 at 16:17, Jocelyn Fournier wrote:
>> Hi,
>>
>> This sounds like a MySQL bug.
>
>>
>> #
> ------------------------------------------------------------ -----------
>> USE test;
>> #
>> # Table structure for table 'error127'
>> #
>> DROP TABLE IF EXISTS `error127`;
>> CREATE TABLE `error127` (
>> `ItemID` int(11) NOT NULL default '0',
>> `Name` varchar(70) NOT NULL default '',
>> `Status` int(11) NOT NULL default '0',
>> PRIMARY KEY (`ItemID`),
>> KEY `Name` (`Name`)
>> ) TYPE=MyISAM;
>> #
>> # Dumping data for table 'error127'
>> #
>> INSERT INTO `error127` (`ItemID`, `Name`) VALUES("1", "AAAAAAAA");
>> INSERT INTO `error127` (`ItemID`, `Name`) VALUES("2", "AAAAAAAA"); #
>> # Set status
>> #
>> UPDATE error127 AS a,error127 AS b SET a.status=2 WHERE a.name =
>> b.name AND a.itemid != b.itemid;
>>
>> #
> ------------------------------------------------------------ -----------
>>
>>>
>>>
>>>
>>> MySQL 4.011g, WinXP Prof
>
>
> I've just checked this bug with current version of MySQL 4.0.12 and
> I can't repeat it. MySQL works just fine.
>
> Could you please also try it once again with MySQL 4.0.12 as soon as
> it is released (it is likely to happen this week) and let us know if
> it is still repeatable for you so we can dig further.

Peter, I'm not sure if you meant me and/or Jocelyn, but I will certainly try
when 4.0.12 is out.

--
Ian Wall
IW Software Development Ltd




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13984@lists.mysql.com
To unsubscribe, e-mail

RE: Locating "Duplicate" records always results in Error 127

on 17 March 2003 16:42 Peter Zaitsev wrote:

[...]

>
> I've just checked this bug with current version of MySQL 4.0.12 and
> I can't repeat it. MySQL works just fine.
>
> Could you please also try it once again with MySQL 4.0.12 as soon as
> it is released (it is likely to happen this week) and let us know if
> it is still repeatable for you so we can dig further.

Peter,

I have just downloaded 4.0.12 and it does indeed seem to have fixed the
problem.

Thanks.

Ian Wall


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13986@lists.mysql.com
To unsubscribe, e-mail