Lines Matching refs:VACUUM
70 do_execsql_test e_vacuum-0.1 { VACUUM } {}
77 # EVIDENCE-OF: R-60541-63059 Running VACUUM to rebuild the database
106 do_execsql_test e_vacuum-1.1.$tn.4 {VACUUM} {}
116 # EVIDENCE-OF: R-05791-54928 Running VACUUM ensures that each table and
121 # e_vacuum-1.2.3 - Run VACUUM.
138 do_execsql_test e_vacuum-1.2.3 { VACUUM } {}
172 execsql VACUUM
177 # auto_vacuum support property can be changed using VACUUM.
187 execsql VACUUM
193 # EVIDENCE-OF: R-40347-36128 By default, VACUUM operates on the main
206 do_execsql_test e_vacuum-2.1.3 { VACUUM } {}
210 # appending the appropriate schema-name to the VACUUM statement.
211 do_execsql_test e_vacuum-2.1.7 { VACUUM aux; } {}
214 # EVIDENCE-OF: R-17495-17419 The VACUUM command may change the ROWIDs of
222 # Update 2019-01-07: Rowids are now preserved by VACUUM.
233 VACUUM;
247 VACUUM;
251 # Rowid is preserved for VACUUM INTO
263 VACUUM INTO 'test2.db';
285 VACUUM;
289 # EVIDENCE-OF: R-12218-18073 A VACUUM will fail if there is an open
291 # VACUUM.
295 VACUUM
296 } {1 {cannot VACUUM from within a transaction}}
298 do_execsql_test e_vacuum-3.2.1.4 { VACUUM } {}
301 VACUUM
302 } {1 {cannot VACUUM from within a transaction}}
304 do_execsql_test e_vacuum-3.2.1.8 { VACUUM } {}
310 if {$a == 10} { set res [catchsql VACUUM] }
313 } {1 {cannot VACUUM - SQL statements in progress}}
316 # EVIDENCE-OF: R-55138-13241 An alternative to using the VACUUM command
327 # shrink, without rebuilding the entire database using VACUUM.