Lines Matching refs:txt
182 VALUES('f.txt', '-rw-r--r--', 1000000000, 5, 'abcde', 0);
186 VALUES('g.txt', 1000000002, 5, '12345', 0);
190 VALUES('g.txt', 1000000002, '12345', 0);
194 VALUES('g.txt', '12345', 7);
199 VALUES('f.txt', '-rw-r--r--', 1000000000, 'abcde', 0);
203 VALUES('g.txt', NULL, 1000000002, '12345', 0);
209 f.txt 1000000000 abcde
210 g.txt 1000000002 12345
215 INSERT INTO zz(name, mode, mtime, data) VALUES('h.txt',
224 f.txt 1000000000 abcde 0
225 g.txt 1000000002 12345 0
226 h.txt 1000000004 aaaaaaaaaabbbbbbbbbb 8
234 f.txt 1
235 g.txt 1
236 h.txt 1
246 VALUES('i.txt', '-rw-r--r--', 1000000006, 'zxcvb', 0);
249 } {f.txt g.txt h.txt i.txt}
252 } {f.txt g.txt h.txt i.txt}
254 SELECT data FROM zz WHERE name='i.txt';
258 DELETE FROM zz WHERE name='g.txt';
260 } {f.txt h.txt i.txt}
265 f.txt 33188 1000000000 abcde 0
266 h.txt 33188 1000000004 aaaaaaaaaabbbbbbbbbb 8
267 i.txt 33188 1000000006 zxcvb 0
272 UPDATE zz SET mtime=4 WHERE name='i.txt';
275 f.txt 33188 1000000000 abcde 0
276 h.txt 33188 1000000004 aaaaaaaaaabbbbbbbbbb 8
277 i.txt 33188 4 zxcvb 0
289 UPDATE zz SET mode=$modes WHERE name='h.txt';
292 f.txt 33188 1000000000 abcde 0
293 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
294 i.txt 33188 4 zxcvb 0
299 UPDATE zz SET name = 'blue.txt' WHERE name='f.txt';
302 blue.txt 33188 1000000000 abcde 0
303 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
304 i.txt 33188 4 zxcvb 0
309 UPDATE zz SET data = 'edcba' WHERE name='blue.txt';
312 blue.txt 33188 1000000000 edcba 0
313 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
314 i.txt 33188 4 zxcvb 0
318 UPDATE zz SET mode=NULL, data = NULL WHERE name='blue.txt';
321 blue.txt/ 16877 1000000000 {} 0
322 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
323 i.txt 33188 4 zxcvb 0
327 UPDATE zz SET data=NULL WHERE name='i.txt'
332 blue.txt/ 16877 1000000000 {} 0
333 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
334 i.txt 33188 4 zxcvb 0
338 UPDATE zz SET data = '' WHERE name='i.txt';
341 blue.txt/ 16877 1000000000 {} 0
342 h.txt %perms% 1000000004 aaaaaaaaaabbbbbbbbbb 8
343 i.txt 33188 4 {} 0
351 blue.txt/ {}
352 h.txt aaaaaaaaaabbbbbbbbbb
353 i.txt {}
357 SELECT name, data FROM zz WHERE name LIKE '%txt'
359 h.txt aaaaaaaaaabbbbbbbbbb
360 i.txt {}
381 INSERT INTO zzz(name, data) VALUES('dirname2/file1.txt', 'abcdefghijklmnop');
386 dirname2/file1.txt 33188 abcdefghijklmnop
397 dirname2/file1.txt 33188 abcdefghijklmnop
417 do_test 2.5.4 { file isdir dirname2/file1.txt } 0
419 set fd [open dirname2/file1.txt]
483 SELECT zipfile('a.txt', m, 1000, 'xyz') FROM m
488 WITH c(name,data) AS ( SELECT 'a.txt', 'abc')
494 SELECT 'a.txt', 'abc' UNION ALL
502 SELECT 'a.txt', 'abc', 0
503 UNION SELECT 'b.txt', 'def', 8
504 UNION SELECT 'c.txt', 'ghi', 16
511 SELECT 'a.txt', 'abc'
512 UNION SELECT 'b.txt', 'def'
513 UNION SELECT 'c.txt/', 'ghi'
523 SELECT 'a.txt', 946684800, 'abc'
529 a.txt 946684800 abc
538 SELECT 'a.txt', 946684800, 'abc' UNION ALL
539 SELECT 'b.txt', 1000000000, 'abc' UNION ALL
540 SELECT 'c.txt', 1111111000, 'abc'
556 test_unzip/a.txt 946684800
557 test_unzip/b.txt 1000000000
558 test_unzip/c.txt 1111111000
564 SELECT sum(name LIKE '%/a.txt')
572 a.txt 946684800 abc
573 b.txt 1000000000 abc
574 c.txt 1111111000 abc
588 test_unzip/a.txt 946684800
589 test_unzip/b.txt 1000000000
590 test_unzip/c.txt 1111111000
596 a.txt 946684800 3 abc abc
597 b.txt 1000000000 3 abc abc
598 c.txt 1111111000 3 abc abc
628 INSERT INTO zz(name, data) VALUES('a.txt', '1');
629 INSERT INTO zz(name, data) VALUES('b.txt', '2');
630 INSERT INTO zz(name, data) VALUES('c.txt', '1');
631 INSERT INTO zz(name, data) VALUES('d.txt', '2');
634 a.txt 1 b.txt 2 c.txt 1 d.txt 2
641 } {a.txt 1 c.txt 1}
769 subdir/x1.txt 143
770 subdir/x2.txt 153
782 } {subdir subdir/x1.txt subdir/x2.txt}
791 } {subdir subdir/x1.txt subdir/x2.txt}
795 } {. ./x1.txt ./x2.txt}