Lines Matching refs:name

61     INSERT INTO hhh(name, data) VALUES('1.txt', 'file data');
82     WITH contents(name,mtime,data) AS (
85     ) SELECT quote( zipfile(name,NULL,mtime,data) ) FROM contents;
92   SELECT name,mtime,data FROM zipfile($blob)
107     SELECT name,mtime,data FROM zipfile($blob)
118     SELECT name,data FROM zipfile($blob)
130     SELECT name,data FROM zipfile($blob)
138 #   WITH contents(name,mtime,data) AS (
140 #   ) SELECT quote( zipfile(name,NULL,mtime,data) ) FROM contents;
159   SELECT name,mtime,data,method FROM zipfile($blob)
169   SELECT name,mtime,data,method FROM zipfile($blob)
175   SELECT name,mtime,data IS NULL,method FROM zipfile($blob)
208   execsql { SELECT name, data IS NULL FROM zipfile($blob2) }
218   INSERT INTO temp.zip (name,data) VALUES ('test1','test'); 
219   INSERT INTO temp.zip (name,data) VALUES ('test2','test'); 
222   UPDATE temp.zip SET name='test1' WHERE name='test2'
223 } {1 {duplicate name: "test1"}}
229   INSERT INTO temp.zip (name,data) VALUES ('test','test'); 
230   UPDATE  temp.zip set name=name||'new' where name='test'; 
231   INSERT INTO temp.zip (name,data) VALUES ('test','test'); 
232   UPDATE  temp.zip set name=name||'new' where name='test'; 
233 } {1 {duplicate name: "testnew"}}
237   INSERT INTO temp.zip (name,data) VALUES ('test1','test'); 
238   INSERT INTO temp.zip (name,data) VALUES ('test2','test'); 
239   UPDATE OR REPLACE zip SET name='test2' WHERE name='test1';
240   SELECT name FROM zip;