On 21/08/10 5:24 AM, A J Stiles wrote: > Can anyone else with a similar setup try running a query such as > SELECT COUNT(*) FROM cdr WHERE calldate LIKE "2010-08-20%" AND > billsec>duration ; > and seeing if they have any calls like this?
Nothing on this box (1.4) mysql> SELECT COUNT(*) FROM cdr WHERE billsec>duration; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.31 sec) mysql> SELECT COUNT(*) FROM cdr; +----------+ | COUNT(*) | +----------+ | 190052 | +----------+ 1 row in set (0.00 sec) -- Cheers, Matt Riddell _______________________________________________ http://www.venturevoip.com/news.php (Daily Asterisk News) http://www.venturevoip.com/exchange.php (Full ITSP Solution) http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer) -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
