2008/10/19 Rama <[EMAIL PROTECTED]>
> hi,
>
> iam using java,hibernate,mysql
>
> i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
> mysql
> DATE field.
>
> when i retrieve the same date from mysql to java it is being displayed as
> *18-10-2008 18:30:00 GMT *
>
>
> i could n
Le mardi 24 janvier 2006 à 19:23 +0100, Fabien SK a écrit :
> Le mardi 24 janvier 2006 à 19:08 +0100, fabsk a écrit :
> > Thank you a lot for your answer. The bug is there: if I drop the index
> > 'tp_idx_part_solution', the result of the count is OK.
> > I recreate
Le mardi 24 janvier 2006 à 19:08 +0100, fabsk a écrit :
> Thank you a lot for your answer. The bug is there: if I drop the index
> 'tp_idx_part_solution', the result of the count is OK.
> I recreated this index and the cound drop to "2" again.
It doesn't happen on version 4.1.12-Max on my machine
Thank you for you answer, but I read many times and I did not found
something to answer my question (well, I did not know about the NULL).
In my case:
- there is one table
- htere is no "distinct"
- there is a WHERE clause, so there is no optimisation
- there is no other field and no "group by"
I
ll.
My PC-Config.is P 233, 32 MB SDRAM, WIN95 OSR2, 4GB partition.
Please help
Sk Islam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)