Bug on update in extension zipfile

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Bug on update in extension zipfile

Djelf

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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users