Hello,
Thanks to SQlite developement team for this wonderfull library
We have been hit today by the following :
package require sqlite3
sqlite3 db1 test
db1 eval {CREATE TABLE T1 (A PRIMARY KEY, B, C, D UNIQUE DEFAULT '-')}
db1 eval {INSERT INTO T1 VALUES (0, 1, 1, 'a') , (1, 1, 1, 'b') , (2,
1, 1 , 'c')}
the issue is here :
db1 transaction {
db1 eval {INSERT OR REPLACE INTO T1 (A, B, C) VALUES (0, 2,
0), (1, 2, 0) , (2, 2, 0)}
}
-> no exception is raised to host langage Tcl for 2 rows not inserted
because a UNIQUE constraint is not respected
-> partial execution : 2 rows are definitely deleted from the table
...(ouch !)
Regards,
Jean-Marie Cuaz
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
