Hi.
I tested this with 3.23.38 and was not able to reproduce the
problem. The UPDATE works as supposed for me.
Did you compile the server yourself? If so, try an official binary. If
not, please post more information, like where you got your binary
from, which version it is and so on. Use "mysqlbug" utility if
possible.
Bye,
Benjamin.
PS: Could you get rid of that footer? It's annoying.
On Thu, Nov 29, 2001 at 03:21:53PM +0000, [EMAIL PROTECTED] wrote:
> I have pared down my bug scenario to a single script, at the end of which I
> have
> failed to update my table, and have reports that the MYD file cannot be
> opened.
> Here it is:
>
> #This script file for mysql shows a possible bug.
> #The update statement near the bottom of the file (a) appears not to
> #work (as shown by the fact that the two selects return the same result)
> #(b) leaves the table <clips> in a state which myisamchk describes as
> #"crashed", and (c) after a flush leaves clips.MYD unreadable
>
> #Drop and re-create the test table
> DROP TABLE IF EXISTS Clips ;
> CREATE TABLE Clips
> (
> ClipID INTEGER NOT NULL,
> Owner TINYTEXT DEFAULT NULL,
> PRIMARY KEY (ClipID),
> FULLTEXT (Owner)
> ) ;
>
> #Create a single row
> INSERT INTO clips SET clipID = 2 ;
>
> #Display it
> SELECT ClipID, Owner FROM clips ;
> #Owner should be NULL
>
> #Update it
> #This is the line which causes the damage
> UPDATE Clips SET Owner = "me" WHERE ClipID = 2 ;
>
> #Display it agaim
> SELECT ClipID, Owner FROM clips ;
> #Owner should be "me" but is NULL
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
