Is there any way to (programmatically) check what version of SQLite is installed?
On Jun 24, 1:09 pm, Mark Carter <mjc1...@googlemail.com> wrote: > Hmmm - this is a bit worrying, isn't it? How to possibly test SQL which can > potentially run so differently on different devices? > > One starting point would be get a list of SQLite version numbers on each > device available... > > 2010/6/24 Tomáš Hubálek <tom.huba...@gmail.com> > > > > > SQL Lite is definitely simpler but in Oracle it sometimes happens that the > > same SQL has very different performance on different versions because of > > different explain plan. > > > Tom > > > On Thu, Jun 24, 2010 at 12:48 PM, Mark Carter <mjc1...@googlemail.com>wrote: > > >> True - though the SQL is a little complex and I'd like to simplify it > >> before posting. > > >> However, whatever the SQL is, there has to be an explanation for the > >> different outcome. > > >> 2010/6/24 Tomáš Hubálek <tom.huba...@gmail.com> > > >> Maybe full SQL would give more clue... > > >>> Tom > > >>> On 24 čvn, 10:13, Mark Carter <mjc1...@googlemail.com> wrote: > >>> > Same data, same code, but different results on these two devices. > > >>> > On the Nexus One, the (INNER JOIN) query runs (first call to > >>> > Cursor.moveToNext()) after a fraction of a second but on the Hero it > >>> > just hangs. > > >>> > I haven't been able to reduce the scenario to something simple yet, > >>> > but it seems to involve using OR within an ON clause. > > >>> > Anyone know why there might be a difference on these two devices? > > >>> -- > >>> You received this message because you are subscribed to the Google > >>> Groups "Android Developers" group. > >>> To post to this group, send email to android-developers@googlegroups.com > >>> To unsubscribe from this group, send email to > >>> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > >>> cr...@googlegroups.com> > >>> For more options, visit this group at > >>>http://groups.google.com/group/android-developers?hl=en > > >> -- > >> You received this message because you are subscribed to the Google > >> Groups "Android Developers" group. > >> To post to this group, send email to android-developers@googlegroups.com > >> To unsubscribe from this group, send email to > >> android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > >> cr...@googlegroups.com> > >> For more options, visit this group at > >>http://groups.google.com/group/android-developers?hl=en > > > -- > > > --------------------------------------------------------------------------- > > -------------------- > > Tom Hubalek (tom.huba...@gmail.com), > >http://android.hubalek.net,http://blog.hubalek.net/ > >http://facebook.com/thubalek,http://www.linkedin.com/in/thubalek > >http://twitter.com/thubalek,http://twitter.com/android_dev_tom > > > -- > > You received this message because you are subscribed to the Google > > Groups "Android Developers" group. > > To post to this group, send email to android-developers@googlegroups.com > > To unsubscribe from this group, send email to > > android-developers+unsubscr...@googlegroups.com<android-developers%2Bunsubs > > cr...@googlegroups.com> > > For more options, visit this group at > >http://groups.google.com/group/android-developers?hl=en -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en