Lines Matching full:8
44 } {1 2 2 4 3 8 4 16 5 32 6 64 7 128 8 256 9 512 10 1024}
68 } {1 6 2 12 3 24 4 48 5 96 6 192 7 384 8 768 9 1536 10 3072}
75 } {1 2 2 4 3 8 4 16 5 32 6 192 7 384 8 768 9 1536 10 3072}
81 } {1 2 2 4 3 8 4 16 5 32 6 64 7 128 8 256 9 512 10 1024}
90 } {2 1 4 2 8 3 16 4 32 5 64 6 128 7 256 8 512 9 1024 10}
97 } {1 2 2 4 3 8 4 16 5 32 6 64 7 128 8 256 9 512 10 1024}
105 INSERT INTO test1(f1,f2) VALUES(8,88);
106 INSERT INTO test1(f1,f2) VALUES(8,888);
111 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
113 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
115 } {6 64 7 128 8 89 8 257 8 889 9 512 10 1024 77 128 777 128}
117 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
119 } {6 64 7 128 8 89 8 257 8 888 9 512 10 1024 77 128 777 128}
121 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
123 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
127 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 778 128}
131 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 777 128}
143 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
150 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
152 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
154 } {6 64 7 128 8 89 8 257 8 889 9 512 10 1024 77 128 777 128}
156 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
158 } {6 64 7 128 8 89 8 257 8 888 9 512 10 1024 77 128 777 128}
160 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
162 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
166 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 778 128}
174 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
175 } {8 88 8 128 8 256 8 888}
181 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 777 128}
192 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
193 } {8 88 8 128 8 256 8 888}
205 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
216 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
217 } {8 88 8 256 8 888}
226 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
228 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
230 } {6 64 7 128 8 89 8 257 8 889 9 512 10 1024 77 128 777 128}
232 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
233 } {8 89 8 257 8 889}
236 } {8 89}
241 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
243 } {6 64 7 128 8 89 8 257 8 888 9 512 10 1024 77 128 777 128}
245 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
247 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
249 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
250 } {8 88 8 256 8 888}
256 } {8 88}
260 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 778 128}
268 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
269 } {8 88 8 128 8 256 8 888}
273 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 777 128}
284 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
285 } {8 88 8 128 8 256 8 888}
289 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
300 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
301 } {8 88 8 256 8 888}
310 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
312 execsql {UPDATE test1 SET f2=f2+1 WHERE f1==8}
314 } {6 64 7 128 8 89 8 257 8 889 9 512 10 1024 77 128 777 128}
316 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
317 } {8 89 8 257 8 889}
320 } {8 89}
325 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2>800}
327 } {6 64 7 128 8 89 8 257 8 888 9 512 10 1024 77 128 777 128}
329 # explain {UPDATE test1 SET f2=f2-1 WHERE f1==8 and F2<300}
330 execsql {UPDATE test1 SET f2=f2-1 WHERE f1==8 and f2<800}
332 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
334 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
335 } {8 88 8 256 8 888}
341 } {8 88}
345 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 778 128}
353 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
354 } {8 88 8 128 8 256 8 888}
358 } {6 64 8 88 8 128 8 256 8 888 9 512 10 1024 78 128 777 128}
369 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
370 } {8 88 8 128 8 256 8 888}
374 } {6 64 7 128 8 88 8 256 8 888 9 512 10 1024 77 128 777 128}
385 execsql {SELECT * FROM test1 WHERE f1==8 ORDER BY f1,f2}
386 } {8 88 8 256 8 888}
498 } {1 15 2 8}
513 INSERT INTO t2 SELECT a+8 FROM t2;