Jigal van Hemert wrote:
These are my results on MySQL 4.0.21 using InnoDB tables (it was suitable data for this test, InnoDB was used for other reasons):
rpm -qa | grep -i mysql MySQL-server-4.1.7-0 MySQL-devel-4.1.7-0 MySQL-client-4.1.7-0 MySQL-shared-compat-4.1.7-0 MySQL-Max-4.1.7-0
And it's a MyISAM table.
This works exactly as expected....
No matter how I performed your query, it always came back with more records than expected, almost like it's ignoring the LIMIT value. With my query it works fine. I wonder if it's a "feature" of the newer version.
--
H | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Imaging . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
