Handle calculating stats for empty table

2 files changed, 13 insertions, 3 deletions

diff --git a/sql/sql.go b/sql/sql.go
index 0ac86fa..74857ac 100644
--- a/sql/sql.go
+++ b/sql/sql.go
@@ -245,7 +245,7 @@ func (c *Client) readLogStats() (logStats, error) {
 	var stats logStats
 	q1 := `SELECT COUNT(*) as total,
                       COUNT(CASE hijacked WHEN 1 THEN 1 ELSE NULL END) as hijacked,
-                      time AS since
+                      IFNULL(time, 0) AS since
                FROM log
                ORDER BY time ASC LIMIT 1`
 	if err := c.db.Get(&stats, q1); err != nil {
diff --git a/sql/sql_test.go b/sql/sql_test.go
index 5c03c2d..6843d3d 100644
--- a/sql/sql_test.go
+++ b/sql/sql_test.go
@@ -185,12 +185,22 @@ func TestInterleavedRW(t *testing.T) {
 
 func TestReadLogStats(t *testing.T) {
 	c := testClient()
-	writeTests(c, t)
+
 	got, err := c.readLogStats()
 	if err != nil {
 		t.Fatal(err)
 	}
-	want := logStats{
+	want := logStats{}
+	if !reflect.DeepEqual(got, want) {
+		t.Errorf("readLogStats() = (%+v, _), want (%+v, _)", got, want)
+	}
+
+	writeTests(c, t)
+	got, err = c.readLogStats()
+	if err != nil {
+		t.Fatal(err)
+	}
+	want = logStats{
 		Since:    1560636910,
 		Hijacked: 1,
 		Total:    8,