>>>>> "Brian" == Brian S Craigie <[EMAIL PROTECTED]> writes:
Brian> On 15-Jan-99 [EMAIL PROTECTED] wrote about Not displayed in SELECT but got
Brian> 'duplicate key..' in ...
Brian> I got this when I had the wrong mysqld running.
Brian> I had 3.21.x and I upgraded 3.22.14b-gamma, then wrote some data, then went
Brian> back to 3.21.x accidentally, and while running that, I couldn't see the data
Brian> which had been populated by 3.22.14. Once I ran the correct mysqld daemon
Brian> again, everything was OK.
This only happens if you create a new table with 3.22; The DATE type
in MySQL 3.22 is incompatible with MySQL 3.21 as I changed it to be
stored on 3 bytes instead of 4. MySQL 3.22 can of course read columns
with the old DATE type.
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.