Hi, not sure if this is a known issue (ver 3.23.43 lists a fix called: "Fixed unlikely bug, which returned non-matching rows, in SELECT with many tables and multi-column indexes and 'range' type.") Anyways, when I do a query like: SELECT sum(minutes) FROM stats_2001 WHERE sdate between 'Oct 29' and 'Oct 29'; I get the correct value (325.81 in this case) BUT when I do: SELECT sum(minutes) FROM `stats_2001` WHERE sdate between 'Oct 29' and 'Oct 30'; I get value: 5605.66 which is impossible - there are no rows with column sdate='Oct 30' (a cron job creates blank rows at midnight, and Oct 30 is "tomorrow" i.e. has not been created yet. (running: SELECT sum(minutes) FROM `stats_2001` WHERE sdate between 'Oct 30' and 'Oct 30'; yields the correct result, i.e. no result as there are no such rows.) Is this the known issue fixed in 3.23.43? Thanks, Sebastian running 3.23.41 on linux redhat 6.1 intel. --------------------------------------------------------------------- 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
