List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:January 15 2003 9:02am
Subject:RE: unexpected: 260 rows in set on a TINYINT
View as plain text  
You know what? You are correct on both accounts. I completely overlooked
what you had written as your SQL query and am a blind moron ;-)

Yeah, I dunno why you got whacky results then. It is true the TINYINT is
still in it's range, so that part is working, so the issue is that the
DISTINCT and/or the ORDER BY is not working.

Out of curiousity, did you try it like gentradedb.gpatomdb instead of
`gentradedb`.`gpatomdb`

Mebbe the ` are confusing mySQL?

> -----Original Message-----
> From: Horizon [mailto:horizonx@stripped] 
> Sent: Monday, January 13, 2003 3:48 AM
> To: Daevid Vincent
> Cc: Mysql List
> Subject: RE: unexpected: 260 rows in set on a TINYINT
> 
> 
> > I would suggest appending an "ORDER BY atomtype" first of all.
> 
> That's what I did, see original select statement:
> 
> mysql> select distinct atomtype from `gentradedb`.`gpatomdb` order by
> atomtype;
> 
> > You could also experiment with SELECT DISTINCT to remove 
> any dupes from
> > your output.
> 
> Experiment how?
> 
> > 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. ;-)
> 
> I don't think I do, the database has several millions rows.
> 
> Thanks for pointing out the dups, isn't what select distinct 
> is meant to do?
> 
> Terry
> 
> ---------
> 
> >
> > I would suggest appending an "ORDER BY atomtype" first of all.
> >
> > I say this because if you scan your results, you have duplicates...
> >
> > |      165 |
> > |      166 |
> > |      167 |  <---
> > |      168 |
> > |      169 |
> > |      170 |
> > |      171 |
> > |      172 |
> > |      173 |
> > |      174 |
> > |      175 |
> > |      167 |  <---
> > |      175 |
> >
> > So you prolly have other in there too.
> >
> > You could also experiment with SELECT DISTINCT to remove 
> any dupes from
> > your output.
> >
> > DÆVID.
> >
> > > -----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
> > >
> > >
> > > mysql> select distinct atomtype from 
> `gentradedb`.`gpatomdb`  order by
> > > atomtype;
> > >
> > > +----------+
> > > | atomtype |
> > > +----------+
> > > |        0 |
> > > |        1 |
> > > |        2 |
> > > |        3 |
> > > |        4 |
> > > |        5 |
> > > |        6 |
> > > |        7 |
> > > |        8 |
> > > |        9 |
> > > |       10 |
> > > |       11 |
> > > |       12 |
> > > |       13 |
> > > |       14 |
> > > |       15 |
> > > |       16 |
> > > |       17 |
> > > |       18 |
> > > |       19 |
> > > |       20 |
> > > |       21 |
> > > |       22 |
> > > |       23 |
> > > |       24 |
> > > |       25 |
> > > |       26 |
> > > |       27 |
> > > |       28 |
> > > |       29 |
> > > |       30 |
> > > |       31 |
> > > |       32 |
> > > |       33 |
> > > |       34 |
> > > |       35 |
> > > |       36 |
> > > |       37 |
> > > |       38 |
> > > |       39 |
> > > |       40 |
> > > |       41 |
> > > |       42 |
> > > |       43 |
> > > |       44 |
> > > |       45 |
> > > |       46 |
> > > |       47 |
> > > |       48 |
> > > |       49 |
> > > |       50 |
> > > |       51 |
> > > |       52 |
> > > |       53 |
> > > |       54 |
> > > |       55 |
> > > |       56 |
> > > |       57 |
> > > |       58 |
> > > |       59 |
> > > |       60 |
> > > |       61 |
> > > |       62 |
> > > |       63 |
> > > |       64 |
> > > |       65 |
> > > |       66 |
> > > |       67 |
> > > |       68 |
> > > |       69 |
> > > |       70 |
> > > |       71 |
> > > |       72 |
> > > |       73 |
> > > |       74 |
> > > |       75 |
> > > |       76 |
> > > |       77 |
> > > |       78 |
> > > |       79 |
> > > |       80 |
> > > |       81 |
> > > |       82 |
> > > |       83 |
> > > |       84 |
> > > |       85 |
> > > |       86 |
> > > |       87 |
> > > |       88 |
> > > |       89 |
> > > |       90 |
> > > |       91 |
> > > |       92 |
> > > |       93 |
> > > |       94 |
> > > |       95 |
> > > |       96 |
> > > |       97 |
> > > |       98 |
> > > |       99 |
> > > |      100 |
> > > |      101 |
> > > |      102 |
> > > |      103 |
> > > |      104 |
> > > |      105 |
> > > |      106 |
> > > |      107 |
> > > |      108 |
> > > |      109 |
> > > |      110 |
> > > |      111 |
> > > |      112 |
> > > |      113 |
> > > |      114 |
> > > |      115 |
> > > |      116 |
> > > |      117 |
> > > |      118 |
> > > |      119 |
> > > |      120 |
> > > |      121 |
> > > |      122 |
> > > |      123 |
> > > |      124 |
> > > |      125 |
> > > |      126 |
> > > |      127 |
> > > |      128 |
> > > |      129 |
> > > |      130 |
> > > |      131 |
> > > |      132 |
> > > |      133 |
> > > |      134 |
> > > |      135 |
> > > |      136 |
> > > |      137 |
> > > |      138 |
> > > |      139 |
> > > |      140 |
> > > |      141 |
> > > |      142 |
> > > |      143 |
> > > |      144 |
> > > |      145 |
> > > |      146 |
> > > |      147 |
> > > |      148 |
> > > |      149 |
> > > |      150 |
> > > |      151 |
> > > |      152 |
> > > |      153 |
> > > |      154 |
> > > |      155 |
> > > |      156 |
> > > |      157 |
> > > |      158 |
> > > |      159 |
> > > |      160 |
> > > |      161 |
> > > |      162 |
> > > |      163 |
> > > |      164 |
> > > |      165 |
> > > |      166 |
> > > |      167 |
> > > |      168 |
> > > |      169 |
> > > |      170 |
> > > |      171 |
> > > |      172 |
> > > |      173 |
> > > |      174 |
> > > |      175 |
> > > |      167 |
> > > |      175 |
> > > |      176 |
> > > |      177 |
> > > |      178 |
> > > |      179 |
> > > |      180 |
> > > |      181 |
> > > |      182 |
> > > |      183 |
> > > |      184 |
> > > |      185 |
> > > |      186 |
> > > |      187 |
> > > |      188 |
> > > |      189 |
> > > |      190 |
> > > |      191 |
> > > |      192 |
> > > |      193 |
> > > |      194 |
> > > |      195 |
> > > |      196 |
> > > |      197 |
> > > |      198 |
> > > |      199 |
> > > |      200 |
> > > |      201 |
> > > |      202 |
> > > |      203 |
> > > |      204 |
> > > |      205 |
> > > |      206 |
> > > |      207 |
> > > |      208 |
> > > |      209 |
> > > |      210 |
> > > |      211 |
> > > |      212 |
> > > |      213 |
> > > |      214 |
> > > |      215 |
> > > |      216 |
> > > |      217 |
> > > |      218 |
> > > |      219 |
> > > |      220 |
> > > |      221 |
> > > |      222 |
> > > |      214 |
> > > |      222 |
> > > |      223 |
> > > |      224 |
> > > |      225 |
> > > |      226 |
> > > |      227 |
> > > |      228 |
> > > |      229 |
> > > |      230 |
> > > |      231 |
> > > |      232 |
> > > |      233 |
> > > |      234 |
> > > |      235 |
> > > |      236 |
> > > |      237 |
> > > |      238 |
> > > |      239 |
> > > |      240 |
> > > |      241 |
> > > |      242 |
> > > |      243 |
> > > |      244 |
> > > |      245 |
> > > |      246 |
> > > |      247 |
> > > |      248 |
> > > |      249 |
> > > |      250 |
> > > |      251 |
> > > |      252 |
> > > |      253 |
> > > |      254 |
> > > |      255 |
> > > +----------+
> > > 260 rows in set (6 min 53.71 sec)
> > >
> > >
> > >
> > > 
> ---------------------------------------------------------------------
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail 
> <mysql-thread129675@stripped>
> > > To unsubscribe, e-mail
> > > <mysql-unsubscribe-daevid=daevid.com@stripped>
> > > Trouble unsubscribing? Try: 
> http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> 
> 

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