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
-- Description / How-To-Repeat
-- 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|
-- ++-+
-- | 4 | general |
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
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|
--