From: Daevid Vincent
Date: January 13 2003 3:37am
Subject: RE: unexpected: 260 rows in set on a TINYINT
List-Archive: http://lists.mysql.com/mysql/129707
Message-Id: <008401c2bab5$264c3290$0801a8c0@telecom>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Also, don't confuse the RANGE of values that the atomtype can be (0-255)
if set to be UNSIGNED with the NUMBER OF ROWS in your output. The
TINYINT is working. You have no values greater than 255 in there. You
just have duplicates which gives you more rows than you were expecting I
think. ;-)

> -----Original Message-----
> From: Horizon [mailto:horizonx@stripped] 
> Sent: Saturday, January 11, 2003 7:46 PM
> To: Mysql List
> Subject: unexpected: 260 rows in set on a TINYINT
> 
> 
> +----------+
> | atomtype |
> +----------+
> |        0 |
> |        1 |
> |        2 |
>    snip
> |      253 |
> |      254 |
> |      255 |
> +----------+
> 260 rows in set (6 min 53.71 sec)