Import SQLite 3.10.2.

third_party/sqlite/src/test/vtab2.test

 # 2006 June 10
 #
 # 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 regression tests for SQLite library.
 #
-# $Id: vtab2.test,v 1.9 2008/10/13 10:37:50 danielk1977 Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
+set testprefix vtab2
 
 ifcapable !vtab||!schema_pragmas {
   finish_test
   return
 }
 
 register_schema_module [sqlite3_connection_pointer db]
 do_test vtab2-1.1 {
   execsql {
     CREATE VIRTUAL TABLE schema USING schema;
@@ skipping 70 matching lines @@
     SELECT * FROM schema WHERE dflt_value IS NULL LIMIT 1
   }
 } {main schema 0 database {} 0 {} 0}
 do_test vtab2-3.2 {
   execsql {
     SELECT *, b.rowid
       FROM schema a LEFT JOIN schema b ON a.dflt_value=b.dflt_value
      WHERE a.rowid=1
   }
 } {main schema 0 database {} 0 {} 0 {} {} {} {} {} {} {} {} {}}
+do_test vtab2-3.3 {
+  execsql {
+    SELECT *, b.rowid
+      FROM schema a LEFT JOIN schema b ON a.dflt_value IS b.dflt_value
+                                      AND a.dflt_value IS NOT NULL
+     WHERE a.rowid=1
+  }
+} {main schema 0 database {} 0 {} 0 {} {} {} {} {} {} {} {} {}}
 
 do_test vtab2-4.1 {
   execsql {
     BEGIN TRANSACTION;
     CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(b, c));
     CREATE TABLE fkey(
       to_tbl,
       to_col
     );
     INSERT INTO "fkey" VALUES('t1',NULL);
     COMMIT;
   }
 } {}
 do_test vtab2-4.2 {
   execsql { CREATE VIRTUAL TABLE v_col USING schema }
 } {}
 do_test vtab2-4.3 {
   execsql { SELECT name FROM v_col WHERE tablename = 't1' AND pk }
 } {a}
 do_test vtab2-4.4 {
   execsql {
     UPDATE fkey 
     SET to_col = (SELECT name FROM v_col WHERE tablename = 't1' AND pk);
   }
 } {}
 do_test vtab2-4.5 {
   execsql { SELECT * FROM fkey }
 } {t1 a}
 
+#-------------------------------------------------------------------------
+#
+ifcapable fts3 {
+  reset_db
+  do_execsql_test 5.1 {
+    PRAGMA encoding='UTF16';
+  }
+
+  do_test 5.2 {
+    sqlite3_exec_hex db { CREATE VIRTUAL TABLE %C8 USING fts3 }
+  } {0 {}}
+
+  do_test 5.3 {
+    sqlite3_exec_hex db { CREATE VIRTUAL TABLE %C9 USING s }
+  } {/1 {malformed database schema.* already exists}/}
+}
+
+
+
 finish_test