diff options
Diffstat (limited to 'test/tabfunc01.test')
-rw-r--r-- | test/tabfunc01.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/test/tabfunc01.test b/test/tabfunc01.test index f65795844..7393238b9 100644 --- a/test/tabfunc01.test +++ b/test/tabfunc01.test @@ -32,5 +32,24 @@ do_execsql_test tabfunc01-1.2 { do_catchsql_test tabfunc01-1.3 { CREATE VIRTUAL TABLE t1 USING generate_series; } {1 {no such module: generate_series}} +do_execsql_test tabfunc01-1.4 { + SELECT * FROM generate_series(1,9,2); +} {1 3 5 7 9} +do_execsql_test tabfunc01-1.5 { + SELECT * FROM generate_series(1,9); +} {1 2 3 4 5 6 7 8 9} +do_execsql_test tabfunc01-1.6 { + SELECT * FROM generate_series(1,10) WHERE step=3; +} {1 4 7 10} +do_catchsql_test tabfunc01-1.7 { + SELECT * FROM generate_series(1,9,2,11); +} {1 {too many arguments on generate_series - max 3}} + +do_execsql_test tabfunc01-2.1 { + CREATE TABLE t1(x); + INSERT INTO t1(x) VALUES(2),(3); + SELECT *, '|' FROM t1, generate_series(1,x) ORDER BY 1, 2 + +} {2 1 | 2 2 | 3 1 | 3 2 | 3 3 |} finish_test |