Hello Richard,
Is the following enhancement included as part of this pre-release snapshot?
- Enhance the session extension to support WITHOUT ROWID tables.
The draft documentation still says that this support does not yet exist,
and my test below also demonstrates this. Please let me know if I am
missing something.
/*
** The following function will print an error as expected: "UNIQUE
constraint failed: a.x".
**
** If table a is WITHOUT ROWID, then there will be no error.
*/
void fn(void){
sqlite3 *db;
sqlite3_session *pSession = 0;
int nChangeset;
void *pChangeset;
char *sql;
char *zMsg;
sqlite3_open(":memory:", &db);
sql = "CREATE TABLE a(x PRIMARY KEY) --WITHOUT ROWID";
sqlite3_exec(db, sql, NULL, NULL, NULL);
sqlite3session_create(db, "main", &pSession);
sqlite3session_attach(pSession, "a");
sql = "INSERT INTO a VALUES (1)";
sqlite3_exec(db, sql, NULL, NULL, NULL);
sqlite3session_changeset(pSession, &nChangeset, &pChangeset);
sql = "DELETE FROM a WHERE x=1";
sqlite3_exec(db, sql, NULL, NULL, NULL);
sqlite3changeset_apply(db, nChangeset, pChangeset, 0, 0, 0);
sql = "INSERT INTO a VALUES (1)";
sqlite3_exec(db, sql, NULL, NULL, &zMsg);
if( zMsg ) printf("%s\n", zMsg);
}
/*****************************************/
Kind Regards
Jake
On Sun, Feb 5, 2017 at 2:23 AM, Richard Hipp <d...@sqlite.org> wrote:
> There is a new pre-release snapshot of SQLite up at
> https://www.sqlite.org/download.html
>
> Change notes can be seen at https://www.sqlite.org/draft/
> releaselog/3_17_0.html
>
> The performance enhancements in the R-Tree extension are of particular
> significance. If you are able to test out this pre-release snapshot
> in your application, please do so and report results to this mailing
> list, or directly to me. Thanks.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
