Hi!
Fournier == Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] writes:
Fournier Hi,
Fournier So I assume in this case the only way to have distinct results is to use
Fournier GROUP BY topic clause ?
If you do this, you can't still use 'ORDER BY date' as 'date' is not
part of the GROUP BY
Fournier Jocelyn [Presence-PC] writes:
Hi,
I have the latest 4.0.2 source installed, and the problem is still here
AFAIK :
mysql \s
--
mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
-=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch
(13:29:52)
#
]; [EMAIL PROTECTED]
Sent: Friday, April 26, 2002 4:45 PM
Subject: Re: How does DISTINCT really work ?
Fournier Jocelyn [Presence-PC] writes:
Hi,
I have the latest 4.0.2 source installed, and the problem is still here
AFAIK :
mysql \s
--
mysql Ver 12.1 Distrib 4.0.2
]
Sent: Monday, April 15, 2002 9:06 AM
Subject: Re: How does DISTINCT really work ?
Hi!
- Original Message -
From: SDiZ (UHome) [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 7:51 AM
Subject: Re: How does DISTINCT really work ?
I
]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 1:06 PM
Subject: Re: How does DISTINCT really work ?
Hi!
Ok, Monty said that this DISTINCT ... ORDER BY bug has already been fixed
in
4.0.
Regards,
Heikki
PROTECTED];
[EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 1:35 PM
Subject: Re: How does DISTINCT really work ?
Hi,
I have the latest 4.0.2 source installed, and the problem is still here
AFAIK :
mysql \s
--
mysql Ver 12.1 Distrib 4.0.2-alpha
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki From: SDiZ (UHome) [EMAIL PROTECTED]
I think every thing are documented.
http://www.mysql.com/doc/B/u/Bugs.html
a.. The optimiser may handle DISTINCT differently if you are using
'hidden' columns in a join or not.
Heikki Ok,
Fournier Jocelyn [Presence-PC] writes:
Hi,
I have the latest 4.0.2 source installed, and the problem is still here
AFAIK :
mysql \s
--
mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
-=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch
(13:29:52)
#
Hi Jocelyn,
I wonder how works DISTINCT when using it with the following join.
Ex :
mysql SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND
(mot='test') AND date = '2002-03-24' ORDER BY date
, 2002 5:54 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I wonder how works DISTINCT when using it with the following join.
Ex :
mysql SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7
? (perhaps a bug ?)
Regards,
Jocelyn Fournier
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 5:54 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I wonder how
Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 6:58 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I don't have a quick/sure answer for you, but am wondering about the
relationship
Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sendt: 14. april 2002 19:22
In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
in the EXPLAIN result :
That's because the MySQL optimizer converts your distinct into a group by.
Read more here:
]; [EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 7:46 PM
Subject: SV: How does DISTINCT really work ?
Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sendt: 14. april 2002 19:22
In fact what it's odd is when I use EXPLAIN, I don't see anywhere
DISTINCT
in the EXPLAIN result
] [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 14 April 2002 18:46
Subject: SV: How does DISTINCT really work ?
Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sendt: 14. april 2002 19:22
In fact what it's odd is when I use EXPLAIN, I don't see anywhere
]
Sent: Sunday, April 14, 2002 7:52 PM
Subject: Re: How does DISTINCT really work ?
Well done Carsten!
Which may bring us back to the relationships between the data/columns
being used to control the query.
Jocelyn: Did you try out my previous suggestions?
Please advise,
=dn
- Original
and latest news on InnoDB
- Original Message -
From: DL Neil [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, April 14, 2002 8:01 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I don't have a quick/sure answer for you, but am wondering about the
relationship
Hi!
- Original Message -
From: SDiZ (UHome) [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 15, 2002 7:51 AM
Subject: Re: How does DISTINCT really work ?
I think every thing are documented.
http://www.mysql.com/doc/B/u/Bugs.html
Hi,
I wonder how works DISTINCT when using it with the following join.
Ex :
mysql SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND
(mot='test') AND date = '2002-03-24' ORDER BY date DESC LIMIT
19 matches
Mail list logo