4.0.10 - order by - varius sort

How-to-repeat :

I don't know when, but sometimes in:

select tab026.*
from tab032 left join tab026 on tab032.m_field1 = tab026.m_field2
group by tab026.id
order by tab026.m_sort

database returns rown with various sort. In all returned rows value m_sort
= 0, but select returns for example:

valueA, valueAA,0
valueB, valueBB, 0
valueC, valueCC, 0

but later returns:

valueB, valueBB, 0
valueA, valueAA,0
valueC, valueCC, 0

Is it bug ?

(I have database with this error, but it about 7000 rows (700 kB).... I can
send it. Char set in MySQL is latin2)

Regards
Irek Smaczny



------------------------------------------------------------ ---------
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-thread13704@lists.mysql.com
To unsubscribe, e-mail

Re: 4.0.10 - order by - varius sort

Irek writes:
> How-to-repeat :
>
> I don't know when, but sometimes in:
>
> select tab026.*
> from tab032 left join tab026 on tab032.m_field1 = tab026.m_field2
> group by tab026.id
> order by tab026.m_sort
>
> database returns rown with various sort. In all returned rows value m_sort
> = 0, but select returns for example:
>
> valueA, valueAA,0
> valueB, valueBB, 0
> valueC, valueCC, 0
>
> but later returns:
>
> valueB, valueBB, 0
> valueA, valueAA,0
> valueC, valueCC, 0
>
> Is it bug ?
>
> (I have database with this error, but it about 7000 rows (700 kB).... I can
> send it. Char set in MySQL is latin2)
>
> Regards
> Irek Smaczny
>

Hi!

Yes, it should be a bug. ORDER BY on the same table, with the same
charset should always retun tuples in the same order.

Please provide a full test case, including table dump and upload it to

ftp://support.mysql.com:/pub/mysql/secret

and let us know a filename.

It must be a repeatable test case, i.e. a bug should pop-up always.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
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-thread13717@lists.mysql.com
To unsubscribe, e-mail