improve sqlite test

3 files changed, 4 insertions, 1 deletions

diff --git a/tests/runner.py b/tests/runner.py
index 8245b8b1..0f8c1b94 100755
--- a/tests/runner.py
+++ b/tests/runner.py
@@ -4942,7 +4942,7 @@ def process(filename):
       self.do_run(r'''
                         #define SQLITE_DISABLE_LFS
                         #define LONGDOUBLE_TYPE double
-                        #define SQLITE_INT64_TYPE int
+                        #define SQLITE_INT64_TYPE long long int
                         #define SQLITE_THREADSAFE 0
                    ''' + open(path_from_root('tests', 'sqlite', 'sqlite3.c'), 'r').read() +
                          open(path_from_root('tests', 'sqlite', 'benchmark.c'), 'r').read(),
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