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 da3m0n8...@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 r...@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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
