Index: third_party/sqlite/sqlite-src-3100200/test/tabfunc01.test |
diff --git a/third_party/sqlite/sqlite-src-3100200/test/tabfunc01.test b/third_party/sqlite/sqlite-src-3100200/test/tabfunc01.test |
deleted file mode 100644 |
index d85cb20ff550ed98082de06e611e760ec21b709a..0000000000000000000000000000000000000000 |
--- a/third_party/sqlite/sqlite-src-3100200/test/tabfunc01.test |
+++ /dev/null |
@@ -1,123 +0,0 @@ |
-# 2015-08-19 |
-# |
-# The author disclaims copyright to this source code. In place of |
-# a legal notice, here is a blessing: |
-# |
-# May you do good and not evil. |
-# May you find forgiveness for yourself and forgive others. |
-# May you share freely, never taking more than you give. |
-# |
-#*********************************************************************** |
-# |
-# This file implements tests for table-valued-functions implemented using |
-# eponymous virtual tables. |
-# |
- |
-set testdir [file dirname $argv0] |
-source $testdir/tester.tcl |
-set testprefix tabfunc01 |
- |
-ifcapable !vtab { |
- finish_test |
- return |
-} |
-load_static_extension db series |
- |
-do_execsql_test tabfunc01-1.1 { |
- SELECT *, '|' FROM generate_series WHERE start=1 AND stop=9 AND step=2; |
-} {1 | 3 | 5 | 7 | 9 |} |
-do_execsql_test tabfunc01-1.2 { |
- SELECT *, '|' FROM generate_series LIMIT 5; |
-} {0 | 1 | 2 | 3 | 4 |} |
-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-1.8 { |
- SELECT * FROM generate_series(0,32,5) ORDER BY rowid DESC; |
-} {30 25 20 15 10 5 0} |
-do_execsql_test tabfunc01-1.9 { |
- SELECT rowid, * FROM generate_series(0,32,5) ORDER BY value DESC; |
-} {1 30 2 25 3 20 4 15 5 10 6 5 7 0} |
-do_execsql_test tabfunc01-1.10 { |
- SELECT rowid, * FROM generate_series(0,32,5) ORDER BY +value DESC; |
-} {7 30 6 25 5 20 4 15 3 10 2 5 1 0} |
- |
-do_execsql_test tabfunc01-1.20 { |
- CREATE VIEW v1(a,b) AS VALUES(1,2),(3,4); |
- SELECT * FROM v1; |
-} {1 2 3 4} |
-do_catchsql_test tabfunc01-1.21.1 { |
- SELECT * FROM v1(55); |
-} {1 {'v1' is not a function}} |
-do_catchsql_test tabfunc01-1.21.2 { |
- SELECT * FROM v1(); |
-} {1 {'v1' is not a function}} |
-do_execsql_test tabfunc01-1.22 { |
- CREATE VIEW v2(x) AS SELECT value FROM generate_series(1,5); |
- SELECT * FROM v2; |
-} {1 2 3 4 5} |
-do_catchsql_test tabfunc01-1.23.1 { |
- SELECT * FROM v2(55); |
-} {1 {'v2' is not a function}} |
-do_catchsql_test tabfunc01-1.23.2 { |
- SELECT * FROM v2(); |
-} {1 {'v2' is not a function}} |
-do_execsql_test tabfunc01-1.24 { |
- CREATE TABLE t0(x); |
- INSERT INTO t0(x) VALUES(123),(456),(789); |
- SELECT * FROM t0 ORDER BY x; |
-} {123 456 789} |
-do_catchsql_test tabfunc01-1.25 { |
- SELECT * FROM t0(55) ORDER BY x; |
-} {1 {'t0' is not a function}} |
-do_catchsql_test tabfunc01-1.26 { |
- WITH w0 AS (SELECT * FROM t0) |
- INSERT INTO t0(x) SELECT * FROM w0() |
-} {1 {'w0' is not a function}} |
- |
-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 |} |
-do_execsql_test tabfunc01-2.2 { |
- SELECT *, '|' FROM (SELECT x FROM t1) AS y, generate_series(1,y.x) |
- ORDER BY 1, 2; |
-} {2 1 | 2 2 | 3 1 | 3 2 | 3 3 |} |
- |
-do_execsql_test tabfunc01-2.50 { |
- SELECT * FROM generate_series() LIMIT 5; |
-} {0 1 2 3 4} |
- |
-do_execsql_test tabfunc01-3.1 { |
- SELECT DISTINCT value FROM generate_series(1,x), t1 ORDER BY 1; |
-} {1 2 3} |
- |
-# Eponymous virtual table exists in the "main" schema only |
-# |
-do_execsql_test tabfunc01-4.1 { |
- SELECT * FROM main.generate_series(1,4) |
-} {1 2 3 4} |
-do_catchsql_test tabfunc01-4.2 { |
- SELECT * FROM temp.generate_series(1,4) |
-} {1 {no such table: temp.generate_series}} |
-do_catchsql_test tabfunc01-4.3 { |
- ATTACH ':memory:' AS aux1; |
- CREATE TABLE aux1.t1(a,b,c); |
- SELECT * FROM aux1.generate_series(1,4) |
-} {1 {no such table: aux1.generate_series}} |
- |
-finish_test |