Re: opendkim-2.5.0.Beta4 & sqlite3

From: Andreas Schulze <sca_at_andreasschulze.de>
Date: Sun, 27 Nov 2011 00:11:11 +0100

Am 26.11.2011 16:13 schrieb Andreas Schulze:
> Now I have to modify opendkim-genrates...

I modified opendkim-genrates to use sqlite3 and print the query.
The query fail in two ways:

1. Debian lenny, old sqlite3:
# sqlite3 opendkim
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> SELECT COUNT(*) AS domains, MIN(l) AS 'min duration', MAX(l) AS 'max duration', AVG(l) AS 'mean duration', STDDEV_POP(l) AS 'duration stddev' FROM (SELECT COUNT(*) AS c, SUM(messages.spam)/COUNT(*) AS r, DATEDIFF(MAX(messages.msgtime), MIN(messages.msgtime)) AS l FROM signatures JOIN messages ON signatures.message = messages.id WHERE messages.id >= 5855122 AND NOT spam = -1 AND pass = 1 GROUP BY signatures.domain) t1 WHERE r >= 0.75 AND c >= 2;
SQL error: no such function: DATEDIFF
sqlite>

2. Debian squeeze, newer sqlite
# SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT COUNT(*) AS domains, MIN(l) AS 'min duration', MAX(l) AS 'max duration', AVG(l) AS 'mean duration', STDDEV_POP(l) AS 'duration stddev' FROM (SELECT COUNT(*) AS c, SUM(messages.spam)/COUNT(*) AS r, DATEDIFF(MAX(messages.msgtime), MIN(messages.msgtime)) AS l FROM signatures JOIN messages ON signatures.message = messages.id WHERE messages.id >= 5855122 AND NOT spam = -1 AND pass = 1 GROUP BY signatures.domain) t1 WHERE r >= 0.75 AND c >= 2;
Error: no such function: STDDEV_POP
sqlite>

Hm...

-- 
########################################################################
#
# Andreas Schulze
# https://andreasschulze.de
#
# GnuPG Key-ID: A7DBA67F, https://andreasschulze.de/sca.asc
# GnuPG Fingerprint: 14C1 39A8 CE6D 6BE0 28C6 5652 03B5 6793 A7DB A67F
#
# $Id: .signature,v 1.3 2007-12-27 21:13:36 sca Exp $
########################################################################
Received on Sat Nov 26 2011 - 23:10:50 PST

This archive was generated by hypermail 2.3.0 : Mon Oct 29 2012 - 23:33:13 PST