RE: Disorder result with ORDER BY with ENUM, INT

2003-11-26 Thread TheMechE
I'm using mySQL 4.0.14 Linux and the mySql CC 0.8.9 Beta. I ran your script and I'm clear. So its version specific. -Original Message- From: Kriengkrai J. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 2:05 AM To: [EMAIL PROTECTED] Subject: Disorder result with ORDER BY wi

Re: Disorder result with ORDER BY with ENUM, INT

2003-11-26 Thread Chuck Gadd
Kriengkrai J. wrote: > -- System: MySQL 4.0.13, 4.0.16 on Linux x86 > -- Table type: MyISAM, InnoDB > -- Description / How-To-Repeat: > -- 1. When I use > -- SELECT id, type FROM test.report ORDER BY type, id; > -- the result is in wrong order > -- -- > -- ++-+ > -- | id | type| >

Re: Disorder result with ORDER BY with ENUM, INT

2003-11-27 Thread Matt W
Hi, - Original Message - From: "Chuck Gadd" Sent: Wednesday, November 26, 2003 2:29 PM Subject: Re: Disorder result with ORDER BY with ENUM, INT > Kriengkrai J. wrote: > > > -- System: MySQL 4.0.13, 4.0.16 on Linux x86 > > -- Table type: MyISAM, InnoDB