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
> > >
> >
>
>
