StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSQLiteDatabase.insert() returns incorrect rowid for virtual tables
text
Body
copied!<p>When I insert a row into a full-text search database declared like:</p> <pre><code>CREATE VIRTUAL TABLE foo USING fts3 (bar); </code></pre> <p>the SQLiteDatabase.insert() method returns an incorrect rowid. If the table is declared like:</p> <pre><code>CREATE TABLE foo (bar VARCHAR(10)); </code></pre> <p>it returns the correct rowid value. The problem is when I query the database soon after the insert using the rowid returned from the method, the returned Cursor has no records. It works correctly for the first insert into the database only. For subsequent inserts, an incorrect rowid is returned.</p> <p>Is there anything I need to do to get the correct rowid from the SQLiteDatabase.insert() method?</p> <p>I'm using Android SDK version 2.1update1.</p> <p>Thanks, Dan</p> <p>Update: I ended up using a hack to get the last row id using the following code:</p> <pre><code>private int getLastRowId(SQLiteDatabase db, String table) { Cursor cursor = null; try { cursor = db .rawQuery(String.format(Locale.US, "SELECT MAX(rowid) FROM %s", table), null); if (cursor.moveToFirst()) { return cursor.getInt(0); } else { return 0; } } finally { if (cursor != null) { cursor.close(); } } } </code></pre> <p>In my case, it's safe because only a single user has access to the app. For service apps, this may not work depending on how it is implemented/used.</p> <p>I believe we have this problem because when performing an insert in fts3 tables, more than one row is inserted. A row is inserted in the subject table and in the fts3 management tables as well.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload