Perhaps the time component of the date is different, hence you are getting back what looks like duplicate rows but they're not really?
- Max Martin Anderson QA Engineer ProfitLogic Eleven Cambridge Center Cambridge, MA 02142 t: 617.218.1946 -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 09, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: MySQL GROUP BY Anomaly? I have 2 tables with RecordDate in them, one has millions of records, one has hundreds of records. If I perform the following query on the table with hundreds; mysql> select RecordDate -> from tblInfo -> WHERE RecordDate BETWEEN '2002-03-04' AND '2002-03-06' -> GROUP BY RecordDate; I get three rows back in the result; +------------+ | RecordDate | +------------+ | 2002-03-04 | | 2002-03-05 | | 2002-03-06 | +------------+ but if I run this query against the table with millions of records I get (a small snippet of the results) | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-06 | | 2002-03-05 | | 2002-03-04 | +------------+ 34164 rows in set (17.78 sec) Can anyone enlighten me as to what is happening? Both tables are on the same machine, but the one with millions of records is a MERGE table. If I run the query against the individual tables in the merge, they return the proper (3 row) result. Thanks! Jay --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php