[Android] No SQLite trigger for HoneyComb
Edward Wang
edward.c.wang at compdigitec.com
Thu Jan 8 17:17:45 CET 2015
On Thu, Jan 8, 2015 at 10:13 AM, Geoffrey Métais <git at videolan.org> wrote:
> + if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.HONEYCOMB &&
> + Build.VERSION.SDK_INT <= Build.VERSION_CODES.HONEYCOMB_MR2) {
> + createMrlTableQuery += "CREATE TRIGGER mrl_history_trigger AFTER INSERT ON " +
> + MRL_TABLE_NAME + "BEGIN " +
> + "DELETE FROM " + MRL_TABLE_NAME + " where " + MRL_URI + " NOT IN (SELECT " + MRL_URI +
> + " from " + MRL_TABLE_NAME + " ORDER BY insertion_date DESC LIMIT " + MRL_TABLE_SIZE + ")" +
> + "END";
> + }
Perhaps I'm mistaken, but isn't this backward, so that the trigger
actually is run on APIs 11-13 (HoneyComb), but not for any other
versions?
Regards,
Edward
More information about the Android
mailing list