[Android] No SQLite trigger for HoneyComb

[Geoffrey Métais]

No you don't, it's plain stupid :/

It somehow solved a crash with HC...
Now I'm done with advanced options I revert this and fix it properly.
Thanks.

On Thu, Jan 8, 2015 at 5:17 PM, Edward Wang <edward.c.wang at compdigitec.com>
wrote:

> 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
> _______________________________________________
> Android mailing list
> Android at videolan.org
> https://mailman.videolan.org/listinfo/android
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.videolan.org/pipermail/android/attachments/20150108/1a958e92/attachment.html>