Annotation of embedaddon/sqlite3/test/fts3malloc.test, revision 1.1
1.1 ! misho 1: # 2009 October 22
! 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: #
! 12: # This file contains tests to verify that malloc() errors that occur
! 13: # within the FTS3 module code are handled correctly.
! 14: #
! 15:
! 16: set testdir [file dirname $argv0]
! 17: source $testdir/tester.tcl
! 18: ifcapable !fts3 { finish_test ; return }
! 19: source $testdir/malloc_common.tcl
! 20: source $testdir/fts3_common.tcl
! 21:
! 22: # Ensure the lookaside buffer is disabled for these tests.
! 23: #
! 24: sqlite3 db test.db
! 25: sqlite3_db_config_lookaside db 0 0 0
! 26:
! 27: set sqlite_fts3_enable_parentheses 1
! 28: set DO_MALLOC_TEST 1
! 29:
! 30: # Test organization:
! 31: #
! 32: # fts3_malloc-1.*: Test OOM during CREATE and DROP table statements.
! 33: # fts3_malloc-2.*: Test OOM during SELECT operations.
! 34: # fts3_malloc-3.*: Test OOM during SELECT operations with a larger database.
! 35: # fts3_malloc-4.*: Test OOM during database write operations.
! 36: # fts3_malloc-5.*: Test that a couple of memory leaks that could follow
! 37: # OOM in tokenizer code have been fixed.
! 38: #
! 39:
! 40:
! 41: proc normal_list {l} {
! 42: set ret [list]
! 43: foreach elem $l {lappend ret $elem}
! 44: set ret
! 45: }
! 46:
! 47: do_write_test fts3_malloc-1.1 sqlite_master {
! 48: CREATE VIRTUAL TABLE ft1 USING fts3(a, b)
! 49: }
! 50: do_write_test fts3_malloc-1.2 sqlite_master {
! 51: CREATE VIRTUAL TABLE ft2 USING fts3([a], [b]);
! 52: }
! 53: do_write_test fts3_malloc-1.3 sqlite_master {
! 54: CREATE VIRTUAL TABLE ft3 USING fts3('a', "b");
! 55: }
! 56: do_write_test fts3_malloc-1.4 sqlite_master {
! 57: CREATE VIRTUAL TABLE ft4 USING fts3(`a`, 'fred''s column');
! 58: }
! 59: do_error_test fts3_malloc-1.5 {
! 60: CREATE VIRTUAL TABLE ft5 USING fts3(a, b, tokenize unknown)
! 61: } {unknown tokenizer: unknown}
! 62: do_write_test fts3_malloc-1.6 sqlite_master {
! 63: CREATE VIRTUAL TABLE ft6 USING fts3(a, b, tokenize porter)
! 64: }
! 65:
! 66: # Test the xConnect/xDisconnect methods:
! 67: #db eval { ATTACH 'test2.db' AS aux }
! 68: #do_write_test fts3_malloc-1.6 aux.sqlite_master {
! 69: # CREATE VIRTUAL TABLE aux.ft7 USING fts3(a, b, c);
! 70: #}
! 71: #do_write_test fts3_malloc-1.6 aux.sqlite_master {
! 72: # CREATE VIRTUAL TABLE aux.ft7 USING fts3(a, b, c);
! 73: #}
! 74:
! 75:
! 76:
! 77: do_test fts3_malloc-2.0 {
! 78: execsql {
! 79: DROP TABLE ft1;
! 80: DROP TABLE ft2;
! 81: DROP TABLE ft3;
! 82: DROP TABLE ft4;
! 83: DROP TABLE ft6;
! 84: }
! 85: execsql { CREATE VIRTUAL TABLE ft USING fts3(a, b) }
! 86: for {set ii 1} {$ii < 32} {incr ii} {
! 87: set a [list]
! 88: set b [list]
! 89: if {$ii & 0x01} {lappend a one ; lappend b neung}
! 90: if {$ii & 0x02} {lappend a two ; lappend b song }
! 91: if {$ii & 0x04} {lappend a three ; lappend b sahm }
! 92: if {$ii & 0x08} {lappend a four ; lappend b see }
! 93: if {$ii & 0x10} {lappend a five ; lappend b hah }
! 94: execsql { INSERT INTO ft VALUES($a, $b) }
! 95: }
! 96: } {}
! 97:
! 98: foreach {tn sql result} {
! 99: 1 "SELECT count(*) FROM sqlite_master" {5}
! 100: 2 "SELECT * FROM ft WHERE docid = 1" {one neung}
! 101: 3 "SELECT * FROM ft WHERE docid = 2" {two song}
! 102: 4 "SELECT * FROM ft WHERE docid = 3" {{one two} {neung song}}
! 103:
! 104: 5 "SELECT a FROM ft" {
! 105: {one} {two} {one two}
! 106: {three} {one three} {two three}
! 107: {one two three} {four} {one four}
! 108: {two four} {one two four} {three four}
! 109: {one three four} {two three four} {one two three four}
! 110: {five} {one five} {two five}
! 111: {one two five} {three five} {one three five}
! 112: {two three five} {one two three five} {four five}
! 113: {one four five} {two four five} {one two four five}
! 114: {three four five} {one three four five} {two three four five}
! 115: {one two three four five}
! 116: }
! 117:
! 118: 6 "SELECT a FROM ft WHERE a MATCH 'one'" {
! 119: {one} {one two} {one three} {one two three}
! 120: {one four} {one two four} {one three four} {one two three four}
! 121: {one five} {one two five} {one three five} {one two three five}
! 122: {one four five} {one two four five}
! 123: {one three four five} {one two three four five}
! 124: }
! 125:
! 126: 7 "SELECT a FROM ft WHERE a MATCH 'o*'" {
! 127: {one} {one two} {one three} {one two three}
! 128: {one four} {one two four} {one three four} {one two three four}
! 129: {one five} {one two five} {one three five} {one two three five}
! 130: {one four five} {one two four five}
! 131: {one three four five} {one two three four five}
! 132: }
! 133:
! 134: 8 "SELECT a FROM ft WHERE a MATCH 'o* t*'" {
! 135: {one two} {one three} {one two three}
! 136: {one two four} {one three four} {one two three four}
! 137: {one two five} {one three five} {one two three five}
! 138: {one two four five} {one three four five} {one two three four five}
! 139: }
! 140:
! 141: 9 "SELECT a FROM ft WHERE a MATCH '\"o* t*\"'" {
! 142: {one two} {one three} {one two three}
! 143: {one two four} {one three four} {one two three four}
! 144: {one two five} {one three five} {one two three five}
! 145: {one two four five} {one three four five} {one two three four five}
! 146: }
! 147:
! 148: 10 {SELECT a FROM ft WHERE a MATCH '"o* f*"'} {
! 149: {one four} {one five} {one four five}
! 150: }
! 151:
! 152: 11 {SELECT a FROM ft WHERE a MATCH '"one two three"'} {
! 153: {one two three}
! 154: {one two three four}
! 155: {one two three five}
! 156: {one two three four five}
! 157: }
! 158:
! 159: 12 {SELECT a FROM ft WHERE a MATCH '"two three four"'} {
! 160: {two three four}
! 161: {one two three four}
! 162: {two three four five}
! 163: {one two three four five}
! 164: }
! 165:
! 166: 12 {SELECT a FROM ft WHERE a MATCH '"two three" five'} {
! 167: {two three five} {one two three five}
! 168: {two three four five} {one two three four five}
! 169: }
! 170:
! 171: 13 {SELECT a FROM ft WHERE ft MATCH '"song sahm" hah'} {
! 172: {two three five} {one two three five}
! 173: {two three four five} {one two three four five}
! 174: }
! 175:
! 176: 14 {SELECT a FROM ft WHERE b MATCH 'neung'} {
! 177: {one} {one two}
! 178: {one three} {one two three}
! 179: {one four} {one two four}
! 180: {one three four} {one two three four}
! 181: {one five} {one two five}
! 182: {one three five} {one two three five}
! 183: {one four five} {one two four five}
! 184: {one three four five} {one two three four five}
! 185: }
! 186:
! 187: 15 {SELECT a FROM ft WHERE b MATCH '"neung song sahm"'} {
! 188: {one two three} {one two three four}
! 189: {one two three five} {one two three four five}
! 190: }
! 191:
! 192: 16 {SELECT a FROM ft WHERE b MATCH 'hah "song sahm"'} {
! 193: {two three five} {one two three five}
! 194: {two three four five} {one two three four five}
! 195: }
! 196:
! 197: 17 {SELECT a FROM ft WHERE b MATCH 'song OR sahm'} {
! 198: {two} {one two} {three}
! 199: {one three} {two three} {one two three}
! 200: {two four} {one two four} {three four}
! 201: {one three four} {two three four} {one two three four}
! 202: {two five} {one two five} {three five}
! 203: {one three five} {two three five} {one two three five}
! 204: {two four five} {one two four five} {three four five}
! 205: {one three four five} {two three four five} {one two three four five}
! 206: }
! 207:
! 208: 18 {SELECT a FROM ft WHERE a MATCH 'three NOT two'} {
! 209: {three} {one three} {three four}
! 210: {one three four} {three five} {one three five}
! 211: {three four five} {one three four five}
! 212: }
! 213:
! 214: 19 {SELECT a FROM ft WHERE b MATCH 'sahm NOT song'} {
! 215: {three} {one three} {three four}
! 216: {one three four} {three five} {one three five}
! 217: {three four five} {one three four five}
! 218: }
! 219:
! 220: 20 {SELECT a FROM ft WHERE ft MATCH 'sahm NOT song'} {
! 221: {three} {one three} {three four}
! 222: {one three four} {three five} {one three five}
! 223: {three four five} {one three four five}
! 224: }
! 225:
! 226: 21 {SELECT a FROM ft WHERE b MATCH 'neung NEAR song NEAR sahm'} {
! 227: {one two three} {one two three four}
! 228: {one two three five} {one two three four five}
! 229: }
! 230:
! 231: } {
! 232: set result [normal_list $result]
! 233: do_select_test fts3_malloc-2.$tn $sql $result
! 234: }
! 235:
! 236: do_test fts3_malloc-3.0 {
! 237: execsql BEGIN
! 238: for {set ii 32} {$ii < 1024} {incr ii} {
! 239: set a [list]
! 240: set b [list]
! 241: if {$ii & 0x0001} {lappend a one ; lappend b neung }
! 242: if {$ii & 0x0002} {lappend a two ; lappend b song }
! 243: if {$ii & 0x0004} {lappend a three ; lappend b sahm }
! 244: if {$ii & 0x0008} {lappend a four ; lappend b see }
! 245: if {$ii & 0x0010} {lappend a five ; lappend b hah }
! 246: if {$ii & 0x0020} {lappend a six ; lappend b hok }
! 247: if {$ii & 0x0040} {lappend a seven ; lappend b jet }
! 248: if {$ii & 0x0080} {lappend a eight ; lappend b bairt }
! 249: if {$ii & 0x0100} {lappend a nine ; lappend b gow }
! 250: if {$ii & 0x0200} {lappend a ten ; lappend b sip }
! 251: execsql { INSERT INTO ft VALUES($a, $b) }
! 252: }
! 253: execsql COMMIT
! 254: } {}
! 255: foreach {tn sql result} {
! 256: 1 "SELECT count(*) FROM ft" {1023}
! 257:
! 258: 2 "SELECT a FROM ft WHERE a MATCH 'one two three four five six seven eight'" {
! 259: {one two three four five six seven eight}
! 260: {one two three four five six seven eight nine}
! 261: {one two three four five six seven eight ten}
! 262: {one two three four five six seven eight nine ten}
! 263: }
! 264:
! 265: 3 {SELECT count(*), sum(docid) FROM ft WHERE a MATCH 'o*'} {
! 266: 512 262144
! 267: }
! 268:
! 269: 4 {SELECT count(*), sum(docid) FROM ft WHERE a MATCH '"two three four"'} {
! 270: 128 66368
! 271: }
! 272: } {
! 273: set result [normal_list $result]
! 274: do_select_test fts3_malloc-3.$tn $sql $result
! 275: }
! 276:
! 277: do_test fts3_malloc-4.0 {
! 278: execsql { DELETE FROM ft WHERE docid>=32 }
! 279: } {}
! 280: foreach {tn sql} {
! 281: 1 "DELETE FROM ft WHERE ft MATCH 'one'"
! 282: 2 "DELETE FROM ft WHERE ft MATCH 'three'"
! 283: 3 "DELETE FROM ft WHERE ft MATCH 'five'"
! 284: } {
! 285: do_write_test fts3_malloc-4.1.$tn ft_content $sql
! 286: }
! 287: do_test fts3_malloc-4.2 {
! 288: execsql { SELECT a FROM ft }
! 289: } {two four {two four}}
! 290:
! 291: do_write_test fts3_malloc-5.1 ft_content {
! 292: INSERT INTO ft VALUES('short alongertoken reallyquitealotlongerimeanit andthistokenisjustsolongthatonemightbeforgivenforimaginingthatitwasmerelyacontrivedexampleandnotarealtoken', 'cynics!')
! 293: }
! 294: do_test fts3_malloc-5.2 {
! 295: execsql { CREATE VIRTUAL TABLE ft8 USING fts3(x, tokenize porter) }
! 296: } {}
! 297:
! 298: do_write_test fts3_malloc-5.3 ft_content {
! 299: INSERT INTO ft8 VALUES('short alongertoken reallyquitealotlongerimeanit andthistokenisjustsolongthatonemightbeforgivenforimaginingthatitwasmerelyacontrivedexampleandnotarealtoken')
! 300: }
! 301:
! 302:
! 303: finish_test
! 304:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to fts3malloc.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test