From 019463d05070f2945f84a4bf57bd37e613c58cd7 Mon Sep 17 00:00:00 2001
From: Alon Zakai <alonzakai@gmail.com>
Date: Sun, 22 Apr 2012 15:43:06 -0700
Subject: improve sqlite test

---
 tests/sqlite/benchmark.c   | 1 +
 tests/sqlite/benchmark.txt | 2 ++
 2 files changed, 3 insertions(+)

(limited to 'tests/sqlite')

diff --git a/tests/sqlite/benchmark.c b/tests/sqlite/benchmark.c
index c1385525..802abab1 100644
--- a/tests/sqlite/benchmark.c
+++ b/tests/sqlite/benchmark.c
@@ -21,6 +21,7 @@ int test(){
     "INSERT INTO t2 VALUES(1,13153,'thirteen thousand one hundred fifty three');",
     "INSERT INTO t2 VALUES(1,987,'some other number');",
     "SELECT count(*) FROM t2;",
+    "SELECT datetime('2012-04-16 12:35:57', '+1 days');",
     "SELECT a, b, c FROM t2;",
     NULL
   };
diff --git a/tests/sqlite/benchmark.txt b/tests/sqlite/benchmark.txt
index 472221df..622493b3 100644
--- a/tests/sqlite/benchmark.txt
+++ b/tests/sqlite/benchmark.txt
@@ -1,5 +1,7 @@
 count(*) = 2
 
+datetime('2012-04-16 12:35:57', '+1 days') = 2012-04-17 12:35:57
+
 a = 1
 b = 13153
 c = thirteen thousand one hundred fifty three
-- 
cgit v1.2.3-18-g5258