INSERT statement with multiple rows does not work, only the last one is inserted.
INSERT INTO Foo (Bar) VALUES(10),(20),(30);
DELETE statement with IN clause does not work.
"DELETE FROM Foo WHERE Id IN (1,2);"
After delete all rows from the table, primary key reset to value 1.
Tested code on RC1:
class Program
{
static void Main()
{
using (var db = new SQLiteDatabase())
{
db.ExecuteNonQuery("CREATE TABLE IF NOT EXISTS Foo (Id INTEGER PRIMARY KEY AUTOINCREMENT, Bar INTEGER);");
db.ExecuteNonQuery("INSERT INTO Foo (Bar) VALUES(10),(20),(30);");
Select(db);
db.ExecuteNonQuery("INSERT INTO Foo (Bar) VALUES(40);");
db.ExecuteNonQuery("DELETE FROM Foo WHERE Id IN (1,2);");
Select(db);
db.ExecuteNonQuery("DELETE FROM Foo WHERE Id = 1;");
db.ExecuteNonQuery("DELETE FROM Foo WHERE Id = 2;");
db.ExecuteNonQuery("INSERT INTO Foo (Bar) VALUES(50);");
Select(db);
}
while (true) ;
}
private static void Select(SQLiteDatabase db)
{
var result = db.ExecuteQuery("SELECT Id, Bar FROM Foo;");
Debug.WriteLine("Rows selected:" + result.RowCount.ToString());
var str = "";
foreach (var j in result.ColumnNames) str += j + " ";
Debug.WriteLine(str);
foreach (ArrayList i in result.Data)
{
str = "";
foreach (object j in i) str += j.ToString() + " ";
Debug.WriteLine(str);
}
}
}