[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