strange behavior when using distinct in 4.0.13
strange behavior when using distinct in 4.0.13
am 29.05.2003 21:18:52 von tibyke
hi!
i have the following table structure (for my postfix):
+-------------+--------------+------+-----+---------+------- +
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+------- +
| sender_hash | varchar(255) | | PRI | | |
| action | varchar(255) | | | | |
+-------------+--------------+------+-----+---------+------- +
in 4.0.12:
mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
+---------------------+-------------------+
| left(sender_hash,1) | sender_hash |
+---------------------+-------------------+
| . | .co.kr |
| 1 | 123greetings.info |
| a | acelink.info |
| b | borahome.net |
| b | boss.com |
+---------------------+-------------------+
5 rows in set (0.01 sec)
however in 4.0.13:
mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
+---------------------+-------------------+
| left(sender_hash,1) | sender_hash |
+---------------------+-------------------+
| | .co.kr |
| | 123greetings.info |
| | 330w.com |
| | aaa.net |
| | acelink.info |
+---------------------+-------------------+
5 rows in set (0.00 sec)
is it a bug, or a feature?
regards,
tibyke
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Re: strange behavior when using distinct in 4.0.13
am 29.05.2003 21:28:58 von Sinisa Milivojevic
tibyke writes:
> hi!
>
> i have the following table structure (for my postfix):
>
> +-------------+--------------+------+-----+---------+------- +
> | Field | Type | Null | Key | Default | Extra |
> +-------------+--------------+------+-----+---------+------- +
> | sender_hash | varchar(255) | | PRI | | |
> | action | varchar(255) | | | | |
> +-------------+--------------+------+-----+---------+------- +
>
> in 4.0.12:
>
> mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
> +---------------------+-------------------+
> | left(sender_hash,1) | sender_hash |
> +---------------------+-------------------+
> | . | .co.kr |
> | 1 | 123greetings.info |
> | a | acelink.info |
> | b | borahome.net |
> | b | boss.com |
> +---------------------+-------------------+
> 5 rows in set (0.01 sec)
>
> however in 4.0.13:
>
> mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
> +---------------------+-------------------+
> | left(sender_hash,1) | sender_hash |
> +---------------------+-------------------+
> | | .co.kr |
> | | 123greetings.info |
> | | 330w.com |
> | | aaa.net |
> | | acelink.info |
> +---------------------+-------------------+
> 5 rows in set (0.00 sec)
>
> is it a bug, or a feature?
>
> regards,
> tibyke
Looks definitely like a bug.
Can you uploade (tarred and gzipped) sender_hash table to:
ftp://support.mysql.com:/pub/mysql/secret
and let us know a filename.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Re: strange behavior when using distinct in 4.0.13
am 29.05.2003 21:32:53 von Jocelyn Fournier
Hi,
To reproduce it :
CREATE TABLE t1 (a varchar(255), b varchar(255), PRIMARY KEY(a));
INSERT INTO t1 VALUES ("test","test");
SELECT LEFT(1,a) FROM bug;
+-----------+
| LEFT(1,a) |
+-----------+
| |
+-----------+
1 row in set (0.00 sec)
Regards,
Jocelyn
----- Original Message -----
From: "Sinisa Milivojevic"
To:
Cc:
Sent: Thursday, May 29, 2003 9:28 PM
Subject: Re: strange behavior when using distinct in 4.0.13
> tibyke writes:
> > hi!
> >
> > i have the following table structure (for my postfix):
> >
> > +-------------+--------------+------+-----+---------+------- +
> > | Field | Type | Null | Key | Default | Extra |
> > +-------------+--------------+------+-----+---------+------- +
> > | sender_hash | varchar(255) | | PRI | | |
> > | action | varchar(255) | | | | |
> > +-------------+--------------+------+-----+---------+------- +
> >
> > in 4.0.12:
> >
> > mysql> select distinct left(sender_hash,1),sender_hash from sender_hash
limit 5;
> > +---------------------+-------------------+
> > | left(sender_hash,1) | sender_hash |
> > +---------------------+-------------------+
> > | . | .co.kr |
> > | 1 | 123greetings.info |
> > | a | acelink.info |
> > | b | borahome.net |
> > | b | boss.com |
> > +---------------------+-------------------+
> > 5 rows in set (0.01 sec)
> >
> > however in 4.0.13:
> >
> > mysql> select distinct left(sender_hash,1),sender_hash from sender_hash
limit 5;
> > +---------------------+-------------------+
> > | left(sender_hash,1) | sender_hash |
> > +---------------------+-------------------+
> > | | .co.kr |
> > | | 123greetings.info |
> > | | 330w.com |
> > | | aaa.net |
> > | | acelink.info |
> > +---------------------+-------------------+
> > 5 rows in set (0.00 sec)
> >
> > is it a bug, or a feature?
> >
> > regards,
> > tibyke
>
> Looks definitely like a bug.
>
>
> Can you uploade (tarred and gzipped) sender_hash table to:
>
> ftp://support.mysql.com:/pub/mysql/secret
>
> and let us know a filename.
>
>
> --
>
> Regards,
>
> --
> For technical support contracts, go to https://order.mysql.com/?ref=msmi
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=joc@presence-pc.com
>
>
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Re: strange behavior when using distinct in 4.0.13
am 29.05.2003 21:33:50 von Jocelyn Fournier
Oups of course the latest query is SELECT LEFT(1,a) FROM t1;
;)
----- Original Message -----
From: "Jocelyn Fournier"
To: ;
Cc:
Sent: Thursday, May 29, 2003 9:32 PM
Subject: Re: strange behavior when using distinct in 4.0.13
> Hi,
>
> To reproduce it :
>
> CREATE TABLE t1 (a varchar(255), b varchar(255), PRIMARY KEY(a));
> INSERT INTO t1 VALUES ("test","test");
> SELECT LEFT(1,a) FROM bug;
> +-----------+
> | LEFT(1,a) |
> +-----------+
> | |
> +-----------+
> 1 row in set (0.00 sec)
>
> Regards,
> Jocelyn
>
> ----- Original Message -----
> From: "Sinisa Milivojevic"
> To:
> Cc:
> Sent: Thursday, May 29, 2003 9:28 PM
> Subject: Re: strange behavior when using distinct in 4.0.13
>
>
> > tibyke writes:
> > > hi!
> > >
> > > i have the following table structure (for my postfix):
> > >
> > > +-------------+--------------+------+-----+---------+------- +
> > > | Field | Type | Null | Key | Default | Extra |
> > > +-------------+--------------+------+-----+---------+------- +
> > > | sender_hash | varchar(255) | | PRI | | |
> > > | action | varchar(255) | | | | |
> > > +-------------+--------------+------+-----+---------+------- +
> > >
> > > in 4.0.12:
> > >
> > > mysql> select distinct left(sender_hash,1),sender_hash from
sender_hash
> limit 5;
> > > +---------------------+-------------------+
> > > | left(sender_hash,1) | sender_hash |
> > > +---------------------+-------------------+
> > > | . | .co.kr |
> > > | 1 | 123greetings.info |
> > > | a | acelink.info |
> > > | b | borahome.net |
> > > | b | boss.com |
> > > +---------------------+-------------------+
> > > 5 rows in set (0.01 sec)
> > >
> > > however in 4.0.13:
> > >
> > > mysql> select distinct left(sender_hash,1),sender_hash from
sender_hash
> limit 5;
> > > +---------------------+-------------------+
> > > | left(sender_hash,1) | sender_hash |
> > > +---------------------+-------------------+
> > > | | .co.kr |
> > > | | 123greetings.info |
> > > | | 330w.com |
> > > | | aaa.net |
> > > | | acelink.info |
> > > +---------------------+-------------------+
> > > 5 rows in set (0.00 sec)
> > >
> > > is it a bug, or a feature?
> > >
> > > regards,
> > > tibyke
> >
> > Looks definitely like a bug.
> >
> >
> > Can you uploade (tarred and gzipped) sender_hash table to:
> >
> > ftp://support.mysql.com:/pub/mysql/secret
> >
> > and let us know a filename.
> >
> >
> > --
> >
> > Regards,
> >
> > --
> > For technical support contracts, go to https://order.mysql.com/?ref=msmi
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> > <___/ www.mysql.com
> >
> >
> > --
> > MySQL Bugs Mailing List
> > For list archives: http://lists.mysql.com/bugs
> > To unsubscribe: http://lists.mysql.com/bugs?unsub=joc@presence-pc.com
> >
> >
>
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Re: strange behavior when using distinct in 4.0.13
am 29.05.2003 21:46:29 von Sinisa Milivojevic
Jocelyn Fournier writes:
> Oups of course the latest query is SELECT LEFT(1,a) FROM t1;
>
> ;)
Thanks, we figured it out ourselves ... ;o)
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
Re: strange behavior when using distinct in 4.0.13
am 30.05.2003 17:52:42 von Sinisa Milivojevic
tibyke writes:
> hi!
>
> i have the following table structure (for my postfix):
>
> +-------------+--------------+------+-----+---------+------- +
> | Field | Type | Null | Key | Default | Extra |
> +-------------+--------------+------+-----+---------+------- +
> | sender_hash | varchar(255) | | PRI | | |
> | action | varchar(255) | | | | |
> +-------------+--------------+------+-----+---------+------- +
>
> in 4.0.12:
>
> mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
> +---------------------+-------------------+
> | left(sender_hash,1) | sender_hash |
> +---------------------+-------------------+
> | . | .co.kr |
> | 1 | 123greetings.info |
> | a | acelink.info |
> | b | borahome.net |
> | b | boss.com |
> +---------------------+-------------------+
> 5 rows in set (0.01 sec)
>
> however in 4.0.13:
>
> mysql> select distinct left(sender_hash,1),sender_hash from sender_hash limit 5;
> +---------------------+-------------------+
> | left(sender_hash,1) | sender_hash |
> +---------------------+-------------------+
> | | .co.kr |
> | | 123greetings.info |
> | | 330w.com |
> | | aaa.net |
> | | acelink.info |
> +---------------------+-------------------+
> 5 rows in set (0.00 sec)
>
> is it a bug, or a feature?
>
> regards,
> tibyke
Thank you for your contribution.
Your test case helped us fix a bug in 4.0.13.
A fix is already present in our source tree and will be available in
future versions of 4.0 and higher.
--
Regards,
--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org