Hi, With this package: https://packages.ubuntu.com/cosmic/sqlite3
In the sqlite file of Asterisk ( https://wiki.asterisk.org/wiki/display/AST/Asterisk+Internal+Database ) you have this schema: CREATE TABLE IF NOT EXISTS `astdb` ( `key` VARCHAR ( 256 ), `value` VARCHAR ( 256 ), PRIMARY KEY(`key`) ); You can have hundred lines like that: INSERT INTO `astdb` (key,value) VALUES ('/SIP/Registry/XXXXXXXX','XXX.XXX.XX.XXX:62467:360:[email protected]:2051 '); When I launch this SQL query: DELETE FROM astdb WHERE key LIKE '%SIP%'; It deletes between 3 and 40 lines, but not all lines. And each time I launch this SQL query, it removes between 3 and 40 other lines, but not all lines. It's a very strange behavior, I have never see that. It looks like a bug. Thanks for your help. Regards. -- Ludovic Gasc Lemaire (GMLudo) _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
