"datetime" problem moving from 3.x to 4.x under OS X

Hi,

When Apple's OS X Server updated mysql from 3.x to 4.x datetime columns
no longer appear correctly. Reverting to the previous version of mysqld
shows
the datetime columns correctly. New entries added under 4.x are not
shown
correctly under 3.x and vice versa.

Is there an easy way to update the records with datetime entries made
under 3.x
so that I can apply the OS X server updates?

TIA

john elemans


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: "datetime" problem moving from 3.x to 4.x under OS X

Hi!

On Mar 16, Support wrote:
> Hi,
>
> When Apple's OS X Server updated mysql from 3.x to 4.x datetime
> columns no longer appear correctly. Reverting to the previous version
> of mysqld shows the datetime columns correctly. New entries added
> under 4.x are not shown correctly under 3.x and vice versa.
>
> Is there an easy way to update the records with datetime entries made
> under 3.x so that I can apply the OS X server updates?

What do you mean "incorrectly" ?
Can you show a query that returns incorrect results ?
What client do you use to connect to mysqld ?

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: "datetime" problem moving from 3.x to 4.x under OS X

>
> On Mar 16, Support wrote:
>> Hi,
>>
>> When Apple's OS X Server updated mysql from 3.x to 4.x datetime
>> columns no longer appear correctly. Reverting to the previous version
>> of mysqld shows the datetime columns correctly. New entries added
>> under 4.x are not shown correctly under 3.x and vice versa.
>>
>> Is there an easy way to update the records with datetime entries made
>> under 3.x so that I can apply the OS X server updates?
>
> What do you mean "incorrectly" ?
> Can you show a query that returns incorrect results ?
> What client do you use to connect to mysqld ?
>
> Regards,
> Sergei
>
The bad dates are random characters. They return with any and all SELECT
statements. The results are the same in any client, my own application,
YourSQL,
or even using mysql from the command line.

Thanks

john elemans


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: "datetime" problem moving from 3.x to 4.x under OS X

Support writes:
> The bad dates are random characters. They return with any and all SELECT
> statements. The results are the same in any client, my own application,
> YourSQL,
> or even using mysql from the command line.
>
> Thanks
>
> john elemans

Are you using our binary ??

This sort of behaviour could happen with badly built binaries.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

Meet the MySQL at User Conference ! (April 14-16, 2004)
http://www.mysql.com/uc2004/


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org