Is there any way to (programmatically) check what version of SQLite is installed?
On Jun 24, 1:09 pm, Mark Carter <[email protected]> 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 <[email protected]> > > > > > 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 <[email protected]>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 <[email protected]> > > >> Maybe full SQL would give more clue... > > >>> Tom > > >>> On 24 čvn, 10:13, Mark Carter <[email protected]> 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 [email protected] > >>> To unsubscribe from this group, send email to > >>> [email protected]<android-developers%2Bunsubs > >>> [email protected]> > >>> 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 [email protected] > >> To unsubscribe from this group, send email to > >> [email protected]<android-developers%2Bunsubs > >> [email protected]> > >> For more options, visit this group at > >>http://groups.google.com/group/android-developers?hl=en > > > -- > > > --------------------------------------------------------------------------- > > -------------------- > > Tom Hubalek ([email protected]), > >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 [email protected] > > To unsubscribe from this group, send email to > > [email protected]<android-developers%2Bunsubs > > [email protected]> > > 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
