aboutsummaryrefslogtreecommitdiff
path: root/test/tabfunc01.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/tabfunc01.test')
-rw-r--r--test/tabfunc01.test19
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