OLD | NEW |
1 # 2007 April 26 | 1 # 2007 April 26 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. | 3 # The author disclaims copyright to this source code. |
4 # | 4 # |
5 #************************************************************************* | 5 #************************************************************************* |
6 # This file implements tests for prefix-searching in the fts3 | 6 # This file implements tests for prefix-searching in the fts3 |
7 # component of the SQLite library. | 7 # component of the SQLite library. |
8 # | 8 # |
9 # $Id: fts3an.test,v 1.2 2007/12/13 21:54:11 drh Exp $ | 9 # $Id: fts3an.test,v 1.2 2007/12/13 21:54:11 drh Exp $ |
10 # | 10 # |
(...skipping 198 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
209 execsql { INSERT INTO ft SELECT * FROM ft } ;# 16384 | 209 execsql { INSERT INTO ft SELECT * FROM ft } ;# 16384 |
210 execsql { INSERT INTO ft SELECT * FROM ft } ;# 32768 | 210 execsql { INSERT INTO ft SELECT * FROM ft } ;# 32768 |
211 execsql { INSERT INTO ft SELECT * FROM ft } ;# 65536 | 211 execsql { INSERT INTO ft SELECT * FROM ft } ;# 65536 |
212 execsql { INSERT INTO ft SELECT * FROM ft } ;# 131072 | 212 execsql { INSERT INTO ft SELECT * FROM ft } ;# 131072 |
213 execsql COMMIT | 213 execsql COMMIT |
214 execsql { UPDATE ft SET x = 'abc' || rowid } | 214 execsql { UPDATE ft SET x = 'abc' || rowid } |
215 execsql { SELECT count(*) FROM ft WHERE x MATCH 'abc*' } | 215 execsql { SELECT count(*) FROM ft WHERE x MATCH 'abc*' } |
216 } {131072} | 216 } {131072} |
217 | 217 |
218 finish_test | 218 finish_test |
OLD | NEW |