diff options
| author | Hans-Christoph Steiner <hans@eds.org> | 2014-10-16 22:51:35 -0400 |
|---|---|---|
| committer | Hans-Christoph Steiner <hans@eds.org> | 2014-10-16 22:51:35 -0400 |
| commit | 569c6676a6ddb0ff73821d7693b5e18ddef809b9 (patch) | |
| tree | 833538da7bba39105daff45e265aef386a200acd /test/limit.test | |
| parent | 08119c361d1181b3e8f1abb429236e488a664753 (diff) | |
Imported Upstream version 3.2.0upstream
Diffstat (limited to 'test/limit.test')
| -rw-r--r-- | test/limit.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/test/limit.test b/test/limit.test index c5b75c2..5d6ef33 100644 --- a/test/limit.test +++ b/test/limit.test @@ -616,4 +616,24 @@ do_test limit-13.81 { db eval {SELECT z FROM v13c LIMIT 1 OFFSET 8} } {} +do_execsql_test limit-14.1 { + SELECT 123 LIMIT 1 OFFSET 0 +} {123} +do_execsql_test limit-14.2 { + SELECT 123 LIMIT 1 OFFSET 1 +} {} +do_execsql_test limit-14.3 { + SELECT 123 LIMIT 0 OFFSET 0 +} {} +do_execsql_test limit-14.4 { + SELECT 123 LIMIT 0 OFFSET 1 +} {} +do_execsql_test limit-14.6 { + SELECT 123 LIMIT -1 OFFSET 0 +} {123} +do_execsql_test limit-14.7 { + SELECT 123 LIMIT -1 OFFSET 1 +} {} + + finish_test |