| 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
|
|
|