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
<[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
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
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
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
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
"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
<[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" &
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
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
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.
&
ier Jocelyn [Presence-PC]" <[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.
ce-PC]" <[EMAIL PROTECTED]>; "DL Neil"
<[EMAIL PROTECTED]>; <[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
> 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:
http:/
---+
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
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]>
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
> >
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
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 0,2
19 matches
Mail list logo
