[Greylist-users] Another MySQL 3.23 non-feature?

[Blair Zajac]

I'm getting this now when trying to run from CVS head:

mysql -u root -p < mysql.sql

Enter password:
ERROR 1064 at line 99: You have an error in your SQL syntax near
'((UNIX_TIMESTAMP( last_update ) - UNIX_TIMESTAMP( create_time )) / 300,
unsigned' at line 1

Line 99 is

select convert((UNIX_TIMESTAMP( last_update ) - UNIX_TIMESTAMP( create_time )) /
 300, unsigned) as foo, count(*) from relaytofrom
where record_expires < NOW() and blocked_count > 0 and passed_count = 0 and
aborted_count = 0 and last_update > 0 group by foo
order by foo;

Best,
Blair

-- 
Blair Zajac <blair at orcaware.com>
Plots of your system's performance - http://www.orcaware.com/orca/