From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id 32B786DE01EF for ; Mon, 29 Jan 2018 07:47:12 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at cworth.org X-Spam-Flag: NO X-Spam-Score: -0.718 X-Spam-Level: X-Spam-Status: No, score=-0.718 tagged_above=-999 required=5 tests=[AWL=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01] autolearn=disabled Received: from arlo.cworth.org ([127.0.0.1]) by localhost (arlo.cworth.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VHj2hxg0TrFj for ; Mon, 29 Jan 2018 07:47:11 -0800 (PST) X-Greylist: delayed 452 seconds by postgrey-1.36 at arlo; Mon, 29 Jan 2018 07:47:10 PST Received: from avasout05.plus.net (avasout05.plus.net [84.93.230.250]) by arlo.cworth.org (Postfix) with ESMTPS id A6F626DE01EC for ; Mon, 29 Jan 2018 07:47:10 -0800 (PST) Received: from mail.bubblegen.co.uk ([80.229.236.194]) by smtp with ESMTP id gBWueJ4Ndk2ZUgBWwe5Und; Mon, 29 Jan 2018 15:39:34 +0000 X-CM-Score: 0.00 X-CNFS-Analysis: v=2.3 cv=dv/19Wo4 c=1 sm=1 tr=0 a=G4bc5lkgapKKm1P+Twxy3Q==:117 a=G4bc5lkgapKKm1P+Twxy3Q==:17 a=RgaUWeydRksA:10 a=AxXxtNlTzlvurJA6AtcA:9 a=Hj4S1aMhTnI8TfWw:21 a=0WhlvSw7az2zTAcJ:21 a=QEXdDO2ut3YA:10 a=3rPs_wqhRAmsuBNV3GMA:9 a=WNkRixq_MzN3LTNz:21 Received: from mail-lf0-f47.google.com (mail-lf0-f47.google.com [209.85.215.47]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: matt) by mail.bubblegen.co.uk (Postfix) with ESMTPSA id AA3D44622016 for ; Mon, 29 Jan 2018 15:39:32 +0000 (GMT) Received: by mail-lf0-f47.google.com with SMTP id q194so10598123lfe.13 for ; Mon, 29 Jan 2018 07:39:32 -0800 (PST) X-Gm-Message-State: AKwxytem2a3+o8XnaJEx3MxVWLliODJYdIwKu6by89X89cQ8GYV90f0l y2EUYD6hYn4t/+miVrICBemHBO9Tz8zET/1fX5s= X-Google-Smtp-Source: AH8x224sPz0TlUGx1ukT1DOoHL1AEA1gsca7Yg3g0FwenEp/wqWaSJ/l9A6FS4kf4za7m9EEJfsfwowqhn7Qr3oTEM4= X-Received: by 10.46.68.93 with SMTP id r90mr6088308lja.13.1517240371648; Mon, 29 Jan 2018 07:39:31 -0800 (PST) MIME-Version: 1.0 Received: by 10.25.223.85 with HTTP; Mon, 29 Jan 2018 07:39:31 -0800 (PST) From: Matthew Lear Date: Mon, 29 Jan 2018 15:39:31 +0000 X-Gmail-Original-Message-ID: Message-ID: Subject: trouble searching with unix timestamps To: notmuch@notmuchmail.org Content-Type: multipart/alternative; boundary="94eb2c1a68286434e80563ec0db2" X-CMAE-Envelope: MS4wfNVcwzV/qXE2EhPmyNGViGFo4Usmr/Uou6b12avfewPXqdGt/Apb5nB/aYhy1X4oTF7MP4btw3CbvmTrHWN2H54Cp4N93qM9VfK0yUj8ZZTNNDFjuMdB Ftdd0F2QqX9gmxqkwwmnwIBM1vivuRK3p5oCBPl68zukO7eWWRn/aTFFZhRmnFd63qEWq3/X1Laj7g== X-BeenThere: notmuch@notmuchmail.org X-Mailman-Version: 2.1.24 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 29 Jan 2018 15:47:12 -0000 --94eb2c1a68286434e80563ec0db2 Content-Type: text/plain; charset="UTF-8" Hi. I've noticed that I'm unable to notmuch search using date with unix timestamps (ie number of seconds since Jan 1st 1970 UTC). I get a xapian error. The notmuch man pages state that searching using 'date:..' where "each timestamp is a number representing the number of seconds since 1970-01-01 00:00:00 UTC" is supported, so I'm wondering what's wrong with my installation. * notmuch config get built_with.field_processor true * xapian-config - xapian-core 1.4.4 * notmuch 0.26+8~ga727e7d Here's an example: # date +%s 1517238733 # date -d @1517238733 Mon Jan 29 15:12:13 GMT 2018 # date -d @1517152333 Sun Jan 28 15:12:13 GMT 2018 # notmuch search date:1517152333..1517238733 notmuch search: A Xapian exception occurred A Xapian exception occurred parsing query: Didn't understand date specification '1517152333..1517238733' Query string was: date:1517152333..1517238733 Yet I can do: # notmuch search date:yesterday..today or # notmuch search date:1/28/2018..1/29/2018 or # notmuch search date:20180128..20180129 ..and all show 216 results. Any thoughts as to why Xapian doesn't like this type of query? Is it just me? :-) Thanks, -- Matt --94eb2c1a68286434e80563ec0db2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi. I've noticed that I'm unable to notmuch search= using date with unix timestamps (ie number of seconds since Jan 1st 1970 U= TC). I get a xapian error. The notmuch man pages state that searching using= 'date:<initial-timestamp>..<final-t= imestamp>' where "each timestamp is a= number representing the number of seconds since 1970-01-01 00:00:00 UTC&qu= ot; is supported, so I'm wondering what's wrong with my installatio= n.

* notmuch config get built_wi= th.field_processor
true
* xapian-config - xapian-= core 1.4.4
* notmuch 0.26+8~ga727e7d

Here's an example:

# date +%s
1= 517238733

# date -d @1517238733
Mon Jan 29 15:12:13 GMT 2018

# date -d @1517152= 333
Sun Jan 28 15:12:13 GMT 2018


# notmuch search date:1517152333..1517238733
notmuch search: A Xapian exception occurred
A Xapian exception= occurred parsing query: Didn't understand date specification '1517= 152333..1517238733'
Query string was: date:1517152333..151723= 8733

Yet I can do:

=
# notmuch search date:yesterday..today
or
# notmuch search date:1/28/2018..1/29/2018
or
#=C2=A0notmuch search date:20180128..20180129

..and all show 216 results.

= Any thoughts as to why Xapian doesn't like this type of query? Is it ju= st me? :-)

Thanks,
--=C2=A0 Matt
--94eb2c1a68286434e80563ec0db2--