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.
&
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
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
---+
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
17 matches
Mail list logo