Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts3malloc.test

 # 2009 October 22
 #
 # 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.
 #
 #***********************************************************************
@@ skipping 44 matching lines @@
 }
 do_write_test fts3_malloc-1.4 sqlite_master {
   CREATE VIRTUAL TABLE ft4 USING fts3(`a`, 'fred''s column');
 }
 do_error_test fts3_malloc-1.5 {
   CREATE VIRTUAL TABLE ft5 USING fts3(a, b, tokenize unknown)
 } {unknown tokenizer: unknown}
 do_write_test fts3_malloc-1.6 sqlite_master {
   CREATE VIRTUAL TABLE ft6 USING fts3(a, b, tokenize porter)
 }
+do_write_test fts3_malloc-1.7 sqlite_master {
+  CREATE VIRTUAL TABLE ft7 USING fts4(a, b, notindexed=b)
+}
 
 # Test the xConnect/xDisconnect methods:
 #db eval { ATTACH 'test2.db' AS aux }
 #do_write_test fts3_malloc-1.6 aux.sqlite_master {
 #  CREATE VIRTUAL TABLE aux.ft7 USING fts3(a, b, c);
 #}
 #do_write_test fts3_malloc-1.6 aux.sqlite_master {
 #  CREATE VIRTUAL TABLE aux.ft7 USING fts3(a, b, c);
 #}
 
 
 
 do_test fts3_malloc-2.0 {
   execsql { 
     DROP TABLE ft1;
     DROP TABLE ft2;
     DROP TABLE ft3;
     DROP TABLE ft4;
     DROP TABLE ft6;
+    DROP TABLE ft7;
   }
   execsql { CREATE VIRTUAL TABLE ft USING fts3(a, b) }
   for {set ii 1} {$ii < 32} {incr ii} {
     set a [list]
     set b [list]
     if {$ii & 0x01} {lappend a one   ; lappend b neung}
     if {$ii & 0x02} {lappend a two   ; lappend b song }
     if {$ii & 0x04} {lappend a three ; lappend b sahm }
     if {$ii & 0x08} {lappend a four  ; lappend b see  }
     if {$ii & 0x10} {lappend a five  ; lappend b hah  }
@@ skipping 193 matching lines @@
 do_test fts3_malloc-4.2 {
   execsql { SELECT a FROM ft }
 } {two four {two four}}
 
 do_write_test fts3_malloc-5.1 ft_content {
   INSERT INTO ft VALUES('short alongertoken reallyquitealotlongerimeanit andthistokenisjustsolongthatonemightbeforgivenforimaginingthatitwasmerelyacontrivedexampleandnotarealtoken', 'cynics!')
 }
 do_test fts3_malloc-5.2 {
   execsql { CREATE VIRTUAL TABLE ft8 USING fts3(x, tokenize porter) }
 } {}
+
 do_write_test fts3_malloc-5.3 ft_content {
   INSERT INTO ft8 VALUES('short alongertoken reallyquitealotlongerimeanit andthistokenisjustsolongthatonemightbeforgivenforimaginingthatitwasmerelyacontrivedexampleandnotarealtoken')
 }
 
 
 finish_test
-