question about pkg

[Waitman Gobble]

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 at 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 at 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