xref: /sqlite-3.40.0/test/vtabB.test (revision 8a29dfde) 
1# 2008 April 10
2#
3# The author disclaims copyright to this source code.  In place of
4# a legal notice, here is a blessing:
5#
6#    May you do good and not evil.
7#    May you find forgiveness for yourself and forgive others.
8#    May you share freely, never taking more than you give.
9#
10#***********************************************************************
11# This file implements regression tests for SQLite library.  The
12# focus of this file is is verifying that a virtual table in the
13# TEMP database that is created and dropped within a transaction
14# is handled correctly.  Ticket #2994.
15
16#
17# $Id: vtabB.test,v 1.1 2008/04/10 18:35:22 drh Exp $
18
19set testdir [file dirname $argv0]
20source $testdir/tester.tcl
21
22ifcapable !vtab {
23  finish_test
24  return
25}
26
27do_test vtabB-1.1 {
28  register_echo_module [sqlite3_connection_pointer db]
29  execsql {
30    CREATE TABLE t1(x);
31    BEGIN;
32    CREATE VIRTUAL TABLE temp.echo_test1 USING echo(t1);
33    DROP TABLE echo_test1;
34    ROLLBACK;
35  }
36} {}
37
38finish_test
39