Re: How does DISTINCT really work ?

2002-04-27 Thread Michael Widenius
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 o

Re: How does DISTINCT really work ?

2002-04-26 Thread Fournier Jocelyn [Presence-PC]
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[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

Re: How does DISTINCT really work ?

2002-04-26 Thread Sinisa Milivojevic
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 > <(1

Re: How does DISTINCT really work ?

2002-04-15 Thread Sinisa Milivojevic
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 > <(1

Re: How does DISTINCT really work ?

2002-04-15 Thread Michael Widenius
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 jo

Re: How does DISTINCT really work ?

2002-04-15 Thread Fournier Jocelyn [Presence-PC]
ROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL 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 probl

Re: How does DISTINCT really work ?

2002-04-15 Thread Fournier Jocelyn [Presence-PC]
"Heikki Tuuri" <[EMAIL PROTECTED]> 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

Re: How does DISTINCT really work ?

2002-04-15 Thread Heikki Tuuri
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" &

Re: How does DISTINCT really work ?

2002-04-14 Thread Heikki Tuuri
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 doc

Re: How does DISTINCT really work ?

2002-04-14 Thread Heikki Tuuri
manual 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 qui

Re: How does DISTINCT really work ?

2002-04-14 Thread Fournier Jocelyn [Presence-PC]
urnier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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. &

Re: How does DISTINCT really work ?

2002-04-14 Thread DL Neil
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 Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Fournier Jocelyn [Presence-P

Re: How does DISTINCT really work ?

2002-04-14 Thread Fournier Jocelyn [Presence-PC]
Yes but when it's written "DISTINCT is converted to a GROUP BY on all columns", which columns are included in "all columns" ? :) Thanks, Jocelyn - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; "DL Neil" <[EMAIL P

Re: How does DISTINCT really work ?

2002-04-14 Thread Fournier Jocelyn [Presence-PC]
---+ 2 rows in set (0.00 sec) Jocelyn - Original 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 re

Re: How does DISTINCT really work ?

2002-04-14 Thread DL Neil
first query > with DISTINCT ? (perhaps a bug ?) > > Regards, > > Jocelyn Fournier > > - Original Message - > From: "DL Neil" <[EMAIL PROTECTED]> > To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]>

Re: How does DISTINCT really work ?

2002-04-14 Thread Fournier Jocelyn [Presence-PC]
TED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 14, 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 > >

Re: How does DISTINCT really work ?

2002-04-14 Thread DL Neil
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 B