| 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 |