List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:January 13 2003 3:37am
Subject:RE: unexpected: 260 rows in set on a TINYINT
View as plain text  
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)

Thread
unexpected: 260 rows in set on a TINYINTHorizon12 Jan
  • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent13 Jan
    • RE: unexpected: 260 rows in set on a TINYINTHorizon13 Jan
      • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent15 Jan
  • RE: unexpected: 260 rows in set on a TINYINTDaevid Vincent13 Jan