Hi, i found a problem in duplicating files in zipfile extension
Code:
SELECT load_extension("sqlite3_mod_zipfile");
CREATE VIRTUAL TABLE temp.zip USING zipfile('zipfile.zip');
DELETE FROM temp.zip;
INSERT INTO temp.zip (name,data) VALUES ('test','test');
UPDATE temp.zip set name=name||'new' where name='test';
INSERT INTO temp.zip (name,data) VALUES ('test','test');
UPDATE temp.zip set name=name||'new' where name='test';
SELECT count(*) from temp.zip WHERE name='testnew'
count is 2!
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
