Lines Matching refs:echo
38 # This file uses the "echo" module (see src/test8.c). Refer to comments
60 CREATE VIRTUAL TABLE t1 USING echo;
62 } {1 {no such module: echo}}
65 CREATE VIRTUAL TABLE IF NOT EXISTS t1 USING echo;
67 } {1 {no such module: echo}}
81 # The "echo" module does not invoke sqlite3_declare_vtab() if it is
86 CREATE VIRTUAL TABLE t1 USING echo;
91 CREATE VIRTUAL TABLE IF NOT EXISTS t1 USING echo;
100 # The "echo" module xCreate method returns an error and does not create
106 CREATE VIRTUAL TABLE t1 USING echo(no_such_table);
111 CREATE VIRTUAL TABLE IF NOT EXISTS t1 USING echo(no_such_table);
125 set sql {CREATE VIRTUAL TABLE t2152a USING echo(t2152b)}
149 CREATE VIRTUAL TABLE sqlite_master USING echo;
154 CREATE VIRTUAL TABLE IF NOT EXISTS sqlite_master USING echo;
160 CREATE VIRTUAL TABLE treal USING echo(treal);
165 CREATE VIRTUAL TABLE IF NOT EXISTS treal USING echo(treal);
178 CREATE VIRTUAL TABLE techo USING echo(treal);
185 } {1 {no such module: echo}}
190 } {1 {no such module: echo}}
195 } {1 {no such module: echo}}
200 } {1 {no such module: echo}}
205 } {1 {no such module: echo}}
210 } {1 {no such module: echo}}
223 CREATE VIRTUAL TABLE techo USING echo(treal, logmsg);
238 # At this point, the database is completely empty. The echo module
241 # If a single argument is passed to the echo module during table
243 # database. The echo module attempts to set the schema of the
258 CREATE VIRTUAL TABLE t1 USING echo(template);
288 # echo module has not been registered with this database connection.
292 } {1 {no such module: echo}}
309 } {xConnect echo main t1 template}
340 # Test case vtab1-3 test table scans and the echo module's
348 CREATE VIRTUAL TABLE t1 USING echo(treal);
351 } [list xCreate echo main t1 treal \
352 xSync echo(treal) \
353 xCommit echo(treal) \
467 # The echo module uses a subquery internally to implement the MATCH operator.
484 # Test case vtab1-3 test table scans and the echo module's
561 CREATE VIRTUAL TABLE et1 USING echo(t1);
562 CREATE VIRTUAL TABLE et2 USING echo(t2);
641 CREATE VIRTUAL TABLE techo USING echo(treal);
796 CREATE VIRTUAL TABLE echo_abc USING echo(real_abc);
891 CREATE VIRTUAL TABLE aux.e2 USING echo(real_abc);
894 } [list xCreate echo aux e2 real_abc \
895 xSync echo(real_abc) \
896 xCommit echo(real_abc) \
915 CREATE VIRTUAL TABLE e USING echo(r, e_log);
929 CREATE VIRTUAL TABLE e USING echo(r, e_log, virtual 1 2 3 varchar(32));
933 xCreate echo main e r e_log {virtual 1 2 3 varchar(32)} \
934 xSync echo(r) \
935 xCommit echo(r) \
941 CREATE VIRTUAL TABLE e2 USING echo(del);
1044 CREATE VIRTUAL TABLE echo_c USING echo(c);
1051 } {1 {echo-vtab-error: UNIQUE constraint failed: c.a}}
1054 } {echo-vtab-error: UNIQUE constraint failed: c.a}
1063 } {1 {echo-vtab-error: UNIQUE constraint failed: c.a}}
1186 CREATE VIRTUAL TABLE echo_t1 USING echo(t1);
1216 CREATE VIRTUAL TABLE echo_t2 USING echo(t2);
1232 } "1 {echo-vtab-error: the $method method has failed}"
1245 } "1 {echo-vtab-error: the $method method has failed}"
1254 } "1 {echo-vtab-error: the xRename method has failed}"
1272 catchsql { CREATE VIRTUAL TABLE t4 USING echo(t3); }
1312 CREATE VIRTUAL TABLE e6 USING echo(t6);
1380 CREATE VIRTUAL TABLE t7v USING echo(t7);
1381 CREATE VIRTUAL TABLE t8v USING echo(t8);
1413 CREATE VIRTUAL TABLE t9v USING echo(t9);
1518 execsql { CREATE VIRTUAL TABLE t1e USING echo(t2) }
1570 CREATE VIRTUAL TABLE t1 USING echo(t0);