Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 4 Sep 2013 06:46:01 +0000
From:      Waitman Gobble <gobble.wa@gmail.com>
To:        "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject:   question about pkg
Message-ID:  <CAFuo_fwLczu1bwWWpfucbEsSejqM30qGv72vSwcs7KezTXb7Eg@mail.gmail.com>

Next in thread | Raw E-Mail | Index | Archive | Help
Hi,

by chance anyone know what's up with this.. could save me some
troubleshooting time..



Here's a 9.2 machine.

# uname -a
FreeBSD do.burplex.com 9.2-BETA2 FreeBSD 9.2-BETA2 #0 r253773M: Mon Jul 29
14:22:34 PDT 2013     da3m0n8t3r@do.burplex.com:/usr/obj/usr/src/sys/KAGISO
 amd64

# sqlite3 /var/db/pkg/local.sqlite

sqlite> SELECT COUNT(id) FROM packages WHERE time is null;
0
sqlite> SELECT COUNT(id) FROM packages WHERE time is not null;
551



Here's a 10.0-CURRENT machine.

> uname -a
FreeBSD dx.burplex.com 10.0-CURRENT FreeBSD 10.0-CURRENT #0 r252355: Fri
Jun 28 16:39:19 PDT 2013     root@dx.burplex.com:/usr/obj/usr/src/sys/FURAHA
 amd64

# sqlite3 /var/db/pkg/local.sqlite

sqlite> SELECT COUNT(id) FROM packages WHERE time is null;
814
sqlite> SELECT COUNT(id) FROM packages WHERE time is NOT null;
104



time = null is causing me some issues..

Thanks

-- 
Waitman Gobble
San Jose California USA
510-830-7975



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?CAFuo_fwLczu1bwWWpfucbEsSejqM30qGv72vSwcs7KezTXb7Eg>