diff options
| author | Alon Zakai <alonzakai@gmail.com> | 2012-04-22 15:43:06 -0700 |
|---|---|---|
| committer | Alon Zakai <alonzakai@gmail.com> | 2012-04-22 15:43:06 -0700 |
| commit | 019463d05070f2945f84a4bf57bd37e613c58cd7 (patch) | |
| tree | 65fa7b6d07db1fc637cc67f8319ac466a5bb9941 /tests/sqlite | |
| parent | b20dc266245d3d7882ba01fccc7c823ee113a9f3 (diff) | |
improve sqlite test
Diffstat (limited to 'tests/sqlite')
| -rw-r--r-- | tests/sqlite/benchmark.c | 1 | ||||
| -rw-r--r-- | tests/sqlite/benchmark.txt | 2 |
2 files changed, 3 insertions, 0 deletions
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 |